Re: [HACKERS] Update Open Items list - Mailing list 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) #