Обсуждение: Port Bug Report: basic.source and advance.source failed
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : T.J. Yang
Your email address : tjyang@zicorp.com
Category : unknown
Severity : serious
Summary: basic.source and advance.source failed
System Configuration
--------------------
Operating System : redhat 6.0
PostgreSQL version : 6.5
Compiler used : gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Hardware:
---------
Linux dns 2.2.5-15 #1 Mon Apr 19 22:21:09 EDT 1999 i586 unknown
Versions of other tools:
------------------------
gmake
--------------------------------------------------------------------------
Problem Description:
--------------------
temp reserved by system ?
date type of char2 and char16 don't work.
--------------------------------------------------------------------------
Test Case:
----------
In "basic.source", the statement "SELECT * INTO TABLE temp FROM weather"
failed until "temp" was changed to name other than "temp"
In advance.source, the type char2 and char16 failed until it as changed to char.
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------
> Problem Description: > -------------------- > temp reserved by system ? > date type of char2 and char16 don't work. > > > > > -------------------------------------------------------------------------- > > Test Case: > ---------- > In "basic.source", the statement "SELECT * INTO TABLE temp FROM weather" > failed until "temp" was changed to name other than "temp" > In advance.source, the type char2 and char16 failed until it as changed to char. > Fixed. Thanks. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026