[ADMIN] Please help - tks

Hi Folks We have about 300,000 records to update, I have created a file with the ids of the records to be updated, since the number of records to be updated is very large, the update statement takes forever and server slows down dramatically, therefore I want to do one at a time. Do you guys hav

[ADMIN] Please help

Hi Can anyone help me write a trigger on a table, I have created an audit table for a table and what I want trigger to do is to whenever a record is deleted from the table it should first be inserted into the audit table, just to keep track of whatever records are deleted. Thanks so much for you

[ADMIN] Please help me write this query or function

Hi We have a table like follows: id, account_name, amount, action_type The amount field has both debit and credit entires and action_type defines the type of transaction ( debit or credit), debit entries have negative '-' symbol before the amount. where there are multipble transaction for the

[ADMIN] Urgent help neede - Important - Tks

Hi all We are trying to implement replication on postgres 7.2 with java and to effectively run it we need to drop all RI triggers from the slave database, but in case when master database fails, we will be using Slave as the master and would need to restore all these RI triggers back on. Therefo

[ADMIN] benchmarking tools

Hi Folks Are there any tools to collect benchmark statistics for postgresql database, we want to do testing with different configurtions to see which configuration is optimal for our database. We have a huge database in postgres running under Solars 7 on a Sun E6500 box with 16 gig of ram and

[ADMIN] Upgrading to 7.2 from 7.1

Hi We are going to upgrade postgresql to 7.2 from 7.1 on Solaris platform, therefore will appreciate your feedback on the issues which we are likely to face, we plan to restore the data-dump from 7.1 to 7.2. Thanks for your help Mike __

[ADMIN] Are there any changes to INTERVAL in 7.2

Hi The following query involving INTERVAL works very well in 7.1 but does not work under 7.2 SELECT order_id FROM order WHERE order_date + INTERVAL (term ||'year') < current_timestamp; Are there any changes to this functionality in 7.2 from 7.1. Please comment Thanks Khat

[ADMIN] gmake check runs just 13 tests instead of 77

Hi I am testing the beta 5 version of 7.3, by using make check under solaris 7 and 8 and it runs just 13 tests as against 77 tests as indicated in the README.regression, I dont get any errors on the screen: /bin/sh ./pg_regress --temp-install --top-builddir=../../.. --schedule=./parallel_sched

Re: [ADMIN] gmake check runs just 13 tests instead of 77

From: Andrew Sullivan <[EMAIL PROTECTED]> According to my report, yes. I tested 7.3b3 on 2002-10-28. I'll bet it had to do with a funky path I had, though; probably I picked up a different awk (there are two on Solaris), because I was also working on another problem during the same period. (I c

Re: [ADMIN] client for solaris

Just complie the source and install it, don't do an initdd and add it to your path : psql -h Khat From: Aravind Vinnakota <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [ADMIN] client for solaris Date: Thu, 12 Dec 2002 18:52:00 -0500 (EST) Hi all, I am looking for a postgreSQL cl