Re: Constraint and Index with same name? (chicken and egg probelm)

From: David Brain <dbrain(at)bandwidth(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Constraint and Index with same name? (chicken and egg probelm)
Date: 2007-03-27 15:14:29
Message-ID: 460934D5.1010507@bandwidth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Not sure I can provide one either I'm afraid, I don't think I did
anything unusual. But I can provide you with some background as to how
this DB was created so if you can see any steps that may have been
problematic.

This db was created as part of an upgrade to new hardware, using Slony
to replicate the data to copy data and keep things in sync during the
initial test period.

1. Created basic db schema, minus indexes and constraints.
2. Setup Slony replication to copy/sync data from master db.
3. Once syc complete, re-added indexes and constraints to new DB using
pgadmin (by copying the ddl from the original db - again using pgadmin)
4. Removed FK constraint from the old db - worked ok.
5. Attempted to remove FK constraint from new DB - hit the problem I am
seeing now.

The db is now semi production, but I'll happily provide whatever info I
can short of needing a restart (and even a restart could be scheduled if
necessary).

Let me know if I can provide any more info.

David.

Tom Lane wrote:
> David Brain <dbrain(at)bandwidth(dot)com> writes:
>> This could well be a recurrence of this issue:
>> http://archives.postgresql.org/pgsql-general/2007-01/msg01801.php
>> for which there doesn't seem to have been a resolution.
>
> I never got a reproduceable case out of the other reporter ... can you
> provide one? His looked like it had something to do with foreign
> key constraints named the same as unique/primary key constraints,
> but AFAICS 8.1 won't let you create such, so I dunno how he got into
> that state.
>
> regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2007-03-27 15:21:54 Re: [GENERAL] Is there a shortage of postgresql skilled ops people
Previous Message Kevin Field 2007-03-27 15:09:21 Re: cutting out the middleperl