Re: [BUGS] BUG #3591: autovacuum crash

2007-08-31 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Ben Kim wrote: >> PostgreSQL version: 8.1.0 >> The server crashed suddenly the second time since two days ago. ulimit is >> unlimited, but I see no core file under the postgresql root directory. > This is a crash all right, but I think we fixed a certai

Re: [BUGS] BUG #3591: autovacuum crash

2007-08-31 Thread Alvaro Herrera
Ben Kim wrote: > > The following bug has been logged online: > > Bug reference: 3591 > Logged by: Ben Kim > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.0 > Operating system: Solaris 8 > Description:autovacuum crash > Details: > > The server crashed su

[BUGS] BUG #3591: autovacuum crash

2007-08-31 Thread Ben Kim
The following bug has been logged online: Bug reference: 3591 Logged by: Ben Kim Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Solaris 8 Description:autovacuum crash Details: The server crashed suddenly the second time since two days a

Re: [BUGS] BUG #3590: Error while in Plpgsql :

2007-08-31 Thread Tom Lane
"Abdus Samad Ansari" <[EMAIL PROTECTED]> writes: > I am using a plpgsql function and in this I am issuing a insert as : > Insert into pis.hrt_emp_leave_bin > (emp_no,leave_cd,curr_dt,bin_sl_no,cal_yr,tran_typ,open_bal,ytd_availed,avai > led) values (EmployeeNumber, LeaveCode, CurrentDate, > Bin_Ser

Re: [BUGS] to_date gives odd results

2007-08-31 Thread Josh Tolley
On 8/31/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Josh Tolley escribió: > > > On Thursday 30 August 2007 21:15, Tom Lane wrote: > > > > to_date and friends are fairly awful in terms of not throwing errors > > > > when the input doesn't really match the format. I think what you > > > > should

Re: [BUGS] to_date gives odd results

2007-08-31 Thread Alvaro Herrera
Josh Tolley escribió: > > On Thursday 30 August 2007 21:15, Tom Lane wrote: > > > to_date and friends are fairly awful in terms of not throwing errors > > > when the input doesn't really match the format. I think what you > > > shoulda got here is a bad-input error. However, somebody's going to >

[BUGS] BUG #3590: Error while in Plpgsql :

2007-08-31 Thread Abdus Samad Ansari
The following bug has been logged online: Bug reference: 3590 Logged by: Abdus Samad Ansari Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.2. Operating system: Fedora 2 Linux Description:Error while in Plpgsql : Details: I am using a plpgsql function and i

Re: [BUGS] to_date gives odd results

2007-08-31 Thread Josh Tolley
> On Thursday 30 August 2007 21:15, Tom Lane wrote: > > to_date and friends are fairly awful in terms of not throwing errors > > when the input doesn't really match the format. I think what you > > shoulda got here is a bad-input error. However, somebody's going to > > have to do a major rewrite