Re: [GENERAL] ERROR: copyObject: don't know how to copy 704 - Mailing list pgsql-general

* 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