Обсуждение: Can't modify a view when in phpPgAdmin

Hi,

I have installed
PostgreSQL 9.1.4
phpPgAdmin 5.0.4

I have a database and in it many tables and so far just one view.

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?

Maybe this isn't the right mailing list for this question?

--
Regards from Pal

Csanyi Pal <csanyipal@gmail.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