Issue 61497 - Unable to use the serial (sequence) field when set as primary key with PostgreSQL
Summary: Unable to use the serial (sequence) field when set as primary key with Postgr...
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO 2.0 Beta2
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2006-02-01 22:50 UTC by poupou
Modified: 2007-06-18 12:22 UTC (History)
3 users (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 poupou 2006-02-01 22:50:09 UTC 
Steps to recreate:

1. Connect to a postgresql database (8.1.2) with unixODBC (2.2.11) and psqlodbc
(08.01.0102).

2. Create a new table.

3. Create one column called "id" that is an autovalued integer (serial).

4. Add a primary key to the column "id".

5. Create a second column (for example varchar(50) with name "desc")

6. Save the table as Table1.

7. Open the table and put some text in the column "desc" (for example 'a').

8. When trying to insert a second value in the column "desc" (for example 'b')
an odbc error is raised.

The warning make a reference to a PostgreSQL error code 22P02 (INVALID TEXT
REPRESENTATION). With this problem, it isn't possible to create a primary key on
a serial column with PostgreSQL. If the serial column has a UNIQUE key, then a
number is correctly generated.
Comment 1 christoph.lukasiak 2006-06-12 16:46:00 UTC 
does this problem still occure in current version
(http://download.openoffice.org/680/index.html)? please acknowledge

thx
Comment 2 alex.thurgood 2006-09-09 09:15:11 UTC 
Hi,

This problem has just been brought up by an experienced db user on one of the
French n-l user lists, except that in that user's scenario the application
crashes (MacOSX OOo D680m1) and he is using a JDBC driver to connect to the pg
server.

I think we should confirm this.

Alex
Comment 3 christoph.lukasiak 2006-09-25 15:09:50 UTC 
change owner
Comment 4 christoph.lukasiak 2007-04-25 17:00:18 UTC 
does this problem still ocure in a current version?
Comment 5 christoph.lukasiak 2007-06-18 12:20:42 UTC 
no respond
Comment 6 christoph.lukasiak 2007-06-18 12:22:26 UTC 
no respond - no confirm for such a long time (nobody seems to be interested in)
-> close

do not hesitate to reopen this issue if it still occure in a current version

thx