Skip site navigation (1) Skip section navigation (2)

Re: ECPG Segfault and variable usage question.

From: Jürgen Cappel <email(at)juergen-cappel(dot)de>
To: "pgsql-interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: ECPG Segfault and variable usage question.
Date: 2004-02-17 20:15:20
Message-ID: JEEKIPNAKJNCFLMOBKHGGEEIDCAA.email@juergen-cappel.de (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hello Michael,

some more info: the segmentation fault still occurs under Linux (SuSE 8.0)
with today's snapshot. No options used, just the filename as the only arg.
I tried it on Solaris 8 today where it compiles fine. It works on Linux
when I change the variable name from "var" to "myvar" or add a variable in
the DECLARE section, but that can't be the solution. Any idea on how to
find the problem ?

Oh, BTW: the expression   :myarray[index[10]]   compiles OK as of
pgc.l version 1.125 2004/02/15  Thanks for your help !

Jürgen



-----Ursprüngliche Nachricht-----
Von: pgsql-interfaces-owner(at)postgresql(dot)org
[mailto:pgsql-interfaces-owner(at)postgresql(dot)org]Im Auftrag von Michael
Meskes
Gesendet: Sonntag, 15. Februar 2004 14:42
An: Jürgen Cappel
Cc: pgsql-interfaces
Betreff: Re: [INTERFACES] ECPG Segfault and variable usage question.


On Thu, Feb 12, 2004 at 08:00:12PM +0100, Jürgen Cappel wrote:
> this is a code snippet that causes ECPG to segfault. It's quite tricky

I took this code as a.pgc and ran 'ecpg a.pgc' without any problem. Do
you use any special options for ecpg?

> Stack trace was obtained using a snapshot from about 2 weeks ago, ECPG
from
> the 7.4.1 release segfaults also.

Hmm, my 7.4.1 version also compiles this snippet cleanly.

> Another problem that's giving me headaches trying to find a workaround for
> is the following use of variables as data sources in INSERT/UPDATE
> statements:
>
> 	:myarray[index[10]]
>
> Any comments, suggestions, hints ?   Thanks a lot,

Could you please try if the following patch helps you?

--- /home/postgres/pgsql-ecpg/preproc/pgc.l	2003-12-29 14:53:04.000000000
+0100
+++ pgc.l	2004-02-15 14:38:43.000000000 +0100
@@ -183,7 +183,7 @@

 identifier		{ident_start}{ident_cont}*

-array			({ident_cont}|{whitespace}|[\+\-\*\%\/\(\)])*
+array			({ident_cont}|{whitespace}|[\[\]\+\-\*\%\/\(\)])*
 typecast		"::"

 /*

This will make it into CVS soon.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


Responses

pgsql-interfaces by date

Next:From: L J BayukDate: 2004-02-18 02:55:06
Subject: Re: Need new project admin for unbundled Tcl interface
Previous:From: Marc G. FournierDate: 2004-02-17 16:35:43
Subject: Re: Need new project admin for unbundled Tcl interface

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group