Re: [BUGS] BUG #1266: Improper unique constraint / MVCC

2004-09-24 Thread Stephan Szabo
On Fri, 24 Sep 2004, Alexey Fedorchenko wrote: > Stephan! > > > This is a known issue with the unique constraint. > > Ok. Do you know any plans on this issue fix? > > > > --case 2 prepare > > > --case 3 prepare > > > > I seem to get foreign key violations on both of these on both 7.4.x and > > 8.

Re: [BUGS] VIEWS

2004-09-24 Thread Stephan Szabo
On Wed, 22 Sep 2004, Markus Feier wrote: > Dear Sirs > > I encountered a minor Postgres problem using VIEW: > > Creating a View like > CREATE VIEW SELECT * FROM table1 > works perfecly > > As soon as we enlarge table1 by new Attributes, they will not show up in the > VIEV > The VIEW will need to

Re: [BUGS] BUG #1268: Two different Unicode chars are treated as

2004-09-24 Thread Kent Tong
Tom Lane wrote: Yes it does, and you missed the point. I said *locale*, not *encoding*. The LC_COLLATE and LC_CTYPE settings that prevail during initdb are fixed and not alterable without re-initdb. (I agree that this sucks, but that's how it is for now...) You're right. After using: initdb --l

Re: [BUGS] Failed install postgresql-8.0-beta2-dev3.msi

2004-09-24 Thread Magnus Hagander
> I attempted to install from postgresql-8.0-beta2-dev3.msi, got to the end, and it failed with a message: >Failed to create process for initdb: 1385. I am a local administrator and I used a custom service account and a >custom su account. This is aknown issue with the installer - the cre