SEO

Thanks for your reply.



As per your suggestion, if we remove "CREATE FUNCTION" statement, we
cannot use that function.

Actually, we need this feature.



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.



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.





Regards,

G. V. Suresh Gupta

------------------------------------------------------------------------
---------------------------------------------------------

Innovative Technology Solutions(ITS), Zensar Technologies

Zensar Knowledge Park, Plot#5, MIDC IT Tower,

Kharadi, Off Nagar Road, Pune - 411014

Landline : +91-20-66453471 | +91-9890898688

Email : suresh.g@zensar.com | website: www.zensar.com













-----Original Message-----
From: John R Pierce [mailtoierce@hogranch.com]
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



Suresh Gupta VG wrote:

>

> I had recently upgraded my pgsql 7.4.2 to pgsql 8.2.5 on Solaris 9

> Sparc machine. All the installation went normally as per install

> documents of Postgresql. In between the installation, I got the

> following error. But at the end I could create database and can use

> 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;

> ...

> -----------

>

> This problem is coming with all the versions of PGSQL. We had a good

> experience with similar error when we were upgraded with 7.4.2 long

> back. Can you pls advice what to do to rectify this error in

> Postgresql 8.2.5.

>



this does not look like a postgres bug to me.





Offhand, it looks like your database loads custom functions from the

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

8.2 compatible, or remove the CREATE FUNCTION statements that reference

it (and modify any SQL code you have which calls these

blowfish_encrypt() etc functions...)







DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails.

Suresh Gupta VG wrote:

> As per your suggestion, if we remove "CREATE FUNCTION" statement, we
> cannot use that function.

Add the PG_MODULE_MAGIC stuff to your code and recompile it. This is
mentioned in the documentation.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Suresh Gupta VG wrote:
>
> Thanks for your reply.
>
> As per your suggestion, if we remove “CREATE FUNCTION” statement, we
> cannot use that function.
>
> Actually, we need this feature.
>
> 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.
>

http://www.postgresql.org/docs/curre...c/xfunc-c.html

again, this isn't a postgres bug. you're posting this on the wrong list.


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly