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

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@wintelcom.net|alfred@freebsd.org]

Table schema? Data?

Alfred Perlstein writes:

> 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,
>

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

* Peter Eisentraut <peter_e@gmx.net> [000305 06:44] wrote:
> Table schema? Data?

*smacks head on keyboard* ... Ed Loehr pointed out a mistake:

>
> Alfred Perlstein writes:
>
> > 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

-----^^^^^^^^^^    fieldname? :)

> >   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

However this error message is a bit more scary than it needs to be, no? :)

thanks,
-Alfred