[SQL] Problem with old relation

Hi, 1) When I create new table expample. CREATE TABLE "kokot" ( "kokot" SERIAL ); 2) and then DROP table kokot .. 3) and then again CREATE table CREATE TABLE "kokot" ( "kokot" SERIAL ); PostgreSQL return this error PostgreSQL said: ERROR: Relation 'kokot_kokot_seq' already exists Your qu

Re: [SQL] Problem with old relation

Hi, you also have to drop the sequence. drop sequence kokot_kokot_seq; regards -andreas On Friday 02 May 2003 14:20, Rado Petrik wrote: > Hi, > > 1) When I create new table expample. > > CREATE TABLE "kokot" ( > "kokot" SERIAL ); > > > 2) and then DROP table kokot .. > > 3) and then again