Re: [ADMIN] Size of Large objects

2005-07-26 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Am Dienstag, 26. Juli 2005 09:55 schrieb Jim C. Nasby: >> decibel=# create table t(v varchar(10)); >> ERROR: length for type varchar cannot exceed 10485760 > The length you can declare and the size you can store (if a length > declaration >

Re: [ADMIN] Size of Large objects

2005-07-26 Thread Peter Eisentraut
Am Dienstag, 26. Juli 2005 09:55 schrieb Jim C. Nasby: > decibel=# create table t(v varchar(10)); > 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 reas

Re: [ADMIN] Size of Large objects

2005-07-26 Thread Bianca Oberst
Okay, thanks! Bianca > --- Ursprüngliche Nachricht --- > Von: Peter Eisentraut <[EMAIL PROTECTED]> > An: "Bianca Oberst" <[EMAIL PROTECTED]> > Kopie: pgsql-admin@postgresql.org > Betreff: Re: [ADMIN] Size of Large objects > Datum: Tue, 26 Jul 2005 09:47:

Re: [ADMIN] Size of Large objects

2005-07-26 Thread Jim C. Nasby
On Tue, Jul 26, 2005 at 09:47:33AM +0200, Peter Eisentraut wrote: > Am Dienstag, 26. Juli 2005 08:37 schrieb Bianca Oberst: > > I'm new in postgres. I searched the archives, but I don't find an answer. > > So can anybody tell me the explicit size, which a clob or a blob can have > > in postgres 8.0

Re: [ADMIN] Size of Large objects

2005-07-26 Thread Peter Eisentraut
Am Dienstag, 26. Juli 2005 08:37 schrieb Bianca Oberst: > I'm new in postgres. I searched the archives, but I don't find an answer. > So can anybody tell me the explicit size, which a clob or a blob can have > in postgres 8.0? Columns can contain up to 1 GB of data. The terms clob or blob are not

[ADMIN] Size of Large objects

2005-07-25 Thread Bianca Oberst
Hello, I'm new in postgres. I searched the archives, but I don't find an answer. So can anybody tell me the explicit size, which a clob or a blob can have in postgres 8.0? Thank you, Bianca -- 5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail +++ GMX - die erste Adresse f�r Mail, Mess