Re: [HACKERS] Useful addition for psql? - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] Useful addition for psql?
Date
Msg-id f2a0ee9c15a1c147da6970c6c0dde9cd
Whole thread Raw
In response to [HACKERS] Useful addition for psql?  (Andrew Martin <martin@biochemistry.ucl.ac.uk>)
List pgsql-hackers
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

------------------------------

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] 6.1 jumbo patch?
Next
From: aixssd!darrenk@abs.net (Darren King)
Date:
Subject: Re: [HACKERS] Tuple size