Hello,
we have an issue concerning multi-column indexes not being used by the planner.
version
Postgr
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
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
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
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
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
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
---
> 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
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
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
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
11 matches
Mail list logo