Re: psql questions: SQL, progname, copyright dates

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: psql questions: SQL, progname, copyright dates
Date: 2004-08-29 22:29:19
Message-ID: b9c4f0abbce5cfefa5363a507dcca94a@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I find this quite ugly, and don't think it's a good change. Anyone
> who's fool enough to use trailing spaces in column names deserves the
> pain it will cost them --- and there is no other case in which the
> unquoted display is ambiguous.

I agree, just wanted to see how pedantic we were going to be. As long
as nobody is using the output of psql for input into a script, we
should be fine.

> If we are going to go over to a policy of displaying names the same way
> you'd have to type them, what of the table name at the top of the
> output? (I actually would vote for some change there, because I think
> the way we are quoting the whole thing is actively misleading...)

Agreed: I'll remove that odd quoting in my next patch if nobody else obejcts.

> For that matter, wouldn't consistency require that column headings
> in SELECT results be quoted similarly?

Yes, that would be consistently ugly. :)

> On the ordering issues, I'd go for straight alphabetical schema/name
> sort in all cases; I thought that's where we were already, but if you
> see some missing cases let's fix it. I'm not enamored of discriminating
> against system objects in the sort order.

I don't agree with this. We already discriminate against system objects by
not showing system tables, for example, when doing a \dt. There is no reason
I should have to scroll through 1500+ system functions using \df because I
forgot the name of one of the 12 functions I've created, or simply because
I want to view all 12 quickly.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200408291827

-----BEGIN PGP SIGNATURE-----

iD8DBQFBMlj2vJuQZxSWSsgRAtOIAJ4mpzC/pSzDcVSjRSecwoGVYUOScgCg150m
m4qpZuc7wT0998bNyPQWU6E=
=yXLQ
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-29 23:34:29 Re: FYI: 8.0beta2 on Monday
Previous Message Tom Lane 2004-08-29 22:26:24 Testing needed for recent tablespace hacking