[BUGS] BUG #4233: Unable to install postgresql-8.3.3 into WindowsXP, an installer error

2008-06-12 Thread Arkady Sherman

The following bug has been logged online:

Bug reference:  4233
Logged by:  Arkady Sherman
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.3.3
Operating system:   Windows XP
Description:Unable to install postgresql-8.3.3 into WindowsXP, an
installer error
Details: 

When I try to install the postgresql (8.3.2, 8.3.3) with the msi installer,
1. Download postgresql-8.3.3-1.zip for Windows
2. Extract the files into a directory
3. Run postgresql-8.3.msi
after a form with the language selection the installer gets hanged with the
three msiexec.exe processes running.
If to kill the MsiExec.exe with the following command line 
"C:\WINNT\system32\MsiExec.exe -Embedding C24956E9C064D059DFD7FCAA1CBBA8F1
C"
the installation seems to continue normally.
The log file before the process killing is following:
=== Verbose logging started: 12.06.2008  11:21:23  Build type: SHIP UNICODE
3.01.4001.5512  Calling process: C:\WINNT\system32\msiexec.exe ===
MSI (c) (5C:C0) [11:21:23:187]: Resetting cached policy values
MSI (c) (5C:C0) [11:21:23:187]: Machine policy value 'Debug' is 0
MSI (c) (5C:C0) [11:21:23:187]: *** RunEngine:
   *** Product: D:\temp\postgresql-8.3-int.msi
   *** Action: 
   *** CommandLine: **
MSI (c) (5C:C0) [11:21:23:187]: Machine policy value 'DisableUserInstalls'
is 0
MSI (c) (5C:C0) [11:21:25:796]: SOFTWARE RESTRICTION POLICY: Verifying
package --> 'D:\temp\postgresql-8.3-int.msi' against software restriction
policy
MSI (c) (5C:C0) [11:21:25:796]: Note: 1: 2262 2: DigitalSignature 3:
-2147287038 
MSI (c) (5C:C0) [11:21:25:796]: SOFTWARE RESTRICTION POLICY:
D:\temp\postgresql-8.3-int.msi is not digitally signed
MSI (c) (5C:C0) [11:21:25:812]: SOFTWARE RESTRICTION POLICY:
D:\temp\postgresql-8.3-int.msi is permitted to run because the user token
authorizes execution (marked SANDBOX_INERT).
MSI (c) (5C:C0) [11:21:25:937]: Cloaking enabled.
MSI (c) (5C:C0) [11:21:25:937]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (5C:C0) [11:21:25:953]: End dialog not enabled
MSI (c) (5C:C0) [11:21:25:953]: Original package ==>
D:\temp\postgresql-8.3-int.msi
MSI (c) (5C:C0) [11:21:25:953]: Package we're running from ==>
C:\DOCUME~1\ai\LOCALS~1\Temp\37265bc.msi
MSI (c) (5C:C0) [11:21:25:984]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{B823632F-3B72-4514-8861-B961CE263224}'.
MSI (c) (5C:C0) [11:21:25:984]: APPCOMPAT: no matching ProductCode found in
database.
MSI (c) (5C:C0) [11:21:25:984]: MSCOREE not loaded loading copy from
system32
MSI (c) (5C:C0) [11:21:25:984]: Machine policy value 'TransformsSecure' is
0
MSI (c) (5C:C0) [11:21:25:984]: User policy value 'TransformsAtSource' is 0
MSI (c) (5C:C0) [11:21:25:984]: Machine policy value 'DisablePatch' is 0
MSI (c) (5C:C0) [11:21:25:984]: Machine policy value 'AllowLockdownPatch' is
0
MSI (c) (5C:C0) [11:21:25:984]: Machine policy value 'DisableLUAPatching' is
0
MSI (c) (5C:C0) [11:21:25:984]: Machine policy value
'DisableFlyWeightPatching' is 0
MSI (c) (5C:C0) [11:21:25:984]: Looking for storage transform: lang_ru
MSI (c) (5C:C0) [11:21:25:984]: Validating transform 'lang_ru' with
validation bits 0
MSI (c) (5C:C0) [11:21:25:984]: Transform 'lang_ru' is valid.
MSI (c) (5C:C0) [11:21:25:984]: Note: 1: 2205 2:  3: Patch 
MSI (c) (5C:C0) [11:21:25:984]: Note: 1: 2205 2:  3: PatchPackage 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: _Tables 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: _Columns 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: Media 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: File 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: TRANSFORM: 'PatchPackage' table is missing
or empty.  No pre-transform fixup necessary.
MSI (c) (5C:C0) [11:21:26:000]: TRANSFORM: Applying regular transform to
database.
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: _Tables 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: _Columns 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: _Validation 3: -2147287038

MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: AdminExecuteSequence 3:
-2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: Condition 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: AdminUISequence 3:
-2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: AdvtExecuteSequence 3:
-2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: Binary 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: CheckBox 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: ComboBox 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: Component 3: -2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: ControlCondition 3:
-2147287038 
MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: ControlEvent 3: -2147287038

MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: CustomAction 3: -2147287038

MS

[BUGS] BUG #4234: VACUUM dies in without error in a PGAgent job

2008-06-12 Thread Lawrence Cohan

The following bug has been logged online:

Bug reference:  4234
Logged by:  Lawrence Cohan
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system:   Linux 4.1.1
Description:VACUUM dies in without error in a PGAgent job
Details: 

We are using PGAgent to do the maintenance and I noticed from the server
status that there's no VACCUM running against the database however the job
still says "Running" and the value is still "r" on the job step from
pgagent.pga_jobsteplog.jslstatus
The job has three steps as described below:

1_Analyze_db that does analyze verbose;
2_Vaccum_db that does vacuum verbose:
3_Analyze_db that does analyze verbose;

the second step is set to "Ignore" if Fail so the analyze will kick off
anyway.

-- 
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 #4056: docu wrong for sqlerrmc[70]

2008-06-12 Thread Michael Enke

The following bug has been logged online:

Bug reference:  4056
Logged by:  Michael Enke
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system:   Linux CentOS 5.1
Description:docu wrong for sqlerrmc[70]
Details: 

In the 8.3.1 documentation, "32.11.2. sqlca" is written:
char sqlerrmc[70];
But a sizeof(sqlca.sqlerrm.sqlerrmc) tells me: 150

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[BUGS] Fwd: BUG #4235: docu wrong for sqlerrmc[70]

2008-06-12 Thread Robert Treat
re-directing  wayward bug report... 

--  Forwarded Message  --

Subject: BUG #4235: docu wrong for sqlerrmc[70]
Date: Thursday 12 June 2008
From: "Michael Enke" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]



The following bug has been logged online:

Bug reference:  4235
Logged by:  Michael Enke
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system:   Linux CentOS 5.1
Description:docu wrong for sqlerrmc[70]
Details: 

In the 8.3.1 documentation, "32.11.2. sqlca" is written:
char sqlerrmc[70];
But a sizeof(sqlca.sqlerrm.sqlerrmc) tells me: 150

---


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] Fwd: BUG #4235: docu wrong for sqlerrmc[70]

2008-06-12 Thread Bruce Momjian
Robert Treat wrote:
> re-directing  wayward bug report... 
> 
> --  Forwarded Message  --
> 
> Subject: BUG #4235: docu wrong for sqlerrmc[70]
> Date: Thursday 12 June 2008
> From: "Michael Enke" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> 
> 
> 
> The following bug has been logged online:
> 
> Bug reference:  4235
> Logged by:  Michael Enke
> Email address:  [EMAIL PROTECTED]
> PostgreSQL version: 8.3.1
> Operating system:   Linux CentOS 5.1
> Description:docu wrong for sqlerrmc[70]
> Details: 
> 
> In the 8.3.1 documentation, "32.11.2. sqlca" is written:
> char sqlerrmc[70];
> But a sizeof(sqlca.sqlerrm.sqlerrmc) tells me: 150

Good point. I have updated the documentation to use the same macro the C
file uses.

-- 
  Bruce Momjian  <[EMAIL PROTECTED]>http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/ecpg.sgml
===
RCS file: /cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v
retrieving revision 1.85
diff -c -c -r1.85 ecpg.sgml
*** doc/src/sgml/ecpg.sgml	3 Dec 2007 23:49:50 -	1.85
--- doc/src/sgml/ecpg.sgml	12 Jun 2008 19:13:28 -
***
*** 4061,4067 
  struct
  {
  int sqlerrml;
! char sqlerrmc[70];
  } sqlerrm;
  char sqlerrp[8];
  long sqlerrd[6];
--- 4061,4067 
  struct
  {
  int sqlerrml;
! char sqlerrmc[SQLERRMC_LEN];
  } sqlerrm;
  char sqlerrp[8];
  long sqlerrd[6];

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs