| 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: | Whole Thread | Raw Message | 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 |