Re: [PERFORM] Response time

2003-11-05 Thread radha.manohar
The \timing psql command gives different time for the same query executed repeatedly. So, how can we know the exact response time for any query? Thanks and Regards, Radha On Tue, 2003-11-04 at 09:49, [EMAIL PROTECTED] wrote: How do we measure the response time in postgresql? In addition to

Re: [PERFORM] error while executing a c program with embedded sql

2003-11-09 Thread radha.manohar
I have a c program called test1.pgc with some sql statements embedded in it. The program was preprocessed, compiled and linked. Now, I have the executable test1. When I run the executable it says, ./test1: error while loading shared libraries: libecpg.so.3: cannot open shared object file: No

Re: [PERFORM] [NOVICE] error while executing a c program with embedded sql

2003-11-10 Thread radha.manohar
Thanks a lot. IT WORKED! with your suggestions. Regards, Radha On Sun, 2003-11-09 at 15:06, [EMAIL PROTECTED] wrote: I have a c program called test1.pgc with some sql statements embedded in it. The program was preprocessed, compiled and linked. Now, I have the executable test1. When I run

Re: [PERFORM] Error in transaction processing

2003-11-14 Thread radha.manohar
When I execute a transaction using embedded sql statements in a c program, I get the error, Error in transaction processing. I could see from the documentation that it means, Postgres signalled to us that we cannot start, commit or rollback the transaction I don't find any mistakes in the

Re: [PERFORM] Error in transaction processing

2003-11-15 Thread radha.manohar
When I execute a transaction using embedded sql statements in a c program, I get the error, Error in transaction processing. I could see from the documentation that it means, Postgres signalled to us that we cannot start, commit or rollback the transaction I don't find any mistakes in the