Обсуждение: 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