Hi,

I've encountered this before, psql gives me a syntax error for no clear
reason. It's allways on the first character of a sql file.
I think that there must be some strange character code at the first
position, maybe it is because i share a ntfs partition with the windows
installation on my laptop and move files around.
I only editted this file with gedit, pgAdmin and vim on ubuntu lucid
desktop.

Here's the error:

postgres=# \i db02-vulling.sql
psql:db02-vulling.sql:1: ERROR:  syntax error at or near "begin"
LINE 1: begin;
        ^
INSERT 0 10100
INSERT 0 101
INSERT 0 100
psql:db02-vulling.sql:12: WARNING:  there is no transaction in progress
COMMIT
postgres=#


The file is in the attachment, both gzipped and as-is.
I hope someone can reproduce this.
(the code itself makes no sense but that's not relevant here)

WBL
-- 
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw
begin;

insert into a (val, description)
select generate_series(100,200), 'dit is nummer '||generate_series(1,100);

insert into c (val)
select generate_series(200,300);

insert into b (aid, cid)
select generate_series(1,100), generate_series(1,100);

commit;

Attachment: db02-vulling.sql.gz
Description: GNU Zip compressed data

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Reply via email to