Re: Superfluous SQL statements

On 08/01/2008, Erwin Brandstetter <brandstetter(at)falter(dot)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