Foreign server script error

From: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
To: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Foreign server script error
Date: 2012-03-23 10:36:19
Message-ID: CAD8_UcZMja0+yiAA5AA-rs36mHOU3NmWEUg0aERSp-BOhrAOAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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"

Regards,
Bartek

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-03-23 16:42:10 Re: Creating relationship links in PostgreSQL via pgAdmin
Previous Message Raymond O'Donnell 2012-03-22 17:18:21 Re: forgotten password