Another PostgreSQL Diff Tool

In just released beta18 sequences are created before tables. In fact all
sequence changes are performed before tables and now not sure how that
affects removal of sequences.

Thank you for your bug report and nice words :-) I'm thinking about
putting them at apgdiff homepage :-)

On further review, there is no semicolon bug. I thought my editor was at
the end of the file, but it wasn't. I has seen this:

CREATE SEQUENCE pet_hit_journal_id_seq


But really I was looking at this:

CREATE SEQUENCE pet_hit_journal_id_seq

START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;

###########

The first one is a complete statement on it's own, which is why I was
confused.

APGDiff helped me resolve dozen of minor differences between a
production and development website (not null, primary keys, indexes,
RI...). The application ran fine on both schemas, but I feel much better
knowing that these little differences have been discovered and resolved
now, thanks to your tool!

Mark

Yeah, you are right, I changed that behavior so sequences are now created
before tables. Anyway I need to clarify the problem about "missing
semicolon" before I release new bugfix. Could you please explain what did
you mean? It's not obvious to me. An example would be also useful.

Thank you.