From f7d979bc58736d48ac1f44e5d638173aa172e87e Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 8 Jun 2000 16:40:51 +0000 Subject: Fix ODBC for new binary fopen/open params --- doc/src/FAQ.html | 18 ++++++++++++------ 1 file changed, 12 insertions(+), 6 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ.html b/doc/src/FAQ.html index e30f4153bfd..19344f93226 100644 --- a/doc/src/FAQ.html +++ b/doc/src/FAQ.html @@ -725,11 +725,13 @@ debugging purposes. Note that a newline terminates the query, not a semicolon. If you have compiled with debugging symbols, you can use a debugger to see what is happening. Because the backend was not started from the postmaster, it is not running in an identical environment and -locking/backend interaction problems may not be duplicated. Some -debuggers can attach to an already-running backend; that is the most -convenient way to diagnose problems in the normal multi-backend -environment. -

+locking/backend interaction problems may not be duplicated.

+ +Another method is to start psql in one window, then find the +PID of the postgres process being used by the +psql. Use a debugger to attach to the postgres +PID. You can set breakpoints in the debugger and issues +queries from psql. The postgres program has -s, -A, and -t options that can be very useful for debugging and performance measurements.

@@ -1061,7 +1063,11 @@ Similarly, you could retrieve the just-assigned SERIAL value with the currval INSERT INTO person (name) VALUES ('Blaise Pascal'); $newID = currval('person_id_seq'); -Finally, you could use the oid returned from the INSERT statement to lookup the default value, though this is probably the least portable approach. In perl, using DBI with Edmund Mergl's DBD::Pg module, the oid value is made available via $sth->{pg_oid_status} after $sth->execute(). +Finally, you could use the oid returned from the +INSERT statement to lookup the default value, though this is probably +the least portable approach. In perl, using DBI with Edmund Mergl's +DBD::Pg module, the oid value is made available via +$sth->{pg_oid_status} after $sth->execute().

4.16.3) Don't currval() and nextval() lead to a race condition with other concurrent backend processes?

-- cgit v1.2.3