I have a relatively simple problem :
I have a field named "id" that has type "Auto-number" in an Access database table.
I know there is no 'auto_number' type in PostgreSQL. I know also, that SERIAL and SEQUENCE are workarounds for this problem, but I'm not sure how to make a field a SERIAL once its already created in the table.
I have tried making the DEFAULT value of field "id" set to SERIAL, but I get this error :
PostgreSQL said: ERROR: Attribute 'serial' not found Your query: ALTER TABLE "names" ALTER "id" SET DEFAULT SERIAL
This is my system :
odbc driver version (on Win machine) : 7.01.00.04 Insight Distrib. (PSQLODBC.DLL)
odbc driver version (on Red Hat machine) : postgresql-odbc-7.0.2-17.rpm
postgre database version : postgresql-7.0.2.rpm
error messages on screen : none.
the commlog file : see attached file (psqlodbc.log)
Suggestions, workarounds and prayers would be appreciated !
love
rich handler
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any another MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.
---- File information -----------
File: psqlodbc.log
Date: 25 Apr 2001, 13:08
Size: 3729 bytes.
Type: Unknown
psqlodbc.log---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
