To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113140 Issue #|113140 Summary|more than 8 columns dont work with PostgreSQL Component|Database access Version|OOo 3.2 Platform|PC URL|http://dba.openoffice.org/drivers/postgresql/index.htm |l OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|jbu Reported by|euleralves
------- Additional comments from [email protected] Wed Jul 14 12:47:43 +0000 2010 ------- 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 ) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
