Issue 113140 - more than 8 columns dont work with PostgreSQL
Summary: more than 8 columns dont work with PostgreSQL
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.2
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://dba.openoffice.org/drivers/pos...
Keywords:
Depends on:
Blocks:
 
Reported: 2010-07-14 13:47 UTC by euleralves
Modified: 2013-07-30 02:41 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Pink subform (417.05 KB, image/png)
2010-07-14 13:51 UTC, euleralves
no flags Details
error message (7.32 KB, image/png)
2010-07-14 13:53 UTC, euleralves
no flags Details
pgAdmin (72.61 KB, image/png)
2010-07-14 14:08 UTC, euleralves
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.