[BUGS] RH 6.1, PostgreSQL 7.0.2, ipcclean madness

2000-08-03 Thread Roland Roberts
-BEGIN PGP SIGNED MESSAGE- I have finally needed to use ipcclean. I recently built HaruspeX 4.0, an application for managing pictures which uses Postgres, and while asking to delete a table, it hung. I had the app in the debugger, and I found it was hung on the database call itself. So

Re: [BUGS] ALTER TABLE

2000-08-03 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > I believe these are all the cases I saw of heap_openr with no lock > and no check in the actual trigger functions (patch to > hopefully elog(ERROR) instead of crashing attached). > [ patch snipped ] We had a discussion about that on 11-July and the cons

[BUGS] RPM buglet, postgres-devel

2000-08-03 Thread Roland Roberts
-BEGIN PGP SIGNED MESSAGE- First, I built from the 7.0.2 source RPM. This RPM seems to have installed /usr/lib/pgsql/os.h as a symlink to .././include/port/linux.h which doesn't exist. roland - -- PGP Key ID: 66 BC 3B CD Roland B. Roberts, PhD

Re: [BUGS] ALTER TABLE

2000-08-03 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: >> Yes, this is a known bug. Two bugs actually, first being that the >> trigger definitions don't track the rename (they should probably be >> storing OID not relname, although that would complicate dump/restore). > I do plan on trying to move all the ta

Re: [BUGS] ALTER TABLE

2000-08-03 Thread Tom Lane
Gena Gurchonok <[EMAIL PROTECTED]> writes: > When I renaming table using ALTER TABLE, > it doesn't change table name in RI triggers. This results in backend > crash due to invalid arguments for RI_Check trigger procedure. Yes, this is a known bug. Two bugs actually, first being that the trigger

Re: [BUGS] ALTER TABLE

2000-08-03 Thread Bruce Momjian
I can confirm that this is a bug, and crashes in the current development tree. > > POSTGRESQL BUG REPORT TEMPLATE > >

[BUGS] ALTER TABLE

2000-08-03 Thread Gena Gurchonok
POSTGRESQL BUG REPORT TEMPLATE Your name : Gena Gurchonok Your email address : [EMAIL PROTECTED] S