Re: [HACKERS] automatic parser generation for ecpg

2008-10-21 Thread Mike Aubury
..) -- 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 subscription: http

Re: [HACKERS] automatic parser generation for ecpg

2008-10-21 Thread Mike Aubury
) 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 Aubury http://www.aubit.com/ Aubit Computing Ltd is registered in England and Wales, Number: 3112827

Re: [HACKERS] keyword list/ecpg

2008-06-13 Thread Mike Aubury
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 always insert a space between tokens, no matter whether there was one originally? There are a few

Re: [HACKERS] keyword list/ecpg

2008-06-13 Thread Mike Aubury
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 a tool for ecpg tool developers and not used as part of a normal installation. -- Mike Aubury http

Re: [HACKERS] keyword list/ecpg

2008-06-13 Thread Mike Aubury
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,Manchester,M1 2AQ -- Sent via pgsql-hackers mailing list

Re: [HACKERS] keyword list/ecpg

2008-06-04 Thread Mike Aubury
! -- 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 subscription: http

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 magic to know when to have blanks in between and when

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

2008-05-02 Thread Mike Aubury
?) 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 application) -- Mike Aubury Aubit Computing Ltd is registered in England and Wales, Number: 3112827 Registered Address : Clayton House,59

Re: [HACKERS] get rid of psql welcome message

2008-04-17 Thread Mike Aubury
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 commands in case they are really attached to it. -- Mike Aubury Aubit Computing Ltd is registered in England

[HACKERS] Scroll cursor oddity...

2008-04-01 Thread Mike Aubury
.. 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 (1 row) TIA -- Mike Aubury Aubit

[HACKERS] Request for feature - ECPGget_PGconn

2008-03-17 Thread Mike Aubury
to 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 Aubury Aubit

Re: [HACKERS] postgresql.org dns problems

2008-03-17 Thread Mike Aubury
] --- --- 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 : Clayton House,59 Piccadilly,Manchester,M1 2AQ -- Sent via pgsql-hackers

[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

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

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]; };

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

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 supported