From: | Alessio Bragadini <alessio(at)albourne(dot)com> |
---|---|
To: | PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Adriaan Joubert <a(dot)joubert(at)albourne(dot)com> |
Subject: | A bug or a feature? |
Date: | 1999-11-23 18:03:48 |
Message-ID: | 383AD704.C464CC26@albourne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
We have a table with ~30 columns, named 'people' and we were going to
create a view for all record with 'relationship' equal to 1. The
database complains where using the '*' placeholder:
albourne=> CREATE VIEW employees AS SELECT * FROM people WHERE
relationship = 1;
ERROR: DefineQueryRewrite: rule plan string too big.
but accepts the same 30 columns on the command:
albourne=> create view employees as select
id,title,first_name,middle_name,last_name,suffix,company,job_title,address,city,zipcode,country,home_phone,home_fax,mobile,bus_phone,bus_fax,other_phone,e_mail_1,e_mail_2,url,birthday,christmas,brochure,golf,croquet,comment
from people where relationship=1;
CREATE
'*' is SQL92 (I think) so is this a bug or a known limitation?
The system is PostgreSQL 6.5.2 on alphaev6-dec-osf4.0f, compiled by cc.
Thanks
Alessio
--
Alessio F. Bragadini alessio(at)albourne(dot)com
APL Financial Services http://www.sevenseas.org/~alessio
Nicosia, Cyprus phone: +357-2-750652
You are welcome, sir, to Cyprus. -- Shakespeare's "Othello"
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-11-23 18:04:14 | Re: SQL statements: begin and end |
Previous Message | Bruce Momjian | 1999-11-23 18:01:02 | Re: AW: AW: [HACKERS] Getting OID in psql of recent insert |