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

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 to pg_createuser

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: Is this a TODO?

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 anybody but Zdenek to

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

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

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 createdb shipped by

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 before?

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 bad

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 following interface:

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
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 EnterpriseDB

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

2007-06-04 Thread Robert Haas
in the name somewhere? ...Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: Monday, June 04, 2007 10:31 AM To: Bruce Momjian Cc: Zdenek Kotala; Andrew Dunstan; Peter Eisentraut; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Command tags

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 these

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 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 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 already exists:

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

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 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. I don't

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 is

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, 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.