Received: from sandberg.webdevelopmentgroup.com ([207.197.204.138]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0EHq8V47501 for ; Mon, 14 Jan 2002 12:52:09 -0500 (EST) (envelope-from marius@webdevgroup.com) Received: from [192.168.1.8] (onyx.wdg.ro [193.231.212.69]) by sandberg.webdevelopmentgroup.com (8.9.3/8.9.3) with ESMTP id MAA12304 for ; Mon, 14 Jan 2002 12:52:11 -0500 Subject: psql bug: copy paste statements looses tab character From: Marius Andreiana To: pgsql-sql Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.1 (1.0.1-1) Date: 14 Jan 2002 20:00:54 +0200 Message-Id: <1011031257.2224.22.camel@aurora.wdg.ro> Mime-Version: 1.0 X-Archive-Number: 200201/221 X-Sequence-Number: 6305 this happens in 7.1.3 (included in red hat 7.2). e.g. CREATE TABLE items ( item_id SERIAL, name VARCHAR(32) ); copy pasted in psql gives this marius=> CREATE TABLE items ( marius(> item_id marius(> item_idSERIAL, marius(> name marius(> nameVARCHAR(32) marius(> ); ERROR: parser: parse error at or near "(" this will work: CREATE TABLE items ( item_id SERIAL, name VARCHAR(32) ); I've seen this behavior on sybase's sqsh once, perhaps it's something system wide, and not psql's fault? -- Marius Andreiana Web Development Group, Inc.