From: | jwieck(at)debis(dot)com (Jan Wieck) |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org (PostgreSQL HACKERS) |
Subject: | Re: [HACKERS] Open 6.3 issues |
Date: | 1998-02-23 17:08:14 |
Message-ID: | m0y71MV-000BFRC@orion.SAPserv.Hamburg.dsh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> Here is the newest list:
>
> ---------------------------------------------------------------------------
>
> Views on aggregates fail
Uh oh - Aggregates require a group by clause in the select.
This is correctly copied into the query action in the views
pg_rewrite entry. But the rewrite handler doesn't insert it
into the parsetree. Thus a wrong execution plan in built.
I'll try some things, but expect to get into trouble if the
select from the view contains it's own grouping clauses.
Let's see.
> REVOKE ALL ON pg_user FROM PUBLIC crashes if run many times, cache issue(Jan)
Done - sent to Marc - not cvs committed yet!
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #
From | Date | Subject | |
---|---|---|---|
Next Message | Mattias Kregert | 1998-02-23 17:11:50 | Re: [HACKERS] Subselects and NOTs |
Previous Message | Bruce Momjian | 1998-02-23 16:58:09 | Open 6.3 issues |