This behavior doesn't look right: nconway=# create table foo (a int default 50, b int default 100); CREATE TABLE nconway=# copy foo from stdin; Enter data to be copied followed by a newline. End with a backslash and a period on a line by itself. >> >> \. nconway=# select * from foo; a | b ---+--- 0 | (1 row)
(The first line of the COPY input is blank: i.e. just a newline) The problem appears to be in both 7.2.1 and current CVS. Cheers, Neil -- Neil Conway <[EMAIL PROTECTED]> PGP Key ID: DB3C29FC ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
