Dependency Additions For PostgreSQL 7.3 Upgrades
In PostgreSQL releases prior to 7.3, certain database objects didn't
have proper dependencies. For example:
1) When you created a table with a SERIAL column, there was no linkage
to its underlying sequence. If you dropped the table with the SERIAL
column, the sequence was not automatically dropped.
2) When you created a foreign k
HOW TO get Apache to log to PostgreSQL
Note: contain of files 'httpconf.txt' and 'apachelog.sql' are below this
First, this is intended mostly as a starting point, an example of how to do it.
The file 'httpconf.txt' is commented and contains two example lines to make
this work, a custom log format, and a line that sends the log data to psq
This is a B-Tree implementation using GiST that supports the int2, int4,
int8, float4, float8 timestamp with/without time zone, time
with/without time zone, date, interval, oid, money, macaddr, char,
varchar/text, bytea, numeric, bit, varbit and inet/cidr types.
All work was done by Teodor Sigaev (firstname.lastname@example.org) , Oleg Bartunov
(email@example.com), Janko Richter (firstname.lastname@example.org).