Re: [PERFORM] Error in transaction processing
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 transaction statements. What can I do to correct this error? Your response would be very much appreciated. Thanks and Regards, Radha ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] Error in transaction processing
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 transaction statements. What can I do to correct this error? Your response would be very much appreciated. Thanks and Regards, Radha ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [PERFORM] [NOVICE] error while executing a c program with embedded sql
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 the executable it says, ./test1: error while loading shared libraries: libecpg.so.3: cannot open shared object file: No such file or directory What does it mean by this error message? What should I do to correct this error and run the executable successfully? Shared libraries are loaded from directories specified to the system by ldconfig. Your shared library, libecpg.so.3, is in a PostgreSQL directory, such as /usr/local/pgsql/lib, which has not been added to the directories known to the loader. If you are able to add that directory with ldconfig, that is the best way to do it, but it requires root privilege. Otherwise you can set the environment variable LD_LIBRARY_PATH, thus: export LD_LIBRARY_PATH=/usr/local/pgsql/lib before you run the program, or you can use LD_PRELOAD: LD_PRELOAD=/usr/local/pgsql/lib/libecpg.so.3 ./test1 -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C O death, where is thy sting? O grave, where is thy victory? 1 Corinthians 15:55 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [PERFORM] error while executing a c program with embedded sql
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 such file or directory What does it mean by this error message? What should I do to correct this error and run the executable successfully? Your response would be very much appreciated. Thanks and Regards, Radha ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PERFORM] Response time
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 EXPLAIN ANALYZE, the log_min_duration_statement configuration variable and the \timing psql command might also be useful. -Neil ---(end of broadcast)--- TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly