On 24.11.2011 11:44, [email protected] wrote:
PostgreSQL version: 8.4 ... Selecting (nonexistant) column 'name' or 'varchar' results in an error. Selecting qualified nonexistant columns 'name' or 'varchar', you get the record as record. The view definition shows * casted to name or varchar.db=# create temp table tmp_table (a int, b text); CREATE TABLE db=# create view v_tmp as select name from tmp_table; FEHLER: Spalte »name« existiert nicht ZEILE 1: create view v_tmp as select name from tmp_table; ^ db=# create view v_tmp as select tmp_table.name, tmp_table.varchar from tmp_table;
See: http://archives.postgresql.org/pgsql-sql/2011-08/msg00028.php -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
