Server does not reply to Alter Table 
Author Message
 Server does not reply to Alter Table

Quote:

> Using pgsql 7.1.3 I have found that on occasions, there is no reply to an
> SQL statement like
> ALTER TABLE x
>    ADD COLUMN y z

You sure it's not just waiting for some other transaction to give up a
lock on the table?  ALTER TABLE ADD COLUMN should be essentially
instantaneous, since it doesn't touch the table data.  But it needs to
get exclusive lock on the table first.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Sun, 25 Jul 2004 00:10:06 GMT
 Server does not reply to Alter Table


comp.databases.postgresql.general on Tue, 5 Feb 2002 16:10:06 +0000

Quote:

> > Using pgsql 7.1.3 I have found that on occasions, there is no reply to an
> > SQL statement like

> > ALTER TABLE x
> >       ADD COLUMN y z

> You sure it's not just waiting for some other transaction to give up a
> lock on the table?  ALTER TABLE ADD COLUMN should be essentially
> instantaneous, since it doesn't touch the table data.  But it needs to
> get exclusive lock on the table first.

Well if it doesn't send a message back to the client then there is no way
of knowing this.

I had it do the same thing on two Drop Table requests, eventually it came
back and said the relation does not exist so I knew then it had dropped
the table but not because it had replied to the first request.



Mon, 26 Jul 2004 08:57:44 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. bufdiscard WARNINGS When NOT doing DUMP and ALTER

2. ALTER TABLE/PRIMARY KEYS & NOT NULL

3. ALTER TABLE: adding 2 not null integer columns

4. ALTER TABLE (Pervasive.SQL 2000) not working?

5. ALTER TABLE to add NOT FOR REPLICATION problem

6. Alter table by adding new column with not null

7. Alter table and Not Null

8. ALTER TABLE Column NOT NULL?

9. Alter table add Not For Replication

10. Altering system tables - safe or not?

11. SQL syntax for ALTER TABLE - NOT FOR REPLICATION

12. Alter table changes not appearing...


 
Powered by phpBB® Forum Software