Skip site navigation (1) Skip section navigation (2)

problem about maximum row size ?

From: zhaoxin <zhaox(at)necas(dot)nec(dot)com(dot)cn>
To: pgsql-odbc(at)postgresql(dot)org
Subject: problem about maximum row size ?
Date: 2006-03-21 07:32:47
Message-ID: 441FAC1F.8040900@necas.nec.com.cn (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi ALL ,

I have a question about maximum row size .
In pgsql FAQ, I can find this description :
  ...
  Maximum size for a row? 1.6TB
  ...

does it mean 1600 text column in a table and 1G every column ?

but, when I test this case by psqlodbc, I got some error :

1.create table testMaxRowSize(c1 text, c2 text, ......c1599 text, c1600
text)
2.insert into testMaxRowSize values('1','2',......'1599','1600')

3.error occurred:
  --ERROR:  row is too big: size 12832, maximum size 8136

does it mean maximum row size 8136 ?
and int4 is 4 bytes , int8 is 8 bytes , and char ,varchar , text is 20
bytes , ......?

if it is true , then how can I reach the max maximum size 1.6T in FAQ????

I want to test this case , can you help me ??

Regards, Zhao.

Responses

pgsql-odbc by date

Next:From: Dave PageDate: 2006-03-21 08:21:20
Subject: Re: Future versions of psqlODBC
Previous:From: AndreasDate: 2006-03-20 18:22:53
Subject: Re: Future versions of psqlODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group