http://www.lamoree.com/machblog/ Lamoree Software Blog en-us Mon, 17 Jun 2013 23:56:58 -0700 Fri, 24 Oct 2008 14:49:00 -0700 MachBlog http://blogs.law.harvard.edu/tech/rss admin@lamoree.com admin@lamoree.com http://www.lamoree.com/machblog/index.cfm?event=showEntry&entryId=94A2F93B%2DC93B%2D4087%2DB39295B486AFCEBA In the last blog post about migrating from MSSQL to PostgreSQL, I left one detail for later -- resetting all the sequences after importing data. I created two PL/pgSQL functions to do the work of selecting the maximum value in the primary key and ... PostgreSQL Shell Programming Fri, 24 Oct 2008 14:49:00 -0700 entryId=94A2F93B-C93B-4087-B39295B486AFCEBA?event=blog&showEntry= http://www.lamoree.com/machblog/index.cfm?event=showEntry&entryId=E2CF99E7%2DE404%2D43A0%2D9B62503BD43DBA8D The following are notes on a migration from Microsoft SQL Server 2000 to PostgreSQL 8. The old database has 60 tables, some with a few million rows, and about 7 Gb of data in total. There were several issues to deal with: The order of the... PostgreSQL Shell Programming Tue, 07 Oct 2008 01:41:00 -0700 entryId=E2CF99E7-E404-43A0-9B62503BD43DBA8D?event=blog&showEntry= http://www.lamoree.com/machblog/index.cfm?event=showEntry&entryId=F384A522%2D8569%2D47FA%2D9D14CFC4B9507568 This is a note to myself, and any other PostgreSQL user that might also be bitten by this circumstance. I like to have my psql client configured without AUTOCOMMIT enabled. This allows me to run long scripts that don't change anything unless it all... PostgreSQL Thu, 06 Dec 2007 12:41:00 -0700 entryId=F384A522-8569-47FA-9D14CFC4B9507568?event=blog&showEntry=