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