Steven Klassen wrote:
* Dennis Gearon <[EMAIL PROTECTED]> [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
