Postgresql 8.3 beta crash

Поиск
Список
Период
Сортировка
От Sheikh Amjad
Тема Postgresql 8.3 beta crash
Дата
Msg-id 4728734F.7000305@gmail.com
обсуждение исходный текст
Ответы Re: Postgresql 8.3 beta crash  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: Postgresql 8.3 beta crash  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: Clarification on a Time travel feature
Следующее
От: "Gokulakannan Somasundaram"
Дата:
Сообщение: Re: Clarification on a Time travel feature