Re: [GENERAL] deleting function

2009-04-26 Thread Sam Mason
On Fri, Apr 24, 2009 at 08:19:37PM -0700, pavunkumar wrote: > On Apr 24, 8:55 pm, t...@sss.pgh.pa.us (Tom Lane) wrote: > > Don't use the same name for a parameter as you use for a table column > > referenced in the function. The above is equivalent to > > "delete... where $1=$1", ie, delete everyt

[GENERAL] Open source and diagramming survey

2009-04-26 Thread chung
Dear open source contributors, I am Eunyoung Chung, a Masters student working with Dr. Jensen at Oregon State University. We are currently doing a research project in collaboration with Dr. Truong and Ph.D student Koji Yatani at University of Toronto. Our goal is to understand how contributors c

Re: [GENERAL] Open source and diagramming survey

2009-04-26 Thread Martin Gainty
Chung - your survey should refrain from collecting demographic information demographic information has no bearing on Computer Science, the Apache community in general or becoming a contributor to the Postgres community Viel Gluck/Bon Chance/Buena Suerte Martin Gainty das Amerika/Etats Unis/EEU

Re: [GENERAL] need help for PostgreSQL consistency check mechanism

2009-04-26 Thread Chen, Dongdong (GE Healthcare)
> Row level: it would be very expensive to compute, store and keep up to date. > And it doesn't protect you from corruption elsewhere in the block. > Block level: there was some effort to implement it for 8.4, but it fell into > some deadly traps. Checksum is my primitive thought, is there ta

Re: [GENERAL] need help for PostgreSQL consistency check mechanism

2009-04-26 Thread Martijn van Oosterhout
On Mon, Apr 27, 2009 at 10:13:47AM +0800, Chen, Dongdong (GE > Healthcare) wrote: Checksum is my primitive thought, is there table > level checksum? Our objective is like this: If shutdown normally, OK. > If shutdown ABNORMALLY, then reboot the OS, check whether there is > database records loss or