Yeah, I didn't realize that contrib source is in regular source download, nor
did I notice that Synaptic was installing its own version of PG. The bulb
wasn't lit. In all, I think I should have had two installs of PG; the one I
built from source way back when (and stored out of standard locati
I just got wholly confused. Synaptic makes it appear that *contrib is a
separate entity. And the source isn't in a src subdirectory, but in the
contrib directory directly. If I built PG on a regular basis, I might remember
all this.
The xTuple folks only support a few PG releases, and with a
D'oh! I didn't recall that it was packaged together, but the contrib source
isn't in src, where I looked. Oh well.
thanks,
Robert
Original message
>Date: Thu, 30 Jun 2011 11:04:43 -0400
>From: Reid Thompson
>Subject: Re: [GENERAL] Contrib source
>To: gnuo...@rcn.com
>Cc: pgsql-g
So, I needed to build a special PG, for use with xTuple (an ERP). I got the
8.4.4 source, dumped it in a directory in my home, and put the executable out
on a non-standard directory on one of my SSD.
Reading Greg Smith's "High Performance..." book, suggested that I needed the
postgresql-contri
(RCN is messing up my e-mail, so this is all copied!)
Hi,
Which version of PostgreSQL is it ?
I can't see any difference with PG 8.4.4.
Regards,
- --
Stéphane Schildknecht
D'oh, 8.4.4 running on Ubuntu 10.04. I originally saw it running AQT in wine,
but it also happens running RazorSQL in
Can anyone explain why the following query (used by AQT to display its tree):
SELECT trig.tgname,
tab.relname,
case trig.tgenabled
when '1' then 'yes'
else 'no'
end,
trig.oid
FROM pg_catalog.pg_trigger trig,
pg_catalog.pg_class tab,
pg_catalog.pg_namespace nam
WHERE trig.tgrelid=tab.oid
AND tab.re
Going through the PLPython threads on the Planet, I realized that I needed
plpython. So I rebuilt PG with python, expecting that I could then re-catalog
the databases. But, not. initdb, wants the data directory, which is where the
database files are, and doesn't run if it's not empty. The da