[BUGS] BUG #2572: ALTER TABLE ADD COLUMN

2006-08-13 Thread Emil J.

The following bug has been logged online:

Bug reference:  2572
Logged by:  Emil J.
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system:   Windows XP
Description:ALTER TABLE ADD COLUMN
Details: 

I create some function (PLPGSQL):

.
BEGIN
 ALTER TABLE sch.table ADD COLUMN abc INTEGER;
 RETURN NULL;
END;

After i called it, nothing happend. No Error, No Exception, No effect - no
column added.

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[BUGS] BUG #2735: DEBUG: Error 2769: Custom Action GetAvailableLocales did not close 1 MSIHANDLEs

2006-11-04 Thread Emil J.

The following bug has been logged online:

Bug reference:  2735
Logged by:  Emil J.
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.1.5, 8.1.4
Operating system:   Windows XP Pro SP2
Description:DEBUG: Error 2769:  Custom Action GetAvailableLocales
did not close 1 MSIHANDLEs
Details: 

When i run postgresql-8.1.msi, "Welcome" window appear. I click on "Start"
button. Nothing happened.

I read this: http://www.postgresql.org/docs/faqs.FAQ_windows.html#3.1
I don't have antivir, don't have firewall.

This is log:
=== Verbose logging started: 4.11.2006  10:43:38  Build type: SHIP UNICODE
3.01.4000.2435  Calling process: C:\WINDOWS\system32\msiexec.exe ===
MSI (c) (EC:2C) [10:43:38:015]: Resetting cached policy values
MSI (c) (EC:2C) [10:43:38:015]: Machine policy value 'Debug' is 0
MSI (c) (EC:2C) [10:43:38:015]: *** RunEngine:
   *** Product:
T:\_WebInstall_\postgresql-8.1.5-1\postgresql-8.1-int.msi
   *** Action: 
   *** CommandLine: **
MSI (c) (EC:2C) [10:43:38:437]: Machine policy value 'DisableUserInstalls'
is 0
MSI (c) (EC:2C) [10:43:39:437]: SOFTWARE RESTRICTION POLICY: Verifying
package --> 'T:\_WebInstall_\postgresql-8.1.5-1\postgresql-8.1-int.msi'
against software restriction policy
MSI (c) (EC:2C) [10:43:39:437]: Note: 1: 2262 2: DigitalSignature 3:
-2147287038 
MSI (c) (EC:2C) [10:43:39:437]: SOFTWARE RESTRICTION POLICY:
T:\_WebInstall_\postgresql-8.1.5-1\postgresql-8.1-int.msi is not digitally
signed
MSI (c) (EC:2C) [10:43:39:437]: SOFTWARE RESTRICTION POLICY:
T:\_WebInstall_\postgresql-8.1.5-1\postgresql-8.1-int.msi is permitted to
run at the 'unrestricted' authorization level.
MSI (c) (EC:2C) [10:43:39:453]: Cloaking enabled.
MSI (c) (EC:2C) [10:43:39:453]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (EC:2C) [10:43:39:468]: End dialog not enabled
MSI (c) (EC:2C) [10:43:39:468]: Original package ==>
T:\_WebInstall_\postgresql-8.1.5-1\postgresql-8.1-int.msi
MSI (c) (EC:2C) [10:43:39:468]: Package we're running from ==>
D:\Temp\6329b.msi
MSI (c) (EC:2C) [10:43:39:484]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{34D95765-2D5A-470F-A39F-BC9DEAAAF04F}'.
MSI (c) (EC:2C) [10:43:39:484]: APPCOMPAT: no matching ProductCode found in
database.
MSI (c) (EC:2C) [10:43:39:484]: MSCOREE not loaded loading copy from
system32
MSI (c) (EC:2C) [10:43:39:484]: Machine policy value 'TransformsSecure' is
0
MSI (c) (EC:2C) [10:43:39:484]: User policy value 'TransformsAtSource' is 0
MSI (c) (EC:2C) [10:43:39:484]: Machine policy value 'DisablePatch' is 0
MSI (c) (EC:2C) [10:43:39:484]: Machine policy value 'AllowLockdownPatch' is
0
MSI (c) (EC:2C) [10:43:39:484]: Machine policy value 'DisableLUAPatching' is
0
MSI (c) (EC:2C) [10:43:39:484]: Machine policy value
'DisableFlyWeightPatching' is 0
MSI (c) (EC:2C) [10:43:39:484]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{34D95765-2D5A-470F-A39F-BC9DEAAAF04F}'.
MSI (c) (EC:2C) [10:43:39:484]: APPCOMPAT: no matching ProductCode found in
database.
MSI (c) (EC:2C) [10:43:39:484]: Transforms are not secure.
MSI (c) (EC:2C) [10:43:39:484]: Command Line: INTERNALLAUNCH=1
CURRENTDIRECTORY=C:\WINDOWS\system32 CLIENTUILEVEL=0 CLIENTPROCESSID=2028 
MSI (c) (EC:2C) [10:43:39:484]: PROPERTY CHANGE: Adding PackageCode
property. Its value is '{41F587DD-BEA3-4597-BFE1-5CB379507A4D}'.
MSI (c) (EC:2C) [10:43:39:484]: Product Code passed to Engine.Initialize:   
   ''
MSI (c) (EC:2C) [10:43:39:484]: Product Code from property table before
transforms: '{34D95765-2D5A-470F-A39F-BC9DEAAAF04F}'
MSI (c) (EC:2C) [10:43:39:484]: Product Code from property table after
transforms:  '{34D95765-2D5A-470F-A39F-BC9DEAAAF04F}'
MSI (c) (EC:2C) [10:43:39:484]: Product not registered: beginning first-time
install
MSI (c) (EC:2C) [10:43:39:484]: PROPERTY CHANGE: Adding ProductState
property. Its value is '-1'.
MSI (c) (EC:2C) [10:43:39:484]: Entering
CMsiConfigurationManager::SetLastUsedSource.
MSI (c) (EC:2C) [10:43:39:484]: User policy value 'SearchOrder' is 'nmu'
MSI (c) (EC:2C) [10:43:39:484]: Adding new sources is allowed.
MSI (c) (EC:2C) [10:43:39:484]: PROPERTY CHANGE: Adding PackagecodeChanging
property. Its value is '1'.
MSI (c) (EC:2C) [10:43:39:484]: Package name extracted from package path:
'postgresql-8.1-int.msi'
MSI (c) (EC:2C) [10:43:39:484]: Package to be registered:
'postgresql-8.1-int.msi'
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2205 2:  3: Error 
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2729 
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2729 
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2729 
MSI (c) (EC:2C) [10:43:39:484]: Note: 1: 2729 
MSI (c) (EC:2C) [10:43:3