Package: postgresql-client-common
Version: 59
Severity: normal

Hi,

The psql wrappers provided by postgresql-client-common break the 
environment sensibility of the psql command line tool. (and possibly 
others.)

The PostgreSQL documenation, as well as "man psql" state that one can 
set environment variables like PGDATABASE, PGHOST, PGPORT and PGUSER.
This is handled low-level by libpq.

However, the multi-cluster wrapper of psql does not honour those 
variables, but overrides them with its own defaults in the absence of 
command line parameters. 

This breaks scripts that rely on those settings.

[~] -> export PGDATABASE=foobar
[~] -> /usr/lib/postgresql/8.1/bin/psql -c "select current_database()"
 current_database 
------------------
 foobar
(1 row)

[~] -> psql -c "select current_database()" 
 current_database 
------------------
 postgres
(1 row)


Thanks,
Markus

-- System Information:
Debian Release: testing/unstable
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable'), (500, 'stable'), (1, 
'experimental')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.17.3-fire
Locale: LANG=C, [EMAIL PROTECTED] (charmap=ISO-8859-15)

Versions of packages postgresql-client-common depends on:
ii  debconf [debconf-2.0]         1.5.3      Debian configuration management sy

postgresql-client-common recommends no packages.

-- no debconf information


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to