Re: 8.0 ecpg crashes with "create table as" statement.

On Wed, 9 Feb 2005 12:27:13 +0100
Michael Meskes <meskes@postgresql.org> wrote:

> Thanks for the report and the patch. I just committed it to CVS HEAD and
> the 8.0 branch. 7.4 does not suffer from this bug.

Probably, "create sequence" and "create domain" have same problems. Here's
a patch for preproc.y .

It's reported by Atsushi Mitani(mitani@sraw.co.jp) in Japanese ML.

=============================================================
--- preproc.y.org   2005-02-07 09:18:44.000000000 +0900
+++ preproc.y   2005-02-10 11:17:03.000000000 +0900
@@ -1621,7 +1621,7 @@
  *****************************************************************************/

 CreateSeqStmt: CREATE OptTemp SEQUENCE qualified_name OptSeqList
-           { $$ = cat_str(4, make_str("create"), $2, make_str("sequence"), $4,$5); }
+           { $$ = cat_str(5, make_str("create"), $2, make_str("sequence"), $4,$5); }
        ;

 AlterSeqStmt: ALTER SEQUENCE qualified_name OptSeqList
@@ -2705,7 +2705,7 @@

 CreateDomainStmt:  CREATE DOMAIN_P any_name opt_as Typename ColQualList
            {
-               $$ = cat_str(55555, make_str("create domain"), $3, $4, $5, $6);
+               $$ = cat_str(5, make_str("create domain"), $3, $4, $5, $6);
            }
        ;

--
TANIDA Yutaka <tanida@sra.co.jp>