Thread: Foreign server script error

Foreign server script error

From
Bartosz Dmytrak
Date:
Hi,
I think there is another bug in foreign server script:
pgAdmin generates script like this one:
-- Server: "kpi@localhost"

-- DROP SERVER "kpi@localhost";

CREATE SERVER kpi@localhost
   FOREIGN DATA WRAPPER "myWrapper"
  OPTIONS (host 'localhost',dbname 'kpi',port '5432');
ALTER SERVER kpi@localhost
  OWNER TO postgres;

but should use server name quotation eg. 
ALTER SERVER "kpi@localhost"

Regards,
Bartek

Re: Foreign server script error

From
Guillaume Lelarge
Date:
On Fri, 2012-03-23 at 11:36 +0100, Bartosz Dmytrak wrote:
> Hi,
> I think there is another bug in foreign server script:
> pgAdmin generates script like this one:
> -- Server: "kpi@localhost"
> 
> -- DROP SERVER "kpi@localhost";
> 
> CREATE SERVER kpi@localhost
>    FOREIGN DATA WRAPPER "myWrapper"
>   OPTIONS (host 'localhost',dbname 'kpi',port '5432');
> ALTER SERVER kpi@localhost
>   OWNER TO postgres;
> 
> but should use server name quotation eg.
> ALTER SERVER "kpi@localhost"
> 

You're right, this is fixed.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com