| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, Bianca Oberst <bianca(dot)oberst(at)gmx(dot)de>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Size of Large objects |
| Date: | 2005-07-26 13:18:51 |
| Message-ID: | 26937.1122383931@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Am Dienstag, 26. Juli 2005 09:55 schrieb Jim C. Nasby:
>> decibel=# create table t(v varchar(1000000000));
>> ERROR: length for type varchar cannot exceed 10485760
> The length you can declare and the size you can store (if a length declaration
> doesn't stop you) are, for various uninteresting reasons, not related.
Also, you can just say "varchar" with no specific length limit, which is
then more or less equivalent to "text".
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edwin Quijada | 2005-07-26 13:19:28 | RE: [pgsql-es-ayuda] ¿Como evitar el "case sensitive"? |
| Previous Message | Peter Eisentraut | 2005-07-26 09:42:48 | Re: Size of Large objects |