Обсуждение: GUC variables in parameter URL

Hi all,

I want to bring the old discussion on GUC variables in the JDBC
connection string back. Currently I definitely need to set the schema
search path, and all I got is the connection URL, because it is in a
place where we alternatively use Microsoft SQL server connection URLs.

Of course I can change the clients code, but this would be a real mess.

The only reason I found which spoke against adding them, was: "If we do,
people stop using the config files and enter all parameters into the
url, and this make them hard to type." Despite the fact that this are
two wrong assumptions in one sentence, we speak about providing
possibilities for cases where other possibilities are lacking.

What are your opinions on this? If this feature is not yet available, I
would even implement this myself in the driver, by issuing a SET command
on startup sending all the parameters starting with "guc_".

Regards,
Daniel Migowski

Good idea.

--
John Abraham
jea@hbaspecto.com


On 2010-03-26, at 5:19 AM, Daniel Migowski wrote:

> Hi all,
>
> I want to bring the old discussion on GUC variables in the JDBC connection string back. Currently I definitely need
toset the schema search path, and all I got is the connection URL, because it is in a place where we alternatively use
MicrosoftSQL server connection URLs. 
>
> Of course I can change the clients code, but this would be a real mess.
>
> The only reason I found which spoke against adding them, was: "If we do, people stop using the config files and enter
allparameters into the url, and this make them hard to type." Despite the fact that this are two wrong assumptions in
onesentence, we speak about providing possibilities for cases where other possibilities are lacking. 
>
> What are your opinions on this? If this feature is not yet available, I would even implement this myself in the
driver,by issuing a SET command on startup sending all the parameters starting with "guc_". 
>
> Regards,
> Daniel Migowski
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>