Re: [COMMITTERS] pgsql: Add DISCARD SEQUENCES command. - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [COMMITTERS] pgsql: Add DISCARD SEQUENCES command.
Date
Msg-id CAB7nPqQi1iqqT=_zEMaNROK15xqo19RwkTB8bt4FKL2kttR6Dw@mail.gmail.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Add DISCARD SEQUENCES command.  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Tue, Oct 8, 2013 at 4:57 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Sat, Oct 5, 2013 at 8:10 AM, Michael Paquier
> <michael.paquier@gmail.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



pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: CREATE FOREIGN TABLE ( ... LIKE ... )
Next
From: Kevin Grittner
Date:
Subject: drop-index-concurrently-1 on master fails at serializable