Re: [BUGS] BUG #5662: Incomplete view

2010-09-22 Thread Tom Lane
Peter Eisentraut writes: > On sön, 2010-09-19 at 14:28 -0400, Tom Lane wrote: >> which would do an appropriate permissions check and then fetch the >> named column. (This could actually be implemented in a line or two in >> plpgsql, but I think we want it in C because information_schema >> shoul

Re: [BUGS] BUG #5662: Incomplete view

2010-09-22 Thread Peter Eisentraut
On sön, 2010-09-19 at 14:28 -0400, Tom Lane wrote: > What about inventing a function to extract a sequence's parameters? > Perhaps something like > > pg_sequence_parameter(seq regclass, colname text) returns > bigint > > which would do an appropriate permissions check and then fetch the >

Re: [BUGS] BUG #5662: Incomplete view

2010-09-19 Thread Tom Lane
Peter Eisentraut writes: > On sön, 2010-09-19 at 09:41 +, saer...@hotmail.com wrote: >> The Sequence view in the information schema is incomplete. It does not >> return a Sequence's maximum_value, minimum_value or increment. Please >> complete the view. > This is known and documented: > http

Re: [BUGS] BUG #5662: Incomplete view

2010-09-19 Thread Peter Eisentraut
On sön, 2010-09-19 at 09:41 +, saer...@hotmail.com wrote: > The Sequence view in the information schema is incomplete. It does not > return a Sequence's maximum_value, minimum_value or increment. Please > complete the view. This is known and documented: http://www.postgresql.org/docs/8.4/stati