pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kristis Makris <kristis.makris@datasoft.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@postgresql.org
Cc: pgsql-sql@postgresql.org
Cc: pgsql-odbc@postgresql.org
Subject: Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
Date: 11 Jul 2001 10:51:46 -0700
Message-ID: <200107111751.f6BHpla87781@postgresql.org> (raw)
In-Reply-To: <23687.994869627@sss.pgh.pa.us>
References: <200107110034.f6B0YX879575@hub.org>
	<18395.994864895@sss.pgh.pa.us>
	<200107111604.f6BG4xJ21783@sss.pgh.pa.us>
	<21997.994867629@sss.pgh.pa.us>
	<200107111617.f6BGHWJ23570@sss.pgh.pa.us>
	<23687.994869627@sss.pgh.pa.us>

> 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 the pgsql-odbc
folks), but in the past (I don't recall if that was postgres 7.0.3,
7.1.1 or 7.1.2) I used to get the following error message while issuing
a "BEGIN, ALTER USER ..., COMMIT" block, coming in through an ODBC
connection using VC++ 6 with the 7.01.00.05 driver:

ERROR:  ALTER USER: may not be called in a transaction block

Doing a BEGIN, ALTER USER.., COMMIT (not through ODBC, through the psql
client) now on 7.1.2 *seems* to work fine though. Should I take it that
ALTER USER may indeed be used in a transaction block? I don't know if
this was actually fixed or bugfixes to this might have something to do
with the system trigger on pg_shadow, but I just thought I'll mention it
in case it rings any more bells. I'm sure you know best.
 
> The workaround I'd recommend to you for now is to use ALTER USER, not
> UPDATE, to perform the second step in your function.

So, how would I go about using the ALTER USER statement to clear out the
valuntil value from the pg_shadow table? If I want to set an expiration
date for the user, I can use a statement such as:

ALTER USER test VALID UNTIL '2001-07-11 10:23:23-07'

but if I want to clear the valuntil completely, how should I issue the
ALTER USER statement? I have tried (with no success) the following so
far:

ALTER USER test VALID UNTIL NULL;
ALTER USER test VALID UNTIL 'NULL';
ALTER USER test VALID UNTIL '';


Me failing to use the "ALTER USER" command successfully caused be to use
the "UPDATE pg_shadow" instead.

Thanks,
-Kristis




view thread (9+ messages)  latest in thread

Message-ID: <200107111751.f6BHpla87781@postgresql.org>
Permalink:  ../200107111751.f6BHpla87781@postgresql.org/
Also on:    postgresql.org/message-id/200107111751.f6BHpla87781@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: kristis.makris@datasoft.com, tgl@sss.pgh.pa.us, pgsql-bugs@postgresql.org, pgsql-odbc@postgresql.org
  Subject: Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
  In-Reply-To: <200107111751.f6BHpla87781@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox