[Phpgroupware-tracker] [Bug #1293] phpgw_sitemgr_blocks.position doesn't work on PostgreSQL

[nobody]

=================== BUG #1293: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1293&group_id=509

Changes by: Dave Hall <address@hidden>
Date: 2002-Sep-30 11:15 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | pjw




=================== BUG #1293: FULL BUG SNAPSHOT ===================


Submitted by: cbsman                    Project: phpGroupWare                   
Submitted on: 2002-Sep-29 23:08
Category:  sitemgr                      Bug Group:  devel cvs                   
Severity:  5 - Major                    Priority:  Immediate                    
Resolution:  None                       Assigned to:  pjw                       
Status:  Open                           Component Version:  None                
Platform Version:  None                 Reproducibility:  Every Time            

Summary:  phpgw_sitemgr_blocks.position doesn't work on PostgreSQL

Original Submission:  The setup module is not able to create table 
"phpgw_sitemgr_blocks" because the word "position" is a restricted word. It 
produces a "parse error at or near 'position'".
Renaming the field to "position_" works - setup is able to create the table.
But one has to change all calls to the "phpgw_sitemgr_blocks.position" field in 
all of the "sitemgr" module to make it work :-(
It behaves like that at least on Postgre 7.1.1



No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1293&group_id=509