pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
does the' text'  type cann't store more than  20,000char ?
2+ messages / 2 participants
[nested] [flat]

* does the' text'  type cann't store more than  20,000char ?
@ 2000-05-31 01:11 xu hai <xvhai@21cn.com>
  2000-05-31 01:49 ` Re: does the' text'  type cann't store more than  20,000char ? Mitch Vincent <mitch@venux.net>
  0 siblings, 1 reply; 2+ messages in thread

From: xu hai @ 2000-05-31 01:11 UTC (permalink / raw)
  To: pgsql-sql

hi .everyine
    when i want put a long file into a field  with text type . i was warning the turple is 
too long  and the table cann't open again.does the' text'  type cann't store more than  about 9,050 char ?
    thank you .
                            xv hai 


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: does the' text'  type cann't store more than  20,000char ?
  2000-05-31 01:11 does the' text'  type cann't store more than  20,000char ? xu hai <xvhai@21cn.com>
@ 2000-05-31 01:49 ` Mitch Vincent <mitch@venux.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Mitch Vincent @ 2000-05-31 01:49 UTC (permalink / raw)
  To: xu hai <xvhai@21cn.com>; +Cc: pgsql-sql

It can't be any larger than 8k (minus a bit of overhead). You can increase
this now to 32k (again, minus the same overhead) by changing BLKSZ to 32k in
the config.h header..

I'm successfully doing this in my database (which is pretty high-traffic and
pretty large).

Good luck!

-Mitch
----- Original Message -----
From: xu hai <xvhai@21cn.com>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, May 30, 2000 9:11 PM
Subject: [SQL] does the' text' type cann't store more than 20,000char ?


> hi .everyine
>     when i want put a long file into a field  with text type . i was
warning the turple is
> too long  and the table cann't open again.does the' text'  type cann't
store more than  about 9,050 char ?
>     thank you .
>                             xv hai
>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-05-31 01:49 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-31 01:11 does the' text'  type cann't store more than  20,000char ? xu hai <xvhai@21cn.com>
2000-05-31 01:49 ` Mitch Vincent <mitch@venux.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox