Received: from datasoft.com (maniac.datasoft.com [63.228.155.187]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6BIL4a01120 for ; Wed, 11 Jul 2001 14:21:05 -0400 (EDT) (envelope-from kristis.makris@datasoft.com) Message-Id: <200107111821.f6BIL4a01120@postgresql.org> Received: (qmail 13158 invoked from network); 11 Jul 2001 18:13:41 -0000 Received: from dsco-user.datasoft.com (HELO leonidas.corp.datasoft.com) (63.228.155.190) by maniac.datasoft.com with SMTP; 11 Jul 2001 18:13:41 -0000 Subject: Re: [BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found From: Kristis Makris To: pgsql-sql@postgresql.org In-Reply-To: <24077.994874218@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> <200107111751.f6BHpqJ24043@sss.pgh.pa.us> <24077.994874218@sss.pgh.pa.us> Content-Type: text/plain X-Mailer: Evolution (0.9/+cvs.2001.03.14.20.47 - Preview Release) Date: 11 Jul 2001 11:13:41 -0700 Mime-Version: 1.0 X-Archive-Number: 200107/151 X-Sequence-Number: 3943 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.