Re: [GENERAL] libpq++

2001-01-15 Thread Bruce Momjian
Can you try 7.0.X or 7.1 beta and let us know if it is still a problem? [ Charset ISO-8859-1 unsupported, converting... ] > I have a problem with postgres freeing resouces. > > Consider the following routine. > > int foo() > { >PgDatabase *pDatabase = new PgDatabase(cpDBName); > > >

[GENERAL] Re: converting .xls to delimited file

2001-01-15 Thread rob
search freshmeat.net there is a tool called something like xls2xml that was derived from the star office package. I haven't tried it, but looks very good. --rob - Original Message - From: "Martin Lillepuu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 10, 2001 5

[GENERAL] Re: How to match percent sybmol in LIKE operator?

2001-01-15 Thread Holger Klawitter
Sergey Filatov wrote: > > Greetings. > > My problem is to find percent character in some field. > I'm wonder how specify percent character or other wildcard characters > in 'LIKE patterns'? > > Many thanks in advance, > Sergey. You have escape them with the backslash. In order to pass the back

[GENERAL] How to match percent sybmol in LIKE operator?

2001-01-15 Thread Sergey Filatov
Greetings. My problem is to find percent character in some field. I'm wonder how specify percent character or other wildcard characters in 'LIKE patterns'? Many thanks in advance, Sergey.

[GENERAL] libpq++

2001-01-15 Thread Belcher, Jim
I have a problem with postgres freeing resouces. Consider the following routine. int foo() { PgDatabase *pDatabase = new PgDatabase(cpDBName); // Use the connection, insert a record etc. delete pDatabase; } The delete call does not cause system resources to be freed, such as

[GENERAL] Re: to_char WW

2001-01-15 Thread Karel Zak
On Sun, 14 Jan 2001, gravity wrote: > Karl, > > you implemented to_char if I'm not mistaken. > > May I ask how you got to the algorithm for WW (weeknumber of the year) and why? > > eg: > znc=# select to_char(now(),'DD-MM- HH24:MI "week" WW'); > to_char > ---

RE: [GENERAL] Re: 'Tuple is too big' Error

2001-01-15 Thread Michael Ansley
Title: RE: [GENERAL] Re: 'Tuple is too big' Error You can set the BLOCKSZ parameter up to a max of 32kB.  This will increase the row length to 32kB (a bit shorter because of some admin overhead, but close enough).  In the medium-term, upgrade to 7.1 as this limit has been removed. MikeA ---

Re: [GENERAL] exporting table to txt

2001-01-15 Thread Poul L. Christiansen
Use the pg_dump utility. pg_dump -t MyTable MyDatabase>MyFile.sql See also "man pg_dump". Poul L. Christiansen Marcos wrote: > hi, > > i would like to make some changes in the configuration of the fields > from a table so my first doubt is concerning to keep the info safe. how > can i ex

[GENERAL] exporting table to txt

2001-01-15 Thread Marcos
hi, i would like to make some changes in the configuration of the fields from a table so my first doubt is concerning to keep the info safe. how can i export data from my table into a text file separated with tabs? thanks in advance, marcos -- m a r c o s @ i v a l . e s

[GENERAL] Universal B-trees...

2001-01-15 Thread Joerg Hessdoerfer
Hi! I just came across an interesting article in a german PC-Mag, covering use of universal B-trees for indexing multi-index databases. Looks VERY promising, indeed. I dunno if that could be implemented in postgreSQL, or is of any interest at all, but here's an URL for anyone ineterested: http

[GENERAL] Re: getting number of rows updated within a procedure

2001-01-15 Thread Dan Langille
On 15 Jan 2001, at 8:44, J.H.M. Dassen (Ray) wrote: > On Sun, Jan 14, 2001 at 23:27:06 +1300, Dan Langille wrote: > > I'm writing some stuff in PL/pgsql (actually, a lot of stuff). I have a > > question: At various times, it does UPDATEs. Is there a way to tell if > > the UPDATE actually affect