Category Archives: Uncategorized

How to fix all postgres sequence numbers in a database

Create this stored procedure: CREATE OR REPLACE FUNCTION “reset_sequence” (tablename text, columnname text, sequence_name text) RETURNS “pg_catalog”.”void” AS $body$ DECLARE BEGIN EXECUTE ‘SELECT setval( ”’ || sequence_name || ”’, ‘ || ‘(SELECT MAX(‘ || columnname || ‘) FROM ‘ || … Continue reading

Posted in Uncategorized | Comments Off on How to fix all postgres sequence numbers in a database

Best Space Conquest Strategy Game

VGA PLanets has been re-done for the web. best ever.

Posted in Uncategorized | Comments Off on Best Space Conquest Strategy Game

GPG error NO_PUBKEY

I am getting W: GPG error: http:// archive.canonical.com quantal Release: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 40976EAF437D05B5 NO_PUBKEY 3B4FE6ACC0B21F32 The fix: sudo apt-key adv –recv-keys –keyserver keyserver.ubuntu.com 40976EAF437D05B5

Posted in Uncategorized | Comments Off on GPG error NO_PUBKEY

Pictures of a cool datacenter

http://www.engadget.com/photos/inside-google-s-data-centers/

Posted in Uncategorized | Comments Off on Pictures of a cool datacenter