Martijn van Oosterhout wrote:
On Thu, Aug 14, 2008 at 05:57:26PM -0500, Decibel! wrote:
FWIW, there is desire to be able to re-order columns within real
tables, too. But before that can happen we need to divorce
presentation order from on-page order (which is actually desirable
for oth
On Thu, Aug 14, 2008 at 05:57:26PM -0500, Decibel! wrote:
> FWIW, there is desire to be able to re-order columns within real
> tables, too. But before that can happen we need to divorce
> presentation order from on-page order (which is actually desirable
> for other reasons), but that's an aw
On Jul 29, 2008, at 9:12 PM, Robert Haas wrote:
Unfortunately, it looks to me like a fully general implementation of
this feature would be Really Hard, because a CREATE OR REPLACE VIEW
command, beyond attempting to add, drop, or retype columns, could also
attempt to reorder them. A cursory inspe
I've been thinking a little more about modifying views:
http://archives.postgresql.org/pgsql-hackers/2008-05/msg00694.php
AFAICS, out of all of the things that ALTER TABLE is capable of doing,
there are only four that make any sense in the context of views:
(1) add a column
(2) drop a column
(3)
