From: | zoulx1982(at)163(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7658: the result of pg_get_viewdef can NOT execute directly |
Date: | 2012-11-14 07:26:08 |
Message-ID: | E1TYXMO-00036L-6u@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 7658
Logged by: ZouLixian
Email address: zoulx1982(at)163(dot)com
PostgreSQL version: 9.2.0
Operating system: Linux
Description:
postgres=#
postgres=# select version();
version
------------------------------------------------------------------------------------------------------------
-------
PostgreSQL 9.2.0 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Asianux 3.0 4.1.2-44),
64-bit
(1 row)
postgres=#
postgres=# create table t1(a int, b int);
CREATE TABLE
postgres=# create table t2(c int, d int);
CREATE TABLE
postgres=# create view v as select * from t1 t where a in (select a from t2
t);
CREATE VIEW
postgres=# select pg_get_viewdef('v');
pg_get_viewdef
------------------------------------------------------------------
SELECT t.a, t.b FROM t1 t WHERE (t.a IN (SELECT t.a FROM t2 t));
(1 row)
postgres=# SELECT t.a, t.b FROM t1 t WHERE (t.a IN (SELECT t.a FROM t2 t));
ERROR: column t.a does not exist
LINE 1: SELECT t.a, t.b FROM t1 t WHERE (t.a IN (SELECT t.a FROM t2 ...
^
postgres=#
postgres=#
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Kuss | 2012-11-14 16:00:08 | Re: BUG #7657: Create Table doesn't create columns |
Previous Message | hubert depesz lubaczewski | 2012-11-13 23:19:48 | Re: BUG #7657: Create Table doesn't create columns |