[ADMIN] RE: [ADMIN] CREATE LANGUAGE cannot load libra ry ERROR!

2008-04-10 Thread Vishal Arora
set $libdir path in environmental variables in windows. Date: Wed, 9 Apr 2008 00:32:10 +0800From: [EMAIL PROTECTED]: [ADMIN] CREATE LANGUAGE cannot load library ERROR!To: [EMAIL PROTECTED]: [EMAIL PROTECTED]; [EMAIL PROTECTED] Hi: I am rather new to PostgreSQL and so have probably done

[ADMIN] updating table with foreign keys cause locking of referenced row/table?

2008-04-10 Thread Jeff Frost
Postgresql-8.3.1 I have a plpgsql function which is called nightly to update rows in a summary table. The summary table has foreign keys that reference the users table. When the nightly job runs, the users table gets locked such that UPDATES to the user table are stuck waiting on the transact