Re: [BUGS] Bug #527: server hangs up and refuses any connection

2001-11-30 Thread Tom Lane
[EMAIL PROTECTED] writes: > "sdec kernel table full" and the server hang up Sounds to me like you're running out of kernel file-table slots or some such. Please read the Postgres documentation on configuring kernel resources. regards, tom lane --

[BUGS] Bug #527: server hangs up and refuses any connection

2001-11-30 Thread pgsql-bugs
Alla El Gohary ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description server hangs up and refuses any connection Long Description dear pgsql-bugs i'm running postgresql 7.1.2 on freebsd4.3 my application consists of several component

Re: [BUGS] Bug #526: Three levels deeply nested SELECT goes wrong

2001-11-30 Thread Tom Lane
[EMAIL PROTECTED] writes: > A 3 levels deeply nested SELECT with "R(a)" in the top-most FROM part > and "R.a=S.a AND XXX" in the middle WHERE part may give different > results if in a SELECT within XXX the term "S.a" is replaced by "R.a". > Version: PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled

Re: [BUGS] Vá: Va: [BUGS] Va: [BUGS] Bug #

2001-11-30 Thread Stephan Szabo
On Fri, 30 Nov 2001 [EMAIL PROTECTED] wrote: > > > So, it is still a mystery for me > > You probably need the locale for sorting the single character letters > > but you don't want the collation values of the multiple character ones. > > I think you're probably going to need to get an alterna

Re: [BUGS] Bug #526: Three levels deeply nested SELECT goes wrong

2001-11-30 Thread Tom Lane
[EMAIL PROTECTED] writes: > Three levels deeply nested SELECT goes wrong Seems to still behave the same in current sources :-( Thanks for the report! regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our

Re: [BUGS] Vá: Va: [BUGS] Va: [BUGS] Bug #519: Bug in order b y clausule

2001-11-30 Thread Tom Lane
[EMAIL PROTECTED] writes: > All Hungarian -and other non standard ANSI- users should expect > "order by problems" due the locale settings.? As far as I can see, this is *not* a Postgres bug. If you don't like the sort order specified by your locale file, you need to choose another lo

[BUGS] Bug #526: Three levels deeply nested SELECT goes wrong

2001-11-30 Thread pgsql-bugs
Maarten Fokkinga ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Three levels deeply nested SELECT goes wrong Long Description A 3 levels deeply nested SELECT with "R(a)" in the top-most FROM part and "R.a=S.a AND XXX" in the