Dear Adrien,

I applied your file and faced a bug-candidate.
(I have not read your source yet. Sorry.)

When I tried to use tab-complition, some dirty messages were appeared.

Messages I faced are attached in this mail.

Best Regards,
Hayato Kuroda
Fujitsu LIMITED

postgres=# SET client_min_messages to LOG;
SET
postgres=# SET log_transaction_sample_rate to 1;
SET
postgres=# select * from LOG:  duration: 4.906 ms  statement: SELECT 
pg_catalog.quote_ident(c.relname) FROM pg_catalog.pg_class c WHERE c.relkind IN 
('r', 'S', 'v', 'm', 'f', 'p') AND 
substring(pg_catalog.quote_ident(c.relname),1,0)='' AND 
pg_catalog.pg_table_is_visible(c.oid) AND c.relnamespace <> (SELECT oid FROM 
pg_catalog.pg_namespace WHERE nspname = 'pg_catalog')
UNION
SELECT pg_catalog.quote_ident(n.nspname) || '.' FROM pg_catalog.pg_namespace n 
WHERE substring(pg_catalog.quote_ident(n.nspname) || '.',1,0)='' AND (SELECT 
pg_catalog.count(*) FROM pg_catalog.pg_namespace WHERE 
substring(pg_catalog.quote_ident(nspname) || '.',1,0) = 
substring('',1,pg_catalog.length(pg_catalog.quote_ident(nspname))+1)) > 1
UNION
SELECT pg_catalog.quote_ident(n.nspname) || '.' || 
pg_catalog.quote_ident(c.relname) FROM pg_catalog.pg_class c, 
pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind IN ('r', 
'S', 'v', 'm', 'f', 'p') AND substring(pg_catalog.quote_ident(n.nspname) || '.' 
|| pg_catalog.quote_ident(c.relname),1,0)='' AND 
substring(pg_catalog.quote_ident(n.nspname) || '.',1,0) = 
substring('',1,pg_catalog.length(pg_catalog.quote_ident(n.nspname))+1) AND 
(SELECT pg_catalog.count(*) FROM pg_catalog.pg_namespace WHERE 
substring(pg_catalog.quote_ident(nspname) || '.',1,0) = 
substring('',1,pg_catalog.length(pg_catalog.quote_ident(nspname))+1)) = 1
LIMIT 1000
LOG:  duration: 1.871 ms  statement: SELECT pg_catalog.quote_ident(c.relname) 
FROM pg_catalog.pg_class c WHERE c.relkind IN ('r', 'S', 'v', 'm', 'f', 'p') 
AND substring(pg_catalog.quote_ident(c.relname),1,0)='' AND 
pg_catalog.pg_table_is_visible(c.oid) AND c.relnamespace <> (SELECT oid FROM 
pg_catalog.pg_namespace WHERE nspname = 'pg_catalog')
UNION
SELECT pg_catalog.quote_ident(n.nspname) || '.' FROM pg_catalog.pg_namespace n 
WHERE substring(pg_catalog.quote_ident(n.nspname) || '.',1,0)='' AND (SELECT 
pg_catalog.count(*) FROM pg_catalog.pg_namespace WHERE 
substring(pg_catalog.quote_ident(nspname) || '.',1,0) = 
substring('',1,pg_catalog.length(pg_catalog.quote_ident(nspname))+1)) > 1
UNION
SELECT pg_catalog.quote_ident(n.nspname) || '.' || 
pg_catalog.quote_ident(c.relname) FROM pg_catalog.pg_class c, 
pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind IN ('r', 
'S', 'v', 'm', 'f', 'p') AND substring(pg_catalog.quote_ident(n.nspname) || '.' 
|| pg_catalog.quote_ident(c.relname),1,0)='' AND 
substring(pg_catalog.quote_ident(n.nspname) || '.',1,0) = 
substring('',1,pg_catalog.length(pg_catalog.quote_ident(n.nspname))+1) AND 
(SELECT pg_catalog.count(*) FROM pg_catalog.pg_namespace WHERE 
substring(pg_catalog.quote_ident(nspname) || '.',1,0) = 
substring('',1,pg_catalog.length(pg_catalog.quote_ident(nspname))+1)) = 1
LIMIT 1000

foo                  pg_catalog.          pg_toast.            public.
information_schema.  pg_temp_1.           pg_toast_temp_1.  

Reply via email to