Bugs item #1648303, was opened at 2007-01-30 23:32 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1648303&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: relational (relational) >Assigned to: Sjoerd Mullender (sjoerd) Summary: database dump does not save/restore auto-increment sequences Initial Comment: auto-increment sequences created using CREATE SEQUENCE are not dumped correctly on a \D database dump. when used as default values for table columns, this leads to wrong behavior on future table inserts after restoring the database from a dump. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2007-02-04 19:20 Message: Logged In: YES user_id=43556 Originator: NO reassigning to sjoerd, as this is a bug in msqldump ---------------------------------------------------------------------- Comment By: relational (relational) Date: 2007-02-04 02:36 Message: Logged In: YES user_id=1695880 Originator: YES I didn't try the jdbc client. I encountered it using MapiClient, but it also occurs on msqldump. test script attached. File Added: dump-sequence.sh ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2007-02-02 08:04 Message: Logged In: YES user_id=43556 Originator: NO I'm guessing your using the jdbc client here to dump the database (therefor I reassigned to mr-meltdown). Probably this bug also holds for msqldump. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1648303&group_id=56967 ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
