Re: [HACKERS] RE: [GENERAL] Benchmarking PGSQL against Microsoft SQL 7

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: tlewis(at)mindspring(dot)net (Todd Graham Lewis)
Cc: lockhart(at)alumni(dot)caltech(dot)edu, bryan(at)silcom(dot)com, pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] RE: [GENERAL] Benchmarking PGSQL against Microsoft SQL 7
Date: 1999-01-10 01:47:46
Message-ID: 199901100147.UAA19458@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Blashko Alexander 1999-01-10 11:09:42 Problems with pg_options.
Previous Message David Wetzel 1999-01-10 00:13:13 Re: [PORTS] Please help with a Solaris 2.6 build error

Browse pgsql-hackers by date

  From Date Subject
Next Message Brook Milligan 1999-01-10 02:50:50 pgdump and sequences
Previous Message Bruce Momjian 1999-01-10 01:43:26 Re: [HACKERS] Libpq functions