Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group