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

From Robert Haas
Subject Re: [COMMITTERS] pgsql: Add DISCARD SEQUENCES command.
Date
Msg-id CA+TgmobsHk56uqMWrPHUvJ9yuN3+hiHRjRTj0AiQRzpvqE_iPA@mail.gmail.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Add DISCARD SEQUENCES command.  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [COMMITTERS] pgsql: Add DISCARD SEQUENCES command.  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
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.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption
Next
From: Kevin Grittner
Date:
Subject: Re: SSI freezing bug