Re: Accessing schema data in information schema

Tom Lane wrote:

>Given the thought that we need both
>transactional and nontransactional state for a sequence, I'm kind of
>inclined to leave the transactional data in pg_class.  We could still
>imagine putting the nontransactional state into a new pg_sequence
>catalog indexed by, say, the pg_class OID of the sequences.  OTOH I'm
>not sure how much that buys for Peter's problem --- it might be better
>for him just to invent some functions that can grab the required data
>given the sequence OID.
>
>            
>

Yes, this seems a lot of lifting for a fairly small need. If there 
aren't other advantages, a simple function or two seems a better way to 
go, and then there are no legacy problems.

cheers

andrew