Re: [BUGS] Multibyte char encoding atttypmod weirdness

2003-02-25 Thread Huaxin WANG
Sorry but I made a mistake in describing the problem. PQfmod(...) returns 20 + 4, but strlen(PQgetvalue(...)) returns something varying, more than 24. Since you said atttypmod is char len + 4, "The actual physical length in bytes of a column entry might be more", it's dependant to the current loc

Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-02-25 Thread Oliver Elphick
On Tue, 2003-02-25 at 22:08, Tim Ellis wrote: > On Mon, 2003-02-24 at 23:03, Oliver Elphick wrote: > > different for different countries. There was a discussion of this on > > the patches list recently > > (http://archives.postgresql.org/pgsql-patches/2003-02/msg00038.php and > > the surrounding t

Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-02-25 Thread Oliver Elphick
On Mon, 2003-02-24 at 22:59, Robert Treat wrote: > [EMAIL PROTECTED] rms_db]$ cal 9 1752 >September 1752 > Su Mo Tu We Th Fr Sa >1 2 14 15 16 > 17 18 19 20 21 22 23 > 24 25 26 27 28 29 30 > > I guess adding 1 day to 1752-09-02 should give us 1752-09-14, but your > right, it gives us

Re: [BUGS] Bug #903: Performance Hangs during Lookups

2003-02-25 Thread Tom Lane
[EMAIL PROTECTED] writes: > We have a postgres backend to our Mail Server product, and encountering > performance issues. Simple selects are taking 7-10 seconds.. strace is not a particularly useful level of analysis for Postgres performance problems. I'd suggest looking at your database schem