Received: from corporate.fx.ro (corporate.fx.ro [193.231.208.29]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0G76eV22391 for ; Wed, 16 Jan 2002 02:06:40 -0500 (EST) (envelope-from marius@wdg.ro) Received: from fx.ro (Beavis.fx.ro [193.231.208.21]) by corporate.fx.ro (8.10.1/8.10.1) with ESMTP id g0G76dr17027 for ; Wed, 16 Jan 2002 09:06:39 +0200 Received: from amber.wdg.ro ([193.231.212.69]) by fx.ro (8.10.1/8.10.1) with ESMTP id g0G76Ys10845 for ; Wed, 16 Jan 2002 09:06:35 +0200 (EET) Received: from [192.168.1.8] (aurora.wdg.ro [192.168.1.8]) by amber.wdg.ro (8.9.3/8.9.3) with ESMTP id JAA28198 for ; Wed, 16 Jan 2002 09:06:32 +0200 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: 16 Jan 2002 09:15:16 +0200 Message-Id: <1011165316.1208.0.camel@aurora.wdg.ro> Mime-Version: 1.0 X-Archive-Number: 200201/176 X-Sequence-Number: 6262 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 -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/