> -----Original Message-----
> From: Carolyn Lu Wong [mailto:carolyn@greatpacific.com.au]
>
> I get the same error when running in the sql. And when try to delete
> data from tmp_table, get ERROR: ExecutePlan: (junk) `ctid' is NULL.
I'm afraid of a table corruption.
Doesn't select * from table1(tmp_table) where ... return a
strange result ?
regards,
Hiroshi Inoue
>
> Hiroshi Inoue wrote:
> >
> > Carolyn Lu Wong wrote:
> > >
> > > I'm using VB5 connecting to PostgreSQL via PsqlODBC V6.50.
> > >
> > > When running the following sQL, got above ODBC failed error:
> > >
> > > insert into tmp_table
> > > select oid, * from table1
> > > where ....;
> >
> > Is it an ODBC's problem ?
> > How is the result when you call the above query
> > in psql ?
> >
> > regards,
> > Hiroshi Inoue