Re: PostgreSQL pollutes the file system

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

In response to

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-pkg-debian by date

  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