[BUGS] The Data Base System is in recovery mode

Hi! I have a problem with postgresl-7.0.2 on Freebsd 4-stable. Somehow, shared memory gets corrupted by a certain type of query, and all databases end up unusable until I kill -9 the bad postgres process and stop+restart postgres. I mistakenly ran postgres without -N and -B flags, and I guess

[BUGS] SELECTs return error with oid in WHERE clause

Ilya Goldberg ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description SELECTs return error with oid in WHERE clause Long Description Create a table (FOO) insert a row, do a SELECT oid from FOO. Now do a SELECT FROM FOO WHERE OID=[wha

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

Palle Girgensohn <[EMAIL PROTECTED]> writes: > I have a problem with postgresl-7.0.2 on Freebsd 4-stable. > query: declare curse cursor for select >personid,foretag,fnamn,enamn,titel,telefon,mobil,email,tidpunkt, lower(foretag) from >wtabmaria order by lower(foretag) > query: fetch forward 20 f

Re: [BUGS] SELECTs return error with oid in WHERE clause

[EMAIL PROTECTED] writes: > ERROR: getattproperties: no attribute tuple 29194 -2 > PostgreSQL 7.0.2 on powerpc-unknown-linux-gnu, compiled by gcc 2.95.2 Current releases don't really work at all on PPC unless compiled -O0. This is fixed for 7.1, but for now you gotta build that way. Someone see

Re: [BUGS] JDBC & XML-DBMS

On Mon, 16 Oct 2000, Alexander Yurov wrote: > 1. JDBC Driver returns empty separator in the database catalog. In the source I have the following comment: // PM Sep 29 97 - changed from "." as we don't support catalogs. So back in 1997 I removed the "." > 2. Why JDBC Driver returns column (proc

Re: [BUGS] SELECTs return error with oid in WHERE clause

I said: > Someone seems to have stuck -O2 into the linux_ppc template since > 7.0 release, which was a bad move. I'll fix the template for 7.0.3. No, I was misreading the CVS logs: the template in the REL7_0 branch does indeed say -O0. So AFAIK it should work, if the programs were built without

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

Gert (Pache) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description UPPER and LOWER dosen't work correctly on special caracters (umlauts) Long Description The Upper- and the lower function don't convert the german umlauts (ü.ä.ö.) but leave them in thei

[BUGS] Field Separator setting not used.

Kevin Colagio ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Field Separator setting not used. Long Description (This is major because I have about 20 scripts that I would have to modify to get this to work...and I don't thi

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

On Tue, 17 Oct 2000 [EMAIL PROTECTED] wrote: > Gert (Pache) reports a bug with a severity of 3 > The lower the number the more severe it is. > > Short Description > UPPER and LOWER dosen't work correctly on special caracters (umlauts) > > Long Description > The Upper- and the lower function don

Re: [BUGS] Field Separator setting not used.

[EMAIL PROTECTED] writes: > psql -t -q -d servicedesk -F '###' -c "select * from users" > > The output should be along the lines of: > > abc123###Kevin###Colagio###820###209###x56469 > > Which is then parsed by a perl program...but instead, it comes up as: > > abc123 | Kevin | Colagio | 820 |

[BUGS] Bugs in to_char function

I wanted to include the following in a select statement: to_char(departtime, 'HH12:MI PM') as xdepart This 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. If I create the formatted Hours using 'HH24', the dis

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

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: ome=# create table foo (bar integer); CREATE ome=# insert into foo values (123); INSERT 29225 1 ome=# select bar from foo where oid=29225; ERROR: getattproperties

Re: [BUGS] Bugs in to_char function

"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 to_char, and is long since fixed in development