Thread: Testing v1.7: CREATE TYPE

Hi developers! Hi Dave!


Testing  pgAdmin III 1.7.0, rev 6292:6293, client Win XP, host: Debian
Sarge, PG 8.1.8.


I have run more tests. Found something more substantial:
If I create like this:

    CREATE TYPE mytype AS   (a integer,   b text,   c integer)

the display in the object browser gets messed up. Looks like you try to
display both forms of CREATE TYPE at once:

    CREATE TYPE mytype AS
       (a integer,
        b text,
        c integer
       (INPUT=record_in, OUTPUT=record_out, DEFAULT='',
           INTERNALLENGTH=-1, ALIGNMENT=double, STORAGE=EXTENDED);
    ALTER TYPE mytype OWNER TO postgres;


Regards
Erwin

Erwin Brandstetter wrote:
> Hi developers! Hi Dave!
>
>
> Testing  pgAdmin III 1.7.0, rev 6292:6293, client Win XP, host: Debian
> Sarge, PG 8.1.8.
>
>
> I have run more tests. Found something more substantial:
> If I create like this:
>
>    CREATE TYPE mytype AS   (a integer,   b text,   c integer)
>
> the display in the object browser gets messed up. Looks like you try to
> display both forms of CREATE TYPE at once:
>
>    CREATE TYPE mytype AS
>       (a integer,
>        b text,
>        c integer
>       (INPUT=record_in, OUTPUT=record_out, DEFAULT='',
>           INTERNALLENGTH=-1, ALIGNMENT=double, STORAGE=EXTENDED);
>    ALTER TYPE mytype OWNER TO postgres;

Simple typo - missing a 'else ' :-(

Fixed now, thanks!

Regards, Dave

Hi Dave!

dpage@postgresql.org wrote:
> Simple typo - missing a 'else ' :-(
>
> Fixed now, thanks!

But that's how bugs should be: clear diagnosis, simple fix. ;)

Regards
Erwin