Re: [COMMITTERS] pgsql: Add DISCARD SEQUENCES command.

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Kevin Hale Boyes <kcboyes(at)gmail(dot)com>, Robert Haas <rhaas(at)postgresql(dot)org>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [COMMITTERS] pgsql: Add DISCARD SEQUENCES command.
Date: 2013-10-08 06:52:08
Message-ID: CAB7nPqQi1iqqT=_zEMaNROK15xqo19RwkTB8bt4FKL2kttR6Dw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Tue, Oct 8, 2013 at 4:57 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Sat, Oct 5, 2013 at 8:10 AM, Michael Paquier
> <michael(dot)paquier(at)gmail(dot)com> wrote:
>> Here is the test case failing:
>> =# create sequence foo;
>> CREATE SEQUENCE
>> =# select nextval('foo');
>> nextval
>> ---------
>> 1
>> (1 row)
>> =# discard sequences ;
>> DISCARD SEQUENCES
>> =# select currval('foo');
>> ERROR: 55000: currval of sequence "foo" is not yet defined in this session
>> LOCATION: currval_oid, sequence.c:780
>> =# select lastval();
>> The connection to the server was lost. Attempting reset: Failed.
>
> Thanks. I have pushed a fix that I hope will be sufficient.
It is fine now. Thanks for the fix.
--
Michael

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2013-10-08 13:48:35 pgsql: Update instructions on creating minor release notes.
Previous Message KONDO Mitsumasa 2013-10-08 04:25:30 Re: pgsql: docs: update release notes for 8.4.18, 9.0.14, 9.1.10, 9.2.5, 9

Browse pgsql-hackers by date

  From Date Subject
Next Message Atri Sharma 2013-10-08 07:17:10 Re: Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption
Previous Message David Fetter 2013-10-08 06:16:56 CREATE FOREIGN TABLE ( ... LIKE ... )