Return-Path: owner-postman Delivery-Date: Thu, 21 Apr 94 15:08:57 -0700 Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id LAA14205 for postgres-redist; Thu, 21 Apr 1994 11:10:27 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199404211810.LAA14205@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id LAA14196; Thu, 21 Apr 1994 11:10:26 -0700 Message-Id: <199404211810.LAA14196@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: ejonge@tpd.tno.nl (Eric de Jonge) Cc: postgres@postgres.Berkeley.EDU (post list) Subject: Re: new Postgres exe Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki) In-reply-to: Your message of Thu, 21 Apr 1994 13:19:23 +0200 (MET DST) <9404211119.AA06375@tpdusv.tpd.tno.nl> Date: Thu, 21 Apr 94 11:10:26 -0700 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-redist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Thu, 21 Apr 94 11:10:27 -0700 Resent-XMts: smtp 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