Re: [BUGS] BUG #5662: Incomplete view - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [BUGS] BUG #5662: Incomplete view
Date
Msg-id 1291639622.10677.12.camel@vanquo.pezone.net
Whole thread Raw
Responses Re: [BUGS] BUG #5662: Incomplete view  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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.


Attachment

pgsql-hackers by date:

Previous
From: Itagaki Takahiro
Date:
Subject: Re: Per-column collation
Next
From: Boxuan Zhai
Date:
Subject: Fwd: new patch of MERGE (merge_204) & a question about duplicated ctid