SQL Power Software Forum

my postgresql are on version 8.1 !

sorry by my fault, and thanks by your various suggestions !

Hi Castorp

the dialog screenshot was taken from PowerArchitect, after run FORWARD ENGINEER.

however, I tried to run the SQL script directly on psql (is a terminal-based front-end to PostgreSQL).

i didn't tried pgAdmin

thanks

thanks castorp

on PowerArchitect the message is:

----------------------------------------------
A SQL statement in the script failed to execute.
Reason: Syntax error near to OWNED.
ALTER SEQUENCE public.users_usercod_seq OWNED BY public.users.usercod.

Do you want to continue? (yes) (no)
------------------------------------------------

this messagem occour on all sequences objects. (my model is near of 90 objects).

* running the SQL script directly on psql console, the message is similar.

I take a look on postgresql 8.3 manual, and i don't found OWNED. Just found:
CACHE INCREMENT MINVALUE RESTART
CYCLE MAXVALUE NO SET SCHEMA

thanks in advance

hi all

I have a trouble when run "forward engineer sql script" over an target database. The generated script have a statement by table like this "ALTER SEQUENCE public.consumiveis_concod_seq OWNED BY public.consumiveis.concod;" This sql command isn't know at my postgresql.

I run postgresql 8.3 and PowerArchitect 0.9.13. However, this feature also occurs in other versions of PowerArchitect

thanks in advance !

yes

Jonathan is right

I get sucessfull download with wget

$wget -t 0 -r http://power-architect.googlecode.com/files/Architect-generic-jdbc-0.9.12.tar.gz

thanks

Hi all

I try to donwload the last version of PowerArchitect, but i get an error on untar. See below:

$ tar -xvzf Desktop/Architect-generic-jdbc-0.9.12.tar.gz
architect-0.9.12/LICENSE
architect-0.9.12/architect.jar
architect-0.9.12/jdbc/hsqldb-1.8.0.9.jar
architect-0.9.12/jdbc/mysql-connector-java-5.1.5-bin.jar
architect-0.9.12/jdbc/postgresql-8.2-506.jdbc3.jar
architect-0.9.12/jdbc/sqlserver_2005.jar
architect-0.9.12/lib/activation.jar
architect-0.9.12/lib/architecthelp.jar

gzip: stdin: unexpected end of file

I re-download more times but this error persist.

thanks in advance

Thanks !!

I will perform on this way.

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

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 !