Language Selection

English French German Italian Portuguese Spanish

[Tip] PostgreSQL Tip of the Day - mass modification of sequences

Filed under

Someone posted a dilemma to the pgsql-sql list today that involved many if not all of his sequences getting out of sync with their respective "serial" columns. In other words, something like "SELECT max(id) FROM sometable" yields 42, but the sequence nextval for is currently set to 36. This is obviously bad (for reasons left as an exercise for the reader).So besides trying to figure out how the database ended up in this state, he needed a script to reset all of his sequences to the correct next value.

I had run into a similar need not too long ago. Namely, when setting up multi-master replication with Bucardo you need your sequences to draw different values on either master so as not to conflict. One solution is to... Read More

More in Tux Machines

Kubuntu 15.10 (Wily Werewolf) Now Has Latest KDE Plasma 5.4.2

Kubuntu 15.10 (Wily Werewolf) is almost ready for launch, but it looks like the developers are still pushing some important changes even this late in the cycle. Read more

Unicode 8.0 Support Added To GNOME's GLib

Within the latest development code of GNOME's key GLib library leading up to GNOME 3.20 is Unicode 8.0 support. Unicode 8.0 as released back in June adds 7,716 characters with six new scripts, many new symbols, and various character additions. Per this commit today by Red Hat's Matthias Clasen, GLib's Unicode support has been updated to version 8.0. Clasen wrote, "Regenerate data tables from the Unicode Character Database, add new scripts, and update tests to include some of the new data." Read more

Huawei Watch Review: Best Android Wear Smartwatch Available

The Huawei Watch currently offers the best option on the Android Wear platform. The Huawei Watch looks elegant and offers great design as well as multiple attractive style options depending on the buyer’s cash flow. Even iPhone owners can take a look. If an iPhone owner prefers a stainless steel round watch, then the Huawei Watch is a usable option at a lower price than the Stainless Steel Apple Watch. Android Wear works well on iPhone, but does not give users the same level of integration. The most important features work fine, including notifications and fitness tracking. We give the Huawei Watch a hearty recommendation. It is worth paying a little more for this attractive and well-designed Android Wear smartwatch. Read more

Linux Kernel 4.1.10 LTS Is Now Available for Download with Networking Fixes

After announcing the release of the Linux 4.2.3 kernel, Greg Kroah-Hartman has informed the world today, October 3, about the release and immediate availability for download of the tenth maintenance version of the Linux 4.1 LTS kernel series. Read more Also: Linux 4.3-rc4 Kernel Released: Adds A New & Better String Copy Function Linus Torvalds Announces Linux Kernel 4.3 RC4 on the Eve of the Project's 24th Birthday