[HACKERS] proper way to fix information_schema.key_column_usage view

2007-08-11 Thread April Lorenzen
Tom Lane commits (http://www.postgresql.org/community/weeklynews/pwn20070121.html) - Fix incorrect permissions check in information_schema.key_column_usage view: it was checking a pg_constraint OID instead of pg_class OID, resulting in "relation with OID n does not exist" failures for anyone w

[HACKERS] default child of partition master

2006-08-20 Thread April Lorenzen
l - (and many other apps in similar situations) to independently choose to run partitions. Thank you for your consideration, - April Lorenzen ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscrib

[HACKERS] error-free disabling of individual child partition tables

2006-05-22 Thread April Lorenzen
It comes up repeatedly that I need to load fresh data into a new table, build indexes and vacuum - then drop the old table and substitute the new. Deleting old and inserting new records is too slow - not to mention the vaccuming. Loading with COPY, then building indexes, then vacuuming is very fa

[HACKERS] pg_resetxlog says file system is read only?

2005-08-03 Thread April Lorenzen
#postgresql freenode channel directed me to write the hackers list I have backup files. Version I believe is 7.4. pg server stopped - short log file is pasted at end of this email PANIC re checkpoint record seems to indicate running pg_resetxlog Ran pg_restxlog with -n successfully and it appe