The lib I use is call lo_in and lo_out for manage BLOB.
I understand that lo_unlink be related with lo_import and lo_export so I don't think that it work.>>> Richard Huxton 07-Oct-05 14:30:05 pm >>>Premsun Choltanwanich wrote:> > Dear All,> > I use '$libdir/lo' for manage my PostgreSQL Large
Premsun Choltanwanich wrote:
The lib I use is call lo_in and lo_out for manage BLOB.
I understand that lo_unlink be related with lo_import and lo_export so I
don't think that it work.
If you are using the contrib/lo library, then README.lo mentions:
* Some frontends may create their own ta
The code that show below is refered to table and function that I use for kept BLOB (LO).
CREATE TABLE t_data_pic( "sysid" bigserial NOT NULL, data_sysid int8 NOT NULL, data_pic lo, CONSTRAINT t_data_pic_pkey PRIMARY KEY ("sysid")) WITH OIDS;ALTER TABLE t_data_pic OWNER TO admin;
CREATE OR
"Premsun Choltanwanich" <[EMAIL PROTECTED]> writes:
> The code that show below is refered to table and function that I use for =
> kept BLOB (LO).
>
> CREATE TABLE t_data_pic
> (
> "sysid" bigserial NOT NULL,
> data_sysid int8 NOT NULL,
> data_pic lo,
> CONSTRAINT t_data_pic_pkey PRIMARY
Sorry that I forgot to sent you trigger on my database.
CREATE OR REPLACE FUNCTION lo_manage() RETURNS "trigger" AS'$libdir/lo', 'lo_manage' LANGUAGE 'c' VOLATILE;ALTER FUNCTION lo_manage() OWNER TO postgres;
>>> Tom Lane <[EMAIL PROTECTED]> 11-Oct-05 10:00:53 am >>>"Premsun Choltanwanich"
