Postgres Pro
Downloads
Home   >   mailing lists

Thread: Extension script error

Extension script error

From
Bartosz Dmytrak
Date:
Hi,
I think there is a bug in extensions SQL window eg. for intarray extension, generated script looks like this: 
-- Extension: intarray

-- DROP EXTENSION intarray;

 CREATE EXTENSION intarray
  SCHEMA public
  VERSION 1.0;
ALTER EXTENSION intarray
  OWNER TO postgres;

But should be:
-- Extension: intarray

-- DROP EXTENSION intarray;

 CREATE EXTENSION intarray
  SCHEMA public
  VERSION "1.0";
ALTER EXTENSION intarray
  OWNER TO postgres;

I mean, there should be quotation around version number. When You create extension, script is generated properly.
pgAdmin 1.14.1 Windows 7 32 bit.

Regards,
Bartek

Re: Extension script error

From
Guillaume Lelarge
Date:
On Tue, 21 Feb 2012 13:13:02 +0100, Bartosz Dmytrak <bdmytrak@eranet.pl>
wrote:
> Hi,I think there is a bug in extensions SQL window eg. for intarray
> extension, generated script looks like this: -- Extension: intarray
> -- DROP EXTENSION intarray;
>   CREATE EXTENSION intarray  SCHEMA public   VERSION 1.0;ALTER
> EXTENSION intarray   OWNER TO postgres;
> But should be:-- Extension: intarray
> -- DROP EXTENSION intarray;
>   CREATE EXTENSION intarray  SCHEMA public   VERSION "1.0";ALTER
> EXTENSION intarray   OWNER TO postgres;
> I mean, there should be quotation around version number. When You create
> extension, script is generated properly. pgAdmin 1.14.1 Windows 7 32
bit.

You're right. This bug is now fixed.

Thank you.


--
Guillaumehttp://www.postgresql.frhttp://dalibo.com