Re: [BUGS] some other backend died abnormally

2002-09-24 Thread fredrik chabot
Tom Lane wrote: >fredrik chabot <[EMAIL PROTECTED]> writes: > >>so I migrated the database to a non-smp machine running RH 7.2 and the postgres >>7.2.1-5 rpm's >> >>Kernel 2.4.7-10 >> >>and I still get >> >>FATAL 1: LWLockAcquire: can't wait without a PROC structure >> >>The code tells me this s

Re: [BUGS] some other backend died abnormally

2002-09-24 Thread Tom Lane
fredrik chabot <[EMAIL PROTECTED]> writes: > so I migrated the database to a non-smp machine running RH 7.2 and the postgres > 7.2.1-5 rpm's > > Kernel 2.4.7-10 > > and I still get > > FATAL 1: LWLockAcquire: can't wait without a PROC structure > > The code tells me this should never heppen

Re: [BUGS] numeric type conversions

2002-09-24 Thread Tom Lane
Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: > I should cast field of 'text' type to the 'numeric' type, > but PG output error message: "ERROR: Cannot cast type 'text' to > 'numeric'". This has been fixed for 7.3. > Imho, almost all types should have default convertors from and to > the 'tex

Re: [BUGS] some other backend died abnormally

2002-09-24 Thread fredrik chabot
Tom Lane wrote: fredrik chabot <[EMAIL PROTECTED]> writes: What version of Postgres? What platform (Linux, etc)? psql (PostgreSQL) 7.2.1SMP Linux 2.2.18pre22 I seem to recall that SMP support was very flaky in the 2.2 serieskernels, and even in 2.4 up to 2.