Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space
After further investigations, it seems the second hypothesis is correct. This particular DB was created with "with OIDs" as default. The script I was using had no SET for this option and it creates a few temporary tables (which are quite small in size as they are created by SELECT .. INTO TEMP TABLE .. FROM .. GROUP BY .., so they are smaller than their origins). Adding SET default_with_oids = true to the script seems to solve the problem. Also, when run with the former releases, AUTOVACUUMING was off. Now it is on. Regards J6M - Original Message - From: "J6M" <[EMAIL PROTECTED]> To: "Stefan Kaltenbrunner" <[EMAIL PROTECTED]> Cc: "Tom Lane" <[EMAIL PROTECTED]>; Sent: Tuesday, April 08, 2008 12:37 PM Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space The df was made while the error messages occured and the scripts were running. So it is not a temporary 'mammothean' table. When I thought of this, two possible elads came to my mind : - A mistake when I tuned the postgresql.conf file (resource is scarce, as this test machine is a PIII 700 with 256 MB RAM dating from Q4 2000) - The default for this particular DB has been set to keep OIDs (I "pour" several INSERTs sets arising from different files in an auxiliary table, and keep the last entered entry for any relevant keys, Those entries then go to a production table). -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] Error in module
IN type integer and character are not matched. Error in the sales management module occures. Please help me for the same as soon as possible.
[BUGS] Error in module
IN type integer and character are not matched. Error in the sales management module occures. Please help me for the same as soon as possible.
Re: [BUGS] BUG #4090: ECPG Selecting table with NULL values
On Fri, Apr 04, 2008 at 12:32:44PM +, Mikael Omma wrote: > > The following bug has been logged online: > > Bug reference: 4090 > Logged by: Mikael Omma > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.6 > Operating system: SUSE Linux 10 > Description:ECPG Selecting table with NULL values > ... This proofed to be a typo in the test case. Bug solved. Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: [EMAIL PROTECTED] Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL! -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #4101: Fails to start when transaction log on another drive
The following bug has been logged online: Bug reference: 4101 Logged by: Mikel Lindsaar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Windows Server 2003 Description:Fails to start when transaction log on another drive Details: Fresh install of PostgreSQL 8.3.1. Complete the install and shutdown the server. Install Postgres into C:\Program Files\PostgreSQL\8.3, install data into D:\PostgreSQL\8.3\data Move the contents of pg_xlog directory to C:\Program Files\PostgreSQL\8.3\transation_log\pg_xlog\ Remove D:\PostgreSQL\8.3\data\pg_xlog Then use linkd.exe from Windows Server 2003 Resource kit to make a Junction (windows symlink) of the pg_xlog directory to another drive using: linkd d:\PostgreSQL\8.3\data\pg_xlog "C:\Program Files\PostgreSQL\transaction_log\pg_xlog" Start postgres service Get the following error in the application event log after the server fails to start: Faulting application postgres.exe version 8.3.1.876 faulting module postgres.exe, version 8.3.1.876 fault address 0x00249229 Type: Error, Category (100) I have uninstalled and reinstalled 8.3 and tried again, same failure. Have not tried with 8.2 Regards Mikel -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
