Apache OpenOffice (AOO) Bugzilla – Issue 113140
more than 8 columns dont work with PostgreSQL
Last modified: 2013-07-30 02:41:51 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 )
Created attachment 70614 [details] Pink subform
Created attachment 70615 [details] error message
Created attachment 70617 [details] pgAdmin
Reset assignee on issues not touched by assignee in more than 1000 days.