Re: [BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found

From: Kristis Makris <kristis(dot)makris(at)datasoft(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
Date: 2001-07-11 18:13:41
Message-ID: 200107111821.f6BIL4a01120@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-odbc pgsql-sql

On 11 Jul 2001 13:56:58 -0400, Tom Lane wrote:
> > 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 ;-).

This seems to have a similar effect:

ALTER USER test VALID UNTIL 'infinity';

I could stick to this for now.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Oyvind Hallsteinsen 2001-07-11 18:40:32 Re: Compilation on Solaris 2.8
Previous Message Stephan Szabo 2001-07-11 18:03:01 Re: PL/pgSQL triggers with parameters don't work

Browse pgsql-odbc by date

  From Date Subject
Next Message jim davis 2001-07-11 20:09:06 fatal ODBC error?
Previous Message Tom Lane 2001-07-11 17:56:58 Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found

Browse pgsql-sql by date

  From Date Subject
Next Message Phuong Ma 2001-07-11 22:56:55 trigger on DELETE
Previous Message Tom Lane 2001-07-11 17:56:58 Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found