Why is sequence not dropping?

[pablogosse]

Hi all. I'm attempting to drop a sequence, but it doesn't seem to be dropping.

I had created a table called unbc_users and a sequence was created unbc_users_user_id_seq. However, after I dropped the table and attempted to recreate it, I got an error telling me the sequence already existed.

So, logically I issued the following command:

unbc-# DROP SEQUENCE unbc_users_user_id_seq

and expected the sequence would be dropped, but when I issue \d to see if it's been dropped, it hasn't.

Anyone know why it's not getting dropped?

Thanks in advance,
Pablo

[ultraslacker]

Is this postgresql? If so, what version?

[pablogosse]

This was my bad. I've been accustomed to admining my db from phpPgAdmin, so I wasn't forced to terminate sql statements with a semi-colon.

Once I added the semi-colon to the end everything was fine.

P.