[ADMIN] bytea

2004-12-22 Thread Nageshwar Rao
Title: bytea We have column job_data  with datatype bytea. This is one of the columns in table used by quartz scheduler(open source). We have to insert the data into it. The data is as follows. [-84,-19,0,5,115,114,0,21,111,114,103,46,113,117,97,114,116,122,46,74,111,98,68,97,116,97,77,97,11

[ADMIN] runing Postgresql on shared disk

2004-12-10 Thread Nageshwar Rao
Hi, Can anybody let me know how to configure postgresql on shared disk? I want postgresql on two systems accessing same disk for data(disk arrays). Our aim is to provide HA DB.  

[ADMIN] calling a java program in a trigger

2004-10-28 Thread Nageshwar Rao
Can we call a java program in a trigger .If so please let me know how to do that. Thx  

[ADMIN] Pg_restore is appending the data to existing table

2004-10-27 Thread Nageshwar Rao
I am trying to replicate the DB using pg_dump and pg_restore.When I use pg_restore  it is appending the data to existing data.This is not what I wanted.Even I used the flag -c .Can anybody throw light on this.