Language Selection

English French German Italian Portuguese Spanish

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

Filed under
OS
Linux

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 sometable.id 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

News about the migration to ODF in Taiwan

The migration of ODF keeps going in many different fields in Taiwan. Since 2016 the Ministry of Education in Taiwan entrusts the Information Service Association of Chinese Colleges (ISAC) and Software Liberty Association Taiwan (SLAT) with the task of promoting and migrating ODF/LibreOffice in universities in Taiwan. Among all the university, National Chi-Nan University (NCNU) is the earliest one, which started migrating LibreOffice since 2014 and has been working on it for three years. Then on April 20, 2017, a student from NCNU posted an article on Dcard forum saying that, according to her teacher, NCNU “Will not use Microsoft Office anymore due to the budget issue. LibreOffice will be used to replace Microsoft Office.” The student strongly questioned, “LibreOffice is totally unknown to everyone. I don’t know what the administrative staffs of our school are thinking about. Microsoft’s software is a very basic skill for enterprises to recruit people. This decision will make students lost their core competitiveness.” Read more

Phoronix on Graphics

NVIDIA GeForce GTX 1080 Ti: Windows 10 Creators Update vs. Ubuntu Linux Gaming

Earlier this week I posted some fresh AMD Radeon Windows vs. Linux gaming benchmarks using the newly-released Windows 10 Creator Update and Ubuntu 17.04. For your viewing pleasure today are some fresh NVIDIA Windows vs. Linux benchmarks using a high-end GeForce GTX 1080 Ti graphics card. Read more

Bits from the Debian Release Team: release update

We're approaching the final sprint towards Debian 9 "stretch". If you're still planning a BSP for stretch, now is the time to get it organised! Read more