Skip site navigation (1) Skip section navigation (2)

Re: Can't modify a view when in phpPgAdmin

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Csanyi Pal <csanyipal(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Can't modify a view when in phpPgAdmin
Date: 2012-07-25 22:21:48
Message-ID: 5364.1343254908@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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 PalDate: 2012-07-26 05:11:26
Subject: How to get dow in Hungarian?
Previous:From: Tom LaneDate: 2012-07-25 21:53:59
Subject: Re: Is there an answer to the Ultimate Question for PostgreSQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group