Thread: 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