[GENERAL] dropping sequences

2003-06-19 Thread Erik Price
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

Re: [GENERAL] dropping sequences

2003-06-19 Thread Erik Price
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

[GENERAL] different datatypes in index scan join

2003-06-23 Thread Erik Price
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