Re: [HACKERS] [BUGS] pg_service.conf ignores dbname parameter

2003-12-20 Thread Peter Eisentraut
Bruce Momjian wrote: > I thought he was more concerned about removing envirnment variables > that have to be tuned for each user. Let's see how he responds. Think about a web server talking to a database server. Where do you set the environment variables for that? Or where is the "home directo

Re: [HACKERS] [BUGS] pg_service.conf ignores dbname parameter

2003-12-19 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> BTW, why is it that pg_service.conf is system-wide? Personally I'd > >> think it more useful to seek settings in ~/.pg_service.conf. > > > Perhaps the solution is to allow an environment variable to point to the

Re: [HACKERS] [BUGS] pg_service.conf ignores dbname parameter

2003-12-19 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> BTW, why is it that pg_service.conf is system-wide? Personally I'd >> think it more useful to seek settings in ~/.pg_service.conf. > Perhaps the solution is to allow an environment variable to point to the > services file. Peter was

Re: [HACKERS] [BUGS] pg_service.conf ignores dbname parameter

2003-12-19 Thread Bruce Momjian
Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Regardless of this particular issue, I think it would be useful if, > > under some conditions to be identified, some service were taken as > > default if nothing is specied in libpq. That would eliminate the need > > to set envi

Re: [HACKERS] [BUGS] pg_service.conf ignores dbname parameter

2003-12-18 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Regardless of this particular issue, I think it would be useful if, > under some conditions to be identified, some service were taken as > default if nothing is specied in libpq. That would eliminate the need > to set environment variables, which i

Re: [HACKERS] [BUGS] pg_service.conf ignores dbname parameter

2003-12-18 Thread Peter Eisentraut
Tom Lane wrote: > Hm. I'm of the opinion that the real problem here is the code's > assumption that it is reasonable to force dbname = servicename when > the service file doesn't say any such thing. For all other > parameters, omitting the parameter from pg_service.conf causes the > standard defa

Re: [HACKERS] [BUGS] pg_service.conf ignores dbname parameter

2003-12-17 Thread Bruce Momjian
Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > When a client connects to the database server using a service name, > > the dbname parameter in pg_service.conf is ignored. In the absence > > of an explicitly-named database in the connection string, the service > > name is used as th

Re: [HACKERS] [BUGS] pg_service.conf ignores dbname parameter

2003-12-17 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > When a client connects to the database server using a service name, > the dbname parameter in pg_service.conf is ignored. In the absence > of an explicitly-named database in the connection string, the service > name is used as the database name regardless