[BUGS] BUG #2572: ALTER TABLE ADD COLUMN
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
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