2) The constraint doesn't exist on the master, only the slave, so I don't
beleive EXECUTE SCRIPT will work, no?
No, it does not work. I've tried.
// John
_
John Parnefjord
Samordnare UBIT Utveckling / Coordinator UBIT Development
Ühel kenal päeval, R, 2007-10-19 kell 15:29, kirjutas Magnus Hagander:
On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
ERROR: items_pkey is an index
Ühel kenal päeval, R, 2007-10-19 kell 15:29, kirjutas Magnus Hagander:
On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
ERROR: items_pkey is an index
Context
On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
ERROR: items_pkey is an index
Context please?
Yeah, I had that one coming, didn't it... That's what I get for
Magnus Hagander [EMAIL PROTECTED] writes:
db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
ERROR: items_pkey is an index
Context please?
regards, tom lane
---(end of broadcast)---
TIP 4: Have you
db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
ERROR: items_pkey is an index
The foreign key points to items.Item_id which is what's indexed by items_pkey.
But I only wanted to drop that constraint.
/Magnus
---(end of