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.
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... |