Re: [HACKERS] Strange.. solved

2001-01-24 Thread Stephan Szabo


Actually, if you look in pg_trigger,  is technically the
constraint name and it should have a system generated constraint name
which you probably can use drop trigger on.  It looks like part of
a FK constraint so I'm not sure how you got just 1/2 of it since
dropping subject should have dropped it (unless you did a partial
dump and restore).


On Mon, 22 Jan 2001, Patrick Welche wrote:

> By comparing backups, I found
> 
> CREATE CONSTRAINT TRIGGER "" AFTER INSERT OR UPDATE ON "person"  NOT 
>DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" 
>('', 'person', 'subject', 'UNSPECIFIED', 'subjectid', 'id');
> 
> Don't know where that came from, but probably operator error.. There isn't
> an easy way of scrubbing an unnamed trigger is there? (I dump/edit/reloaded)
> 
> Cheers,
> 
> Patrick
> 




[HACKERS] Strange.. solved

2001-01-23 Thread Patrick Welche

By comparing backups, I found

CREATE CONSTRAINT TRIGGER "" AFTER INSERT OR UPDATE ON "person"  NOT 
DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" 
('', 'person', 'subject', 'UNSPECIFIED', 'subjectid', 'id');

Don't know where that came from, but probably operator error.. There isn't
an easy way of scrubbing an unnamed trigger is there? (I dump/edit/reloaded)

Cheers,

Patrick