Re: pyPgSQL error

Looks like you don't have plpgsql language installed in that database,
or you did, and the file is now missing:

> libpq.OperationalError: ERROR:  stat failed on file
> '/usr/local/pgsql-7.2/lib/plpgsql': No such file or directory

---------------------------------------------------------------------------

Laurette Cisneros wrote:
> 
> I'm using 7.2.3 and I've compile --with-python
> 
> Anyone know what could cause this error when trying to delete a row in
> python using pyPgSQL?
> 
> Traceback (most recent call last):
>   File "./2_12_jobgen.py", line 497, in ?
>     job2db(dbConn,jobList,pathEntryList)
>   File "./2_12_jobgen.py", line 66, in job2db
>     curs.execute("""delete from jobsequences
>   File "/usr/local/lib/python2.2/site-packages/pyPgSQL/PgSQL.py", line
> 2590, in execute    raise OperationalError, msg
> libpq.OperationalError: ERROR:  stat failed on file
> '/usr/local/pgsql-7.2/lib/plpgsql': No such file or directory
> 
> Thanks,
> 
> -- 
> Laurette Cisneros
> The Database Group
> (510) 420-3137
> NextBus Information Systems, Inc.
> www.nextbus.com
> ----------------------------------
> Life is an SQL old chum...
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073