Re: psql + autocommit

Lars Haugseth wrote:
> * Michael Paesold:
> | Peter Eisentraut wrote:
> | > Lars Haugseth wrote:
> | > > Version 8.0.0beta2 supports a global configuration file. It's should
> | > > be located in '~postgres/etc/pgsql'.
> | >
> | > That would be pretty useless, since normal users often don't have read
> | > access to another user's home directory.
> |
> | Further up in this thread I read $PGDATA/etc/psqlrc, which seems like
> | nonsense, too. First, $PGDATA is not known at compile time, second no user
> | should have access to that directory.
> |
> | Perhaps it should be (and really is) $PREFIX/etc/psqlrc?
> | (where $PREFIX is of course the installation prefix set during configure)
> |
> | I am not at work, so I can have a look at the code or test it myself right
> | now.
>
> There's a file $PREFIX/share/psqlrc.sample that reads:
>
> --
> -- psql configuration file
> --
> -- This file is read before the .psqlrc file in the user's home directory.
> --
> -- Copy this to your sysconf directory (typically /usr/local/pgsql/etc) and
> -- rename it psqlrc.
>
> So $PREFIX/etc/psqlrc is the right place. (In my setup, ~postgres equals
> $PREFIX).
>
> This directory is not created by "gmake install", though. Perhaps it should
> be?

The directory is not created because we don't know if they will be using
this feature.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073