[GENERAL] xlog viewer

2008-11-05 Thread H.J. Sanders
Hello. Does someone have a tool to read xlog? Nothing high-tech , just simple to read it in ascii. Thanks Henk Sanders

Re: FW: [GENERAL] Male/female

2006-12-11 Thread H.J. Sanders
> > I would also suggest using a *coded* gender, not "male", > "female" strings which will make gender-based calculations a > lot easier down the road. Which will also make it easier to have a "multi-langual" solution. Henk Sanders ---(end of broadcast)--

FW: [GENERAL] Male/female

2006-12-08 Thread H.J. Sanders
> -Oorspronkelijk bericht- > Van: H.J. Sanders [mailto:[EMAIL PROTECTED] > Verzonden: vrijdag 8 december 2006 16:33 > Aan: Raymond O'Donnell > Onderwerp: RE: [GENERAL] Male/female > > > Hi ray. > > We have done it with a integer whereby >

Re: [GENERAL] converting Informix outer to Postgres

2006-11-08 Thread H.J. Sanders
Hi. >From some documentation: In INFORMIX SQL, outer tables are defined in the FROM clause with the OUTER keyword : SELECT ... FROM a, OUTER(b) WHERE a.key = b.akey SELECT ... FROM a, OUTER(b,OUTER(c)) WHERE a.key = b.akey AND b.key1 = c.bkey1 AND b.key2 = c.bke

Re: [GENERAL] minimizing downtime when upgrading

2006-06-21 Thread H.J. Sanders
>>> > >>> Is anybody over at the dev team considering what an onerous burden > >>> this is? Is anyone considering doing away with it? Just my 2 cents: more and more databases have to run 24 * 7 , so something has to be done. The last 15 years we also used Informix and we never, never had to

[GENERAL] error 57014

2006-06-08 Thread H.J. Sanders
Hello.   The next query runs into error 57014 in about 50 % of the cases. We certainly have not aborted the request. In the other 50 % it runs OK. The statement is executed in pgsql 7.4.8     Statement: SELECT pst.typ_stay, SUM(pst.nr_rooms), SUM(pst.nr_trans), SUM(pst.pst_amnt)

[GENERAL] Plans for 8.2?

2006-01-13 Thread H.J. Sanders
Hello. Just one request that would make the transition from another great database to PostgreSQL a lot easier: SET LOCK MODE TO WAIT n n = the max.time in second to wait. Please? My Christmas present?? For Christmas 2007 I like: statistics about how many sequential scans where have been for

[GENERAL] FW: deleted records

2005-12-28 Thread H.J. Sanders
Hi Folks. Couldn't find it in any mailing list so: is there a way to find out how many deleted records there are in a table (this gives an indication that it is time to vacuum)? Many thanks Henk Sanders ---(end of broadcast)--

[GENERAL] installation AIX - LINUX

2005-04-05 Thread H.J. Sanders
Hello. We have installed 7.4.7 on both AIX 4.3.3 and LiNUX SUSE 9. On AIX from source and on Linux from the rpm. Both went well but in comparing the installation we found that something is missing on AIX. On Linux we got .. include/pgsql/libpg server/libpq