Csanyi Pal <csanyipal(at)gmail(dot)com> writes:
> When in phpPgAdmin I can't modify the existing view.
> I get the message:
> ERROR: cannot change name of view column "az els nap" to "els nap"
> Why can't I modify the view when in phpPgAdmin?
I don't think this has anything to do with phpPgAdmin; it's a safety
check built into CREATE OR REPLACE VIEW.
Try using ALTER TABLE viewname RENAME COLUMN x TO y;
(Not sure why ALTER VIEW doesn't have this variant, but that's
just a cosmetic detail. ALTER TABLE will work.)
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Csanyi Pal||Date: 2012-07-26 05:11:26|
|Subject: How to get dow in Hungarian?|
|Previous:||From: Tom Lane||Date: 2012-07-25 21:53:59|
|Subject: Re: Is there an answer to the Ultimate Question for PostgreSQL?|