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

Michael Paquier escribió:

> =# 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.

I wonder if it would be better to have this "seqtab" thing be a dlist,
and move the most recently used item to head position on nextval().
That way we don't have to maintain last_used_seq separately.

I also just noticed that the DISCARD SEQUENCE patch made a "NOTE:"
comment in init_sequence be outdated.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services