From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com> |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Heads up: does RULES regress test still work for you? |
Date: | 1999-09-28 19:53:40 |
Message-ID: | 199909281953.PAA26568@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Added to TODO list.
>
> Does the following indicate a bug? It sure is wierd. Maybe some of these
> statements aren't supported by postgresql (??), but the outcome doesn't
> make sense to me.
>
> httpd=> CREATE TABLE x (y text);
> CREATE
> httpd=> CREATE VIEW z AS select * from x;
> CREATE
> httpd=> CREATE TABLE a (b text) INHERITS(z);
> CREATE
> httpd=> INSERT INTO x VALUES ('foo');
> INSERT 168602 1
> httpd=> select * from z*;
> y
> ---
> foo
> foo
> (2 rows)
>
> How did we suddenly get two rows??
>
> --
> Chris Bitmead
> http://www.bigfoot.com/~chris.bitmead
> mailto:chris(dot)bitmead(at)bigfoot(dot)com
>
>
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-09-28 20:32:30 | Re: [HACKERS] SYSLOGD facility |
Previous Message | Bruce Momjian | 1999-09-28 18:03:56 | Re: [HACKERS] PG_UPGRADE status |