Re: pg_attribute.attnum - wrong column ordinal?
От
Konstantin Izmailov
Тема
Re: pg_attribute.attnum - wrong column ordinal?
Дата
Msg-id
72746b5e0911242029q1af87603wa0e1fb21e63ceb10@mail.gmail.com
Ответ на
Re: pg_attribute.attnum - wrong column ordinal? (Greg Stark)
Список
Дерево обсуждения
pg_attribute.attnum - wrong column ordinal? Konstantin Izmailov <pgfizm@gmail.com>
Re: pg_attribute.attnum - wrong column ordinal? Greg Stark <gsstark@mit.edu>
Re: pg_attribute.attnum - wrong column ordinal? Alvaro Herrera <alvherre@commandprompt.com>
Re: pg_attribute.attnum - wrong column ordinal? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_attribute.attnum - wrong column ordinal? Peter Eisentraut <peter_e@gmx.net>
Re: pg_attribute.attnum - wrong column ordinal? Konstantin Izmailov <pgfizm@gmail.com>
Re: pg_attribute.attnum - wrong column ordinal? Greg Stark <gsstark@mit.edu>
Re: pg_attribute.attnum - wrong column ordinal? Konstantin Izmailov <pgfizm@gmail.com>
Oops, the server that I thought was 8.3 was recently upgraded to 8.4.
I'm going to generate the ordinals on the client then. The nature of the query is that it can request columns information for all or several tables as well. The ordinals generation algorithm can reset counter to 1 each time the table name changes.
Thank you tons!
On Tue, Nov 24, 2009 at 8:04 PM, Greg Stark <gsstark@mit.edu> wrote:
On Wed, Nov 25, 2009 at 2:00 AM, Konstantin Izmailov <pgfizm@gmail.com> wrote:It's 8.4 only.
> Greg,
> this is brilliant - thank you very much!
>
> Is "partition by" compatible to PostgreSQL 8.0/8.2? I could not find
> compatibility information. It works fine with PG 8.3/8.4 and Greenplum 3.3
> thou.
You could also just generate them on the client since the ordering the
query requests is the right order for it.
--
greg
В списке pgsql-general по дате отправления
От: Greg Smith
Дата:
