Re: connection or query affected

Steven Klassen wrote:

> * Dennis Gearon <gearond(at)fireserve(dot)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.