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
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
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
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
Show quoted text
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 715Bruce, can you try yours?
Works here, my snapshot is from Feb 19.
--
Bruce Momjian
maillist@candle.pha.pa.us