[BUGS] all 96 tested passed: fedora core 1 (2.4.22-1.2115.nptlsmp) on Intel P4 3.06
The install is a generic fedora core 1 install with few mods, notably bison upgraded to bison-1.875-5; the CPU is a P4 3.06GHz from last year. here's /proc/cpuinfo processor : 1 vendor_id : GenuineIntel cpu family : 15 model : 2 model name : Intel(R) Pentium(R) 4 CPU 3.06GHz stepping: 7 cpu MHz : 3066.828 cache size : 512 KB physical id : 0 siblings: 2 fdiv_bug: no hlt_bug : no f00f_bug: no coma_bug: no fpu : yes fpu_exception : yes cpuid level : 2 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid runqueue: 0 bogomips: 6121.06 adam ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [BUGS] BUG #1220: "alter table rename to" inside a transaction
well, that's fine I suppose -- but then why does it work the other way for DROP TABLE? i.e. feels like we're confusing "implementation" and "desired semantics" adam Tom Lane wrote: "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: ==> yikes! in window 2, it should have errored. Why are you of the opinion that this is a bug? The catalog lookup has to happen before the second xact can hope to obtain a lock on the table, no? regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend