ERROR: copyObject: don't know how to copy 704

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]

Responses

Browse pgsql-general by date

  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