To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61497 Issue #:|61497 Summary:|Unable to use the serial (sequence) field when set as |primary key with PostgreSQL Component:|Database access Version:|OOO 2.0 Beta2 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|poupou
------- Additional comments from [EMAIL PROTECTED] Wed Feb 1 14:50:09 -0800 2006 ------- 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. --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
