> 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;
> DELETE
> FROM T1
> WHERE Count = 1;
> -- It hangs on the last statement above
>
Looks like someone fixed it in the current tree at least:
test=> BEGIN;
BEGIN
test=> SELECT A, COUNT(*)
test-> INTO TEMP T1
test-> FROM Test
test-> GROUP BY A;
SELECT
test=> DELETE
test-> FROM T1
test-> WHERE Count = 1;
DELETE 2
--
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
************
