Re: [ADMIN] Problem with ucred.h building 7.2.1

2002-05-26 Thread Niclas Gustafsson
> Niclas Gustafsson <[EMAIL PROTECTED]> writes: >> I'm having some trouble compiling 7.2.1 on one of our machines, >> It's a linux box running SuSE 6.0, with kernel version 2.2.14. >> ... >> After searching the system I see that I do not have the ucred

[ADMIN] Problem with ucred.h building 7.2.1

2002-05-26 Thread Niclas Gustafsson
nother dist. on the machine, as it is up and running a lot of services that is important to me. Regards, Niclas Gustafsson ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[ADMIN] Indices for both where and order by.

2002-05-17 Thread Niclas Gustafsson
he query up using an index scan, however the Sorting is taking some time. An idea was to create an Index on both tcode and timestamp, like this Create index hs_tcode_timestamp_idx on hs (tcode, timestamp) Am I completely wrong here, or could the planner not use it for both the where and th

Re: [ADMIN] PG_XLOG grows and grows

2002-05-15 Thread Niclas Gustafsson
If that is not possible, I'll just have to turn on the information as you mentioned below, and wait a month or two for it to occur again. Regards, Niclas Gustafsson -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Tom Lane Sent: den 15 maj 2002 1

Re: [ADMIN] PG_XLOG grows and grows

2002-05-15 Thread Niclas Gustafsson
Ok, I'm running 7.1.2 on the machine with the problem. I'll be upgrading later on, but for now, is there a way to see what the "idle in transaction" is waiting for? As this probably would help us solve some flaw in Our software? Regards, Niclas Gustafsson -Origin

[ADMIN] PG_XLOG grows and grows

2002-05-15 Thread Niclas Gustafsson
since the "idle in transaction" is waiting with an: VACUUM waiting. Is there any way of finding out exactly what the "idle in transaction" transactions have issued so far? What DB / logins etc. they are associated with? Regards, Niclas Gustafsson

Re: [ADMIN] to --enable-locale or not to --enable-locale?

2002-03-25 Thread Niclas Gustafsson
Sorry, I'm a bit overclocked today, the locale is ofcourse sv_SE... -Original Message- From: Oliver Elphick [mailto:[EMAIL PROTECTED]] Sent: den 25 mars 2002 13:57 To: Niclas Gustafsson Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] to --enable-locale or not to --enable-locale? O

Re: [ADMIN] to --enable-locale or not to --enable-locale?

2002-03-25 Thread Niclas Gustafsson
åa åb The å and ä are sorted in the wrong order. Where can I see the order of the charset? Regards, Niclas Gustafsson -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Niclas Gustafsson Sent: den 25 mars 2002 12:47 To: 'Oliver Elphick' Cc:

Re: [ADMIN] to --enable-locale or not to --enable-locale?

2002-03-25 Thread Niclas Gustafsson
Hi, I am sure that 1) is correct, allthough I think I've overlooked 2)! pg_controldata reports: (last 2 rows) LC_COLLATE: en_US LC_CTYPE: en_US Is it possible to change this after you've run initdb? Regards, Niclas

Re: [ADMIN] to --enable-locale or not to --enable-locale?

2002-03-25 Thread Niclas Gustafsson
get: aa aå aä åa äa ab åb äb aö ba bå bä bb bö za zö I want it sorted in abcd..zåäö What am I missing here? Any Ideas? Regards, Niclas Gustafsson -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jean-Michel POURE Sent: den 17 mars 2002 11:15 To: Peter