Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > I am cleaning up /contrib by adding "autocommit = 'on'"
>
> Is everyone in the world now required to add "autocommit = on" in all
> scripts, interfaces, programs, applications that are not strictly personal
> use? Is there no better solution?
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I am cleaning up /contrib by adding "autocommit = 'on'" and making it
> more consistent. Should I be adding this too:
> -- Adjust this setting to control where the objects get created.
> SET search_path = public;
Yes, that would be a good i
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am cleaning up /contrib by adding "autocommit = 'on'" and making it
> > more consistent. Should I be adding this too:
>
> > -- Adjust this setting to control where the objects get created.
> > SET search_path = public;
>
>
I am cleaning up /contrib by adding "autocommit = 'on'" and making it
more consistent. Should I be adding this too:
-- Adjust this setting to control where the objects get created.
SET search_path = public;
and doing all object creation in one transaction, like /contrib/cube
does