[BUGS] BUG: PLPGSQL function causes PgSQL process to die when inserting into a view

2003-10-23 Thread Christopher Travers
Hi all; I have two tables which have different security considerations wrapped into a view. Inserting into the view is done using a simple rule which inserts into both tables (tables have a 1:1 relationship and reflect the user-defined and admin-defined portions of a user profile). From psql,

Re: [BUGS] BUG: PLPGSQL function causes PgSQL process to die when inserting into

2003-10-23 Thread Christopher Travers
Sorry, forgot the version information: 7.3.2 Full schema and example: CREATE TABLE owners_admin ( owner_id integer DEFAULT nextval('"owners_owner_id_seq"'::text) NOT NULL, first_name character varying(15) DEFAULT '', last_name character varying(15) DEFAULT '', login character varying

Re: [BUGS] BUG: PLPGSQL function causes PgSQL process to die when inserting into

2003-10-23 Thread Christopher Travers
My bad; As Tom has pointed out this is a known issue. Thanks. I wonder why my first search didn't find it (probably a typo on my part) :( Best Wishes. _ Try MSN Messenger 6.0 with integrated webcam functionality! http://www.msnm

[BUGS] Behavior at odds with documentation (CREATE USER and SQL language functions)

2003-10-23 Thread Christopher Travers
Hi all; I came across another piece of strange behavior that I wanted to report to you. This appears to be related to previous email disucssions (see http://archives.postgresql.org/pgsql-bugs/2003-04/msg00091.php). Utility statements do not work from SQL language functions. Presumably this i