Postgres Pro
Downloads
Home   >   mailing lists

Thread: Tuple is too big: size 524592

Tuple is too big: size 524592

From
Carolyn Lu Wong
Date:
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 ....;

What could be the problem?

Re: Tuple is too big: size 524592

From
Hiroshi Inoue
Date:
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

Re: Tuple is too big: size 524592

From
Tom Lane
Date:
Carolyn Lu Wong <carolyn@greatpacific.com.au> writes:
> What could be the problem?

Postgres too old?  Versions before 7.1 don't support wide fields.

            regards, tom lane

Re: Tuple is too big: size 524592

From
Carolyn Lu Wong
Date:
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

Re: Tuple is too big: size 524592

From
"Hiroshi Inoue"
Date:
> -----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