Updating postgresql


Users affected by CVE-2017-7547 will need to perform additional steps after upgrading to resolve the issue.

Other users should plan to update at the next convenient downtime.

Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a user or automatically by some sort of a database program.A transaction is the propagation of one or more changes to the database.For example, if you are creating a record, updating a record, or deleting a record from the table, then you are performing transaction on the table.The ROLLBACK command can only be used to undo transactions since the last COMMIT or ROLLBACK command was issued.Database triggers are a handy way to monitor database activity and to efficiently perform some maintenance tasks.if there are 3 bool columns c1,c2,c3 all set to false initially. update set c1=TRUE where id in (subquery1),set c2=TRUE where id in (subquery2), set c3=True where id in (subquery3).

You must have an account to comment. Please register or login here!