Re: [BUGS] Postmaster 7.1.2 hanging

2001-07-06 Thread Justin Clift
Hi Tom, I had to kill -9 the postmaster process and go from there about 2 minutes after sending that email. Although the data wasn't important, the availability of PostgreSQL on the server was. Had to get it up and running again asap. If it happens again, I'll attach a debugger to the postmast

[BUGS] can't create timestamp field (only timestamp with time zone)

2001-07-06 Thread pgsql-bugs
Dave E Martin ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description can't create timestamp field (only timestamp with time zone) Long Description 7.1.2 on debian It appears to be impossible to create a field with the "timestamp" dat

[BUGS] Perl DBI Module fails to install correctly from RPM

2001-07-06 Thread pgsql-bugs
Chris Carkner ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Perl DBI Module fails to install correctly from RPM Long Description I installed version 7.1.2 from RPMs from your FTP site specifically with the following files (n

Re: [BUGS] Referential Integrity corrupted sometimes by Rules

2001-07-06 Thread Stephan Szabo
On Fri, 6 Jul 2001 [EMAIL PROTECTED] wrote: > José María Fernández González ([EMAIL PROTECTED]) reports a bug with a severity >of 1 > The lower the number the more severe it is. > > Short Description > Referential Integrity corrupted sometimes by Rules > > Long Description If you define an em

Re: [BUGS] Rules with conditions over views don't work

2001-07-06 Thread Tom Lane
[EMAIL PROTECTED] writes: > Since PostgreSQL 7.1 (or 7.0, I don't remember), if you define a view, and >then a rule with a condition over the view, the rule doesn't work when you try to do >an operation from the type defined in the rule (it echoes an error message). But, if >you also defi

Re: [BUGS] Referential Integrity corrupted sometimes by Rules

2001-07-06 Thread Tom Lane
[EMAIL PROTECTED] writes: > -- Rule over the referenced table > -- which breaks referential integrity > create rule nodelrel > as on delete to rel > where old.ref > 3 and user = 'prueba' > do instead nothing; This rule is preventing the foreign key triggers from performing the DELETEs implied by

[BUGS] Referential Integrity corrupted sometimes by Rules

2001-07-06 Thread pgsql-bugs
José María Fernández González ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Referential Integrity corrupted sometimes by Rules Long Description If you define an empty rule with a condition over a table which references to an