Re: TEXT and BLOBS - Mailing list pgsql-general

From Ben Souther
Subject Re: TEXT and BLOBS
Date
Msg-id 026a01c04b31$fa002c90$0264000a@redtrainint.com
Whole thread Raw
In response to TEXT and BLOBS  ("Martin A. Marques" <martin@math.unl.edu.ar>)
List pgsql-general
----- Original Message -----
From: Martin A. Marques <martin@math.unl.edu.ar>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, November 08, 2000 8:36 AM
Subject: [GENERAL] TEXT and BLOBS


> I want to find out how confused I am. ;-)
> I'm testing something on a Postgres 7.0.2 database. I made a small table
with
> two columns, one serial and the other TEXT, and tried to make serveral
> inserts with PHP.
> Some went OK, until I tried to insert a large amount of text. It failed.
Of
> course, I did it on porpose to check the 8 K tuple limitation.
> Until here, am I right?
> So, now I'm gonna try to make inserts to a table just like the other one,
but
> with the slight change of making the text column a oid column.
> The questions are:
> 1) where are the blobs stored?
> 2) Is it posible to insert a chunk of text that has not been saved to a
file?
> 3) where is all the documentation on the behave of BLOBS? All I have found
> was in Bruce's book. I couldn't find such things in the users
documentations.
>
> TIA
>
> --
> "And I'm happy, because you make me feel good, about me." - Melvin Udall
> -----------------------------------------------------------------
> Martín Marqués email: martin@math.unl.edu.ar
> Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> Administrador de sistemas en math.unl.edu.ar
> -----------------------------------------------------------------
>


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Increasing the number of semaphores on FreeBSD 4.1 (clarification)
Next
From: "Vilson farias"
Date:
Subject: No Luck -> Re: Sequencial scan over primary keys