Skip site navigation (1) Skip section navigation (2)

Re: pyPgSQL error

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: pyPgSQL error
Date: 2003-01-15 01:11:31
Message-ID: Pine.LNX.4.44.0301141711220.1837-100000@visor.corp.nextbus.com (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)org)
> > 
> 
> 

-- 
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
Life is an SQL old chum...


In response to

pgsql-interfaces by date

Next:From: Key88 SFDate: 2003-01-15 22:51:22
Subject: libpqxx: Cursors needed??!
Previous:From: Bruce MomjianDate: 2003-01-15 00:55:48
Subject: Re: pyPgSQL error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group