Skip to content
#

postgres

postgresql logo

PostgreSQL is a database management system that is object-relational. PostgreSQL originated from the Ingres project at the University of California, Berkeley.

Here are 4,147 public repositories matching this topic...

grafana
supabase
posthog
IdemenB
IdemenB commented May 1, 2021

Running a query on a Postgres DB table with a field of MONEY type gives the following error with the query_as! macro. This happens despite the fact that the related field in the Struct field is set as "PgMoney" documented in https://docs.rs/sqlx/0.5.2/sqlx/postgres/types/struct.PgMoney.html.

unsupported type MONEY of column #5 ("paymentamount")

Am I missing something here?

questdb
ideoma
ideoma commented May 5, 2021

Describe the bug
When joining to tables on the same column name SQL error happens

To Reproduce

create table l as
( select x from long_sequence(100) )

create table r as
( select x + 50 from long_sequence(100) )

select x
from l join r on l.x = r.x

and got back
Invalid column: r.x

Expected behavior
Tables should be joined, no SQL syntax error

**Enviro

sharadregoti
sharadregoti commented Dec 18, 2020

The problem faced currently?

While adding an ingress route, or a target in ingress route.
If by mistake white space gets added to the route or host. We get the error specified route not found or unable to reach the specified target

How can we solve it?

Mission control should remove the white space if present before saving the config

If you want this feature to be implemented, gi

Created by Michael Stonebraker

Released July 8, 1996

Repository
postgres/postgres
Website
www.postgresql.org
Wikipedia
Wikipedia