Hi everybody:
In a computer which is un production, I have a PostgreSQL 7.4 database.
In a couple of tables, I have just realised that I made a small mistake:
the primary key is SERIAL but what I really need is an INTEGER, since I
do not need the auto-increment feature or the sequence. Until n
id from pg_class where
relname = 'mytable_mytableid_seq');
DROP SEQUENCE mytable_mytableid_seq;
Regards
Pandu
On 1/27/06, Pedro Monjo Florit <[EMAIL PROTECTED]> wrote:
but the last command fails, saying that mytable still uses this sequence.
Is there any way to change a SERIAL type to an INTEGER? I
