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: dam...@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.