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

Re: psycopg2 Operational Error

From: ganesh gajre <ganeshgajre(at)gmail(dot)com>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: psycopg2 Operational Error
Date: 2011-01-18 13:24:43
Message-ID: AANLkTimW9MmwFT_NtPb_1FA+qD2A_eVLasqP7d0GGig5@mail.gmail.com (view raw or flat)
Thread:
Lists: psycopg
Thanks,  for pointing me in right direction.

Problem get solved. error occurs due to  " value of plpgsql_call  handler
written explicitely to search for 8.3" in my sql file.

On Tue, Jan 18, 2011 at 6:10 PM, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>wrote:

> On Tue, Jan 18, 2011 at 01:35:22PM +0100, Harald Armin Massa wrote:
>
> > > When I tried to create connection with my database under  Postgres 8.4,
>  it
> > > create the connection. But failed to load database through script.
> > >
> > > It's gives me error as follow:
> > >
> > > psycopg2.OperationalError: could not access file
> > > "/usr/lib/postgresql/8.3/lib/plpgsql.so": No such file or directory
> > >
> > > I am quite sure that psycopg2 is passing on the error PostgreSQL server
> is
> > giving.
> >
> > And I gutess "load database through script" refers to "Ganesh has a
> database
> > dump which he is trying to upload via python + psycopg2"
> >
> > So, please look at your datbase dump. Is somewhere within that dump
> > something along "create procedural language plpgsql ...... plpgsql.so"
> ???
> > THAT is source of the error.
>
> Quite apart from the fact that said "database dump" might
> contain psql-specific commands which python+psycopg2 will be
> quite confused about.
>
> Karsten
> --
> GPG key ID E4071346 @ wwwkeys.pgp.net
> E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
>
> --
> Sent via psycopg mailing list (psycopg(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/psycopg
>



-- 
Ganesh (Dragger)
Be a FOSSERS, use GNU/Linux

In response to

psycopg by date

Next:From: Daniele VarrazzoDate: 2011-01-18 17:34:00
Subject: Psycopg Buildbot online
Previous:From: Karsten HilbertDate: 2011-01-18 12:40:21
Subject: Re: psycopg2 Operational Error

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