> 2) Will PostgreSQL _ever_ have support for foreign keys? That is the
> single biggest gripe around here at MindSpring. Lots of people use psql
> and love it, myself included, but the lack of support for foreign keys
> is so annoying that it boggles the mind. I know that you can simulate
> the behaviour using triggers, and so the question comes, why can't
> someone just hack the command syntax to translate the "foreign keys"
> directive into the appropriate trigger insertion? This has been on the
> TODO list for as long as I have been watching PostgreSQL, and at this
> point I despair that it will ever get done. I would be happier if the
> README just said "PostgreSQL does not and will never support the SQL
> 'FOREIGN KEYS' directive."
I was going to soapbox this item, row reuse without vacuum, and buffered
logging as things at we really need. I am thinking about row reuse now,
and want to post something about buffered logging this week to Vadim.
That leaves foreign keys. We really need to address this, because it
comes up so often. Can we hash through the issues again, and see if
someone takes on the project.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026