Re: duplicate primary key entries?

From: Baldur Norddahl <bbn-pgsql(dot)general(at)clansoft(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: duplicate primary key entries?
Date: 2003-11-26 08:36:13
Message-ID: 1069835773.3fc465fd11c11@dark.clansoft.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I found the problem. It was not hardware problems or any malfunction in
postgresql.

I thought I had dropped all tables that inherited from the problem table, but
apparently I forgot one.

It really sucks that inheritance breaks their parent tables constraints :-(.
Which is also why we had to drop using it even when it fitted perfectly into
the structure.

Baldur

Quoting Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)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?
>
> --
> Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
> Licensee shall have no right to use the Licensed Software
> for productive or commercial use. (Licencia de StarOffice 6.0 beta)
>
>

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-11-26 08:45:40 Re: pam authentication for postgres
Previous Message Marek Lewczuk 2003-11-26 08:21:25 Re: PostgreSQL is much faster than MySQL, only when...