[BUGS] BUG #1438: Non UTF-8 client encoding problem

2005-01-23 Thread Estagus
The following bug has been logged online: Bug reference: 1438 Logged by: Estagus Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Debian SID Description:Non UTF-8 client encoding problem Details: Hi... I use postgresql 7.4.6 on Debian woo

Re: [BUGS] BUG #1437: converting column from text to int4 requires USING

2005-01-23 Thread Kim Hansen
> From: "Kim Hansen" <[EMAIL PROTECTED]> > To: pgsql-bugs@postgresql.org > Date: Mon, 24 Jan 2005 00:41:10 GMT > Subject: BUG #1437: converting column from text to int4 requires USING > > The following bug has been logged online: > > Bug reference: 1437 > Logged by: Kim Hansen > Ema

[BUGS] 8.0.0 on disk fails regress test, but on ram disk it is fine...

2005-01-23 Thread Jeff Ross
I'm preparing to upgrade our PostgreSQL installation from 7.3.5 to 8.0.0. I downloaded, configured, compiled, and did gmake check and much to my surprise, 26 of the 96 tests failed. Examination of regression.diffs shows that 1 of the failures is random (and it is ignored) but 23 of the 26 erro

[BUGS] BUG #1437: converting column from text to int4 requires USING

2005-01-23 Thread Kim Hansen
The following bug has been logged online: Bug reference: 1437 Logged by: Kim Hansen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: Windows Description:converting column from text to int4 requires USING Details: When running the input be

[BUGS] BUG #1436: not null condition is not respected

2005-01-23 Thread Florin Borsa
The following bug has been logged online: Bug reference: 1436 Logged by: Florin Borsa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Description:not null condition is not respected Details: I ceate a table with some integer fi

[BUGS] BUG #1433: domain check constraint not checked when adding new column

2005-01-23 Thread craig perras
The following bug has been logged online: Bug reference: 1433 Logged by: craig perras Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 release Operating system: win2000 Description:domain check constraint not checked when adding new column Details: Domain ch

[BUGS] 8.0.0 gmake check fails if on disk, passes on ram disk....

2005-01-23 Thread Jeff Ross
Hi, If I put the source for 8.0.0 on disk (RAID 1) , configure, compile and run gmake check, it fails with 33 errors, 30 of which are ! psql: could not send startup packet: Broken pipe If I put the same source code up on a ram disk, configure and compile it the same way, all 96 tests pass. OS i

Re: [BUGS] Privilege escalation via LOAD

2005-01-23 Thread David Litchfield
John, _init() is the equivalent of DllMain on Linux/etc; in fact the other database server I was looking at is vulnerable to this exact problem. If postgresql accepts CLOB/BLOB input from a client to a table and then can dump to disk you might be able to achieve it that way - which is how I did

[BUGS] BUG #1435: Optimizer not using index on large tables when inner joining two views

2005-01-23 Thread Yary Hluchan
The following bug has been logged online: Bug reference: 1435 Logged by: Yary Hluchan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: OpenBSD 3.6 Description:Optimizer not using index on large tables when inner joining two views Details:

[BUGS] BUG #1430: CSRSS.EXE high CPU after 8.0 Installed

2005-01-23 Thread Rick Walrond
The following bug has been logged online: Bug reference: 1430 Logged by: Rick Walrond Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Description:CSRSS.EXE high CPU after 8.0 Installed Details: I have installed v8.0 on 2 compute

[BUGS] Privilege escalation via LOAD

2005-01-23 Thread John Heasman
Hi guys, It appears that low privileged users can invoke the LOAD extension to load arbitrary libraries into the postgres process space. On Windows systems this is achieved by calling LoadLibrary (src/backend/port/dynloader/win32.c). The effect of this is that DllMain will be executed. Since

Re: [BUGS] Problem with driver ODBC / VB

2005-01-23 Thread Hendrik Müller
Kalitech schrieb: Hello, These tests are done with the 2 versions of the driver 7.3 Table User description : u_num int4 nextval( …), u_comm varchar(512) In my table I have one row : u_num 1 u_comm ‘hello world all is fine.’ Imagine I want

[BUGS] BUG #1429: stats tests fails

2005-01-23 Thread Hendrik Mueller
The following bug has been logged online: Bug reference: 1429 Logged by: Hendrik Mueller Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0.0 Operating system: Windows 2000 SP4 Description:stats tests fails Details: The stats-test execute after make (with ma

[BUGS] BUG #1432: type "cube" does not exist

2005-01-23 Thread Sam Hahn
The following bug has been logged online: Bug reference: 1432 Logged by: Sam Hahn Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Pro v2002 SP 2 Description:type "cube" does not exist Details: When installing with various contri

[BUGS] BUG #1434: ERROR: type "bigserial" does not exist

2005-01-23 Thread Brad Snobar
The following bug has been logged online: Bug reference: 1434 Logged by: Brad Snobar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Linux Description:ERROR: type "bigserial" does not exist Details: The column was a primary key bigint. AL

[BUGS] BUG #1428: SHGetSpecialFolderPath not found in SHELL32.dll

2005-01-23 Thread Hendrik Mueller
The following bug has been logged online: Bug reference: 1428 Logged by: Hendrik Mueller Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0.0 Operating system: Windows NT 4.0 + SP4 Description:SHGetSpecialFolderPath not found in SHELL32.dll Details: On some

Re: [BUGS] shared_buffers vs. -B flag: 7.4

2005-01-23 Thread Tom Lane
[EMAIL PROTECTED] (elein) writes: > Hmmm. This was reproduced at a customer site by > a very meticulous dba. I'll check back with him. It would be worth enquiring exactly what values he was testing. IIRC, 7.4 doesn't have any defense against setting NBuffers so large as to make the shmem segmen

Re: [BUGS] shared_buffers vs. -B flag: 7.4

2005-01-23 Thread elein
Hmmm. This was reproduced at a customer site by a very meticulous dba. I'll check back with him. But I'm glad to know it is not an on-going problem. thanks for your quick response --elein On Sun, Jan 23, 2005 at 02:15:07PM -0500, Tom Lane wrote: > [EMAIL PROTECTED] (elein) writes: > > However

Re: [BUGS] shared_buffers vs. -B flag: 7.4

2005-01-23 Thread Tom Lane
[EMAIL PROTECTED] (elein) writes: > However, if you use the -B option on the pg_ctl > start up, postgres starts up fine. And > the shared_buffers value shown by show > is the higher value. It behaves as expected for me, in both 7.4 and CVS tip. Are you sure your test case wasn't such that the hi

[BUGS] shared_buffers vs. -B flag: 7.4

2005-01-23 Thread elein
This was reproduced on 7.4. I don't know if it is still an issue on 8.0. If you set shared_buffers (shmem_max) to greater than the shmem config on the OS pg will not start. And gives a useful message (below). However, if you use the -B option on the pg_ctl start up, postgres starts up fine. And

Re: [BUGS] inconsitent tab completion in psql

2005-01-23 Thread Alvaro Herrera
On Sun, Jan 23, 2005 at 11:01:14AM -0500, Bruce Momjian wrote: > The reason this happens is because both ALTER OPERATOR and ALTER > OPERATOR CLASS are supported so for the third word you would have to do > tab complete only when the C-L-A-S-S is unique. I suppose you could say > as soon as they t

Re: [BUGS] inconsitent tab completion in psql

2005-01-23 Thread Bruce Momjian
Robert Treat wrote: > Disclaimer that this was found under RC1 so it might have been fixed in final > release, though I don't recall it being reported, anyway, the problem is that > tab completion does not seem to work for "\h alter operator class". > > template1=# \h ALTER > AGGREGATE DOM

[BUGS] inconsitent tab completion in psql

2005-01-23 Thread Robert Treat
Disclaimer that this was found under RC1 so it might have been fixed in final release, though I don't recall it being reported, anyway, the problem is that tab completion does not seem to work for "\h alter operator class". template1=# \h ALTER AGGREGATE DOMAIN INDEX SCHEMA