Re: [HACKERS] automatic parser generation for ecpg

2008-10-21 Thread Mike Aubury
already and we're trying to help automate the process.. (ducks for cover) > As against that ... does a2p produce code that is readable/maintainable? > If the code wasn't perl to start with I'd be a little worried about > ending up with ugly hard-to-read code. -- Mike Au

Re: [HACKERS] automatic parser generation for ecpg

2008-10-21 Thread Mike Aubury
ite..) -- Mike Aubury http://www.aubit.com/ Aubit Computing Ltd is registered in England and Wales, Number: 3112827 Registered Address : Clayton House,59 Piccadilly,Manchester,M1 2AQ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscript

Re: [HACKERS] keyword list/ecpg

2008-06-13 Thread Mike Aubury
eloper changes the original gram.y? > Is he expected to run the script before committing too? That sounds > brittle to me. > -- Mike Aubury http://www.aubit.com/ Aubit Computing Ltd is registered in England and Wales, Number: 3112827 Registered Address : Clayton House,59 Piccadilly,Manch

Re: [HACKERS] keyword list/ecpg

2008-06-13 Thread Mike Aubury
heres also another thing that needs to be decided, which is if the generated ecpg grammer should be developer generated (ie. Michael Meskes runs a script and commits the output), or should be generated for each and every source based installation. I personally would stongly favour the script being

Re: [HACKERS] keyword list/ecpg

2008-06-13 Thread Mike Aubury
noticed that I didn't answer this email. ] > > On Wed, Jun 04, 2008 at 05:06:41PM +0100, Mike Aubury wrote: > > It might depend on the tokens.. > > Are ">=", "++" etc single tokens ? > > ... > > > > > Wouldn't it work to just a

Re: [HACKERS] keyword list/ecpg

2008-06-04 Thread Mike Aubury
It might depend on the tokens.. Are ">=", "++" etc single tokens ? On Wednesday 04 June 2008 17:06:44 Tom Lane wrote: > Mike Aubury <[EMAIL PROTECTED]> writes: > > On Wednesday 04 June 2008 16:11:49 Michael Meskes wrote: > >> There is some small m

Re: [HACKERS] keyword list/ecpg

2008-06-04 Thread Mike Aubury
dot De, Michael at Meskes dot (De|Com|Net|Org) > ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: [EMAIL PROTECTED] > Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL! -- Mike Aubury http://www.aubit.com/ Aubit Computing Ltd is registered in England and Wales, Number: 3112

[HACKERS] ecpg issue - not sending datatype to the backend

2008-05-02 Thread Mike Aubury
it was a text it was a text This to me looks 'wrong', especially when previous versions of ecpg (<8.0?) gave the correct : it was a date it was a int it was a text Any thoughts ? (This is manifesting itself as arithmetic errors when I'm using dates in my applicat

Re: [HACKERS] get rid of psql welcome message

2008-04-17 Thread Mike Aubury
; > The version mismatch warning would remain, of course. > > I'd also like to get rid of the SSL notice but I'm not sure what to replace > it by. Something in the prompt perhaps? > > Btw., any user could put the welcome message in his own psqlrc file via > \echo comm

[HACKERS] Scroll cursor oddity...

2008-04-01 Thread Mike Aubury
tional fetch to get back to our last row.. For reference - heres what I get as output : CREATE TABLE INSERT 32429 1 INSERT 32430 1 INSERT 32431 1 BEGIN DECLARE CURSOR a --- 1 (1 row) a --- 2 (1 row) a --- 3 (1 row) a --- (0 rows) a --- 3 (1 row) a --- 2 (1 row) a --- 1

Re: [HACKERS] postgresql.org dns problems

2008-03-17 Thread Mike Aubury
Email: [EMAIL PROTECTED] > --- >--- Make your life a dream, make your dream a reality. (St Exupery) -- Mike Aubury Aubit Computing Ltd is registered in England and Wales, Number: 3112827 Registered Address : Clay

[HACKERS] Request for feature - ECPGget_PGconn

2008-03-17 Thread Mike Aubury
o the existing ecpglib/connect.c file : PGconn* ECPGget_PGconn(const char *connection_name) { struct connection * con; con=ecpg_get_connection(connection_name); if (con==NULL) return NULL; return con->connection; } TIA -- Mike Aubur

Re: [HACKERS] CREATE TYPE

2003-07-18 Thread Mike Aubury
OK - i've got the basic input/output working now - but how to I do the extent bit ? eg. allow : create table ( something a4gl_datime(15) ) On Friday 18 July 2003 6:53 pm, [EMAIL PROTECTED] wrote: > Programmers Guide , Chap 10 > http://www.postgresql.org/docs/7.3/static/xtypes.html > > c

[HACKERS] CREATE TYPE

2003-07-18 Thread Mike Aubury
Can someone point me at some detailed instructions for creating new datatypes.. I've found quite a few web pages that mention it (in passing) and give brief examples - but nothing much I can actually work with for my purposes.. Ideally I'd like to use C as the language and the datatype will nee

Re: [HACKERS] ss_family in hba.c

2003-06-17 Thread Mike Aubury
My system has the same problem - struct sockaddr_storage is defined in /usr/include/bits/socket.h : struct sockaddr_storage { __SOCKADDR_COMMON (__ss_); /* Address family, etc. */ __ss_aligntype __ss_align; /* Force desired alignment. */ char __ss_padding[_SS_PADSIZE]; }; Whe

Re: [HACKERS] SQL parser error

2003-03-07 Thread Mike Aubury
Isn't there a space missing in there ? limit10 - limit 10 All you've done is alias the tablename On Friday 07 March 2003 11:25 am, Teodor Sigaev wrote: > Query > select * from TABLE limit10; > returns all rows, but it seems to me this is a syntax error... > > pgsql 7.3.2 and current CVS has

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-20 Thread Mike Aubury
Informix supports 2 different styles for the update - your one would have to be written : UPDATE djp SET(col1, col2) = ((SELECT col1,col2 FROM some_other_table)) Notice the double brackets ! The first signifies a list of values - the second is the brackets around the subquery... (NB If you tr

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-19 Thread Mike Aubury
On Wednesday 19 February 2003 8:18 pm, Dave Cramer wrote: > I have a customer with a rather large application which uses this > syntax, because they were using informix. There is also a rather > interesting 4GL project called aubit which is on sourceforge. They would > also like to see this support