> I have created a table called experimenters with the following query:
> CREATE TABLE experimenters (
> experimenter_id INTEGER CONSTRAINT firstkey PRIMARY KEY,
> first_name CHAR(20),
> last_name CHAR(25),
> address CHAR(30),
> phone_num CHAR(15)
> );
> The query was successful. But when I try to drop or alter the table, it just
> hangs without
> echoing any error message. I have to cancel the query to get out.
> I ran the following query to drop the table
> DROP TABLE experimenters;
> It also hangs when I try to alter the table.
> Just don't understand the problem here.
> Any help will be highly appreciated.
You might want to post this on the PG_General Mailing list of you do not get
many responses.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
