From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | ic(at)cms(dot)spb(dot)su (Ivan Crivoruchko) |
Cc: | hackers(at)postgreSQL(dot)org (PostgreSQL-development) |
Subject: | Re: [BUGS] postgresql-6.1.1: losing "distinct" in "create view XXX as select distinct ...". |
Date: | 1998-01-11 21:34:44 |
Message-ID: | 199801112134.QAA12726@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Distinct is now disabled for Views in 6.3. It reports an error and fails.
> Please describe a way to repeat the problem. Please try to provide a
> concise reproducible example, if at all possible:
> ----------------------------------------------------------------------
>
> [ic(at)cms PGconi]$ createdb bugexample
> [ic(at)cms PGconi]$ psql bugexample
> Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
>
> type \? for help on slash commands
> type \q to quit
> type \g or terminate with semicolon to execute query
> You are currently connected to the database: bugexample
>
> bugexample=> create table foo ( x int );
> CREATE
> bugexample=> insert into foo values (1);
> INSERT 3035854
> bugexample=> insert into foo values (1);
> INSERT 3035855
> bugexample=> insert into foo values (2);
> INSERT 3035856
> bugexample=> create view bar as select distinct * from foo;
> CREATE
> bugexample=> select * from bar;
> x
> -
> 1
> 1
> 2
> (3 rows)
>
> bugexample=>
>
>
> If you know how this problem might be fixed, list the solution below:
> ---------------------------------------------------------------------
>
> ?
>
>
>
> ic
>
> P.S. Sorry for my bad english grammatic ... :-(
>
>
--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-01-11 21:35:41 | Re: [BUGS] postgresql-6.1.1: wrong roll-back'ing "drop table" query. |
Previous Message | Bruce Momjian | 1998-01-11 21:33:51 | Re: [BUGS] postgresql-6.1.1: insert into XXX select * from YYY does not working where YYY are view. |