In this week's General Bits, we talk about using
large objects. Perhaps this might help you understand
what is involved with using them.
http://www.varlena.com/GeneralBits/
cheers,
[EMAIL PROTECTED]
On Thu, Sep 25, 2003 at 09:41:28AM +0530, Kumar wrote:
> Hi Friends,
>
> I am running Postgre
Hi, Friends !
On Thursday 25 September 2003 08:11, you wrote:
> I am migrating MS SQL DB to Postgres DB. I have tables with columns of data
> type 'Image' in the MS SQL database. IF I choose 'bytea' datatype, I am
> afraid it may lead to poor performance of the database (which I read from
> the m
Hi Friends,
I am running Postgres 7.3.4 on RH Linux 7.2.
I am migrating MS SQL DB to Postgres DB. I have tables with
columns of data type 'Image' in the MS SQL database.
IF I choose 'bytea' datatype, I am afraid it may lead to poor
performance of the database (which I read from the manua
Hi,
I'm handling large objects from JDBC in a servlet environment. Every
time we create a lo we also create a row in the zp_file table that
holds additional information about the file, as well as the oid of
the large object:
Column | Type | Modifiers
-+
You must be logged in as the unix user postgres.
(Presuming /home/postgres/ is writable by postgres and
the file doesn't exist.)
Try doing
touch /home/postgres/junk.tgz
from the command line. It should also fail.
Troy
>
>
> Hi to list !
>
> while running psql as 'postgres' user, i exec
I couldn't find the documentation for dealing with Large Objects on
the documentation. Any pointers?
The only info I found on Large Objects was on the programming guide,
but I'm not looking to write C functions with largo objects.
Thanks,
-Roberto
--
+| http:
FROM test.pl of DBD-Pg-0.93.tar ...
# test large objects
# create large object from binary file
my ($ascii, $pgin);
foreach $ascii (0..255) {
$pgin .= chr($ascii);
};
my $PGIN = '/tmp/pgin';
open(PGIN, ">$PGIN") or die "can not open $PGIN";
print PGIN $pgin;
close
Hi,
Could someone please provide a demo of creating the type "Lo".
Regards,
Craig May
Enth Dimension
http://www.enthdimension.com.au
