[BUGS] Strange behavior

2004-09-23 Thread Jed Nicolau Filho
Hi there   I was testing Postgre 8.0 beta2 dev3 with pgAdmin III and I found a strange behavior with Blob:   For this table: CREATE TABLE lo_test (  id serial NOT NULL,  image lo ) WITH OIDS;   When I try insert a record only with "id" value wihout image raise this error message:   "ERROR: I

[BUGS] Beta 2 build failure using Cygwin/XP

2004-09-23 Thread Reto Stamm
Hi, I tried to build Postgres on XP - and got the following message after standard configure and make: > ./configure > ./make ... make[2]: Leaving directory `/cygdrive/c/postgresql-8.0.0beta2/src/port' make -C timezone all make[2]: Entering directory `/cygdrive/c/postgresql-8.0.0beta2/src/timezon

[BUGS] CREATE DATABASE OWNER not propagating to child objects?

2004-09-23 Thread Sean Chittenden
Howdy. I think this problem is best demonstrated with a test case: template1=# CREATE DATABASE foo OWNER someuser; CREATE DATABASE template1=# \c foo You are now connected to database "foo". foo=# \dn List of schemas Name| Owner +--- information_schem

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

2004-09-23 Thread Monte Hansen
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.   I then fired up my dev environment and wrote some c

[BUGS] VIEWS

2004-09-23 Thread Markus Feier
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 be deleted and recreated. This behaviuor may not be considere

[BUGS] Regression test geometry.out may have wrong value.

2004-09-23 Thread John Kelly
Folks, I built and ran the Postgres 8.0.0 beta 2 on MacOS 10.3.5 and got a strange failure on the geometry tests. It appears as if the result (-0,0) is expected (expected/geometry.out), which does not make much sense, the actual value was (0,0) as expected. The actual regression.diff is attach

[BUGS] Bug Report PostGreSQL win32

2004-09-23 Thread M.Leondaris
Obviously there is a problem with the Potsgre Binary and Zend Optimizer working with PHP!   When uncommenting Zend Extensions in php.ini Postgre causes a child-process error and tries to restart Apache.   Enviroment:   W2K Sp 4   Apache 2.0.50 (service) PHP 5.01 MySQL (service) PostgreSQL (se

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

2004-09-23 Thread Tom Lane
Kent Tong <[EMAIL PROTECTED]> writes: > Does it matter? The encoding provided to initdb is just > a default for the databases to be created in the future. 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 fi

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

2004-09-23 Thread Kent Tong
Tom Lane wrote: "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: Description:Two different Unicode chars are treated as equal in a query This would be a matter to take up with the maintainer of your locale (which you didn't mention, but in any case it's a locale bug). We just do what

Re: [BUGS] BUG #1268: Two different Unicode chars are treated as equal in a query

2004-09-23 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > Description:Two different Unicode chars are treated as equal in a > query This would be a matter to take up with the maintainer of your locale (which you didn't mention, but in any case it's a locale bug). We just do what strcoll() te

[BUGS] BUG #1268: Two different Unicode chars are treated as equal in a query

2004-09-23 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1268 Logged by: Kent Tong Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.5 Operating system: RedHat 9 Description:Two different Unicode chars are treated as equal in a query Details: Steps: 1.

Re: [BUGS] Permissions problem with sequences

2004-09-23 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > There is, however, an ownership problem with restoring sequences > in 8.0.0beta. In 7.4.5, for example, pg_dump issues a SET SESSION > AUTHORIZATION command and then creates a table, so implicitly-created > sequences are restored with the corre

Re: [BUGS] BUG #1267: Suggest TEXTOID parameters be treated like UNKNOWNOID

2004-09-23 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > - if (inputTypeId == UNKNOWNOID && IsA(node, Const)) > + if ( ( ( ( inputTypeId == UNKNOWNOID) || (inputTypeId == TEXTOID ) ) > && IsA(node, Const))&& IsA(node, Const) ) No thank you. Fix your broken client code, rather than screw

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

2004-09-23 Thread Stephan Szabo
On Thu, 23 Sep 2004, PostgreSQL Bugs List wrote: > /* */ > --case 1 prepare > delete from buggy_uq; > insert into buggy_uq values (1); > insert into buggy_uq values (2); > --case 1 test > update buggy_uq set i = i + 1; > select * from buggy_uq; > --expect - SUCCESS > --result - ERROR: du

[BUGS] BUG #1267: Suggest TEXTOID parameters be treated like UNKNOWNOID

2004-09-23 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1267 Logged by: Colin Chapman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: fedora linux Description:Suggest TEXTOID parameters be treated like UNKNOWNOID Details: postgr

[BUGS] BUG #1266: Improper unique constraint / MVCC activities within single transaction

2004-09-23 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1266 Logged by: Aleksey Fedorchenko Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: MS Windows 2003 Description:Improper unique constraint / MVCC activities within single tra