Re: patch: Add columns via CREATE OR REPLACE VIEW - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: patch: Add columns via CREATE OR REPLACE VIEW
Date
Msg-id 20080807154908.GI4171@alvh.no-ip.org
Whole thread Raw
In response to Re: patch: Add columns via CREATE OR REPLACE VIEW  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: patch: Add columns via CREATE OR REPLACE VIEW  ("Robert Haas" <robertmhaas@gmail.com>)
List pgsql-hackers
Tom Lane escribió:

> But it seems hard to tell the difference between a "rename" and a
> "drop".  I think that we aren't going to get far on this until we
> decide what we will consider to be the identity of a view column.
> With regular tables the attnum is a persistent identifier, but that
> doesn't seem to play nicely for REPLACE VIEW, at least not if you're
> wanting to allow people to remove columns from their view definitions.

Hmm, maybe we need to pull off the project to separate logical attribute
number from physical and position.  It sounds like it could make it
easier for view modification.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Infrastructure changes for recovery
Next
From: Simon Riggs
Date:
Subject: Re: Infrastructure changes for recovery