Skip site navigation (1) Skip section navigation (2)

psql questions: SQL, progname, copyright dates

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: psql questions: SQL, progname, copyright dates
Date: 2004-08-27 23:17:32
Message-ID: e0faa0afda7c4ffe226c67ad11866aa5@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
 
I was looking through the code of psql and had a few questions:
 
1. Do we want to use quote_ident on object names? Ideally, column
names with a space in them, for example, should be surrounded by
double quotes.
 
2. There is a disconnect between what \? says:
 
  \d [NAME]      describe table, index, sequence, or view
  \d{t|i|s|v|S} [PATTERN] (add "+" for more detail)
                 list tables/indexes/sequences/views/system tables
 
and the actual default case:
 
  WHERE c.relkind IN ('r','v','S','')
 
Should we include indexes by default? If not, the help file should
be clearer about what happens when no arg is given to \d.
 
3. I'd like to rearrange the ORDER BY on some objects to show
user-created objects before system ones. Currently, if I create
a new function and do a \df, I have to wade through all the
system functions in the pg_catalog schema before seeing mine.
This seems to be solely because "public" comes after "pg_catalog"
alphabetically.
 
4. Some of the ORDER BY clauses are incomplete, and not all are
consistent with each other. Most seem to be ordering by schema name,
then object name. If this the direction we want all of them to
go? (e.g. \df)
 
5. psql from cvs was coredumping on me earlier today when psql_error
was called. I tracked it down to the invoking of the pset.progname
variable in fprintf, but the problem fixed itself on the next make,
so I don't have more detail than that. I'd appreciate if someone could
check out the 'progname' var and see if I overlooked something.
 
6. Can someone run that magic year-changing update script mentioned
earlier? The dates should be 2004, not 2003.
 
Thanks,
 
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200408271906
-----BEGIN PGP SIGNATURE-----
 
iD8DBQFBL8FfvJuQZxSWSsgRAifeAKC8cTVXJLRe5oj87b18E2VFAY6B2ACg/L3s
lYrIEDfDZWANnafPiFx/bBc=
=8lO2
-----END PGP SIGNATURE-----



Responses

pgsql-hackers by date

Next:From: Jonathan GardnerDate: 2004-08-27 23:18:32
Subject: Re: Contrib -- PostgreSQL shared variables
Previous:From: Tom LaneDate: 2004-08-27 22:58:39
Subject: Re: Regression test failures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group