Re: logical column position

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Jon Jensen <jon(at)endpoint(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: logical column position
Date: 2003-11-18 01:24:12
Message-ID: 3FB974BC.8030108@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Right -- AFAICS, the only change in COPY compatibility would be if you
> COPY TO'd a table and then changed the logical column order in some
> fashion, you would no longer be able to restore the dump (unless you
> specified a column list for the COPY FROM -- which, btw, pg_dump
> does). I don't think it will be a problem, I just thought I'd mention
> it.

Well it's the same problem as if you'd dropped a column in the middle of
the table.

BTW, one main consideration is that all the postgres admin apps will now
need to support ORDER BY attlognum for 7.5+.

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2003-11-18 01:36:08 help!
Previous Message Peter Eisentraut 2003-11-18 01:21:45 Re: Release cycle length