Hi all,

I don't know if this is the right place to place a feature request. I did
not find a bug tracker/feature request page at www.pgadmin.org - or should
I use the main bug tracker of PostgreSQL.

Anyway, here are my 2 smaller requests:

* Table Creation Dialogue --> Column-tab --> Add --> New column dialogue:
Would it be possible to offer the data type "serial" and "bigserial" along
with the other data types offered? I know this is not a true datatype, but
a convenience shortcut. As such, it would also be convenient to have it in
pgAdmin. I use this data type for almost every table for the primary key
column, since it is the easiest way to get autoincrementation.

* Table Creation Dialogue --> Column-tab: it would be convenient if one
could re-order the columns after they were added with the "Add" Button.
This shouldn't be a problem prior to creation of the table. I would
suggest to have "Arrow buttons" to shift a column definition up and down.
The user has to select a column definition (one row) and after pressing
the "Up" or "Down" button the order would change.

Thank you for considering or discussing my feature requests.

Andreas

--
Andreas Neumann
Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland
Email: a.neumann@carto.net, Web:
* http://www.carto.net/ (Carto and SVG resources)
* http://www.carto.net/neumann/ (personal page)
* http://www.svgopen.org/ (SVG Open Conference)
* http://www.geofoto.ch/ (Georeferenced Photos of Switzerland)


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Andreas Neumann a écrit :
> Hi all,
>
> I don't know if this is the right place to place a feature request. I did
> not find a bug tracker/feature request page at www.pgadmin.org - or should
> I use the main bug tracker of PostgreSQL.
>
> Anyway, here are my 2 smaller requests:
>
> * Table Creation Dialogue --> Column-tab --> Add --> New column dialogue:
> Would it be possible to offer the data type "serial" and "bigserial" along
> with the other data types offered? I know this is not a true datatype, but
> a convenience shortcut. As such, it would also be convenient to have it in
> pgAdmin. I use this data type for almost every table for the primary key
> column, since it is the easiest way to get autoincrementation.
>

It's already available. You'll find it at the end of the combobox
listing all the types.

We know this is not an ideal GUI. Works are intended in this area for
pgAdmin III next release.

> * Table Creation Dialogue --> Column-tab: it would be convenient if one
> could re-order the columns after they were added with the "Add" Button.
> This shouldn't be a problem prior to creation of the table. I would
> suggest to have "Arrow buttons" to shift a column definition up and down.
> The user has to select a column definition (one row) and after pressing
> the "Up" or "Down" button the order would change.
>

I find this really interesting. I just wonder how long it will take for
someone to ask to have this feature even to alter a table.

> Thank you for considering or discussing my feature requests.
>

I'm quite interested by your last feature request. The first one, I
think Dave wanted to work on it.

Hope it helps.


--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

>> * Table Creation Dialogue --> Column-tab --> Add --> New column
>> dialogue:
>> Would it be possible to offer the data type "serial" and "bigserial"
>> along
>> with the other data types offered? I know this is not a true datatype,
>> but
>> a convenience shortcut. As such, it would also be convenient to have it
>> in
>> pgAdmin. I use this data type for almost every table for the primary key
>> column, since it is the easiest way to get autoincrementation.
>>
>
> It's already available. You'll find it at the end of the combobox
> listing all the types.

ah yes, sorry - now I see it. I never scrolled to the bottom of the data
type list. I expected it to be in the alphabetical order.

> We know this is not an ideal GUI. Works are intended in this area for
> pgAdmin III next release.
>
>> * Table Creation Dialogue --> Column-tab: it would be convenient if one
>> could re-order the columns after they were added with the "Add" Button.
>> This shouldn't be a problem prior to creation of the table. I would
>> suggest to have "Arrow buttons" to shift a column definition up and
>> down.
>> The user has to select a column definition (one row) and after pressing
>> the "Up" or "Down" button the order would change.
>>
>
> I find this really interesting. I just wonder how long it will take for
> someone to ask to have this feature even to alter a table.

well - modifying the order of columns after the table was created is
probably not possible. At least I am unaware of how to do this without
dropping and recreating the table.

But it would already help being able to change the order of columns during
the table setup, before it is created. One can disable those up/down
buttons when the user opens the table properties dialogue after the table
was created - either make them invisible or gray out/disable the buttons.

>
>> Thank you for considering or discussing my feature requests.
>>
>
> I'm quite interested by your last feature request. The first one, I
> think Dave wanted to work on it.

this is great.

Thank you!

Andreas

--
Andreas Neumann
Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland
Email: a.neumann@carto.net, Web:
* http://www.carto.net/ (Carto and SVG resources)
* http://www.carto.net/neumann/ (personal page)
* http://www.svgopen.org/ (SVG Open Conference)
* http://www.geofoto.ch/ (Georeferenced Photos of Switzerland)


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Andreas Neumann a écrit :
> [...]
> But it would already help being able to change the order of columns during
> the table setup, before it is created. One can disable those up/down
> buttons when the user opens the table properties dialogue after the table
> was created - either make them invisible or gray out/disable the buttons.
>

AFAIK, Dave wants to re-design the complete table properties dialog.
Perhaps this is something we can add to the request list for the new
dialog ?


--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support