Re: Superfluous SQL statements

On 08/01/2008, Erwin Brandstetter <brandstetter@falter.at> wrote:
> Hi developers!

Hi Erwin,

> You have not heard a lot of me lately, and I am afraid that will not change
> substantially for some time. I am kind of swamped with other stuff.
> Anyhoo, I hope this bug report proves  useful.

Sorry to hear that :-(.

> Testing pgAdmin v.1.8.1 (Jan 3 2008), rev: 6948).
> host: pg 8.2.5 on Debian Etch
> client: Windows XP.
>
> Trying to edit the default of a column with type integer[] per dialogue
> fails. I think I found the cause in the database logs.  pgAdmin sends
> additional (unneeded) SQL-statements, that trigger an error.
>
> That's what it should send:
>         ALTER TABLE ef.kat ALTER COLUMN pfad SET DEFAULT '{}'::integer[];
>
> That's what pgAdmin sends:
>         ALTER TABLE ef.kat ALTER pfad TYPE integer[];
>         ALTER TABLE ef.kat ALTER COLUMN pfad SET DEFAULT '{}'::integer[];
>         COMMENT ON COLUMN ef.kat.pfad IS 'bla bla bla';

Fixed in SVN.

Thanks for the report!

Regards, Dave