Sequence START WITH is not read by reverse engineering

PostgreSQL - related issues
Post Reply
petr.fedorov
Posts: 32
Joined: Sun Aug 19, 2012 8:57 am
Location: Russia

Sequence START WITH is not read by reverse engineering

Post by petr.fedorov » Sun Feb 24, 2013 6:00 am

Hello,
Steps to reproduce:

1. Create new sequence in DbSchema and specify value for 'Start with' property different from the default value 1, say, 100.
2. Go to psql and enter \d <sequence_name> - and you will see that the sequence has been created properly, i.e. it starts from 100.
3. Press 'Refresh schema from database' button
4. Press Review changes button
5. DbSchema Project/Value 'Start With 100' vs Database/Value 'Start with 1'

Please fix.

donose.mihai
Posts: 470
Joined: Thu Apr 07, 2011 11:05 am

Re: Sequence START WITH is not read by reverse engineering

Post by donose.mihai » Mon Feb 25, 2013 6:23 am

Hello,

Opened a ticket for this issue: ID 0001459

Regards,

Mihai

peleus
Posts: 54
Joined: Fri Nov 09, 2012 3:43 pm

Re: Sequence START WITH is not read by reverse engineering

Post by peleus » Sun Mar 24, 2013 2:13 pm

Sorry for bumping this old post but has this been fixed? Can you please share how this was resolved?

waleed121
Posts: 1
Joined: Thu Mar 12, 2015 7:45 am

Re: Sequence START WITH is not read by reverse engineering

Post by waleed121 » Thu Mar 12, 2015 7:53 am

When synchronizing Schema with Database and there is a foreign key to rename in database, DbSchema identifies it fine, but no SLQ statements is generated.

Post Reply