I would like to register a "transaction callback" in the backend. Don't
think it's possible today and my question is, how hard would it be to
implement something that would enable this registration?
Ideally, I'd like a "beforeCompletion" that is executed prior to the start

I downloaded the port for Postgres for PHP-NUKE.
All insert statements are as follows:
For table:
                                   Table "nuke_referer"

One of our developers came across the fact that postgres is ignoring
spaces when sorting results from a query.  We are using PGSQL 7.3.4 on
the backend.  Is there something that needs to be set somewhere to for
the sort to not ignore spaces?

Just want to share in case you want to make a change
in the code, or perhaps tell us that we didn't do the right thing.
At some point we needed to add -DTCL_THREADS and -D_REENTRANT
to the makefiles and then we ran into a problem with pgtcl library.

(I hope this is -hackers appropriate - feel free to point me elsewhere)
I'm using 7.4.1 as the backend to several applications. Until recently,
I've been developing solely single-threaded applications.
I just rebuilt postgresql with --enable-thread-safety, to work with

I'm fairly new to this database, and have read much discussion on
sub-queries.  I've seen that they can be great for some queries, and
downright slow for others.  I have a table with two foreign keys referencing
another table, like:

Hey folks.  I'm new to the list, and not quite what you'd call a DB
Guru, so please be patient with me.  I'm afraid the lead up here is a
bit verbose . . .
I am working on an application that uses very high volume DB

I have Two databases names 'MyDb1' and 'MyDb2' in My
System.
I have installed Postgres 7.4 with dblink
What i need is, when ever a NEW record is inserted in

The following bug has been logged online:
Bug reference:      1071
Logged by:          Palle Girgensohn
Email address:      girgen@pingpong.net

could someone please explain to me the mechanics of an UpDate:Cascade?
Delete:Cascade I fully understand but not Update. I have 2 tables A and
B. On B I have created a foreign key on user_id in both B and A for
Update and Delete cascade. If I delete from A it deletes all from B. ...

The India Time Zone (IST) which is 5:30 + ahead of UST / GMT is not available in PostgreSQL.
Also, India specific built in conversions (e.g. utf_8_to_euc_jp) for Indian languages like Hindi, Tamil, etc. seem to be missing.
Sanjay Banerji

I upgraded two servers today from 7.3.* to 7.4.1.  In both cases, the
schemas which existed in the original databases were not created in
the new database.
The CREATE SCHEMA commands are there...

The following bug has been logged online:
Bug reference:      1070
Logged by:          Piotr Mysliwiec
Email address:      piotrek@radio.katowice.pl

I need to develop my database so when a record is entered through a
browser, it will automatically email a list of interested parties. I
am ok at designing the tables so the relevant personid's have the
email address and their interested subjects. But can anybody help on

I'm having some issues dumping a database from 7.2, reloading it to 7.4.
I'm using the 7.4 pg_dump. The problem I'm having is an issue of internal
object dependancies. For instance I have a_function that uses b_function. The
a_function gets dumped in first, and errors out because ...