Marc G. Fournier wrote:
>
> On Fri, 20 Jun 1997, Vadim B. Mikheev wrote:
>
> > > in the users directory. When createdb is run, have a 'system default'
> > > profile written to that databases pg_profile? Or would each table created
> > ^^^^
> > Why not in .../data dirrectory ? User may connect to different databases...
>
> Would a user necessariloy want the same settings for all databases they
> access?
pg_profile in /data:
usesysid int4
database oid
^^^^^^^^^^^^^^^^^^^ - if this oid is invalid that these
settings are global (to be processed
first)
settings text
> for all tables?
^^^^^^^^^^^^^^
Currently, all our settings affect session at whole...
I haven't idea about usefull table-level settings.
>
> > ...But - it requires dump/reload...
> > .pgsqlrc doesn't...
>
> True...add .pgsqlrc, if possible, in time for Bruce's desire for
> a quick *one time only* v6.1 mega patch, and then throw in the pg_profile
> table right after?
Yes.
Vadim
------------------------------