On 24.11.2011 11:44, karacho@kommespaeter.de 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