http://www.sqlpower.ca/forum/posts/list/2.page JForum - http://www.jforum.net
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 !]]> http://www.sqlpower.ca/forum/posts/preList/1606/1616.page http://www.sqlpower.ca/forum/posts/preList/1606/1616.page GMT
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]]> http://www.sqlpower.ca/forum/posts/preList/1606/1617.page http://www.sqlpower.ca/forum/posts/preList/1606/1617.page GMT
I will perform on this way.

ps - is this project an open source ? can others programmers make contributions ?]]> http://www.sqlpower.ca/forum/posts/preList/1606/1618.page http://www.sqlpower.ca/forum/posts/preList/1606/1618.page GMT
-Jonathan]]> http://www.sqlpower.ca/forum/posts/preList/1606/1619.page http://www.sqlpower.ca/forum/posts/preList/1606/1619.page GMT
Nelson]]> http://www.sqlpower.ca/forum/posts/preList/1606/1909.page http://www.sqlpower.ca/forum/posts/preList/1606/1909.page GMT
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]]> http://www.sqlpower.ca/forum/posts/preList/1606/1910.page http://www.sqlpower.ca/forum/posts/preList/1606/1910.page GMT
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!]]> http://www.sqlpower.ca/forum/posts/preList/1606/1941.page http://www.sqlpower.ca/forum/posts/preList/1606/1941.page GMT
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]]> http://www.sqlpower.ca/forum/posts/preList/1606/1942.page http://www.sqlpower.ca/forum/posts/preList/1606/1942.page GMT
I've just posted a small article about [url=http://ventanazul.com/webzine/articles/open-source-app-for-database-modelling]open source applications for database modelling[/url] and my recommendation for Power*Architect.

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

Cheers!]]> http://www.sqlpower.ca/forum/posts/preList/1606/1943.page http://www.sqlpower.ca/forum/posts/preList/1606/1943.page GMT
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]]> http://www.sqlpower.ca/forum/posts/preList/1606/1945.page http://www.sqlpower.ca/forum/posts/preList/1606/1945.page GMT
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]]> http://www.sqlpower.ca/forum/posts/preList/1606/1965.page http://www.sqlpower.ca/forum/posts/preList/1606/1965.page GMT

I get
[code]
CREATE SEQUENCE profile_id_seq;

CREATE TABLE public.profile (
id INTEGER NOT NULL,
CONSTRAINT profile_pk PRIMARY KEY (id)
);
ALTER SEQUENCE profile_id_seq OWNED BY public.profile.id;
[/code]

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

Or instead of the integer type make it SERIAL



[quote=Sean]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[/quote]]]> http://www.sqlpower.ca/forum/posts/preList/1606/2823.page http://www.sqlpower.ca/forum/posts/preList/1606/2823.page GMT
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]]> http://www.sqlpower.ca/forum/posts/preList/1606/2826.page http://www.sqlpower.ca/forum/posts/preList/1606/2826.page GMT
-Jonathan]]> http://www.sqlpower.ca/forum/posts/preList/1606/2832.page http://www.sqlpower.ca/forum/posts/preList/1606/2832.page GMT