Re: [GENERAL] unable to drop a constraint

2008-07-17 Thread Enrico Sirola
Hi Michael, Il giorno 16/lug/08, alle ore 18:21, Michael Glaesemann ha scritto: 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 fi

Re: [GENERAL] unable to drop a constraint

2008-07-17 Thread Enrico Sirola
Hello Tom, Il giorno 16/lug/08, alle ore 16:40, Tom Lane ha scritto: Enrico Sirola <[EMAIL PROTECTED]> writes: 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 use

Re: [GENERAL] unable to drop a constraint

2008-07-16 Thread Michael Glaesemann
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

Re: [GENERAL] unable to drop a constraint

2008-07-16 Thread Tom Lane
Enrico Sirola <[EMAIL PROTECTED]> writes: > 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 I don't think you're b

[GENERAL] unable to drop a constraint

2008-07-16 Thread Enrico Sirola
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 test=# select * from pg_constra