Hi,
I have a database with a few tables in it (this is just a "learning"
database). Originally I set these tables up with sequences on them
which increment the primary key of the table when a new record is
inserted. I would like to drop these sequences.
1. First I wanted to copy the database
Tom Lane wrote:
Erik Price <[EMAIL PROTECTED]> writes:
So, is the solution to drop the column first, then drop the sequence,
then re-create the column by using ALTER TABLE ?
Perhaps what you are really looking to do is just to reset the sequence
counters with setval() ?
Believe it or
At the bottom of an email from this list, I saw:
> -(end of broadcast)-
> TIP 9: the planner will ignore your desire to choose an index scan
> if your joining column's datatypes do not match
If that's so, then what is the recommended way to ensure an