Thread: Re: [COMMITTERS] pgsql: Implement remaining fields of information_schema.sequences view

peter_e@gmx.net (Peter Eisentraut) writes:
> Implement remaining fields of information_schema.sequences view
>
> Add new function pg_sequence_parameters that returns a sequence's start,
> minimum, maximum, increment, and cycle values, and use that in the view.
> (bug #5662; design suggestion by Tom Lane)
>
> Also slightly adjust the view's column order and permissions after review of
> SQL standard.


http://git.postgresql.org/gitweb?p=postgresql.git;a=blobdiff;f=src/backend/catalog/information_schema.sql;h=5b8b9417701a06b423636fe8b6e4bff91f1aa563;hp=090c10c3220e6f8b41f60ad83135830206417de4;hb=39b88432968a2f4c01c20948f12bf9c8e388474d;hpb=e657b55e661577cf664949bce78068e2922f594f

Is there a particular reason that the start/min/max/inc values are now
being cast to character_data, rather than integer, as they have been?  I
have some views I'm using that just broke because of this.

I'd rather not work around this if it's not necessary, and it doesn't
seem to make sense for these values to be of other than a numeric type
(and likely BIGINT, as that's what pg_sequence_parameters() returns).
-- 
(reverse (concatenate 'string "ofni.secnanifxunil" "@" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/slony.html
E.V.A., pod 5, launching...