From: | "" <karacho(at)kommespaeter(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6306: sql parser: weird behaviour when selecting tablename.'name' from a table |
Date: | 2011-11-24 09:44:48 |
Message-ID: | 201111240944.pAO9imQB065672@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 6306
Logged by:
Email address: karacho(at)kommespaeter(dot)de
PostgreSQL version: 8.4
Operating system: Windows XP
Description: sql parser: weird behaviour when selecting
tablename.'name' from a table
Details:
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;
HINWEIS: Sicht »v_tmp« wird eine temporäre Sicht
CREATE VIEW
db=# \d v_tmp
Sicht »pg_temp_1.v_tmp«
Spalte | Typ | Attribute
---------+-------------------+-----------
name | name |
varchar | character varying |
Sichtdefinition:
SELECT tmp_table.*::name AS name, tmp_table.*::character varying AS
"varchar"
FROM tmp_table;
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2011-11-24 10:23:09 | Re: BUG #6304: initdb fails with loale ko_KR.eucKR |
Previous Message | Tom Lane | 2011-11-23 18:07:36 | Re: Repeatable crash in pg_dump (with -d2 info) |