Re: [HACKERS] Update Open Items list - Mailing list pgsql-hackers

From jwieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] Update Open Items list
Date
Msg-id m10hcQK-000EBbC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to Re: [HACKERS] Update Open Items list  (jwieck@debis.com (Jan Wieck))
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.

    Done.

>
> > 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.

    Done.


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) #

pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] backend dies suddenly after a lot of error messages
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] backend dies suddenly after a lot of error messages