From: | "Furesz Peter" <spam(at)srv(dot)hu> |
---|---|
To: | "postgres levlista" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: too many trigger records found for relation "item" - |
Date: | 2007-01-26 13:33:05 |
Message-ID: | 006f01c7414e$8293fe60$6500a8c0@bixerverintel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have the same problem yesterday. I got this error when I try to disable
the trigger in pg_catalog:
UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid =
'foobar'::pg_catalog.regclass';
But if I disabling the trigger using this syntax:
"ALTER TABLE tablename DISABLE TRIGGER triggername"
everything ok.
----- Original Message -----
From: "Csaba Nagy" <nagy(at)ecircle-ag(dot)com>
To: "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, January 26, 2007 10:06 AM
Subject: Re: [GENERAL] too many trigger records found for relation "item" -
>> [snip] I believe this is fixed as of 8.2 --- can you duplicate it
>> there? (No, backpatching the fix is not practical.)
>
> No, I was not able to duplicate it on 8.2, so I think it's fixed (given
> that on 8.1 the errors are triggered almost 100% of the runs).
>
>> How sure are you about that uninterlocked getChildTableName() thing?
>> It's possible to get a failure complaining about duplicate type name
>> instead of duplicate relation name during CREATE TABLE, if the timing
>> is just right.
>
> Not sure at all (I left it deliberately unsynchronized to go as fast as
> it can even if it errors sometimes on duplicate tables), so that might
> be an explanation. The error is a bit misleading though, or better
> inconsistent: if I would have to detect the duplicate table error
> condition in my code so that I can take corrective steps I would need to
> look for 2 error types instead of 1 - if I only knew that I have to.
>
> And BTW, I have seen something similar while creating temporary tables
> which should not conflict even with the same table name I think...
>
> Cheers,
> Csaba.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2007-01-26 14:00:52 | Re: "no unpinned buffers available" ? why? (hstore and plperl involved) |
Previous Message | Furesz Peter | 2007-01-26 13:31:48 | Re: trigger question |