Postgres Pro
Downloads
Home   >   mailing lists

Re: error auto-completing "GRANT SELECT ON" - Mailing list pgadmin-support

From Dave Page
Subject Re: error auto-completing "GRANT SELECT ON"
Date
Msg-id 47274D35.6030606@postgresql.org
Whole thread Raw
In response to error auto-completing "GRANT SELECT ON"  ("Alejandro Gasca" <galejadror@gmail.com>)
Responses Re: error auto-completing "GRANT SELECT ON"  (Magnus Hagander <magnus@hagander.net>)
List pgadmin-support
Tree view 
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

pgadmin-support by date:

Previous
From: "Stefan Wolf \(Zielpunkt-Marketing\)"
Date:
Subject: Error creating a new index with tablespace and fillfacotor
Next
From: Dave Page
Date:
Subject: Re: Error creating a new index with tablespace and fillfacotor