Installed PostgreSQL
От | Thien Lee |
---|---|
Тема | Installed PostgreSQL |
Дата | |
Msg-id | 369D68F4.B5C95C8C@quickturn.com обсуждение исходный текст |
Список | pgsql-ports |
Hi, Thanks folks for a free SQL server, I'm just getting my hands wet with SQL in spare time... -Thien Version: PostgreSQL 6.4.2 OS: RedHat 4.2 Linux 2.0.30 Hardware: Pentium-II, 300 MHz Configure options: --with-perl flex: 2.5.4 bison: 1.25 gmake: 3.75 gcc: egcs-2.90.29 (egcs-1.0.3 release) Building was successful, though quite a few compiler warnings about implicit declarations (i.e. missing declaration/prototype). Regression passed except: geometry .. failed datetime .. failed horology .. failed ----- geometry.out ----- QUERY: SELECT '' AS count, p.f1, l.s, l.s # p.f1 AS intersection FROM LSEG_TBL l, POINT_TBL p; ERROR: There is more than one possible operator '#' for types 'lseg' and 'point' You will have to retype this query using an explicit cast ----- datetime.out ----- (crash?) QUERY: INSERT INTO DATETIME_TBL VALUES ('1997-01-02'); pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. We have lost the connection to the backend, so further processing is impossible. Terminating. ----- horology.out ----- (crash?) QUERY: INSERT INTO TEMP_DATETIME (f1) SELECT d1 FROM DATETIME_TBL WHERE d1 BETWEEN '13-jun-1957' AND '1-jan-1997' OR d1 BETWEEN '1-jan-1999' AND '1-jan-2010'; pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. We have lost the connection to the backend, so further processing is impossible. Terminating.
В списке pgsql-ports по дате отправления: