agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Paul M. Aoki <aoki@postgres.Berkeley.EDU>
To: Eric de Jonge <ejonge@tpd.tno.nl>
Cc: post list <postgres@postgres.Berkeley.EDU>
Subject: Re: new Postgres exe
Date: Thu, 21 Apr 94 11:10:26 -0700
Message-ID: <199404211810.LAA14196@nobozo.CS.Berkeley.EDU> (raw)
In-Reply-To: <9404211119.AA06375@tpdusv.tpd.tno.nl>

ejonge@tpd.tno.nl (Eric de Jonge) writes:
> Is it possible to integrade dynamic load functions into Postgres itself.
> (make a new executable)

of course, but you have to edit a couple of source files, which
is substantially harder than...

> If so, How? (dynamic loading on a DEC is very slow)

...upgrading to 4.2, which has an ultrix dynamic loader that
is really, really fast.

the main thing you have to edit is src/backend/catalog/pg_proc.h;
if you stare at that for a while and the 4.2 ref manual (which 
explains what the fields means) it should be figure-out-able.
everything else -- function manager jump table, etc. -- is 
generated from that.  then some Makefile.inc (probably 
src/backend/utils/adt/Makefile.inc) would be edited to also point 
to your source file.  HOWEVER -- to insert a function with the oid
desired, you must re-run initdb!  if you're going to build new 
databases, you may as well upgrade to 4.2, hence my comment 
above.  (there are tricky ways around this but they take even 
more time to explain.)

if someone else would like to do a more thorough job of explaining
this, feel free, but i don't have the time right now and we don't 
really support this anyway.
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki

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: postgres@postgres.berkeley.edu
  Cc: aoki@postgres.Berkeley.EDU, ejonge@tpd.tno.nl
  Subject: Re: new Postgres exe
  In-Reply-To: <199404211810.LAA14196@nobozo.CS.Berkeley.EDU>

* 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