[Issue 127350] New: Table design: can't change length of Postgresql char types

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127350

          Issue ID: 127350
        Issue Type: DEFECT
           Summary: Table design: can't change length of Postgresql char
                    types
           Product: Base
           Version: 4.2.0-dev
          Hardware: All
                OS: All
            Status: CONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: damjan@apache.org
  Target Milestone: ---

Connect to a Postgresql server using its JDBC driver and the usual URL of the
form "jdbc:postgresql://127.0.0.1/database".
In "Tables", "Create Table in Design View..."
Try create a column of type "Text [varchar]", and "Length" will be frozen at
10485760.
Try create a column of type "Text (fix) [char]", and "Length" won't even
appear.

Problem is the method OFieldDescControl::DisplayData() in
main/dbaccess/source/ui/control/FieldDescControl.cxx, which will deactivate the
tpTextLen if pFieldType->nPrecision is 0, which it is for "Text (fix) [char]",
and which will call pTextLen->SetSpecialReadOnly(true) when
pFieldType->aCreateParams.getLength() is 0, which it is for "Text [varchar]".

It is possible to hack this method, but that will affect all databases. We
should rather make a Postgresql driver under main/connectivity/source/drivers
that implements such fixes for Postgresql only (like we already have for
several other databases).

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127350] Table design: can't change length of Postgresql char types

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127350

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oooforum@free.fr

--- Comment #1 from oooforum (fr) <oo...@free.fr> ---
A long time ago, Joerg Budischewski has been worked on a specific driver:
http://www.openoffice.org/dba/drivers/postgresql/index.html

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127350] Table design: can't change length of Postgresql char types

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127350

--- Comment #2 from SVN Robot <sv...@dev.null.org> ---
"damjan" committed SVN revision 1805579 into trunk:
#i127350# - Table design: can't change length of Postgresql char types

-- 
You are receiving this mail because:
You are the assignee for the issue.