Обсуждение: Another one I thought should work...
Backend crashes on this one too...? CREATE TABLE projects ( pid INT NOT NULL PRIMARY KEY, ppid INT, grp VARCHAR(10), o_date INT, o_tech VARCHAR(10), sc_date INT, c_date INT, c_tech VARCHAR(5), currtech VARCHAR(10), state VARCHAR(1), status VARCHAR(1), priority INT, c_name VARCHAR(20), c_phone VARCHAR(20), problem VARCHAR(100), summary VARCHAR(80) ) \g Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
> 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
On Fri, 20 Feb 1998, Thomas G. Lockhart wrote: > > Backend crashes on this one too...? > > My 980217 cvs tree does not crash on this. Ack...wait, that is 3 days old...okay, mine is based on todays CVS... scrappy=> CREATE TABLE projects ( scrappy-> pid INT NOT NULL PRIMARY KEY, scrappy-> ppid INT, scrappy-> grp VARCHAR(10), scrappy-> o_date INT, scrappy-> o_tech VARCHAR(10), scrappy-> sc_date INT, scrappy-> c_date INT, scrappy-> c_tech VARCHAR(5), scrappy-> currtech VARCHAR(10), scrappy-> state VARCHAR(1), scrappy-> status VARCHAR(1), scrappy-> priority INT, scrappy-> c_name VARCHAR(20), scrappy-> c_phone VARCHAR(20), scrappy-> problem VARCHAR(100), scrappy-> summary VARCHAR(80) scrappy-> ) \g NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index projects_pkey for table projects NOTICE: _outNode: don't know how to print type 715 NOTICE: _outNode: don't know how to print type 715 Bruce, can you try yours? Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
The Hermit Hacker wrote: > > Backend crashes on this one too...? > > CREATE TABLE projects ( > pid INT NOT NULL PRIMARY KEY, ^^^^^^^^^^^^^^^^^^^^ No probs here, in 6.3... Vadim
> > > Backend crashes on this one too...? > > > > My 980217 cvs tree does not crash on this. btw, I'm not running with asserts on. Also, this will be easy to fix; it is trying to print a node which does not have an associated print routine. Actually, are you sure the table did not get created? That is a NOTICE, not ERROR... - Tom > Ack...wait, that is 3 days old...okay, mine is based on todays CVS... > > scrappy=> CREATE TABLE projects ( > scrappy-> pid INT NOT NULL PRIMARY KEY, > scrappy-> ppid INT, > scrappy-> grp VARCHAR(10), > scrappy-> o_date INT, > scrappy-> o_tech VARCHAR(10), > scrappy-> sc_date INT, > scrappy-> c_date INT, > scrappy-> c_tech VARCHAR(5), > scrappy-> currtech VARCHAR(10), > scrappy-> state VARCHAR(1), > scrappy-> status VARCHAR(1), > scrappy-> priority INT, > scrappy-> c_name VARCHAR(20), > scrappy-> c_phone VARCHAR(20), > scrappy-> problem VARCHAR(100), > scrappy-> summary VARCHAR(80) > scrappy-> ) \g > NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index projects_pkey > for table projects > NOTICE: _outNode: don't know how to print type 715 > NOTICE: _outNode: don't know how to print type 715
> > On Fri, 20 Feb 1998, Thomas G. Lockhart wrote: > > > > Backend crashes on this one too...? > > > > My 980217 cvs tree does not crash on this. > > Ack...wait, that is 3 days old...okay, mine is based on todays CVS... > > scrappy=> CREATE TABLE projects ( > scrappy-> pid INT NOT NULL PRIMARY KEY, > scrappy-> ppid INT, > scrappy-> grp VARCHAR(10), > scrappy-> o_date INT, > scrappy-> o_tech VARCHAR(10), > scrappy-> sc_date INT, > scrappy-> c_date INT, > scrappy-> c_tech VARCHAR(5), > scrappy-> currtech VARCHAR(10), > scrappy-> state VARCHAR(1), > scrappy-> status VARCHAR(1), > scrappy-> priority INT, > scrappy-> c_name VARCHAR(20), > scrappy-> c_phone VARCHAR(20), > scrappy-> problem VARCHAR(100), > scrappy-> summary VARCHAR(80) > scrappy-> ) \g > NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index projects_pkey > for table projects > NOTICE: _outNode: don't know how to print type 715 > NOTICE: _outNode: don't know how to print type 715 > > > Bruce, can you try yours? Works here, my snapshot is from Feb 19. -- Bruce Momjian maillist@candle.pha.pa.us