X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 96CC1D1B1B0 for ; Tue, 13 Jul 2004 17:01:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37383-04 for ; Tue, 13 Jul 2004 20:01:09 +0000 (GMT) Received: from web51407.mail.yahoo.com (web51407.mail.yahoo.com [206.190.38.186]) by svr1.postgresql.org (Postfix) with SMTP id 80645D1B1AA for ; Tue, 13 Jul 2004 17:01:04 -0300 (ADT) Message-ID: <20040713200106.41391.qmail@web51407.mail.yahoo.com> Received: from [192.88.67.254] by web51407.mail.yahoo.com via HTTP; Tue, 13 Jul 2004 13:01:06 PDT Date: Tue, 13 Jul 2004 13:01:06 -0700 (PDT) From: Bill Chandler Subject: Using PL/pgSQL with statically built PostgreSQL binaries To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200407/152 X-Sequence-Number: 14220 Hi, I built my Solaris PostgreSQL 7.4.2 installation using: configure --disable-shared My reason was so that clients that install it would have everything there in one binary tar file and would not have to install any gcc lib patches, etc. Anyway, everything seemed to work great until I wanted to use stored procedures with PL/pgSQL. Now it can't find plpgsql.so. Is there a way to do what I want to do and still be able to use PL/pgSQL stored procedures? Is there a better way to link statically? Is there a configure option to statically link 'plpgsql.a' as well? thanks, Bill C __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail