| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2006-03-21 08:21:20 | Re: Future versions of psqlODBC |
| Previous Message | Andreas | 2006-03-20 18:22:53 | Re: Future versions of psqlODBC |