psql questions: SQL, progname, copyright dates
От | Greg Sabino Mullane |
---|---|
Тема | psql questions: SQL, progname, copyright dates |
Дата | |
Msg-id | e0faa0afda7c4ffe226c67ad11866aa5@biglumber.com обсуждение исходный текст |
Ответы |
Re: psql questions: SQL, progname, copyright dates
Re: psql questions: SQL, progname, copyright dates |
Список | 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@turnstep.com PGP Key: 0x14964AC8 200408271906 -----BEGIN PGP SIGNATURE----- iD8DBQFBL8FfvJuQZxSWSsgRAifeAKC8cTVXJLRe5oj87b18E2VFAY6B2ACg/L3s lYrIEDfDZWANnafPiFx/bBc= =8lO2 -----END PGP SIGNATURE-----
В списке pgsql-hackers по дате отправления: