Re: [GENERAL] trouble with on insert rule via libpg-perl

2004-12-11 Thread Ron Peterson
On Fri, Dec 10, 2004 at 11:26:09PM -0500, Ron Peterson wrote: > I have a simple table, a view, and an on insert rule. These work fine, > ordinarily. But when I attempt to to insert a value into thesis_ps_v > via libpq_sql, nothing happens. Fixed. I didn't set the schema search path properly in

[GENERAL] trouble with on insert rule via libpg-perl

2004-12-10 Thread Ron Peterson
I have a simple table, a view, and an on insert rule. These work fine, ordinarily. But when I attempt to to insert a value into thesis_ps_v via libpq_sql, nothing happens. If I capture the sql string I'm sending (as per code sample below), print it to a file, and paste it into a psql session, it

Re: [GENERAL] trouble with on insert rule via libpg-perl

2004-12-10 Thread Ron Peterson
On Fri, Dec 10, 2004 at 11:26:09PM -0500, rpeterso wrote: I should have mentioned... PostgreSQL versions 8.0.0beta5 and 7.4.6 libpq-perl 2.0.2 perl 5.8.4 -- Ron Peterson Network & Systems Manager Mount Holyoke College http://www.mtholyoke.edu/~rpeterso ---(end of broadc