X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5E67053A9D for ; Thu, 7 Apr 2005 12:37:34 +0100 (BST) 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 35446-06 for ; Thu, 7 Apr 2005 11:37:25 +0000 (GMT) Received: from mail.logix-tt.com (wallaby.dingens.org [212.75.36.180]) by svr1.postgresql.org (Postfix) with ESMTP id 427D353A8A for ; Thu, 7 Apr 2005 12:37:24 +0100 (BST) Received: from kingfisher.intern.logi-track.com (pD95DC1AD.dip0.t-ipconnect.de [217.93.193.173]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id 08F61A85AA; Thu, 7 Apr 2005 13:37:29 +0200 (CEST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with ESMTP id 63B1FAB19F; Thu, 7 Apr 2005 13:36:58 +0200 (CEST) Message-ID: <42551B57.30208@logix-tt.com> Date: Thu, 07 Apr 2005 13:36:55 +0200 From: Markus Schaber Organization: Logical Tracking and Tracing International AG, Switzerland User-Agent: Mozilla Thunderbird 1.0 (X11/20050116) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: bandeng Cc: pgsql-sql@postgresql.org Subject: Re: [despammed] Crosstab function References: <3817e22905040523552e43ca9b@mail.gmail.com> <20050406083230.GF6459@webserv.wug-glas.de> <3817e2290504070246704c9af@mail.gmail.com> In-Reply-To: <3817e2290504070246704c9af@mail.gmail.com> X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-ripemd160; protocol="application/pgp-signature"; boundary="------------enigC8B5B6F5C526E54A1AF2E3D9" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/70 X-Sequence-Number: 20963 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigC8B5B6F5C526E54A1AF2E3D9 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi, Bandeng, bandeng schrieb: > I have install postgresql-contrib finally... i'm newbie in server. > I use freebsd 4.8, I saw in documentation it is said use tablefunc.sql > but in freebsd i found file tablefunc.so , it is already compiled. is > there suggestion to install tablefunc.so ? I think you misunderstood the relationship between tablefunc.so and tablefunc.sql, as the former one is not the compiled form of the latter one. The .sql file contains the statements that create functions, datatypes, aggregates etc. For functions programmed in C, SQL function definitions eference the .so file and the function symbol name therein so postgresql can load the library and jump into the C code functions, but the SQL files could also define functions by including their source (for languages such as plpgsql). So to "install" the .so file, you have use psql -f tablefunc.sql yourdb. Markus --------------enigC8B5B6F5C526E54A1AF2E3D9 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCVRtYyHQIGEs7eeARAyNPAJ9ygjw0vKOpJ4va2zoGv1oK1NjgkwCgsSFN 9rSP3375rH1uTqnUFHOWhdw= =baL/ -----END PGP SIGNATURE----- --------------enigC8B5B6F5C526E54A1AF2E3D9--