Обсуждение: psql -f option
I am trying to use the psql -f <filename> 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
Вложения
"Graham Vickrage" wrote: >I am trying to use the psql -f <filename> option to load a script into the >DB ( v7.0 ) from thelinux 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 associatedline number in >the script. This would be a very useful feature for me as my scripts can be >very long. > >Is therea configuration option i am missing? Use -e as well, to have the SQL queries echoed; then you can see where the errors are arising. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "But because of his great love for us, God, who is rich in mercy, made usalive with Christ even when we were dead in transgressions-it is by grace you have been saved." Ephesians2:4,5
Graham Vickrage writes: > 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. Works here: $ psql -f /etc/sysctl.conf psql:/etc/sysctl.conf:8: ERROR: parser: parse error at or near "#" It looks to me like you are using an older psql, perhaps from a previous installation. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/