Horton

Re: [HACKERS] Update Open Items list

Jan Wieck <jwieck@debis.com>

View thread
From: jwieck@debis.com (Jan Wieck)
To: maillist@candle.pha.pa.us (Bruce Momjian)
Cc: pgsql-hackers@postgreSQL.org
Date: 1999-05-12T15:29:14Z
Lists: pgsql-hackers 
> CREATE VIEW ignores DISTINCT?

    Will  not  be  fixed in v6.5. I'll add an elog(ERROR, ...) to
    reject those view definitions during CREATE VIEW.

> CREATE TABLE t1 (a int4, b int4); CREATE VIEW v1 AS SELECT b, count(b)
>    FROM t1 GROUP BY b; SELECT count FROM v1; fails

    Fixed.

    SELECT b FROM v1; still fails with

    ERROR:  union_planner: query is marked hasAggs, but I don't see any

    Must adjust hasAggs as final step in rewriter.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #