[BUGS] postmaster dies on EOF?

2000-10-18 Thread Denis A. Doroshenko
Hello, i really don't know if this is already known issue, unfortunatelly i was unable to find any relevant information on the web. The problem is very simple, and doesn not seem to be too important, i really amn't sure whether i should report it with the tool... one day i decided to switch pass

Re: [BUGS] Bugs in to_char function

2000-10-18 Thread Karel Zak
On Tue, 17 Oct 2000, Tom Rogers wrote: > I wanted to include the following in a select statement: > > to_char(departtime, 'HH12:MI PM') as xdepart Very old story and already fixed in the current CVS. Wait for great 7.1 :-) Karel PS. has this list so

Re: [BUGS] Bugs in to_char function

2000-10-18 Thread Karel Zak
On Tue, 17 Oct 2000, Tom Lane wrote: > "Tom Rogers" <[EMAIL PROTECTED]> writes: > > [to_char] gives the correct meridian value for all AM times but incorrectly > > returns an AM meridian for PM times between 12:00 PM and 1:50:59 PM. > > I believe this is a known bug in the 7.0 implementation of

Re: [BUGS] The Data Base System is in recovery mode

2000-10-18 Thread Palle Girgensohn
Hi! If needed, I'll try to provoke the error again, first recompiling with -g. I will probably not find time for it before the week-end, though. New facts: The problem "moved" when raising the -B from default (64) to 1000 (-N 100 now). Now, here's what happens: query: CREATE VIEW wtabmaria AS S

Re: [BUGS] The Data Base System is in recovery mode

2000-10-18 Thread Tom Lane
Palle Girgensohn <[EMAIL PROTECTED]> writes: > New facts: The problem "moved" when raising the -B from default (64) > to 1000 (-N 100 now). Now, here's what happens: Interesting. > query: CREATE VIEW wtabmaria AS SELECT >p.personid,p.foretag,p.fnamn,p.enamn,p.titel,p.telefon,p.mobil,p.email,p.

Re: [BUGS] postmaster dies on EOF?

2000-10-18 Thread Tom Lane
"Denis A. Doroshenko" <[EMAIL PROTECTED]> writes: > one day i decided to switch password authetntication in pg_hba.conf > for local tcp/unix connection as well, ran psql and saw 'Password:' for > the first time :-) But, when i pressed ^D in answer it showed many > lines with 'Password:' at the beg

Re: [BUGS] OID in WHERE clause of SELECT results in error

2000-10-18 Thread Lamar Owen
Ilya Goldberg wrote: > For some strange reason, using an OID in a WHERE clause no longer > works in 7.0.2. It did in 6.5.3 Here is an example psql session: > PostgreSQL 7.0.2 on powerpc-unknown-linux-gnu, compiled by gcc 2.95.2 > Installed via RPMs from your FTP site. Sounds like the optimiza

Re: [BUGS] The Data Base System is in recovery mode

2000-10-18 Thread Palle Girgensohn
Tom Lane <[EMAIL PROTECTED]> writes: > Palle Girgensohn <[EMAIL PROTECTED]> writes: > > New facts: The problem "moved" when raising the -B from default (64) > > to 1000 (-N 100 now). Now, here's what happens: > > Interesting. I am also using -o -S 2048 now, but I doubt it helps... > > query: C

Re: [BUGS] The Data Base System is in recovery mode

2000-10-18 Thread Tom Lane
Palle Girgensohn <[EMAIL PROTECTED]> writes: > Oh, gee. sorry! I slipped with the mouse when cut'n'pasting. The first > statement should be a create view. The view is dropped and created > "on-the-fly" with different where-clauses every time, depending on the > user's search arguments. As I might

AW: [BUGS] UPPER and LOWER dosen't work correctly on special caracters (umlauts)

2000-10-18 Thread Ronald Kuczek
You need to enable locale support (see documentation). Best regards Rony > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im > Auftrag von [EMAIL PROTECTED] > Gesendet: 17 paŸdziernika 2000 21:58 > An: [EMAIL PROTECTED] > Betreff: [BUGS] UPPER and LOWER dosen

Re: [BUGS] The Data Base System is in recovery mode

2000-10-18 Thread Palle Girgensohn
Tom Lane <[EMAIL PROTECTED]> writes: > Palle Girgensohn <[EMAIL PROTECTED]> writes: > Oh, gee. sorry! I slipped with the mouse when cut'n'pasting. The > first > statement should be a create view. The view is dropped and > created > "on-the-fly" with different where-clauses every time, > dependin