From: | "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | TEXT and BLOBS |
Date: | 2000-11-08 13:36:58 |
Message-ID: | 00110810365801.07797@math.unl.edu.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Edward Q. Bridges | 2000-11-08 15:03:30 | Re: default timestamp and default autoinc |
Previous Message | Lorenz Bateman | 2000-11-08 12:21:14 | Re: Speed issues with update |