| From: | jwieck(at)debis(dot)com (Jan Wieck) |
|---|---|
| To: | maillist(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian) |
| Cc: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] Update Open Items list |
| Date: | 1999-05-12 15:29:14 |
| Message-ID: | m10hawc-000EBaC@orion.SAPserv.Hamburg.dsh.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(at)debis(dot)com (Jan Wieck) #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 1999-05-12 15:30:00 | Re: [HACKERS] defalut value |
| Previous Message | Tom Lane | 1999-05-12 15:20:52 | Re: [HACKERS] Re: [SQL] plpgsql error |