| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Bartosz Dmytrak <bdmytrak(at)gmail(dot)com> |
| Cc: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Foreign server script error |
| Date: | 2012-03-23 16:57:46 |
| Message-ID: | 1332521866.3142.95.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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(at)localhost"
>
> -- DROP SERVER "kpi(at)localhost";
>
> CREATE SERVER kpi(at)localhost
> FOREIGN DATA WRAPPER "myWrapper"
> OPTIONS (host 'localhost',dbname 'kpi',port '5432');
> ALTER SERVER kpi(at)localhost
> OWNER TO postgres;
>
> but should use server name quotation eg.
> ALTER SERVER "kpi(at)localhost"
>
You're right, this is fixed.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Colin Beckingham | 2012-03-23 17:01:47 | 1.15 dev: cut and paste |
| Previous Message | Guillaume Lelarge | 2012-03-23 16:42:10 | Re: Creating relationship links in PostgreSQL via pgAdmin |