Re: [eGroupWare-users] Update 1.8.001 to 1.8.004 on PostgreSQL 9.2

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

knowing how egw_categories should look like, even line 

>CREATE TABLE "egw_categories" ("cat_owner" VARCHAR(255) DEFAULT '0' NOT
>NULL);

is wrong (from the point of view what is expected to be the result).

__________________________________________________
kl...@st... 
Stylite AG
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

----------------ursprüngliche Nachricht-----------------
Von: webratz [ir...@we... ]
An: egr...@li... 
Datum: Thu, 4 Apr 2013 06:45:51 -0700 (PDT)
----------------------------------------------------------

>
>Hi,
>
>in my case it happens on this query:
>
>BEGIN;
>SELECT * INTO TEMPORARY TABLE egw_categories_tmp FROM egw_categories;
>DROP TABLE "egw_categories";
>CREATE TABLE "egw_categories" ("cat_owner" VARCHAR(255) DEFAULT '0' NOT
>NULL);
>INSERT INTO egw_categories SELECT FROM egw_categories_tmp;
>DROP TABLE egw_categories_tmp;
>COMMIT;
>
>As you can see the 3rd line from bottom is wrong:
>
>INSERT INTO egw_categories SELECT FROM egw_categories_tmp;
>
>Sure, something after the select is missing:
>
>INSERT INTO egw_categories SELECT * FROM egw_categories_tmp;
>
>But that does also fail with the following error:
>
>ERROR: INSERT has more expressions than target columns
>
>So it seems the select only should use some fields to map it into the
>new table. Just which fields?
>
>Am 04.04.2013 14:51, schrieb Leithoff, Klaus [via EGroupware]:
>
>> I checked. This seems to happen when Refreshing the table egw_links.
>> Refreshing with pgsql is done in several steps:
>> creating a temp table with SELECT * INTO TEMPORARY TABLE xyz FROM
>> egw_links;
>> then dropping egw_links;
>> then recreating egw_links with the new definition
>> and then refilling the table.
>>
>> Your transaction seemed to have failed while copying the data into
>> the TEMPORARY Table,
>> because it refuses to cooperate after that statement.
>> --
>> [hidden email] [1]
>> Stylite AG
>> [ open style of IT ]
>> Morschheimer Strasse 15
>> 67292 Kirchheimbolanden
>> fon 06352 . 70629-0
>> fax 06352 . 70629-30
>> www.stylite.de | www.egroupware.org
>>
>> Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
>> Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer
>>
>> VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany
>>
>> ----------------ursprüngliche Nachricht-----------------
>> Von: webratz [[hidden email] [2] ]
>> An: [hidden email] [3]
>> Datum: Thu, 4 Apr 2013 00:57:10 -0700 (PDT)
>> -------------------------------------------------
>>
>>> Hello,
>>>
>>> i'm experiencing the same problem while upgrading on PostgreSQL 9.1.
>>> The SQL queries itself are working fine except the last one when
>>> directly
>>> executed. (Missing SELECT parameters).
>>> Altough the upgrade is still not working for me.
>>>
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> [http://egroupware.219119.n3.nabble.com/Update-1-8-001-to-1-8-004-on- 
>>> [4]
>>> PostgreSQL-9-2-tp3989348p3989722.html
>>> Sent from the egroupware-users mailing list archive at Nabble.com.
>>>
>>>
>>> --------------------------------------------------------------------
>>> ----------
>>> Minimize network downtime and maximize team effectiveness.
>>> Reduce network management and security costs.Learn how to hire
>>> the most talented Cisco Certified professionals. Visit the
>>> Employer Resources Portal
>>> http://www.cisco.com/web/learning/employer_resources/index.html [5]
>>> _______________________________________________
>>> eGroupWare-users mailing list
>>> [hidden email] [6]
>>> https://lists.sourceforge.net/lists/listinfo/egroupware-users [7]
>>>
>>
>> ------------------------------------------------------------------------------
>> Minimize network downtime and maximize team effectiveness.
>> Reduce network management and security costs.Learn how to hire
>> the most talented Cisco Certified professionals. Visit the
>> Employer Resources Portal
>> http://www.cisco.com/web/learning/employer_resources/index.html [5]
>> _______________________________________________
>> eGroupWare-users mailing list
>> [hidden email] [8]
>> https://lists.sourceforge.net/lists/listinfo/egroupware-users [7]
>>
>> -------------------------
>>
>> If you reply to this email, your message will be added to the
>> discussion below:
>> http://egroupware.219119.n3.nabble.com/Update-1-8-001-to-1-8-004-on-PostgreSQL-9-2-tp3989348p3989737.html
>> [9]
>> To unsubscribe from Update 1.8.001 to 1.8.004 on PostgreSQL 9.2,
>> click here [10].
>> NAML [11]
>>
>> Links:
>> ------
>> [1]
>> http://backend.webratz.de/user/SendEmail.jtp?type=node&node=3989737&i=0
>> [2]
>> http://backend.webratz.de/user/SendEmail.jtp?type=node&node=3989737&i=1
>> [3]
>> http://backend.webratz.de/user/SendEmail.jtp?type=node&node=3989737&i=2
>> [4]
>> http://egroupware.219119.n3.nabble.com/Update-1-8-001-to-1-8-004-on-
>> [5] http://www.cisco.com/web/learning/employer_resources/index.html
>> [6]
>> http://backend.webratz.de/user/SendEmail.jtp?type=node&node=3989737&i=3
>> [7] https://lists.sourceforge.net/lists/listinfo/egroupware-users
>> [8]
>> http://backend.webratz.de/user/SendEmail.jtp?type=node&node=3989737&i=4
>> [9]
>> http://egroupware.219119.n3.nabble.com/Update-1-8-001-to-1-8-004-on-PostgreSQL-9-2-tp3989348p3989737.html
>> [10]
>> [11]
>> http://egroupware.219119.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
> 
>
>
>__________________________________________________
>View this message in context: Re: Update 1.8.001 to 1.8.004 on PostgreSQL 9.2
>Sent from the egroupware-users mailing list archive -> 
>http://egroupware.219119.n3.nabble.com/Update-1-8-001-to-1-8-004-on-] at Nabble.com.
>
>
>__________________________________________________
> 
>
>
>-------------------------------------------------------------------------
>-----
>Minimize network downtime and maximize team effectiveness.
>Reduce network management and security costs.Learn how to hire 
>the most talented Cisco Certified professionals. Visit the 
>Employer Resources Portal
>http://www.cisco.com/web/learning/employer_resources/index.html
>
>
>__________________________________________________
> 
>
>_______________________________________________
>eGroupWare-users mailing list
>eGr...@li... 
>https://lists.sourceforge.net/lists/listinfo/egroupware-users
>
>