Testing v1.7: CREATE TABLE

Поиск
Список
Период
Сортировка
Искать

Testing v1.7: CREATE TABLE

От:
Erwin Brandstetter <brandstetter@falter.at>
Дата:
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

Re: Testing v1.7: CREATE TABLE

От:
Guillaume Lelarge <guillaume@lelarge.info>
Дата:
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.
FAQ