Alejandro Gasca wrote: > Hi, if i open a sql pane, and put: > GRANT SELECT ON > and press [ctrl]+[space] this error rise: > > ERROR: syntax error at or near "DATABASE" > LINE 6: UNION SELECT "DATABASE" UNION SELECT "FUNCTION" UNION S...
Magnus - can you take a look at this please. I'm not overly familiar with your code and would rather not break it... It seems that _complete_from_query() (in tabcomplete.c) is calling PQescapeString() on the addon param which is doubling the existing quotes around the unioned bits of the query (ie. SELECT 'DATABASE'). As far as I can see all this does is break cases like the one Alejandro has reported. Have I missed any other cases? /D ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org