Received: from digitalplanit.wdi.co.uk ([195.13.87.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f34Fam844557 for ; Wed, 4 Apr 2001 11:36:49 -0400 (EDT) (envelope-from graham@digitalplanit.com) Received: from graham (dp0002.demon.co.uk [193.237.187.164]) by digitalplanit.wdi.co.uk (8.9.3/8.9.3) with SMTP id QAA06173 for ; Wed, 4 Apr 2001 16:35:32 GMT From: "Graham Vickrage" To: "Postgres SQL" Subject: Strategy for unlocking query Date: Wed, 4 Apr 2001 16:34:54 +0100 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_003A_01C0BD25.2DECB0E0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-MS-TNEF-Correlator: X-Archive-Number: 200104/46 X-Sequence-Number: 2385 This is a multi-part message in MIME format. ------=_NextPart_000_003A_01C0BD25.2DECB0E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I have just done a rather large transaction via a telnet/psql session which executed OK. The problem occured when the telnet session timed out before I could commit the rows. This must have locked the rows in question because when I tried to vacuum the table it just hung. What is the best way of dealing with this problem as I ended up stopping and restarting the postmaster? Also are functions within functions dealt with in a 'transactional' sense? Cheers Graham ------=_NextPart_000_003A_01C0BD25.2DECB0E0 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IjYPAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcA GAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEG gAMADgAAANEHBAAEABAAIgAAAAMAFQEBA5AGAGQGAAAlAAAACwACAAEAAAAL ACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAABAAAAHQAAAFN0 cmF0ZWd5IGZvciB1bmxvY2tpbmcgcXVlcnkAAAAAAgFxAAEAAAAWAAAAAcC9 HMHpjbJMgSdLEdWQFwBIVFAftgAAAgEdDAEAAAAeAAAAU01UUDpHUkFIQU1A RElHSVRBTFBMQU5JVC5DT00AAAALAAEOAAAAAEAABg4A5HmrHL3AAQIBCg4B AAAAGAAAAAAAAACLp1q8RsjTEZATAEhUUB+2woAAAAsAHw4BAAAAAgEJEAEA AAD9AQAA+QEAAIACAABMWkZ16i79OgMACgByY3BnMTI1JjIA+AtgbmcB0DU3 TwH3AqQD4wIAY2gKwHOwZXQwIAcTAoB9CoGSdgiQd2sLgGQ0DGCOYwBQCwML tSBJIBDwQHZlIGp1cwVAZAMCIBQgYSByYXRopQSQIAtgcmcUIHQVANMAgADQ dGkCICASIBTgERTgdGVsFLB0L3A8c3EDIBEgBBAWUndooQ3gaCBleAWQdRbw gGQgT0suIFQVMAwgcANgAmBlbSBv/mMYwAlxGCEJ8BXAGXEW9L8XpxZAB4AZ AAhgBUBiARDPBbAUIBPQBaB1bBkABaA4bW1pBUAa8gNgd3M+LgqiCoQKgBlg BAAgbWcUUhPzCQBjaxjxHiYgeQuAIHEKUBRgFlIcwGP+YRRQFCAaoxPQFdAI kCCx5m8WgADQdXUaABrzAaDPGeAhUAVAFENodQ8gHqt+VxDwBUAfkRryHMAU YXfUYXkaEGYUgGUHQAuAfmcYIB3wGHAVIB+RGaZhnwQgE9AJ8AEAGQB1cBeg +SNwcHAoAgBwGQAJcBRgzwrAFkAoERrycG8UYADAixRgBJA/HrpBbHMjgPsK wBQgZiVAFjMEIChCIWG/LggnwicxKFIhYRTgJxXZrQdAJxehAIBlLKtDFTC3 BJAQsB7JRxUAEPBtHrQFEeEANPAAAAALAAGACCAGAAAAAADAAAAAAAAARgAA AAADhQAAAAAAAAMAA4AIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAH gAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAACdqAQAeAAmACCAGAAAAAADAAAAA AAAARgAAAABUhQAAAQAAAAQAAAA5LjAAHgAKgAggBgAAAAAAwAAAAAAAAEYA AAAANoUAAAEAAAABAAAAAAAAAB4AC4AIIAYAAAAAAMAAAAAAAABGAAAAADeF AAABAAAAAQAAAAAAAAAeAAyACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAA AAEAAAAAAAAACwANgAggBgAAAAAAwAAAAAAAAEYAAAAAgoUAAAEAAAALADqA CCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAPIAIIAYAAAAAAMAAAAAA AABGAAAAABGFAAAAAAAAAwA9gAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAA AAALAFKACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAMAU4AIIAYAAAAA AMAAAAAAAABGAAAAAAGFAAAAAAAAAgH4DwEAAAAQAAAAi6davEbI0xGQEwBI VFAftgIB+g8BAAAAEAAAAIunWrxGyNMRkBMASFRQH7YCAfsPAQAAAIIAAAAA AAAAOKG7EAXlEBqhuwgAKypWwgAAUFNUUFJYLkRMTAAAAAAAAAAATklUQfm/ uAEAqgA32W4AAABDOlxXSU5ET1dTXExvY2FsIFNldHRpbmdzXEFwcGxpY2F0 aW9uIERhdGFcTWljcm9zb2Z0XE91dGxvb2tcb3V0bG9vay5wc3QAAAADAP4P BQAAAAMADTT9NwAAAgF/AAEAAAA4AAAAPE5EQkJKQUJESUxPUEFPT01GSkhP R0VBSkNKQUEuZ3JhaGFtQGRpZ2l0YWxwbGFuaXQuY29tPgADAAYQFB6vnAMA BxB8AQAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAElIQVZFSlVTVERP TkVBUkFUSEVSTEFSR0VUUkFOU0FDVElPTlZJQUFURUxORVQvUFNRTFNFU1NJ T05XSElDSEVYRUNVVEVET0tUSEVQUk9CTEVNT0NDVVJFRFdIRU5USEVURUwA AAAA+lw= ------=_NextPart_000_003A_01C0BD25.2DECB0E0--