From: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: postgresql generate ddl returns FK with `<?>()` in it |
Date: | 2022-07-08 11:12:30 |
Message-ID: | 20220708111230.hcw2m7v6y6f3pagx@hjp.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2022-07-07 07:05:53 -0600, Roman Gavrilov wrote:
> I have a schema with two tables, where the first table's composite 2-columns FK
> points to the second table's 2-columns composite PK. But the order of columns
> is reversed.
>
> When I use `Generate DDL` on the first table, FK definition comes back as:
PostgreSQL doesn't have a `Generate DDL` command. So the question is,
what program are you using to generate the ddl.
> Full details on SO:
>
> https://stackoverflow.com/questions/72898296/what-is-in-postgresql-ddl
Ah, it's "DBeaver". (Please include relevant details when you ask a
question here - don't expect people to look at a stack overflow
question).
> How can I fix that `<?>();` issue? Is this documented behavior?
My guess is that's a bug in DBeaver.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2022-07-08 11:17:52 | Re: postgresql generate ddl returns FK with `<?>()` in it |
Previous Message | Laurenz Albe | 2022-07-08 11:00:15 | Re: postgresql bug |