- cvs2svn --encoding=ISO-8859-1 -s /home/cvs/doc_gwolf /home/svn/doc_gwolf
- cd /tmp; svn co file:///home/svn/doc_gwolf
- Locate all files which differ between the two checkouts
- As I had done some work without committing, check against the list what was text, what was binary
- For each of the binary files, svn remove $file;cp /tmp/cvs/doc_gwolf/$file $file; svn add $file
- Add/replace all the files which were locally modified
- Everything seems to work? Ok, svn ci, and be merry.
Much More Scientific
77% SCIENTIFIC INTUITION and
47% EMOTIONAL INTUITION
Try my other test!
The 3 Variable Funny Test
|My test tracked 2 variables How you compared to other people your age and gender:|
|Link: The 2-Variable Intuition Test written by jason_bateman on Ok Cupid, home of the 32-Type Dating Test|
CREATE OR REPLACE VIEW table_attributes AS SELECT c.relname AS tablename, a.attname AS attrname, t.typname AS type, a.attnotnull AS required, d.description AS description FROM pg_class c JOIN pg_attribute a ON a.attrelid=c.oid JOIN pg_type t ON a.atttypid=t.oid LEFT OUTER JOIN pg_description d ON d.objoid=c.oid AND d.objsubid=a.attnum WHERE a.attnum>0 AND a.attisdropped = 'f' AND c.relkind='r' AND c.relname NOT LIKE 'pg_%' AND c.relname NOT LIKE 'sql_%' ORDER BY tablename, a.attnum;Nice, but still not enough - As with any other RDBMS, fields can not only hold data, but -of course- they can be foreign keys, referring to data in other tables. Ok, in order to check those relations and be able to build a map of the relations in my DB, I came up with this:
CREATE OR REPLACE VIEW related_tables AS SELECT c1.relname AS referrer, c2.relname AS refered, a.attname AS ref_key FROM pg_constraint con JOIN pg_class c1 ON con.conrelid=c1.oid JOIN pg_class c2 ON con.confrelid=c2.oid JOIN pg_attribute a ON c1.oid=a.attrelid AND a.attnum=ANY(con.conkey) WHERE contype='f' ORDER BY c1.relname, c2.relname;In the first query, note that I am excluding from what I report all the tables starting with pg_ or sql_ - While that's a usual convention in Postgres, there surely is a better way to do it, some attribute signalling it's a system catalog... But, at least for now, this covers my needs. Anyway, this might come useful for your projects. PostgreSQL introspection is fun! (Yes, those two queries are the result of many lonely hours going through the documentation and a couple of spontaneous questions to several friends - But it's worth it!)
- Gunnar needs to stamp images with time when captured
- Obviously gunnar needs a world map store and use the information he has gathered
- Gunnar needs a box for his blocks
- Gunnar needs to finish his clean-ups he planned or I guess already started.
- Gunnar needs to develop more body rhythm to advance in this style.
- Go rent "Scars Don't Sweat' because Gunnar needs the .003 cents he earns from each rental
- Asther and Gunnar need a miracle! Asther needs her healing and Gunnar needs an additional measure of God’s strength and grace as he cares for Asther
- Gunnar needs your help with Dwellingup data