The following bug has been logged online: Bug reference: 2710 Logged by: Jason Palmer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Redhat enterprise 4 Description: Intermittent hangs on sequence generation Details:
We can't exactly pinpoint the cause for this so I submit the problem to the postgres community. We are currently running Postgres 8.1. Postgres is our main database engine and several of our applications connect to it including our java stack (tomkat 5.0.28 running java 1.4.2 struts) and Ruby on Rails (Rails 1.6 w/ ActiveRecord). What we experience is bizarre. We can always create tables with no sequences. But occasionally the database will hang when we attempt to create a table with a sequence or foreign key. We can cancel the operation and when it "hangs" the database will still be able to insert/update/delete/select records so it's not totally down. But we are required to reboot the database before we can successfully run the query. Again, this does not happen all the time, but we've found that it happens quite a lot. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
