From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Laurette Cisneros <laurette@nextbus.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: pyPgSQL error
Date: Tue, 14 Jan 2003 19:55:48 -0500 (EST)
Message-ID: <200301150055.h0F0tmL19325@candle.pha.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.44.0301141642190.977-100000@visor.corp.nextbus.com>
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, Pennsylvania 19073
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: pgman@candle.pha.pa.us, laurette@nextbus.com
Subject: Re: pyPgSQL error
In-Reply-To: <200301150055.h0F0tmL19325@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox