Skip site navigation (1) Skip section navigation (2)

Postgresql 8.3 beta crash

From: Sheikh Amjad <sheikhamjad(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Postgresql 8.3 beta crash
Date: 2007-10-31 12:21:35
Message-ID: 4728734F.7000305@gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Following test case is crashing the postgresql-8.3-beta 

create schema st;

 CREATE TABLE ST.STUDENT(
    STUDENT_ID     VARCHAR2(10),
    NAME         VARCHAR(50) NOT NULL,
    NIC         CHAR(11),
    DOB          DATE NOT NULL,
    GENDER         CHAR(1) NOT NULL,
    MAR_STAT      CHAR(1) NOT NULL,
    NATION         VARCHAR2(15),
    FNAME         VARCHAR2(50) NOT NULL,
    GNAME         VARCHAR2(50),
    ADDRESS            VARCHAR2(100) NOT NULL,
    POS_CODE     VARCHAR2(8),
    PER_TEL     VARCHAR2(15),
    EMAIL_ADD     VARCHAR(20),
    LAST_DEGREE     VARCHAR(25),
    ENT_DATE     DATE NOT NULL);

 ALTER TABLE ST.STUDENT
     ADD CONSTRAINT PK_ST PRIMARY KEY (STUDENT_ID);




Insert into st.student values(0,'Hassan
Mustafa','1887749999','10-Jan-1981','M','S','Pakistani','Mustafa
Kamal',NULL,'H#2,ST#20,
Islamabad',44000,'0300-4329984','hmustafa(at)hotmail(dot)com','BS','10-JAN-2005');
Insert into st.student values(1,'Faiza
Shah','1887749999','05-Jan-1980','F','S','Pakistani','Muneer
Shah','Sadia Shah','H#6,ST#1 G-10,
Islamabad',44000,'0333-233329984','faiza(at)hotmail(dot)com','FSC','12-FEB-2005');
Insert into st.student values(2,'Mustafa
Kamal','23388777','23-Aug-1978','M','S','Pakistani','Ali
baig',NULL,'H#12,ST#2 F-6,
Islamabad',44000,'0321-66788800','mkamal(at)hotmail(dot)com','BS','10-JAN-2005');
Insert into st.student values(3,'Kashif
Parveez','334459999','27-Dec-1975','M','S','Pakistani','Parveez
Haq',NULL,'H#2,ST#20,
Islamabad',44000,'0345-54329984','kp(at)hotmail(dot)com','BCom','10-JAN-2005');
Insert into st.student values(4,'Ali
Khan','567749999','11-Jan-1981','M','S','Pakistani','S
Kamal',NULL,'H#2,ST#20,
Islamabad',44000,'0399-4329984','skmsss(at)hotmail(dot)com','BS','10-JAN-2005');
Insert into st.student values(5,'Saadia
Naz','1887749999','10-Jan-1981','S','S','Pakistani','Malik
Awan',NULL,'H#2,ST#20,
Islamabad',44000,'0300-4329984','hmustafa(at)hotmail(dot)com','BS','10-JAN-2005');
Insert into st.student values(6,'Shah
Rafeeq','1887749999','10-Jan-1982','M','S','Pakistani','Rafeed
Ahmed',NULL,'H#2,ST#20,
Islamabad',44000,'0300-4329984','hmustafa(at)hotmail(dot)com','BS','10-JAN-2005');
Insert into st.student values(7,'Mohammad
Bilal','1887749999','10-Jun-1981','M','S','Pakistani','Abdul
Hameed',NULL,'H#2,ST#20,
Islamabad',44000,'0300-4329984','hmustafa(at)hotmail(dot)com','BS','10-JAN-2005');
Insert into st.student values(8,'Bilal
Mustafa','1887749999','10-Feb-1980','M','S','Pakistani','Mustafa
Kamal',NULL,'H#2,ST#20,
Islamabad',44000,'0300-4329984','hmustafa(at)hotmail(dot)com','BS','10-JAN-2005');
Insert into st.student values(8,'Shahkir Hussain
Naqvi','1887749999','10-Mar-1978','M','S','Pakistani','Mustafa
Kamal',NULL,'H#2,ST#20,
Islamabad',44000,'0300-4329984','hmustafa(at)hotmail(dot)com','BS','10-JAN-2005');
Insert into st.student values(9,'Amir
Husain','5677499993','20-Jan-1981','M','S','Pakistani','Mustafa
Kamal',NULL,'H#2,ST#20,
Islamabad',44000,'0300-4329984','hmustafa(at)hotmail(dot)com','BS','10-JAN-2005');





SELECT XMLELEMENT
        ( NAME "Program",
            XMLAGG
             ( XMLELEMENT
                 ( NAME "Student", s.name::xml )
             )
        ) AS "Registered Student"
from st.student s ;





Responses

pgsql-hackers by date

Next:From: Gregory StarkDate: 2007-10-31 12:26:18
Subject: Re: UTF-8 for SGML docs?
Previous:From: Gokulakannan SomasundaramDate: 2007-10-31 11:44:16
Subject: Re: Clarification on a Time travel feature

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group