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(at)hub(dot)org secondary: scrappy(at){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(at)hub(dot)org secondary: scrappy(at){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

> 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(at)candle(dot)pha(dot)pa(dot)us