Another footgun is that, while `DELETE FROM table_name` is transactional, TRUNCATE is not transactional. Once you push the truncate button, that data is gone in every transaction everywhere all at once.
You should be very hesitant about using TRUNCATE on a production database unless that table (and all related foreign keyed tables) are truly ephemeral. Even if the data is cleared every night at midnight, for example, is there going to be a 10 second analysis transaction running across the midnight boundary that will fail hard with suddenly missing rows?
Running a full delete on the rows and vacuum will still result in a tiny file on storage and doesn't wake me up in a cold sweat when I have a flashback. Even renaming the table is in many ways safer.
The only difference to other DML statements is, that it will put an exclusive lock on the table. So until the TRUNCATE is committed, no other transaction can read from the table.
> TRUNCATE is not MVCC-safe. After truncation, the table will appear empty to concurrent transactions, if they are using a snapshot taken before the truncation occurred.
Sorry, that's what I mean. It's safe in the sense that you can roll it back, but it's not safe in the sense that other concurrent transactions will see the table as empty if they are long-running.
The comment section on the chrome store page pretty much reveals that you can purchase licence codes that work only once and the developer isnt responding at all.
I'm from the UK but listened to this episode, one of the shocking aspects to it was they set noindex directives on the FreeFile site - although looks like they've removed them since
I've been using a HP Spectre x360 (13") with Ubuntu 18.04 for the last couple of weeks and it's been working very well for me. I even use the tablet mode when reading PDFs.
Price wise it's quite cheap (same specs as the Dell: i7, 16GB, 1TB SSD, 4k screen) as you can usually find a coupon online. For me it was about EUR300 cheaper than the XPS currently is. So far everything has worked out of the box with exception of the fingerprint reader on the side.
You account is your phone number which is a really smart thing I think. Therefore you do not have to add each of your contacts one by one. And when someone in your contact list installs WhatsApp they automatically show up in your WhatsApp contacts.
Would it be possible to make the text inside the Quicklook window selectable?
I often just want to quickly copy something from a file, and Quicklook would be the fastest way to do so.
Last month I was forced to use a netbook for a week and decided to install Ubuntu with Unity on it. I was really impressed with the user experience. I was probably just as efficient (if not more) than on my macbook!
"Automatically truncate all tables that have foreign-key references to any of the named tables, or to any tables added to the group due to CASCADE."
So it will simply clear out other tables that reference table to truncate, even if you have `on delete set null` and the foreign key column is null.
https://www.postgresql.org/docs/current/sql-truncate.html