Issue 63529 - PostgreSQL via ODBC: problem with serial data type
Summary: PostgreSQL via ODBC: problem with serial data type
Status: CLOSED DUPLICATE of issue 3872
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.1
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-03-23 13:39 UTC by pmike
Modified: 2006-09-06 11:46 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description pmike 2006-03-23 13:39:22 UTC 
OOo 2.0.1, running on Windows 2000 SP4
ASPLinux 9 (Ural) with PostgreSQL 7.3.2, via psqlodbc-08_01_0200

OOo works incorrectly with "serial" pseudo-datatype. It drops error during
database edit (upon inserting new record):
ERROR: pg_atoi: zero-length string

It seems that OOo tries to fill "serial" field while it should not.
SDBC driver does not have such problem.

PS. This issue might be related to Issue 3872. However i3872 is RESOLVED FIXED
with target "OOo later". Can somebody clarify this?
Comment 1 christoph.lukasiak 2006-05-15 15:49:42 UTC 
clu->pmike: may you write, what is unclear for you (the target itselve or why
this target in this special case)?
Comment 2 pmike 2006-05-16 07:24:41 UTC 
Well, the state of Issue 3872 is unclear for me (RESOLVED FIXED to "OOo Later" -
is 3872 abandoned?).

That issue described similar problem (PostgreSQL, problem with "serial" data type).
But, since 3872 is closed, *and* problem still exists, I've filed this (63529)
issue.
Comment 3 christoph.lukasiak 2006-07-04 16:59:25 UTC 
clu->pmike: issue 3872 has a master called: 'jbu' and is still open - fixed with
target 'oo later' could mean, that he has fixed the problem, but the fix is not
important enough or dangerous etc. to came in one of the next cws (but maybe it
is only mistaken by jbu) - feel free to ask jbu what the state of the issue is
(in such neverending stories it make sense to demend the current state if
'nothing happens')

thx
Comment 4 christoph.lukasiak 2006-07-04 17:01:32 UTC 
so this seems to be a duplicate

*** This issue has been marked as a duplicate of 3872 ***
Comment 5 christoph.lukasiak 2006-07-04 17:03:19 UTC 
=> close

do not hestitate to reopen this issue if still exist after the fix of the duplicate

thx
Comment 6 benratty 2006-09-06 11:46:16 UTC 
I have installed the postgres jdbc0.7.2 and I have connected to my database
using base sucessfully.

I have tried setting my serial (autoincrement) field in postgres to allow null
values so ooo base can insert the record and postgres to add the serial field.
However my serial field is the primary key and there is no other field that can
could be a natural pk in the table, ooo base will not allow me to add records to
a table with no primary key.

ps. using ooo and postgres on win

Rgds
Ben