On 8/4/05, Frank Miles <[EMAIL PROTECTED]> wrote: > Hi everyone... > > I have a python-based application which provides a user interface > to a Postgresql database. The latest version of the application suddenly > lost the inability to insert new data in some of the tables. The SQL > statement(s) used still work if manually typed in psql, but it appears as > though there are some locks that are persisting and prevent inserts and > updates when the application is still running. Examining pg_locks shows a > number of locks (almost all of mode 'AccessShareLock'). Other inserts > and updates (to other tables) still work. The database logs (default > noise level setting) don't show any errors. >
AccessShareLocks are safe, it's the type of lock a SELECT does. The fact that you can execute the statements in psql show that the problem is not about locking... Are you sure there isn't a problem on your client side? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org