For the record:
> Should'nt plplython.dll be a valid win32_x64 application when being loaded
> > into PostgreSQL 64bit? Could this be the source of the error? (as in:
> > "plpython.dll is 32 bit, PostgreSQL is 64bit, so no loading of
> 32-bit-module
> > into 64-bit-process?)
>
> plpython.dll is un
On Sun, Oct 24, 2010 at 10:02 AM, Massa, Harald Armin wrote:
> (which translated to english is roughly:
> createlang: Installation of language failed: ERROR: could not load library
> »C:/Program Files/PostgreSQL/9.0/lib/plpython.dll« : %1 is not a valid
> Win32 application.
> Should'nt plplytho
Hello,
I am using PostgreSQL 9.0.1 on Windows 7.0 Ultimate 64bit.
I tried to use plpython within one of my databases, but installing the
language fails with:
C:\Program Files\PostgreSQL\9.0\lib>createlang --dbname=ibox --echo -U
postgres plpythonu
SELECT oid FROM pg_catalog.pg_language WHERE lan
On Wed, Nov 04, 2009 at 12:12:50AM -0500, Tom Lane wrote:
> John Burski writes:
> > I got my postgresql build from the from a Novell SuSE Linux repository
> > (mirror.susestudio.com).
>
> > Here's the result of a run of ldd against the plperl.so file:
>
> > linux-gate.so.1 => (0xe000)
Thanks for your response, Tom!
I got my postgresql build from the from a Novell SuSE Linux repository
(mirror.susestudio.com).
Here's the result of a run of ldd against the plperl.so file:
linux-gate.so.1 => (0xe000)
libperl.so => not found
libnsl.so.1 => /lib/libn
John Burski writes:
> I got my postgresql build from the from a Novell SuSE Linux repository
> (mirror.susestudio.com).
> Here's the result of a run of ldd against the plperl.so file:
> linux-gate.so.1 => (0xe000)
> libperl.so => not found
File a bug with the SUSE packager.
John Burski writes:
> createlang: language installation failed: ERROR: could not load library
> "/usr/lib/postgresql/plperl.so": libperl.so: cannot open shared object
> file: No such file or directory
ldd on plperl.so might be informative.
> The "libperl.so" file is located in the
> /usr/lib/
Greetings, everyone!
I'm experiencing some troubles using the createlang command to add
plperl to my PostgreSQL installation. When I issue the command
"createlang plperl template1" I receive the following error message:
createlang: language installation failed: ERROR: could not load library
Well they are probably busy people and I have not got a reply from
them as yet. The reason I post the problem here is in the hops that
someone has come across this problem before and has some experience
that might help. For-instance they might have found an economical
shared hosting site wi
Am Montag, den 21.11.2005, 20:12 -0800 schrieb Jeremy Sellors:
> I see the problem now. On a shared host the createuser and createdb
> are handled by cPanel scripts but not (as yet on my host) createlang.
> The createlang utility only installs procedural languages included in
> the default PostgreS
I see the problem now. On a shared host the createuser and createdb are handled by cPanel scripts but not (as yet on my host) createlang.The createlang utility only installs procedural languages included in the default PostgreSQL distribution, which fortunately includes plpgsql language I need.If t
Am Freitag, den 18.11.2005, 15:29 -0800 schrieb Jeremy Sellors:
> Hi,
> How can I 'createlang plpgsql database' on a shared server? on my ouwn
> machine I just used 'su postgres' and 'createlang plpgsql template1'
> but I need to have plpgsql available on a shared server.
Shared or not, the dba ha
Hi, How can I 'createlang plpgsql database' on a shared server? on my ouwn machine I just used 'su postgres' and 'createlang plpgsql template1' but I need to have plpgsql available on a shared server.Kind Regards,Jeremy Sellors
On 15 Aug 2005, at 22:03, James Cradock wrote:
Almost forgot:
http://www.postgresql.org/docs/8.0/interactive/app-createlang.html
I hope this and the prior reply help.
On Aug 15, 2005, at 4:45 PM, eoghan wrote:
Hi James
Thanks! That got it...
Exit psql prompt and ran createlang...
Suppose s
On 8/15/05 4:45 PM, "eoghan" <[EMAIL PROTECTED]> wrote:
> Hello
> Im trying to load plpgsql into my test db... Im wondering if theres a
> way to check if its loaded... I do:
> test-# createlang plpgsql test
> test-#
> When i try load an example function:
> test-# \i test.sql
> Im getting:
> psql:t
On 15 Aug 2005, at 21:58, Joshua D. Drake wrote:
eoghan wrote:
Hello
Im trying to load plpgsql into my test db... Im wondering if
theres a way to check if its loaded... I do:
test-# createlang plpgsql test
createlang is a command line client:
bash# createlang -U postgres -P 5432 plpgsq
Almost forgot:
http://www.postgresql.org/docs/8.0/interactive/app-createlang.html
I hope this and the prior reply help.
On Aug 15, 2005, at 4:45 PM, eoghan wrote:
Hello
Im trying to load plpgsql into my test db... Im wondering if theres a
way to check if its loaded... I do:
test-# createlan
Exit the psql prompt. Type the same command:
createlang plpgsql test
Then access your db:
psql test
And load your script:
\i test.sql
On Aug 15, 2005, at 4:45 PM, eoghan wrote:
Hello
Im trying to load plpgsql into my test db... Im wondering if theres a
way to check if its loaded... I do:
eoghan wrote:
Hello
Im trying to load plpgsql into my test db... Im wondering if theres a
way to check if its loaded... I do:
test-# createlang plpgsql test
createlang is a command line client:
bash# createlang -U postgres -P 5432 plpgsql database
What you are looking for is:
CREATE LANGU
Hello
Im trying to load plpgsql into my test db... Im wondering if theres a
way to check if its loaded... I do:
test-# createlang plpgsql test
test-#
When i try load an example function:
test-# \i test.sql
Im getting:
psql:test.sql:5: ERROR: language "plpgsql" does not exist
HINT: You need to
Am Mi, den 01.12.2004 schrieb Tom Lane um 22:00:
> Probably more like /usr/local/lib/postgresql ... did you look at the
> directory structure? Or consult pg_config --pkglibdir ?
[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/pg_config --pkglibdir
/usr/local/pgsql/lib
and there is
[EMAIL PROTECTED]:
Joachim Zobel <[EMAIL PROTECTED]> writes:
> Am Mi, den 01.12.2004 schrieb Tom Lane um 21:22:
>> That's how it's built, but it should be installed as plperl.so. Are you
>> sure you are looking in the right $libdir?
> I did not give any directory options during install, so
> ls -l /usr/local/pgsql/
Am Mi, den 01.12.2004 schrieb Tom Lane um 21:22:
> Joachim Zobel <[EMAIL PROTECTED]> writes:
> > Checking my build dirs I find that no plperl.so has been build
> > (--with-perl was used in configure). Instead I find a libplperl.so in
> > the pgperl build directory.
>
> That's how it's built, but i
Joachim Zobel <[EMAIL PROTECTED]> writes:
> Checking my build dirs I find that no plperl.so has been build
> (--with-perl was used in configure). Instead I find a libplperl.so in
> the pgperl build directory.
That's how it's built, but it should be installed as plperl.so. Are you
sure you are loo
Hi.
If I try createlang plperl I get:
[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/createlang plperl shop
createlang: language installation failed: ERROR: could not access file
"$libdir/plperl": No such file or directory
Checking my build dirs I find that no plperl.so has been build
(--with-perl
Maybe you didn't restart your beta4-or-older postmaster after updating?
SPI_restore_connection definitely exists in the beta5 sources ...
all ok now.
restarting wasn't doing the trick ... same errors. still able to
access/read/write to my db's but nada else.
but, looking in my logs i noted a slew
OpenMacNews <[EMAIL PROTECTED]> writes:
> i _think_ i'm up to date ...
Maybe you didn't restart your beta4-or-older postmaster after updating?
SPI_restore_connection definitely exists in the beta5 sources ...
regards, tom lane
---(end of broadcast)
hi tom,
thx for the reply =)
You seem to be trying to load a current plpgsql.so into a less than
current backend. SPI_restore_connection() was just added a few days
ago ...
just getting used to pgsql terminology, but i presume by 'backend' you simply
mean version of pgsql iteslf, yes?
to that en
OpenMacNews <[EMAIL PROTECTED]> writes:
> createlang: language installation failed: ERROR: could not load library
> "/usr/local/pgsql/lib/plpgsql.so": dyld: /usr/local/pgsql/bin/postmaster
> Undefined symbols:
> /usr/local/pgsql/lib/plpgsql.so undefined reference to
> _SPI_rest
hi all,
i've a successful install of pgsql 8b5 on OSX 10.3.6.
trying to install pl/pgsql:
% createlang plpgsql template1
results in an immediate error:
createlang: language installation failed: ERROR: could not load library
"/usr/local/pgsql/lib/plpgsql.so": dyld: /usr/local/pgsql/bin/post
30 matches
Mail list logo
