Hima Surapaneni <[EMAIL PROTECTED]> writes:
> 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.
Sounds like there's some open transaction with a lock on the table.
The pg_locks view mig
> 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_nameCHAR(25),
> address CHAR(30),
> phone_num
Hi,
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_nameCHAR(25),
address CHAR(30),
phone_numCHAR(15)
