"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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend