From: | Andreas Karlsson <andreas(at)proxel(dot)se> |
---|---|
To: | Chris Travers <chris(dot)travers(at)adjust(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, euler(at)timbira(dot)com(dot)br, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, rjuju123(at)gmail(dot)com, "Fred (dot)Flintstone" <eldmannen(at)gmail(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PostgreSQL pollutes the file system |
Date: | 2019-03-21 12:12:23 |
Message-ID: | fdbcadf7-9edd-b20d-9987-4e7d21d23b2d@proxel.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-pkg-debian |
On 3/21/19 7:07 AM, Chris Travers wrote:
> 1. createuser/dropuser are things that I don't consider good ways of
> creating users anyway. I think we should just consider removing these
> binaries. The SQL queries are better, more functional, and can be
> rolled back as a part of a larger transaction.
Those binaries are pretty convenient to use in scripts since they handle
SQL escaping for you, but probably not convenient enough that we would
have added createuser today.
Compare
createuser "$USER"
vs
echo 'CREATE ROLE :"user" LOGIN' | psql postgres -v "user=$USER"
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Jesper Pedersen | 2019-03-21 12:45:19 | Re: speeding up planning with partitions |
Previous Message | Christoph Berg | 2019-03-21 11:51:00 | Re: Re: Reporting script runtimes in pg_regress |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-03-21 14:02:40 | Re: PostgreSQL pollutes the file system |
Previous Message | Alvaro Herrera | 2019-03-21 11:45:25 | Re: PostgreSQL pollutes the file system |