AnantLabs / wwwsqldesigner

Automatically exported from code.google.com/p/wwwsqldesigner
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

Importing from PostgreSQL uses arbitrary ordering of tables and columns. #151

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Import a schema from PostgreSQL
2. Look at order of columns for each table in diagram.
3. Look at order of tables in 'Save XML' output.

What is the expected output?
I expect to see the columns in declared order and the tables listed in a stable 
ordering as well (ie. alphabetical).

What do you see instead?
The columns and tables are imported in arbitrary order. This makes it difficult 
to detect what's the same and different between different versions of the 
schema XML.

What version of the product are you using?
changeset:   12:1b0941e1a7c2
date:        Thu Feb 05 10:36:08 2009 +0000

On what operating system?
Xubuntu Linux 11.10

Please provide any additional information below.

Also corrected is the output of extraneous "KEY()" for each 'NOT NULL' check 
criteria--these are now suppressed.

The Mercurial "hg diff" against changeset 108:a34114bd2e96 is attached.

Original issue reported on code.google.com by Keith.Karmakaze@gmail.com on 4 Apr 2012 at 3:00

Attachments:

GoogleCodeExporter commented 9 years ago
There's no way of searching issues for attachments. How strange. How about 
searching for the words diff or patch? There, now this issue should be tagged 
with these words.

Original comment by Keith.Karmakaze@gmail.com on 4 Apr 2012 at 3:06

GoogleCodeExporter commented 9 years ago
Adding search words: attach attached attachment

Original comment by Keith.Karmakaze@gmail.com on 4 Apr 2012 at 3:08

GoogleCodeExporter commented 9 years ago
Commited in changeset 109:33c0cd26faeb. Thanks!

Original comment by ondrej.zara on 6 Apr 2012 at 10:37