Re: Reordering columns in a table - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Reordering columns in a table
Date
Msg-id 20060106200045.GE1989@kaufbach.delug.de
Whole thread Raw
In response to Re: Reordering columns in a table  (John McCawley <nospam@hardgeus.com>)
List pgsql-general
John McCawley <nospam@hardgeus.com> schrieb:

> OK, one last question on the subject and I'll shut up.  I would assume that
> all dependent database objects are also dropped when you drop the table, so
> you'd have to recreate all of your foreign keys (both directions) and
> triggers etc.?

Um, yes, this may be a problem. I don't know a practicable solution.
As i said, attach new columns at the end and formulate useful SELECT's and
INSERT's. Or, see also "Joshua D. Drake", create VIEWS.


>
> Andreas Kretschmer wrote:

Btw.: Top Posting with Fullquote Below (german: TOFU) are silly...
(-> http://learn.to/quote)


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Wes
Date:
Subject: ./configure --with-openssl=path fails
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Indexes works only on miss