Thread: Re: [BUGS] BUG #5662: Incomplete view

On sön, 2010-09-19 at 14:28 -0400, Tom Lane wrote:
> Or maybe we could implement that function, call it like this
>
>            CAST((pg_sequence_parameters(c.oid)).max_value AS
> cardinal_number) AS maximum_value,
>
> and plan on optimizing the view when we get LATERAL.

Here is an implementation of that.

I'm not exactly sure if the accesses to the sequence are correctly
locked/unlocked, but it appears to work.

I also revised the definition of the info schema view slightly, after
juggling several more recent SQL standard drafts.

On mån, 2010-12-06 at 14:47 +0200, Peter Eisentraut wrote:
> On sön, 2010-09-19 at 14:28 -0400, Tom Lane wrote:
> > Or maybe we could implement that function, call it like this
> > 
> >            CAST((pg_sequence_parameters(c.oid)).max_value AS
> > cardinal_number) AS maximum_value,
> > 
> > and plan on optimizing the view when we get LATERAL.
> 
> Here is an implementation of that.

Committed.