Re: [BUGS] BUG #3483: Dropped temporary tables filled up the disk

2007-07-24 Thread Tom Lane
"Brent Reid" <[EMAIL PROTECTED]> writes: > Description:Dropped temporary tables filled up the disk I believe what's going on in your test case is that (1) The two sessions are competing for shared buffers; this means that sometimes the SELECT (session B) has to flush buffers that were dir

[BUGS] BUG #3483: Dropped temporary tables filled up the disk

2007-07-24 Thread Brent Reid
The following bug has been logged online: Bug reference: 3483 Logged by: Brent Reid Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: Red Hat Linux 3.2.3-53 Description:Dropped temporary tables filled up the disk Details: Our application o

Re: [BUGS] [GENERAL] Should SERIAL column have MAXVAL set on sequence

2007-07-24 Thread Zoltan Boszormenyi
Jim Nasby írta: Moving to -bugs. On Jul 23, 2007, at 9:02 AM, Woody Woodring wrote: I have a table in our DB that functions as a queue with a SERIAL column for its primary key. At 4am this weekend I started getting the error: ERROR: integer out of range Which was attributed to the sequence

Re: [BUGS] [GENERAL] Should SERIAL column have MAXVAL set on sequence

2007-07-24 Thread Tom Lane
Jim Nasby <[EMAIL PROTECTED]> writes: > On Jul 23, 2007, at 9:02 AM, Woody Woodring wrote: >> I ended up fixing my queue table with the following to avoid the >> issue in the future: >> >> ALTER SEQUENCE transfer_transferid_seq MAXVALUE 2147483647 CYCLE; > This does seem like a bug... I see no

Re: [BUGS] [GENERAL] Should SERIAL column have MAXVAL set on sequence

2007-07-24 Thread Jim Nasby
Moving to -bugs. On Jul 23, 2007, at 9:02 AM, Woody Woodring wrote: I have a table in our DB that functions as a queue with a SERIAL column for its primary key. At 4am this weekend I started getting the error: ERROR: integer out of range Which was attributed to the sequence incrementing pa

Re: [BUGS] BUG #3482: Postgresql DB does not start when lanuched via .bat

2007-07-24 Thread Harald Armin Massa
adding to my own mail: the command you need to look up in the documentation will be initdb.exe, not createdb.exe Best wishes, Harald On 7/24/07, Nathalie Azzola <[EMAIL PROTECTED]> wrote: > > > The following bug has been logged online: > > Bug reference: 3482 > Logged by: Nathali

Re: [BUGS] BUG #3482: Postgresql DB does not start when lanuched via .bat

2007-07-24 Thread Harald Armin Massa
Nathalie, you should open a command-shell (Run, Execute, cmd) and start the .bat launcher file from there. Propably you will learn that the installer did not create a template database when you chose to not install PostgreSQL as a service. Blease consult the excellent documentation for "createdb

[BUGS] BUG #3482: Postgresql DB does not start when lanuched via .bat

2007-07-24 Thread Nathalie Azzola
The following bug has been logged online: Bug reference: 3482 Logged by: Nathalie Azzola Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4-1 Operating system: Windows XP Pro Description:Postgresql DB does not start when lanuched via .bat Details: Hi, Steps