Re: pg_attribute.attnum - wrong column ordinal?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_attribute.attnum - wrong column ordinal?
Date: 2009-11-25 03:04:02
Message-ID: 407d949e0911241904t5c11b373n9af9acdd370b460@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wed, Nov 25, 2009 at 2:00 AM, Konstantin Izmailov <pgfizm(at)gmail(dot)com> wrote:
> 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.

It's 8.4 only.

You could also just generate them on the client since the ordering the
query requests is the right order for it.

--
greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Konstantin Izmailov 2009-11-25 04:29:16 Re: pg_attribute.attnum - wrong column ordinal?
Previous Message Scott Marlowe 2009-11-25 02:19:12 Re: Processing Delay

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2009-11-25 03:12:15 Re: Hot standby and removing VACUUM FULL
Previous Message Itagaki Takahiro 2009-11-25 02:55:32 Re: SE-PgSQL patch review