Re: [HACKERS] Command tags in create/drop scripts

2008-03-11 Thread Bruce Momjian
Added to TODO: * Prefix command-line utilities like createuser with 'pg_' http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php --- Alvaro Herrera wrote: > Zdenek Kotala wrote: > > Tom Lane wrote: > > >Bruce

Re: [HACKERS] Command tags in create/drop scripts

2007-06-12 Thread Zdenek Kotala
David Fetter wrote: On Fri, Jun 08, 2007 at 08:12:22PM -0500, Jim C. Nasby wrote: On Tue, Jun 05, 2007 at 05:52:39PM -, Andrew Hammond wrote: On Jun 5, 9:19 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote: Zdenek Kotala wrote: Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: Is th

Re: [HACKERS] Command tags in create/drop scripts

2007-06-09 Thread David Fetter
On Fri, Jun 08, 2007 at 08:12:22PM -0500, Jim C. Nasby wrote: > On Tue, Jun 05, 2007 at 05:52:39PM -, Andrew Hammond wrote: > > On Jun 5, 9:19 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > > > Zdenek Kotala wrote: > > > > Tom Lane wrote: > > > > >Bruce Momjian <[EMAIL PROTECTED]> writes: > >

Re: [HACKERS] Command tags in create/drop scripts

2007-06-09 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Jim C. Nasby wrote: >> On Tue, Jun 05, 2007 at 05:52:39PM -, Andrew Hammond wrote: >>> +1. Given the prevalence of the pg_foo convention, those names are >>> clunky. So is initdb. I'm less creative than Zdenek, so I'd suggest >>> simply renaming t

Re: [HACKERS] Command tags in create/drop scripts

2007-06-08 Thread Joshua D. Drake
Jim C. Nasby wrote: On Tue, Jun 05, 2007 at 05:52:39PM -, Andrew Hammond wrote: On Jun 5, 9:19 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote: Zdenek Kotala wrote: Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: Is this a TODO? I don't think so; there is no demand from anybody b

Re: [HACKERS] Command tags in create/drop scripts

2007-06-08 Thread Jim C. Nasby
On Tue, Jun 05, 2007 at 05:52:39PM -, Andrew Hammond wrote: > On Jun 5, 9:19 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > > Zdenek Kotala wrote: > > > Tom Lane wrote: > > > >Bruce Momjian <[EMAIL PROTECTED]> writes: > > > >>Is this a TODO? > > > > > >I don't think so; there is no demand from

Re: [HACKERS] Command tags in create/drop scripts

2007-06-05 Thread Andrew Hammond
On Jun 5, 9:19 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > Zdenek Kotala wrote: > > Tom Lane wrote: > > >Bruce Momjian <[EMAIL PROTECTED]> writes: > > >>Is this a TODO? > > > >I don't think so; there is no demand from anybody but Zdenek to remove > > >those programs. Has it ever even come up b

Re: [HACKERS] Command tags in create/drop scripts

2007-06-05 Thread Alvaro Herrera
Zdenek Kotala wrote: > Tom Lane wrote: > >Bruce Momjian <[EMAIL PROTECTED]> writes: > >>Is this a TODO? > > > >I don't think so; there is no demand from anybody but Zdenek to remove > >those programs. Has it ever even come up before? Personally I found really strange to have "createuser" and "cre

Re: [HACKERS] Command tags in create/drop scripts

2007-06-05 Thread Zdenek Kotala
Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: Is this a TODO? I don't think so; there is no demand from anybody but Zdenek to remove those programs. Has it ever even come up before? Tom, Bruce I started with postgres 6.5 as administrator and from this version names of these u

Re: [HACKERS] Command tags in create/drop scripts

2007-06-04 Thread Robert Haas
postgresql.org Subject: Re: [HACKERS] Command tags in create/drop scripts Bruce Momjian <[EMAIL PROTECTED]> writes: > Is this a TODO? I don't think so; there is no demand from anybody but Zdenek to remove those programs. Has it ever even come up before?

Re: [HACKERS] Command tags in create/drop scripts

2007-06-04 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Is this a TODO? > > I don't think so; there is no demand from anybody but Zdenek to remove > those programs. Has it ever even come up before? No. Agreed. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us Enterp

Re: [HACKERS] Command tags in create/drop scripts

2007-06-04 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Is this a TODO? I don't think so; there is no demand from anybody but Zdenek to remove those programs. Has it ever even come up before? regards, tom lane ---(end of broadcast)---

Re: [HACKERS] Command tags in create/drop scripts

2007-06-04 Thread Bruce Momjian
Is this a TODO? --- Zdenek Kotala wrote: > Tom Lane napsal(a): > > Andrew Dunstan <[EMAIL PROTECTED]> writes: > >> Zdenek Kotala wrote: > > And what about replace all "scripts" by one command e.g pg_cmd with > > fol

Re: [HACKERS] Command tags in create/drop scripts

2007-06-04 Thread Zdenek Kotala
Tom Lane napsal(a): Andrew Dunstan <[EMAIL PROTECTED]> writes: Zdenek Kotala wrote: And what about replace all "scripts" by one command e.g pg_cmd with following interface: Well, I don't think rolling up the miscellaneous commands into a single binary with behaviour dependent on arg[0] is a

Re: [HACKERS] Command tags in create/drop scripts

2007-06-01 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Zdenek Kotala wrote: And what about replace all "scripts" by one command e.g pg_cmd with following interface: > Well, I don't think rolling up the miscellaneous commands into a single > binary with behaviour dependent on arg[0] is a bad idea

Re: [HACKERS] Command tags in create/drop scripts

2007-06-01 Thread Andrew Dunstan
Zdenek Kotala wrote: Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: Zdenek Kotala wrote: And what about replace all "scripts" by one command e.g pg_cmd with following interface: pg_cmd create database <...> And we'll break a million applications that rely on the command names

Re: [HACKERS] Command tags in create/drop scripts

2007-06-01 Thread Zdenek Kotala
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: Zdenek Kotala wrote: And what about replace all "scripts" by one command e.g pg_cmd with following interface: pg_cmd create database <...> And we'll break a million applications that rely on the command names. Compatibility is po

Re: [HACKERS] Command tags in create/drop scripts

2007-06-01 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Zdenek Kotala wrote: >> And what about replace all "scripts" by one command e.g pg_cmd with >> following interface: >> >> pg_cmd create database <...> > And we'll break a million applications that rely on the command names. If you want that, it alre

Re: [HACKERS] Command tags in create/drop scripts

2007-06-01 Thread Andrew Dunstan
Zdenek Kotala wrote: And what about replace all "scripts" by one command e.g pg_cmd with following interface: pg_cmd create database <...> create role ... drop database ... list database ... It solves potential name collision (for example createuser should collide

Re: [HACKERS] Command tags in create/drop scripts

2007-06-01 Thread Zdenek Kotala
Peter Eisentraut wrote: The messages output by the "scripts" always seemed unnecessary to me, e.g., $ createdb foo CREATE DATABASE A Unix program (hi Magnus) shouldn't need to say anything if the requested action succeeded. I believe the history of this output is actually that these scripts

Re: [HACKERS] Command tags in create/drop scripts

2007-06-01 Thread Bruce Momjian
Peter Eisentraut wrote: > The messages output by the "scripts" always seemed unnecessary to me, e.g., > > $ createdb foo > CREATE DATABASE > > A Unix program (hi Magnus) shouldn't need to say anything if the requested > action succeeded. > > I believe the history of this output is actually that

Re: [HACKERS] Command tags in create/drop scripts

2007-05-31 Thread CAJ CAJ
On 5/31/07, CAJ CAJ <[EMAIL PROTECTED]> wrote: > Can it me made to return an integer like most UNIX commands do? This > helps > > immensely when writing shell scripts. > > Don't they do that already? If not, that's a bug quite independent of > Peter's cosmetic concern. Ah, I just tested it.

Re: [HACKERS] Command tags in create/drop scripts

2007-05-31 Thread Tom Lane
"CAJ CAJ" <[EMAIL PROTECTED]> writes: > Can it me made to return an integer like most UNIX commands do? This helps > immensely when writing shell scripts. Don't they do that already? If not, that's a bug quite independent of Peter's cosmetic concern. regards, tom lane --

Re: [HACKERS] Command tags in create/drop scripts

2007-05-31 Thread CAJ CAJ
On 5/31/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote: The messages output by the "scripts" always seemed unnecessary to me, e.g ., $ createdb foo CREATE DATABASE A Unix program (hi Magnus) shouldn't need to say anything if the requested action succeeded. I believe the history of this output

[HACKERS] Command tags in create/drop scripts

2007-05-31 Thread Peter Eisentraut
The messages output by the "scripts" always seemed unnecessary to me, e.g., $ createdb foo CREATE DATABASE A Unix program (hi Magnus) shouldn't need to say anything if the requested action succeeded. I believe the history of this output is actually that these scripts simply used to call psql a