Postgresql 8.3 beta crash - Mailing list pgsql-hackers
From | Sheikh Amjad |
---|---|
Subject | Postgresql 8.3 beta crash |
Date | |
Msg-id | 4728734F.7000305@gmail.com Whole thread Raw |
Responses |
Re: Postgresql 8.3 beta crash
Re: Postgresql 8.3 beta crash |
List | 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) NOTNULL, 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@hotmail.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@hotmail.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@hotmail.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@hotmail.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@hotmail.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@hotmail.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@hotmail.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@hotmail.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@hotmail.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@hotmail.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@hotmail.com','BS','10-JAN-2005'); SELECT XMLELEMENT ( NAME "Program", XMLAGG ( XMLELEMENT ( NAME "Student", s.name::xml) ) ) AS "Registered Student" from st.student s ;
pgsql-hackers by date: