From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgreSQL(dot)org> |
Subject: | ERROR: copyObject: don't know how to copy 704 |
Date: | 2000-03-04 22:32:07 |
Message-ID: | 20000304143207.C14279@fw.wintelcom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
select
raw.ipaddress,
formatted.ipaddress
from
raw ,
formatted
where
raw.stat_date < '2000-02-26 02:00:24-08'
AND
formatted > '2000-02-26 02:00:24-08'::datetime - '24 hour'::timespan
AND
raw.ipaddress = formatted.ipaddress;
gives this:
NOTICE: unknown node tag 704 in fireRIRonSubselect()
NOTICE: Node is: { IDENT "formatted" }
NOTICE: unknown node tag 704 in modifyAggrefQual()
NOTICE: Node is: { IDENT "formatted" }
ERROR: copyObject: don't know how to copy 704
I recently had a crash, is this because my SQL is broken, or because
of table corruption?
I've dropped and re-created the "formatted" table (DROP/CREATE) and
this still happens.
Any ideas? (i'm using 6.5.3)
thanks,
--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-03-04 22:58:54 | Re: [GENERAL] Transactional logging |
Previous Message | Ed Loehr | 2000-03-04 21:40:14 | Re: [GENERAL] Median, Quartile and Percentile Aggregate Functions |