Re: PostgreSQL pollutes the file system

From: Christoph Berg <myon(at)debian(dot)org>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, Andreas Karlsson <andreas(at)proxel(dot)se>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, eldmannen(at)gmail(dot)com, mark(dot)kirkwood(at)catalyst(dot)net(dot)nz, Michael Paquier <michael(at)paquier(dot)xyz>, Chris Travers <chris(dot)travers(at)adjust(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Euler Taveira <euler(at)timbira(dot)com(dot)br>, rjuju123(at)gmail(dot)com, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL pollutes the file system
Date: 2019-03-29 20:30:09
Message-ID: 20190329203008.GE19154@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-pkg-debian

Re: Joe Conway 2019-03-29 <f579fde8-8266-f2d6-4ba1-91c6046bc2f6(at)joeconway(dot)com>
> >> echo "\password :\"role\"" | psql -v role='my role'
> >
> > It is on-topic because the reason we can't just tell people to replace
> > createuser $foo
> > with
> > psql -c "create user $foo"
> > is because $foo might need escaping.
> >
> > IMHO if we find an way to do that which is acceptable for sh scripts,
> > the createuser/... commands could go.
>
> I think these commands *were* once (at least some of them) shell scripts
> and we went to executable C in order to make them work on Windows, IIRC.

I meant the interface to these programs. It needs to be something
people can use in sh scripts without wtf'ing. The :\"weirdness\" |
cited above is IMHO not acceptable.

Christoph

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Danylo Hlynskyi 2019-03-29 20:37:44 Unix socket dir, an idea
Previous Message Robert Haas 2019-03-29 20:07:42 Re: monitoring CREATE INDEX [CONCURRENTLY]

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Andrew Dunstan 2019-03-29 21:06:35 Re: PostgreSQL pollutes the file system
Previous Message Joe Conway 2019-03-29 20:05:29 Re: PostgreSQL pollutes the file system