agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Markus Schaber <schabi@logix-tt.com>
To: bandeng <postgredb@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: [despammed] Crosstab function
Date: Thu, 07 Apr 2005 13:36:55 +0200
Message-ID: <42551B57.30208@logix-tt.com> (raw)
In-Reply-To: <3817e2290504070246704c9af@mail.gmail.com>
References: <3817e22905040523552e43ca9b@mail.gmail.com>
<20050406083230.GF6459@webserv.wug-glas.de>
<3817e2290504070246704c9af@mail.gmail.com>
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
Attachments:
[application/pgp-signature] signature.asc (255B, ../42551B57.30208@logix-tt.com/2-signature.asc)
download
view thread (10+ messages) latest in thread
Message-ID: <42551B57.30208@logix-tt.com>
Permalink: ../42551B57.30208@logix-tt.com/
Also on: postgresql.org/message-id/42551B57.30208@logix-tt.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: schabi@logix-tt.com, postgredb@gmail.com
Subject: Re: [despammed] Crosstab function
In-Reply-To: <42551B57.30208@logix-tt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox