[GENERAL] DataBase Problem

2009-12-29 Thread Premila Devi
I am having problem as : Caused by: org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed at org.springframework.orm.hibernate3.HibernateTransactionManager.doRoll

[GENERAL] Performance with Boolean datatype

2009-04-01 Thread devi
Hi, I would like to know is there any perf differences between case 1: when i use ( ...where validate=FALSE) [validate as Boolean] case 2: when i use ( ... where validate=1) [validate as int(1)] Thanks DEVI.G

Re: [GENERAL] PostgreSQL connect error

2009-03-10 Thread devi
Hi Richard, Thanks & it works.. DEVI.G - Original Message - From: "Richard Huxton" To: "devi" Cc: ; Sent: Tuesday, March 10, 2009 3:39 PM Subject: Re: [GENERAL] PostgreSQL connect error devi wrote: Hi , As john suggested, i tried setting up the env .. b

Re: [GENERAL] PostgreSQL connect error

2009-03-10 Thread devi
help me out here!! Thanks DEVI.G - Original Message - From: "Thomas Pundt" To: "devi" ; Sent: Tuesday, March 10, 2009 2:53 PM Subject: Re: [GENERAL] PostgreSQL connect error devi schrieb: Hi Friends, I wrote a sample php program that connects to PostgreSQL DB. ==>

[GENERAL] PostgreSQL connect error

2009-03-10 Thread devi
Hi Friends, I wrote a sample php program that connects to PostgreSQL DB. ==> I was able to run the PHP program from the command prompt as postgres user & not as anyother user $ php pgsql.php ==> I was not able execute the same file from the web browser. FATAL ERROR- undefined functio

Re: [GENERAL] Checkpoints questions

2008-03-04 Thread Devi
Hi, Hope this helps http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm Thanks DEVI.G - Original Message - From: "Henrik" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 04, 2008 3:28 PM Subject: [GENERAL] Checkpoints questions Hi list, I'm using 8.3 and I've started loo

Re: [GENERAL] rule question

2008-02-28 Thread Devi
Hi, CREATE RULE dosen't require any lock. It is carried out in the parser level. But there will be ACCESS SHARE lock over the tables which are being queried & are acquired automatically. Thanks DEVI.G - Original Message - From: "Tim Rupp" <[EMAIL PROTECTED]> To: Sent: Friday, Feb

[GENERAL] restoring pgdump.sql

2006-12-08 Thread anuradha devi
Hi I am trying to restore a pgdump.sql file. i am very much in need of help. i first went to pgAdmin III and created two database ( postgres and anuradha)... properties of anuradha :: 1) owner = ofbiz 2) encoding = 'UTF8' 3)connected ? yes 4) allow connections? yes