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 pvh=# \i 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. -p -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt." -- Kurt Vonnegut -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers