[BUGS] all 96 tested passed: fedora core 1 (2.4.22-1.2115.nptlsmp) on Intel P4 3.06

2004-08-13 Thread Adam Sah
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

2004-08-18 Thread Adam Sah
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