Postgres Pro
Downloads
Home   >   mailing lists

Foreign server script error - Mailing list pgadmin-support

From Bartosz Dmytrak
Subject Foreign server script error
Date
Msg-id CAD8_UcZMja0+yiAA5AA-rs36mHOU3NmWEUg0aERSp-BOhrAOAQ@mail.gmail.com
Whole thread Raw
Responses Re: Foreign server script error  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
Tree view
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

pgadmin-support by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: forgotten password
Next
From: MrTeeth
Date:
Subject: Creating relationship links in PostgreSQL via pgAdmin