pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpyPgSQL error
3+ messages / 2 participants
[nested] [flat]
* pyPgSQL error
@ 2003-01-15 00:42 Laurette Cisneros <laurette@nextbus.com>
0 siblings, 1 reply; 3+ messages in thread
From: Laurette Cisneros @ 2003-01-15 00:42 UTC (permalink / raw)
To: pgsql-interfaces
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...
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pyPgSQL error
@ 2003-01-15 00:55 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Laurette Cisneros <laurette@nextbus.com>
0 siblings, 1 reply; 3+ messages in thread
From: Bruce Momjian @ 2003-01-15 00:55 UTC (permalink / raw)
To: Laurette Cisneros <laurette@nextbus.com>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pyPgSQL error
@ 2003-01-15 01:11 Laurette Cisneros <laurette@nextbus.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Laurette Cisneros @ 2003-01-15 01:11 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-interfaces
Ah, yes could be. Thanks!
On Tue, 14 Jan 2003, Bruce Momjian wrote:
>
> 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)
> >
>
>
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
Life is an SQL old chum...
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-01-15 01:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-15 00:42 pyPgSQL error Laurette Cisneros <laurette@nextbus.com>
2003-01-15 00:55 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-01-15 01:11 ` Laurette Cisneros <laurette@nextbus.com>
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