On 11 Jul 2001 12:07:09 -0400, Tom Lane wrote:
> Kristis Makris <[EMAIL PROTECTED]> writes:
> > On 11 Jul 2001 11:21:35 -0400, Tom Lane wrote:
> >> Hmm, are you trying to create triggers on pg_shadow? It's hard to see
> >> how that message could come from an "UPDATE pg_shadow" otherwise.
>
> > I
Hi Tom, thanks for your feedback on this.
On 11 Jul 2001 11:21:35 -0400, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not
found
>
> Hmm, are you trying to create triggers on pg_shadow? It's hard to see
> how that message could co
> So that raises this from an unimplemented feature to a real bug, or at
> least higher priority in my eyes. You can't do a CREATE/ALTER USER
> followed by an UPDATE on pg_shadow in a single transaction:
I'm glad I could be of some help.
I don't know if the following means anything to you (or t
Kristis Makris <[EMAIL PROTECTED]> writes:
> but if I want to clear the valuntil completely, how should I issue the
> ALTER USER statement?
Offhand I don't believe ALTER USER can do that. Feel free to submit
a patch ;-).
regards, tom lane
---(end
Kristis Makris <[EMAIL PROTECTED]> writes:
> On 11 Jul 2001 12:07:09 -0400, Tom Lane wrote:
>> Maybe you made a table with a foreign key reference to pg_shadow?
> I suspected that, grep'ed all my sql source for "pg_shadow" and the only
> place where I use the pg_shadow table is on the "UPDATE pg_
Kristis Makris <[EMAIL PROTECTED]> writes:
> On 11 Jul 2001 11:21:35 -0400, Tom Lane wrote:
>> Hmm, are you trying to create triggers on pg_shadow? It's hard to see
>> how that message could come from an "UPDATE pg_shadow" otherwise.
> I'm not trying to explicitly create triggers on pg_shadow. N
[EMAIL PROTECTED] writes:
> ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
Hmm, are you trying to create triggers on pg_shadow? It's hard to see
how that message could come from an "UPDATE pg_shadow" otherwise.
Triggers on system catalogs don't work very well, because
Kristis Makris ([EMAIL PROTECTED]) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
Long Description
Using Postgres 7.1.2, I'm executing a plpgsql function that is expected to
