Re: [HACKERS] A bug or a feature?

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@debis.com (Jan Wieck) #