|
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" <[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 KEY ("sysid") > ) > WITH OIDS; > ALTER TABLE t_data_pic OWNER TO admin; Why am I not seeing any trigger attached to this table? That lo_manage trigger is the useful part of contrib/lo --- the separate data type is mere window dressing. regards, tom lane |
