From: Jim C. Nasby <decibel@decibel.org>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Bianca Oberst <bianca.oberst@gmx.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Size of Large objects
Date: Tue, 26 Jul 2005 02:55:43 -0500
Message-ID: <20050726075543.GN29346@decibel.org> (raw)
In-Reply-To: <200507260947.33721.peter_e@gmx.net>
References: <3853.1122359862@www10.gmx.net>
<200507260947.33721.peter_e@gmx.net>
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?
>
> Columns can contain up to 1 GB of data. The terms clob or blob are not used
> in PostgreSQL; the limitation is the same on all column types.
Not entirely true...
decibel=# select version();
PostgreSQL 8.0.3 on powerpc-apple-darwin7.9.0, compiled by GCC gcc
(GCC) 3.3 20030304 (Apple Computer, Inc. build 1495)
decibel=# create table t(v varchar(1000000000));
ERROR: length for type varchar cannot exceed 10485760
decibel=#
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: decibel@decibel.org, peter_e@gmx.net, bianca.oberst@gmx.de
Subject: Re: Size of Large objects
In-Reply-To: <20050726075543.GN29346@decibel.org>
References: <3853.1122359862@www10.gmx.net> <200507260947.33721.peter_e@gmx.net> <20050726075543.GN29346@decibel.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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