| From: | Andreas Karlsson <andreas(at)proxel(dot)se> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, "Fred (dot)Flintstone" <eldmannen(at)gmail(dot)com> |
| Cc: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(at)paquier(dot)xyz>, Chris Travers <chris(dot)travers(at)adjust(dot)com>, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Euler Taveira <euler(at)timbira(dot)com(dot)br>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL pollutes the file system |
| Date: | 2019-03-27 14:07:24 |
| Message-ID: | 044a865f-c0c2-70e4-f4d0-ec841d701fda@proxel.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-pkg-debian |
On 3/27/19 2:51 PM, Tomas Vondra wrote:
> I think the consensus in this thread (and the previous ancient ones) is
> that it's not worth it. It's one thing to introduce new commands with the
> pg_ prefix, and it's a completely different thing to rename existing ones.
> That has inherent costs, and as Tom pointed out the burden would fall on
> people using PostgreSQL (and that's rather undesirable).
>
> I personally don't see why having commands without pg_ prefix would be
> an issue. Especially when placed in a separate directory, which eliminates
> the possibility of conflict with other commands.
I buy that it may not be worth breaking tens of thousands of scripts to
fix this, but I disagree about it not being an issue. Most Linux
distributions add PostgreSQL's executables in to a directory which is in
the default $PATH (/usr/bin in the case of Debian). And even if it would
be installed into a separate directory there would still be a conflict
as soon as that directory is added to $PATH.
And I think that it is also relatively easy to confuse adduser and
createuser when reading a script. Nothing about the name createuser
indicates that it will create a role in an SQL database.
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2019-03-27 14:20:05 | Re: PostgreSQL pollutes the file system |
| Previous Message | Alvaro Herrera | 2019-03-27 14:00:18 | Re: PostgreSQL pollutes the file system |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2019-03-27 14:20:05 | Re: PostgreSQL pollutes the file system |
| Previous Message | Alvaro Herrera | 2019-03-27 14:00:18 | Re: PostgreSQL pollutes the file system |