[GENERAL]

2011-05-30 Thread Sairam Krishnamurthy
http://turedure.oboroduki.com/find11.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Table name as parameter

2011-05-09 Thread Sairam Krishnamurthy
a record variable for further processing. So my query actually is EXECUTE 'SELECT * FROM "' || table || '" INTO "record_data" WHERE '; This one will not work with the following error message: ERROR: syntax error at or near "INTO" Can some one help me ? Thanks, Sairam Krishnamurthy +1 612 859 8161

[GENERAL] COPY FROM and INSERT INTO rules

2010-12-06 Thread Sairam Krishnamurthy
All, I have a rule written on a temp table which will copy the values inserted into it to another table applying a function. The temp table will be discarded then. The rules I have written works when I use "Insert into" the temp table. But when I use bulk copy "COPY FROM", the rule doesn't ge

[GENERAL] Query precision issue

2010-10-25 Thread Sairam Krishnamurthy
trailing zeros when querying, but I am interested in finding why an additional trailing zero returns an empty set. -- Thanks, Sairam Krishnamurthy +1 612 859 8161

Re: [GENERAL] Having two simultaneous and similar database

2010-10-06 Thread Sairam Krishnamurthy
updating database A always. I want the update to be backed up to database B automatically during the night when no one will be using the databases. Can some one tell if if this can be done and if yes how ? Thanks, Sairam Krishnamurthy +1 612 859 8161 On 10/04/2010 06:31 PM, Ben Madin wrote: I

Re: [GENERAL] Having two simultaneous and similar database

2010-10-05 Thread Sairam Krishnamurthy
Scott, Thanks to answering the question. Thats exactly the reason. Also any operation on the tables is going to be huge. LIke 10s of thousands of rows inserted of deleted. This basically locks the table and that y we wanted to update a database and sync it with the production database when no one

Re: [GENERAL] Having two simultaneous and similar database

2010-10-05 Thread Sairam Krishnamurthy
synchronous databases. On Mon, Oct 4, 2010 at 6:31 PM, Ben Madin wrote: > I think you want something like : > http://www.postgresql.org/docs/8.4/interactive/backup.html > On 05/10/2010, at 7:02 AM, Sairam Krishnamurthy wrote: > > Hi all. > > I am trying to create two datab

[GENERAL] Having two simultaneous and similar database

2010-10-04 Thread Sairam Krishnamurthy
using the databases. Can some one tell if if this can be done and if yes how ? -- Thanks, Sairam Krishnamurthy +1 612 859 8161