Обсуждение: Testing v1.7: CREATE TABLE

Hi developers! Hi Dave!

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

A solved issue, and a minor thing. If I create a table like this:
    CREATE TABLE mytest ( t timestamp(0))

That's what pgAdmin 1.6.3 displays:

    -- Table: mytest

    -- DROP TABLE mytest;

    CREATE TABLE mytest
    (
      t timestamp(0 without time zone
    )
    WITHOUT OIDS;
    ALTER TABLE mytest OWNER TO postgres;


pgAdmin 1.7:

    -- Table: mytest

    -- DROP TABLE mytest;

    CREATE TABLE mytest
    (
      t timestamp(0) without time zone
    )
    WITHOUT OIDS
    ;
    ALTER TABLE mytest OWNER TO postgres;


The good news: type with modifier is being displayed correctly in 1.7.
The minor thing: why the extra line break before ";"?


Regards
Erwin

Erwin Brandstetter a écrit :
> Testing  pgAdmin III 1.7.0, rev 6292:6293, client Win XP, host: Debian
> Sarge, PG 8.1.8.
>
> A solved issue, and a minor thing. If I create a table like this:
>    CREATE TABLE mytest ( t timestamp(0))
>
> That's what pgAdmin 1.6.3 displays:
>
>    -- Table: mytest
>
>    -- DROP TABLE mytest;
>
>    CREATE TABLE mytest
>    (
>      t timestamp(0 without time zone
>    )
>    WITHOUT OIDS;
>    ALTER TABLE mytest OWNER TO postgres;
>
>
> pgAdmin 1.7:
>
>    -- Table: mytest
>
>    -- DROP TABLE mytest;
>
>    CREATE TABLE mytest
>    (
>      t timestamp(0) without time zone
>    )
>    WITHOUT OIDS
>    ;
>    ALTER TABLE mytest OWNER TO postgres;
>
>
> The good news: type with modifier is being displayed correctly in 1.7.
> The minor thing: why the extra line break before ";"?
>

This is due to my FILLFACTOR patch. I'll try to fix this. Thanks for the
report.

Regards.


--
Guillaume.
<!-- http://abs.traduc.org/
      http://lfs.traduc.org/
      http://docs.postgresqlfr.org/ -->