Thanks for your reply.
=20
As per your suggestion, if we remove "CREATE FUNCTION" statement, we
cannot use that function.
Actually, we need this feature.
=20
Can you pls suggest some url or docs to help us in developing the
c-language code to rectify this as we had done earlier for pgsql7.4.2.
=20
And pls provide us with new macros introduced in 8.2.5 later to 7.4.2,
so that it can help us in our coding very mush
Thanks in advice.
=20
=20
Regards,
G. V. Suresh Gupta
------------------------------------------------------------------------
---------------------------------------------------------
Innovative Technology Solutions(ITS), Zensar Technologies=20
Zensar Knowledge Park, Plot#5, MIDC IT Tower,=20
Kharadi, Off Nagar Road, Pune - 411014
Landline : +91-20-66453471 | +91-9890898688=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20
Email : suresh.g@zensar.com | website: www.zensar.com
=20
=20
=20
=20
=20
=20
-----Original Message-----
From: John R Pierce [mailto:pierce@hogranch.com]=20
Sent: Thursday, January 17, 2008 2:31 PM
To: Suresh Gupta VG
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Bug in all version with encryption
=20
Suresh Gupta VG wrote:
>=20
> I had recently upgraded my pgsql 7.4.2 to pgsql 8.2.5 on Solaris 9=20
> Sparc machine. All the installation went normally as per install=20
> documents of Postgresql. In between the installation, I got the=20
> following error. But at the end I could create database and can use=20
> the DB as normal.
> -------
> ERROR: incompatible library "/usr/lib/pgsql_clcrypt.so": missing magic
> block
> HINT: Extension libraries are required to use the PG_MODULE_MAGIC
macro.
> STATEMENT: CREATE FUNCTION blowfish_encrypt(text, text) RETURNS text
> AS '/usr/lib/pgsql_clcrypt.so', 'blowfish_encrypt'
> LANGUAGE c;
> ...
> -----------
>=20
> This problem is coming with all the versions of PGSQL. We had a good=20
> experience with similar error when we were upgraded with 7.4.2 long=20
> back. Can you pls advice what to do to rectify this error in=20
> Postgresql 8.2.5.
>=20
=20
this does not look like a postgres bug to me.
=20
=20
Offhand, it looks like your database loads custom functions from the=20
shared object library /usr/lib/pgsql_clcrypt.so which was probably built
for your older 7.4... you'd either need to rebuild that library to be=20
8.2 compatible, or remove the CREATE FUNCTION statements that reference=20
it (and modify any SQL code you have which calls these=20
blowfish_encrypt() etc functions...)
=20
=20
DISCLAIMER:
This email may contain confidential or privileged information for the inten=
ded recipient(s) and the views expressed in the same are not necessarily th=
e views of Zensar Technologies Ltd. If you are not the intended recipient o=
r have received this e-mail by error, its use is strictly prohibited, pleas=
e delete the e-mail and notify the sender. Zensar Technologies Ltd. does no=
t accept any liability for virus infected mails.=20