Received: from digitalplanit.wdi.co.uk ([195.13.87.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f04G2M799797 for ; Thu, 4 Jan 2001 11:02:22 -0500 (EST) (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 BAA21330 for ; Thu, 4 Jan 2001 01:28:49 GMT From: "Graham Vickrage" To: Subject: psql -f option Date: Thu, 4 Jan 2001 16:04:07 -0000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_000F_01C07667.F7A26CE0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Importance: Normal X-MS-TNEF-Correlator: X-Archive-Number: 200101/53 X-Sequence-Number: 714 This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C07667.F7A26CE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am trying to use the psql -f option to load a script into the DB ( v7.0 ) from the linux command line. The documentation says -f enables some nice features such as error messages with line numbers. It seems to me that this is half true i.e. it shows me error messages, its doesn't however give me the associated line number in the script. This would be a very useful feature for me as my scripts can be very long. Is there a configuration option i am missing? Thanx in advance Graham ------=_NextPart_000_000F_01C07667.F7A26CE0 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IgcQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcA GAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEG gAMADgAAANEHAQAEABAAAwAAAAQA9AABA5AGAHwGAAAlAAAACwACAAEAAAAL ACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAABAAAADwAAAHBz cWwgLWYgb3B0aW9uAAACAXEAAQAAABYAAAABwHZn8l35z0gm4icR1JAWAEhU UB+2AAACAR0MAQAAAB4AAABTTVRQOkdSQUhBTUBESUdJVEFMUExBTklULkNP TQAAAAsAAQ4AAAAAQAAGDgBSa89ndsABAgEKDgEAAAAYAAAAAAAAAIunWrxG yNMRkBMASFRQH7bCgAAACwAfDgEAAAACAQkQAQAAACUCAAAhAgAA5AIAAExa RnX3USEYAwAKAHJjcGcxMjUmMgD4C2BuZwHQNTdPAfcCpAPjAgBjaArAc/Bl dDAgBxMCgwBQA1RXEMkHbQKAfQqBdgiQd9JrC4BkNAxgYwBQCwMBC7UgSSBh bSB0FHJ5C4BnFoBvIHWLESAWgGgXUHBzcQMg4C1mIDxmAxAJ8BZg0GU+IG8F MGkCIBby6QkAYWQWUCAE9QuAFwEBF3JEQiAoIHY3si4RUCkgA1IXY2wLgOh1 eCAFoG0DgRmwHEE8ZS4K4wqECoQLMHNi5DEwAUBzYR7BEzAXgbBkb2N1B4AC MGEZA90fAHkEIhIRC/A0F/IYcbsCYAeRcwNwF1ADAGMXULxmZSAgCHAh4hUw aBZQvwQgBJADYAXAB4EfAGcHkV8D8BdwHRMiUB/QYgSQc80dYEkFQBEgZW0E IBcB/yIxF3AgIBdhBAAaUAQgEPDebBgQFpAKUBpQLh1RJMBxGeBob3cEICIx I8wszyiBBCAfoAeQbicFQCjRxGV2BJAgZ2krUCaU1xdQI5AiEGMHMHQJgCT6 vxpRF2ME9B1gH2AnQXcIYF5sGbAlgBnBK1F5FyJm3y8gIqYboCPzI4JtL+AE 9H0EIGMDkS9hL7MJAA8gLvcd6gu2HZNJJlEXgDDBGdB1BaBuGEBnCHAgJBjl ae0WUm0EARbBPx2KH2AAcHccgC3BGaB2AHAigB2KR1s2ABDwbR2EFFEAOzAA AAALAAGACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAA4AIIAYAAAAA AMAAAAAAAABGAAAAABCFAAAAAAAAAwAHgAggBgAAAAAAwAAAAAAAAEYAAAAA UoUAACdqAQAeAAmACCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA5 LjAAHgAKgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4A C4AIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAAyACCAG AAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAACwANgAggBgAAAAAA wAAAAAAAAEYAAAAAgoUAAAEAAAALADqACCAGAAAAAADAAAAAAAAARgAAAAAO hQAAAAAAAAMAPIAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwA9gAgg BgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAALAFKACCAGAAAAAADAAAAAAAAA RgAAAAAGhQAAAAAAAAMAU4AIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAA AgH4DwEAAAAQAAAAi6davEbI0xGQEwBIVFAftgIB+g8BAAAAEAAAAIunWrxG yNMRkBMASFRQH7YCAfsPAQAAAIIAAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAA UFNUUFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4AAABDOlxXSU5ET1dT XExvY2FsIFNldHRpbmdzXEFwcGxpY2F0aW9uIERhdGFcTWljcm9zb2Z0XE91 dGxvb2tcb3V0bG9vay5wc3QAAAADAP4PBQAAAAMADTT9NwAAAgF/AAEAAAA4 AAAAPE5EQkJKQUJESUxPUEFPT01GSkhPSUVMTkNHQUEuZ3JhaGFtQGRpZ2l0 YWxwbGFuaXQuY29tPgADAAYQNd6yDAMABxCJAQAAAwAQEAAAAAADABEQAAAA AB4ACBABAAAAZQAAAElBTVRSWUlOR1RPVVNFVEhFUFNRTC1GPEZJTEVOQU1F T1BUSU9OVE9MT0FEQVNDUklQVElOVE9USEVEQihWNzApRlJPTVRIRUxJTlVY Q09NTUFORExJTkVUSEVET0NVTUVOVEEAAAAAZF0= ------=_NextPart_000_000F_01C07667.F7A26CE0--