To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67075 Issue #|67075 Summary|Table Wizard uses parameters with data type text using | PostgreSQL Component|Database access Version|OOo 2.0.2 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|canita
------- Additional comments from [EMAIL PROTECTED] Thu Jul 6 06:44:13 -0700 2006 ------- I use OOo 2.0.2, Ubuntu Dapper, PostgreSQL 8.0 (8.0.7-2build1) and SDBC driver 0.7.2 and I am new with OOo Base. I tried to go through the tutorial (http://www.oooforum.org/forum/viewtopic.phtml?t=25060) but at the beginning I got stuck. I can not create a table with the Table Wizard, it gives an error message: pg_driver: [PGRES_FATAL_ERROR]ERROR: syntax error at or near "(" at character 107 (caused by statement 'CREATE TABLE "public"."Employees" ( "Address" text, "BillingRate" float8, "Birthdate" date, "City" text(50), "CountryOrRegion" text(50), "DateHired" date, "Deductions" serial NOT NULL , "DepartmentID" serial NOT NULL , "EmailAddress" text(50), "EmployeeID" serial NOT NULL , "EmployeeNumber" text(50), "Extension" text(30), "FaxNumber" text(30), "FirstName" text(50), "LastName" text(50), "MiddleName" text(50), "MobileNumber" text(30), "OfficeLocation" text(50), "PhoneNumber" text(30), "PostalCode" text(20), "Salary" float8, "SocialSecurityNumber" text(50), "SpouseName" text(50), "StateOrProvince" text(50), "SupervisorID" serial NOT NULL , "Title" text(50), PRIMARY KEY( "EmployeeID" ) )') The problem is that according to Postgres' FAQ, Postgres has a data type 'text', not 'text(i)' where i is for integer. I don't know if it is a Base or an SDBC error, but anyway it should be fixed. (Although creating table in Design View works.) Thanx, Anita --------------------------------------------------------------------- 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]
