connection or query affected

[Dennis Gearon]

please cc me

If I am using some server side langauge to access Postgres - php,
python, perl, asp, if I make a connection, do the following actions
affect the connection, or the individual query that contains them:

turn off autocommit
start transaction
commit transaction
SET schema

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Steven Klassen]

* Dennis Gearon <ge*****@fireserve.net> [2004-10-12 08:13:07 -0700]:

turn off autocommit
Per connection.
start transaction
commit transaction
They're statements themselves that change the state of the
connection. You start a transaction, run your queries, and then
commit/rollback.
SET schema

It depends if you're setting your search path for subsequent queries
which would be tracked per connection or you're actually prepending
the schema where the table exists in the query.

E.g.

$dbh->query("SET search_path='my_schema'");

- or -

$dbh->query('SELECT foo FROM my_schema.bar WHERE active');

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, [phone]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Dennis Gearon]

Steven Klassen wrote:

* Dennis Gearon <ge*****@fireserve.net> [2004-10-12 08:13:07 -0700]:

turn off autocommit

Per connection.

start transaction
commit transaction

They're statements themselves that change the state of the
connection. You start a transaction, run your queries, and then
commit/rollback.

SET schema

It depends if you're setting your search path for subsequent queries
which would be tracked per connection or you're actually prepending
the schema where the table exists in the query.

E.g.

$dbh->query("SET search_path='my_schema'");

- or -

$dbh->query('SELECT foo FROM my_schema.bar WHERE active');

Thanks, I meant the first of the two schema related queries above.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings