[HACKERS] Patch for TNS services

[Jan Wieck]

Mario Weilguni wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
>
> Last week I created a patch for the Postgres client side libraries to allow
> something like a (not so mighty) form of Oracle TNS, but nobody showed any
> interest. Currently, the patch is not perfect yet, but works fine for us. I
> want to avoid improving the patch if there is no interest in it, so if you
> think it might be a worthy improvement please drop me a line.
>
> It works like this:
> The patch allows to supply another parameter to the Postgres connect string,
> called "service". So, instead of having a connect string (e.g. in PHP) like
> "dbname=foo host=bar port=5433 user=foouser password=barpass"
> the string would be
> "service=stupid_name_here"
> or more often
> "service=stupid_name_here user=foouser password=barpass"
>
> There's a config [...]

IMHO a good idea.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanW...@Yahoo.com #

[Thomas Lockhart]

> > Last week I created a patch for the Postgres client side libraries to allow
> > something like a (not so mighty) form of Oracle TNS, but nobody showed any
> > interest.

Perhaps it would be helpful to describe TNS: what it does, and what it
is good for. You posted your notice out of the blue, and for those of us
who didn't take the time to research what the heck you were talking
about, there wasn't much point in responding.

There are lots of good ideas floating around out there, and it is a
shame, but true anyway, that it takes most of us a while to warm up to a
new idea or proposal. Thanks for posting a followup message, and it
would be good to hear more about your proposal. I'm sure if it is a
useful feature that it will be of interest in the long run...

Regards.

- Thomas

[Tom Lane]

Mario Weilguni <mwei...@sime.com> writes:
> Last week I created a patch for the Postgres client side libraries to allow
> something like a (not so mighty) form of Oracle TNS, but nobody showed any

> interest. Currently, the patch is not perfect yet, but works fine for us. I
> want to avoid improving the patch if there is no interest in it, so if you
> think it might be a worthy improvement please drop me a line.

FWIW, it seemed like a moderately reasonable idea to me. But it
troubles me that you didn't get positive responses; as you say, no
point in maintaining the feature unless people will use it.

Perhaps you should bring it up on pgsql-interfaces, which seems like
the most likely place to discuss such a feature.

regards, tom lane