Re: postgresql generate ddl returns FK with `<?>()` in it

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!"