While testing Noah's filename quoting patch on my local development
machine, I noticed some strange behaviour around tab completion with
\i; it doesn't appear to be present in 9.1, but it is present on 9.2
HEAD and appears to be present with and without readline.
It manifests as the client preferring statement completion over
filename completion until the first time \i is forced to check
something on disk, after which it begins to work as expected.
Here's a reliable reproduction on my OS X laptop.
-> % bin/psql
psql (9.2devel, server 9.0.4)
WARNING: psql version 9.2, server version 9.0.
Some psql features might not work.
Type "help" for help.
pvh=# \i <TAB><TAB>
ABORT ALTER ANALYZE BEGIN
CHECKPOINT CLOSE CLUSTER COMMENT COMMIT
COPY CREATE DEALLOCATE
DECLARE DELETE FROM DISCARD DO DROP
END EXECUTE EXPLAIN FETCH
GRANT INSERT LISTEN
LOAD LOCK MOVE NOTIFY
PREPARE REASSIGN REINDEX RELEASE RESET
REVOKE ROLLBACK SAVEPOINT
SECURITY LABEL SELECT SET SHOW START
TABLE TRUNCATE UNLISTEN UPDATE
VACUUM VALUES WITH
pvh=# \i asdf
asdf: No such file or directory
pvh=# \i ./<TAB><TAB>
./bin ./include ./lib ./oh hai ./share
I don't see this regression with the 9.1 client I have here, so I
suspect it has something to do with whatever patch introduced the
relative paths by default.
Peter van Hardenberg
San Francisco, California
"Everything was beautiful, and nothing hurt." -- Kurt Vonnegut
pgsql-hackers by date
|Next:||From: Noah Misch||Date: 2012-02-23 23:57:47|
|Subject: Re: foreign key locks, 2nd attempt|
|Previous:||From: Peter Eisentraut||Date: 2012-02-23 23:16:30|
|Subject: Re: Notes about fixing regexes and UTF-8 (yet again)|