[SQL] building psycopg2

2013-04-16 Thread Thomas Burnett
Hello, I'm trying to put together a fully contained runtime environment and am having trouble with fully qualified path names to dynamic library being included in _psycopg2.so (I'm on a Mac). See below: ^@^L^@^@^@`^@^@^@^X^@^@^@^B^@^@^@^@^E^E^@^@^@^E^@/Users/tburnett/Development/Lab7/main/alpha

[SQL] Peer-review requested of soft-delete scheme

2013-04-16 Thread Mark Stosberg
Hello, I'm working on designing a soft-delete scheme for our key entity-- there are 17 other tables that reference our key table via RI. Let's call the table "foo". I understand there are a couple common design patterns for soft-deletes: 1. Use a trigger to move the rows to a "tombstone table".