| From: | Michael Glaesemann <michael(dot)glaesemann(at)myyearbook(dot)com> |
|---|---|
| To: | Enrico Sirola <enrico(dot)sirola(at)gmail(dot)com> |
| Cc: | Michael Glaesemann <michael(dot)glaesemann(at)myyearbook(dot)com>, "pgsql-general(at)postgresql(dot)org General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: unable to drop a constraint |
| Date: | 2008-07-16 16:21:34 |
| Message-ID: | 5557917C-1667-45ED-B3C1-A1899993F190@myyearbook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2008-07-16, at 7:18 AM, Enrico Sirola wrote:
> Hi,
>
> I'm using postgresql version 8.3.1
>
> I have two tables, one has a field with a foreign key pointing to
> the primary key of another table. When I to drop the first table, I
> get the following error:
>
> test=# drop table user;
> ERROR: "customer_pkey" is an index
Are you using slony perchance? This looks like an issue with slony
blocking DDL operations:
http://lists.slony.info/pipermail/slony1-general/2006-November/005216.html
Michael Glaesemann
michael(dot)glaesemann(at)myyearbook(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Atkins | 2008-07-16 16:40:39 | Re: vacuum taking an unusually long time |
| Previous Message | Mason Hale | 2008-07-16 15:40:58 | Re: vacuum taking an unusually long time |