Bugs item #1648303, was opened at 2007-01-31 00:32
Message generated for change (Comment added) made by sjoerd
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: Fixed
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: Sjoerd Mullender (sjoerd)
Date: 2007-02-14 12:51
Message:
Logged In: YES
user_id=43607
Originator: NO
Dumping of sequences is now implemented.
Not closing yet since I still have to come up with a test.
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2007-02-13 13:08
Message:
Logged In: YES
user_id=43556
Originator: NO
implemented get_value_for('sequence_name'), so back to sjoerd
----------------------------------------------------------------------
Comment By: Sjoerd Mullender (sjoerd)
Date: 2007-02-13 12:47
Message:
Logged In: YES
user_id=43607
Originator: NO
I've done most of the work to implement this (not checked in yet), but I
need something from Niels: a way to get the current value of a sequence.
So assigning this to Niels.
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2007-02-04 20: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 03: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 09: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
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
