> On Wed, 4 Aug 1999, Bruce Momjian wrote:
>
> > Please send a reproducable sample, with CREATE TABLE, INSERT, etc.
>
> My table is rather large so here's one small sample. This one doesn't
> crash, but it hangs on DELETE using up 100% CPU. This one is tested on
> FreeBSD 3.2-STABLE.
>
> CREATE TABLE Test (
> A INTEGER
> );
>
> INSERT INTO Test VALUES (1);
> INSERT INTO Test VALUES (1);
> INSERT INTO Test VALUES (2);
> INSERT INTO Test VALUES (2);
> INSERT INTO Test VALUES (3);
> INSERT INTO Test VALUES (4);
>
> -- Quit psql and start another session:
>
> BEGIN;
> SELECT A, COUNT(*)
> INTO TEMP T1
> FROM Test
> GROUB BY A;
^P
> DELETE
> FROM T1
> WHERE Count = 1;
> -- It hangs on the last statement above
Yes, I see there is a problem. Fortunately, this is the first TEMP bug
in 6.5.1. Not sure on a cause.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
