Issue 113140

Summary: more than 8 columns dont work with PostgreSQL
Product: Base Reporter: euleralves <eulerbr>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, lionel
Version: OOo 3.2   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
URL: http://dba.openoffice.org/drivers/postgresql/index.html
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Pink subform
none
error message
none
pgAdmin none

Description euleralves 2010-07-14 13:47:43 UTC
When I use a sub-form at Base to make modifications to rows in a sub-table with
more than 8 columns, the SDBC driver allocate wrong data to columns. If I delete
the columns up to 8, by pgAdmin, then it works.

==============
Error message
==============
pq_driver: [PGRES_FATAL_ERROR]ERRO:  date/time field is out of range: "0-00-00"
at character 122
 (caused by statement 'INSERT INTO "public"."cg_portarias" (
"artigo","tipo","data","membro1","numero","prescrito") VALUES (
NULL,'-641129432','0-00-00','40371','1','0')')

****at this exemple, I don't input this values at statement, but others and to
others fields****


==============
  Main table
==============
CREATE TABLE cg_processos
(
  protocolo bigint NOT NULL,
  data_conhecimento date NOT NULL,
  desc_ocorrido character varying(60) NOT NULL,
  del_ocorrido smallint NOT NULL,
  natureza_denuncia smallint NOT NULL,
  situacao smallint NOT NULL,
  observacoes text,
  genero smallint NOT NULL,
  cgupad date,
  CONSTRAINT processos_pkey PRIMARY KEY (protocolo),
)
==============
  Sub-table
==============

CREATE TABLE cg_portarias
( numero smallint NOT NULL,
  data date NOT NULL,
  publicacao date,
  boletim smallint,
  observacao character varying(80) DEFAULT NULL::character varying,
  servidor integer NOT NULL,
  processo bigint NOT NULL,
  tipo smallint NOT NULL,
  membro1 integer,
  membro2 integer,
  presidente integer,
  artigo character varying(10),
  prescrito smallint DEFAULT 0,
  CONSTRAINT potarias_pk PRIMARY KEY (processo,data,tipo),
  CONSTRAINT portarias_processo_fk FOREIGN KEY (processo)
      REFERENCES cg_processos (protocolo) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
Comment 1 euleralves 2010-07-14 13:51:32 UTC
Created attachment 70614 [details]
Pink subform
Comment 2 euleralves 2010-07-14 13:53:41 UTC
Created attachment 70615 [details]
error message
Comment 3 euleralves 2010-07-14 14:08:05 UTC
Created attachment 70617 [details]
pgAdmin
Comment 4 Rob Weir 2013-07-30 02:41:51 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.