Horton
Menu

Thread

  1. Another one I thought should work...

    Marc Fournier <scrappy@hub.org> — 1998-02-20T05:12:32Z

    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

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

    Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-02-20T05:29:39Z

    > 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

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

    Vadim Mikheev <vadim@sable.krasnoyarsk.su> — 1998-02-20T05:39:46Z

    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

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

    Marc Fournier <scrappy@hub.org> — 1998-02-20T05:40:48Z

    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

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

    Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-02-20T06:10:43Z

    > > > 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

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

    Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-20T14:52:09Z

    > 
> 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