serial type to postgresql databases

hi all

how i use or chose serial type (type with auto-increment on postgresql) ?

if i set auto-increment box to a column, on genrerated script i continue having INTEGER or NUMERIC types !

thanks in advance and ...
Congratulations to Power Architect Team - is a great job !

Hi Jose,

Thanks for your question!

Unfortunately, there is currently no way to forward engineer a serial auto-increment column to PostgreSQL. This is clearly a big missing feature, and we will include this ability in an upcoming release of the Architect.

The only workaround I can offer you right now is to save the create script that the Architect generated, then use a text editor to set certain columns to the serial data type.

-Jonathan

Thanks !!

I will perform on this way.

ps - is this project an open source ? can others programmers make contributions ?

Sorry, the Power Architect is not currently an open source product. We have talked about it, and everyone on the development team would be happy to open it up (we have nothing to hide and much to gain). However, we can't commit to when or if it will ever happen. This would represent a big shift in the way we do business as a company. Deciding whether or not to make that kind of change can be a long process without definite timelines.

-Jonathan

well... I really liked Power@Architect, but not having the serial type, is a problem to me. Now that PA is open-source do you intend to include it in the near future ?

Nelson

Hi nelson,

We do plan to include the non-standard native types for all the databases we support before the Architect hits the 1.0 milestone. However, the 1.0 milestone is defined by a particular set of features, not a certain future date. So I can't tell you when we'll be adding this new feature.

Until then, you might consider saving your DDL scripts to a file and using find-and-replace in a text editor to create SERIAL columns, or better yet, implement the feature for us and post a patch to the developers list.

jose_aof, who started this thread, sounded interested in contributing this feature before the open source announcement. Now that we're open source, you could try asking him to implement this feature.

-Jonathan

This message was edited 1 time. Last update was at 2007-09-11 20:55:45

Hey Jonathan, congratulations for such a nice tool and for being a bunch of smart guys brave enough to make it open source.

I've read in other threads that you'll work on the auto increment issue for next versions and just wanted to add my vote for this feature. I work with both MySQL and PostgreSQL and really need to be able to use their native auto increment types.

I know you may have many features pending but I'm sure many users would be happy to have auto increment asap.

Good luck on the project and keep the good work!

Hi Alexis,

Thanks for your input. Auto-increment support in DDL is definitely at the top of our enhancement list now. We have a number of competing priorities with the Architect and other projects too (I'm sure you can sympathize), but as soon as we get the opportunity, we will implement this feature.

-Jonathan

That's great news.

I've just posted a small article about open source applications for database modelling and my recommendation for Power*Architect.

I hope more developers will join and help you with the project soon.

Cheers!

Thank you!

I've shared the article with the rest of the team. We all appreciate your recommendation and kind words about the product. Sometimes we wonder if all the time we've spent agonizing over seemingly minor details of the user interface go unnoticed or unappreciated, but positive feedback keeps us on the right track!

-Jonathan

Hi,

As of the September 19 nightly build auto-increment will be supported in both MySQL and PostgreSQL. Thank you for your suggestions.

You can find one week worth on nightly builds at http://nightlybuild.sqlpower.ca/architect/.

-Sean

This message was edited 5 times. Last update was at 2008-04-21 22:46:48

I have tried the current snapshot Architect-Setup-Windows-jdbc-0.9.11-20080421.exe and the auto increment does not generate the code needed for PostgreSQL. Am I missing something?

I get

This would be ok if the id default was set to
nextval('profile_id_seq')

Or instead of the integer type make it SERIAL

Sean wrote:Hi,

As of the September 19 nightly build auto-increment will be supported in both MySQL and PostgreSQL. Thank you for your suggestions.

You can find one week worth on nightly builds at http://nightlybuild.sqlpower.ca/architect/.

-Sean

This message was edited 4 times. Last update was at 2008-04-22 13:30:23

Hi wizhippo,

Looks like the auto-increment support for PostgreSQL got broken about a month ago. We're in the process of fixing it so hopefully the next nightly build will have it working.

Sorry about that!

If you need PostgreSQL auto-increment support right away, try one of our weekly builds from before March 19.

This would be the latest one before that.
http://nightlybuild.sqlpower.ca/architect/weekly/0.9.10-20080315/

I should note that the Windows installer is an executable JAR file, instead of an EXE. As long as you have your JAR files associate with the Java Runtime Environment, you should be fine.

Otherwise, you might run into this problem:
http://www.sqlpower.ca/forum/posts/list/1669.page

Unfortunately a pressing internal project has come up and we will have to postpone this and all other bugfixes for problems that have a known workaround. For your reference, I've created bug 1557 to track this problem. We hope to address it next month.

-Jonathan