From: | wieck(at)debis(dot)com (Jan Wieck) |
---|---|
To: | alessio(at)albourne(dot)com (Alessio Bragadini) |
Cc: | pgsql-hackers(at)postgreSQL(dot)org, a(dot)joubert(at)albourne(dot)com |
Subject: | Re: [HACKERS] A bug or a feature? |
Date: | 1999-11-24 02:36:17 |
Message-ID: | m11qSI5-0003kGC@orion.SAPserv.Hamburg.dsh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Alessio F. Bragadini wrote:
> 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:
>
> [...]
>
> '*' 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.
It's a well known limitation in versions up to 6.5.*.
I've lowered the problem in the 7.0 tree by compressing the
rule plan string, using a new data type. A 'SELECT *' view
from a table with 54 fields uses only about 25% of the
available space then.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck(at)debis(dot)com (Jan Wieck) #
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 1999-11-24 03:18:24 | From the LDP web site... |
Previous Message | Jan Wieck | 1999-11-24 02:26:21 | Re: [HACKERS] lztext.c |