Re: duplicate primary key entries? - Mailing list pgsql-general

From Baldur Norddahl
Subject Re: duplicate primary key entries?
Date
Msg-id 1069769116.3fc3619cb0c1b@dark.clansoft.dk
Whole thread Raw
In response to Re: duplicate primary key entries?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Quoting Alvaro Herrera <alvherre@dcc.uchile.cl>:

> On Tue, Nov 25, 2003 at 01:02:37PM +0100, Baldur Norddahl wrote:
>
> > No, there can be no space after 'any' because the foreign key prevents it
> (which
> > you of course could not check since I didn't show the content of the
> foreign
> > table).
>
> Huh ... has the table any inherited tables?

No, but I did play a little with inheritance a few months ago until I discovered
that it didn't play well with my use of foreign keys.

When I said that the "locale" column could not contain the value "any ", I was
refering to the foreign key to the table "languages". Since there is no "any "
(with a space) in that table, this could not happen.

Baldur

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

pgsql-general by date:

Previous
From: Marek Lewczuk
Date:
Subject: Re: PostgreSQL is much faster than MySQL, only when...
Next
From: Andrew Sullivan
Date:
Subject: Re: PGSQL on shared hosting