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@xxxxxx | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!"
Attachment:
signature.asc
Description: PGP signature
