Re: [BUGS] BUG #1348: Wishlist: \pset expanded with value

2004-12-18 Thread Bruce Momjian
I see your problem. Added to TODO: * Allow psql \pset boolean variables to set to fixed values, rather than toggle --- PostgreSQL Bugs List wrote: > > The following bug has been logged online: > > Bug reference:

Re: [BUGS] Checkpoints occur too frequently

2004-12-18 Thread Simon Riggs
On Fri, 2004-12-17 at 00:12, Tom Lane wrote: > Tom Lane <[EMAIL PROTECTED]> writes: > > Simon Riggs <[EMAIL PROTECTED]> writes: > >> I'd say no code changes for 8.0, now we know what's causing it. A doc > >> patch to show the limit is probably just going to annoy the translators > >> at this stage

Re: [BUGS] Postgresql 8.0 RC1 not using indexes

2004-12-18 Thread Tom Lane
Tony Caduto <[EMAIL PROTECTED]> writes: > I just installed 8.0 RC1 and then restored my database which was working > perfectly on 7.4.5. > I have a function that imports rows from a comma seperated file and on > 7.4.5 using this same function I could get around 1000 rows every 2.5 > seconds, now

Re: [BUGS] posgresql 8.0 RC1 missing schemas

2004-12-18 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Sat, Dec 18, 2004 at 10:34:31AM +0100, Zsolt Pfiszter wrote: >>> I tried to initdb again, but problem isn't ok. > What happens if you initdb in the C locale? We're wondering if the > Hungarian stuff is causing a problem. Also, would you send me (off-

Re: [BUGS] Problem with Upper/Lower Function

2004-12-18 Thread Roland Volkmann
Hello, Hesse, Hendrik schrieb am 16.12.2004 16:41: I fond a problem at the RC1 of PostgreSQL (W32 - Version) When you use the UPPER or LOWER function with German letters (ä,ö,ü) this letters stay in lower/upper case. You can reproduce this error with this simple examples: select upper('ü'); select

Re: [BUGS] solaris 10 with gcc 3.3.2

2004-12-18 Thread Mike Mascari
Mike Mascari wrote: Tom Lane wrote: I wrote: This is standard practice for gcc: it tries to use "cleaned up" versions of system headers that will not elicit useless warnings from gcc. It's a good idea, actually, because the degree of insanity in vendor-supplied system headers is pretty depres

Re: [BUGS] solaris 10 with gcc 3.3.2

2004-12-18 Thread Mike Mascari
Tom Lane wrote: I wrote: This is standard practice for gcc: it tries to use "cleaned up" versions of system headers that will not elicit useless warnings from gcc. It's a good idea, actually, because the degree of insanity in vendor-supplied system headers is pretty depressing. But if the gcc

Re: [BUGS] posgresql 8.0 RC1 missing schemas

2004-12-18 Thread Michael Fuhr
On Sat, Dec 18, 2004 at 10:34:31AM +0100, Zsolt Pfiszter wrote: > > I tried to initdb again, but problem isn't ok. > > our enviroment settings: > > postgres# locale > LANG=hungarian > LC_CTYPE="hungarian" > LC_NUMERIC="hungarian" > LC_TIME="hungarian" > LC_COLLATE=POSIX > LC_MONETARY="hungarian"

Re: [BUGS] posgresql 8.0 RC1 missing schemas

2004-12-18 Thread Zsolt Pfiszter
Dear Tom, and Michael! Thanks in advance your help! I tried to initdb again, but problem isn't ok. our enviroment settings: postgres# locale LANG=hungarian LC_CTYPE="hungarian" LC_NUMERIC="hungarian" LC_TIME="hungarian" LC_COLLATE=POSIX LC_MONETARY="hungarian" LC_MESSAGES="hungarian" LC_AL