[BUGS] Optimizer problem with multi-column index

2013-04-29 Thread Marc Schablewski
Hello, we have an issue concerning multi-column indexes not being used by the planner. version Postgr

Re: [BUGS] BUG #4565: nextval not updated during wal replication, leading to pk violations

2008-12-10 Thread Marc Schablewski
Tom Lane wrote: > Marc Schablewski <[EMAIL PROTECTED]> writes: > >> cache_value is set to one for all sequences. As far as I can tell, they >> were all created by a plain CREATE SEQUENCE seq_name and no other >> settings changed. And as we found out later this &qu

Re: [BUGS] BUG #4565: nextval not updated during wal replication, leading to pk violations

2008-12-09 Thread Marc Schablewski
Tom Lane wrote: > "Marc Schablewski" <[EMAIL PROTECTED]> writes: > >> A job tried to insert some records into a few tables and complained about a >> PK violation. PK are of type bigint. The column is populated by a sequence >> and a "default n

Re: [BUGS] BUG #4565: nextval not updated during wal replication, leading to pk violations

2008-12-08 Thread Marc Schablewski
rdered list ("steps"), but I had to read it several times to get it. I think, a better place would be right after the list. ...But then, maybe it's just me, not sleeping well last night. ;) Marc Marc Schablewski wrote: > The following bug has been logged online: > > Bug refe

[BUGS] BUG #4565: nextval not updated during wal replication, leading to pk violations

2008-12-05 Thread Marc Schablewski
The following bug has been logged online: Bug reference: 4565 Logged by: Marc Schablewski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.5 Operating system: Debian, 2.6.24-19 kernel Description:nextval not updated during wal replication, leading to pk

Re: [BUGS] could not read block 77 of relation 1663/16385/388818775

2008-11-27 Thread Marc Schablewski
necessary patches? Thanks in advance Thomas Goerner Marc Schablewski John R Pierce wrote: > Gregory Stark wrote: >> John R Pierce <[EMAIL PROTECTED]> writes: >> >> >>> oracle has had an option for some time that uses read/only page >>> protectio

Re: [BUGS] BUG #4447: install failed to start; libintl3.dll was not found

2008-11-24 Thread Marc Schablewski
thout issue. >> However, the same issue was observed when attempting to install v8.3.3 >> > > Strange. You are using the MSI installer from our ftp site? Or are you > using the binaries-no-installer? > > Also, please verify using "depends.exe" that all t

Re: [BUGS] BUG #3787: configure: error: readline library not found

2007-11-29 Thread Marc Schablewski
--- > TIP 4: Have you searched our list archives? > >http://archives.postgresql.org > > > -- Marc Schablewski click:ware Informationstechnik GmbH ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-10-04 Thread Marc Schablewski
e question is: would an error like the one we had appear in WAL and would it be replicated too? Or is there some kind of consistency check, that prevents broken WAL from being restored? Marc Schablewski click:ware Informationstechnik GmbH Decibel! wrote: > On Jul 25, 2007, at 4:02 PM, Marc Sc

Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-07-31 Thread Marc Schablewski
ow you're > using the database, and the hardware certainly seems pretty > common-place, so I'm rather doubtful that it's software. But if you > still have copies of the bad database, someone might be able to help you. -- Marc Schablewski click:ware Informationstech

[BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-07-25 Thread Marc Schablewski
The following bug has been logged online: Bug reference: 3484 Logged by: Marc Schablewski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: SuSE Linux 10.0 / Kernel 2.6.13-15.8-smp (x86-64) Description:Missing pg_clog file / corrupt index