Re: postgresql generate ddl returns FK with `()` in it - Mailing list 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@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"