Re: [HACKERS] Another one I thought should work...

Thomas Lockhart <lockhart@alumni.caltech.edu>

From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
To: The Hermit Hacker <scrappy@hub.org>
Cc: pgsql-hackers@postgresql.org
Date: 1998-02-20T05:29:39Z
Lists: pgsql-hackers
> Backend crashes on this one too...?

My 980217 cvs tree does not crash on this.

                                                       - Tom

postgres=> CREATE TABLE projects (
postgres->   pid INT NOT NULL PRIMARY KEY,
postgres->   ppid INT,
postgres->   grp VARCHAR(10),
postgres->   o_date INT,
postgres->   o_tech VARCHAR(10),
postgres->   sc_date INT,
postgres->   c_date INT,
postgres->   c_tech VARCHAR(5),
postgres->   currtech VARCHAR(10),
postgres->   state VARCHAR(1),
postgres->   status VARCHAR(1),
postgres->   priority INT,
postgres->   c_name VARCHAR(20),
postgres->   c_phone VARCHAR(20),
postgres->   problem VARCHAR(100),
postgres->   summary VARCHAR(80)
postgres-> ) \g
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index projects_pkey for
table projects
CREATE
postgres=> insert into projects values
(1,2,'hi',3,'there',4,5,'five','six','y','n',99,'tom','123-4567','crashes?','no
way!');
INSERT 1018395 1