Re: ecpg - GRANT bug - Mailing list pgsql-hackers

From Lee Kindness
Subject Re: ecpg - GRANT bug
Date
Msg-id 15306.62331.332853.699939@elsick.csl.co.uk
Whole thread Raw
In response to ecpg - GRANT bug  (Lee Kindness <lkindness@csl.co.uk>)
Responses Re: ecpg - GRANT bug
Re: ecpg - GRANT bug
List pgsql-hackers
Tom Lane writes:> Lee Kindness <lkindness@csl.co.uk> writes:> > The existing code in ecpg/preproc/preproc.y to handle
theWITH option> > simply throws an error and aborts the processing... The patch below> > prevents the segfault and also
passeson the WITH option to the> > backend, probably a better fix.> I agree.  It shouldn't be ecpg's business to throw
errorson behalf of> the backend, especially not "not yet implemented" kinds of errors.> That just causes ecpg to be
moretightly coupled to a particular backend> version than it needs to be.
 

In which case a number of other cases should be weeded out of
parser.y and passed onto the backend:
CREATE TABLE:    GLOBAL TEMPORARY option.CREATE FUNCTION: IN/OUT/INOUT options (note there's a bug in parser.y
      there anyway, it would pass on 'oinut' for INOUT).COMMIT:          AND [NO] CHAIN options? Where do these come
from,                it's not ANSI (i'd probably leave this one).
 

Perhaps an ET_NOTICE should still be output however...

Let me known if you want a patch for these cases too.

Regards, Lee Kindness.


pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: Deadlock? idle in transaction
Next
From: Tom Lane
Date:
Subject: Re: New contrib/tsearch module for 7.2