Home > mailing lists

Thread: Foreign server script error

Foreign server script error

From

Bartosz Dmytrak

Date:

23 March 2012, 10:37:15

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:

23 March 2012, 16:58:01

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