[BUGS] BUG #5317: no puedo instalarlo

2010-02-06 Thread Marc
The following bug has been logged online: Bug reference: 5317 Logged by: Marc Email address: rasck...@gmail.com PostgreSQL version: 8.4.2-1 Operating system: windows xp Description:no puedo instalarlo Details: No me deja instalar el programa ya que me pide una

[BUGS] BUG #6350: Delete a role which is still in use

2011-12-21 Thread marc
The following bug has been logged on the website: Bug reference: 6350 Logged by: Marc Balmer Email address: m...@msys.ch PostgreSQL version: 9.1.1 Operating system: NetBSD Description: A role can be deleted although it is still referenced in a column privilege. Here

[BUGS] BUG #8144: Problem with rank window function and CTEs

2013-05-09 Thread marc
The following bug has been logged on the website: Bug reference: 8144 Logged by: Marc Munro Email address: m...@bloodnok.com PostgreSQL version: 9.2.4 Operating system: Linux 3.6.3 (debian wheezy) Description: I have a query in which I want to use the result of a

[BUGS] BUG #8153: check constraint results in a lot of casts

2013-05-13 Thread marc
The following bug has been logged on the website: Bug reference: 8153 Logged by: Marc Mamin Email address: m...@intershop.de PostgreSQL version: 9.2.4 Operating system: Linux & windows Description: hello, This is not a functional bugs, but it appers (at least fo

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

2008-11-24 Thread Marc Schablewski
nvolved or it's a broken w2k3 installation. But we couldn't investigate any further. We used the MSI-Package for installation. As a workaround we installed postgres without running initdb and initialized the database manually. Marc Magnus Hagander wrote: > Jen McCann wrote: > >

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

[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] 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

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-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

[BUGS] perl5 interface won't compile

2000-03-25 Thread Marc Lehmann
POSTGRESQL BUG REPORT TEMPLATE Your name : Marc Lehmann Your email address : [EMAIL

[BUGS] initdb won't run due to syntax errors

2000-03-25 Thread Marc Lehmann
POSTGRESQL BUG REPORT TEMPLATE Your name : Marc Lehmann Your email address : [EMAIL

Re: [BUGS] perl5 interface won't compile

2000-04-01 Thread Marc Lehmann
c [etc] It will tell you about most things that need to be fixed. -- -==- | ==-- _ | ---==---(_)__ __ __ Marc Lehmann +-- --==---/ / _ \/ // /\ \/ / [EMAI

[BUGS] postmaster quits

2001-08-29 Thread Marc Prewitt
this form. POSTGRESQL BUG REPORT TEMPLATE Your name : Marc Prewitt Your email address : [EMAIL PROTECTED] System Con

[BUGS] array_dims function is poorly behaved

2002-02-01 Thread Marc Lavergne
. Cheers, Marc L. -- 01010101010101010101010101010101010101010101010101 Marc P. Lavergne [wk:407-648-6996] Product Development richLAVA Corporation -- "Anyone who slaps a 'this page is best viewed with Browser X' label on a Web page appears to be yearning for the bad old days,

[BUGS] BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver java.sql.SQLException: ERROR: oidin: error in "\377\330\377\340...I'm on Linux 2.4.16 using JDK 1.4.0 but it fails in 1.3.1 as well. Here's a quick reproducible test case:-- start --package sample.java.jdbc;import java.sql.*;import java.io.*;import java.util.*;class testBlob{ public static void main(String args[]) { new testBlob(); System.exit(0); } public testBlob() { System.out.println("Let's begin the test ..."); String v_username = "postgre"; String v_password = "postgre"; String v_database = "jdbc:postgresql://127.0.0.1/TEST"; PreparedStatement v_pstmt = null; try { DriverManager.registerDriver(new org.postgresql.Driver()); Connection v_conn = DriverManager.getConnection( v_database, v_username, v_password); v_conn.setAutoCommit(false); File v_file = new File("/home/postgre/something.jpg"); FileInputStream v_fis = new FileInputStream(v_file); v_pstmt = v_conn.prepareStatement( "insert into lob_test (id,data) values (?,?)"); v_pstmt.setInt(1,2); v_pstmt.setBinaryStream(2,v_fis,(int)v_file.length()); System.out.println("now you see me"); v_pstmt.executeUpdate(); System.out.println("now you don't"); v_conn.commit(); v_fis.close(); v_pstmt.close(); } catch (IOException e_io) { System.out.println(e_io); } catch (SQLException e_sql) { System.out.println(e_sql); } System.out.println("You'll only get here with the 7.1 driver!"); }}-- end --01010101010101010101010101010101010101010101010101Marc P. Lavergne [wk:407-648-6996]Product DevelopmentrichLAVA Corporation--"Anyone who slaps a 'this page is best viewed withBrowser X' label on a Web page appears to beyearning for the bad old days, before the Web,when you had very little chance of reading adocument written on another computer, another wordprocessor, or another network."-Tim Berners-Lee (Technology Review, July 1996)01010101010101010101010101010101010101010101010101-- 01010101010101010101010101010101010101010101010101Marc P. Lavergne [wk:407-648-6996]Product DevelopmentrichLAVA Corporation--"Anyone who slaps a 'this page is best viewed withBrowser X' label on a Web page appears to beyearning for the bad old days, before the Web,when you had very little chance of reading adocument written on another computer, another wordprocessor, or another network."-Tim Berners-Lee (Technology Review, July 1996) java.sql.SQLException: ERROR: oidin: error in "\377\330\377\340...I'm on Linux 2.4.16 using JDK 1.4.0 but it fails in 1.3.1 as well. Here's a quick reproducible test case:-- start --package sample.java.jdbc;import java.sql.*;import java.io.*;import java.util.*;class testBlob{ public static void main(String args[]) { new testBlob(); System.exit(0); } public testBlob() { System.out.println("Let's begin the test ..."); String v_username = "postgre"; String v_password = "postgre"; String v_database = "jdbc:postgresql://127.0.0.1/TEST"; PreparedStatement v_pstmt = null; try { DriverManager.registerDriver(new org.postgresql.Driver()); Connection v_conn = DriverManager.getConnection( v_database, v_username, v_password); v_conn.setAutoCommit(false); File v_file = new File("/home/postgre/something.jpg"); FileInputStream v_fis = new FileInputStream(v_file); v_pstmt = v_conn.prepareStatement( "insert into lob_test (id,data) values (?,?)"); v_pstmt.setInt(1,2); v_pstmt.setBinaryStream(2,v_fis,(int)v_file.length()); System.out.println("now you see me"); v_pstmt.executeUpdate(); System.out.println("now you don't"); v_conn.commit(); v_fis.close(); v_pstmt.close(); } catch (IOException e_io) { System.out.println(e_io); } catch (SQLException e_sql) { System.out.println(e_sql); } System.out.println("You'll only get here with the 7.1 driver!"); }}-- end --01010101010101010101010101010101010101010101010101Marc P. Lavergne [wk:407-648-6996]Product DevelopmentrichLAVA Corporation--"Anyone who slaps a 'this page is best viewed withBrowser X' label on a Web page appears to beyearning for the bad old days, before the Web,when you had very little chance of reading adocument written on another computer, another wordprocessor, or another network."-Tim Berners-Lee (Technology Review, July 1996)01010101010101010101010101010101010101010101010101-- 01010101010101010101010101010101010101010101010101Marc P. Lavergne [wk:407-648-6996]Product DevelopmentrichLAVA Corporation--"Anyone who slaps a 'this page is best viewed withBrowser X' label on a Web page appears to beyearning for the bad old days, before the Web,when you had very little chance of reading adocument written on another computer, another wordprocessor, or another network."-Tim Berners-Lee (Technology Review, July 1996)

2002-02-18 Thread Marc Lavergne
intln(e_sql); } System.out.println("You'll only get here with the 7.1 driver!"); } } -- end -- 01010101010101010101010101010101010101010101010101 Marc P. Lavergne [wk:407-648-6996] Product Development richLAVA Corporation -- "Anyone who slaps a 'this page is best viewed with Brow

[BUGS] psqlODBC

2002-02-19 Thread Marc Breneiser
fine (a little extra manipulation when updating the permanent table with the temporary data).  I did not know if this was a known problem.   Marc Breneiser

[BUGS] [Fwd: BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver java.sql.SQLException: ERROR: oidin: error in "\377\330\377\340... I'm on Linux 2.4.16 using JDK 1.4.0 but it fails in 1.3.1 as well. Here's a quick reproducible test case: -- start -- package sample.java.jdbc; import java.sql.*; import java.io.*; import java.util.*; class testBlob { public static void main(String args[]) { new testBlob(); System.exit(0); } public testBlob() { System.out.println("Let's begin the test ..."); String v_username = "postgre"; String v_password = "postgre"; String v_database = "jdbc:postgresql://127.0.0.1/TEST"; PreparedStatement v_pstmt = null; try { DriverManager.registerDriver(new org.postgresql.Driver()); Connection v_conn = DriverManager.getConnection( v_database, v_username, v_password); v_conn.setAutoCommit(false); File v_file = new File("/home/postgre/someth!ing.jpg"); FileInputStream v_fis = new FileInputStream(v_file); v_pstmt = v_conn.prepareStatement( "insert into lob_test (id,data) values (?,?)"); v_pstmt.setInt(1,2); v_pstmt.setBinaryStream(2,v_fis,(int)v_file.length()); System.out.println("now you see me"); v_pstmt.executeUpdate(); System.out.println("now you don't"); v_conn.commit(); v_fis.close(); v_pstmt.close(); } catch (IOException e_io) { System.out.println(e_io); } catch (SQLException e_sql) { System.out.println(e_sql); } System.out.println("You'll only get here with the 7.1 driver!"); } } -- end -- 01010101010101010101010101010101010101010101010101 Marc P. Lavergne [wk:407-648-6996] Product Development richLAVA Corporation -- "Anyone who slaps a 'this page is best viewed with Browser X' label on a Web page appears to be yearning for the bad old days, before the Web, when you had v!ery little chance of reading a document written on another computer, a

2002-02-19 Thread Marc Lavergne
4.16 using JDK 1.4.0 but it fails in 1.3.1 as well. Here's a quick reproducible test case: -- see prior post -- 01010101010101010101010101010101010101010101010101 Marc P. Lavergne [wk:407-648-6996] Product Development richLAVA Corporation -- "Anyone who slaps a 'this page is b

[BUGS] BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver

2002-02-19 Thread Marc Lavergne
you don't"); v_conn.commit(); v_fis.close(); v_pstmt.close(); } catch (IOException e_io) { System.out.println(e_io); } catch (SQLException e_sql) { System.out.println(e_sql); } System.out.println("You'll only ge

[BUGS] BUG #2606: (libpq) incorrect function declaration in libpq-fe.h

2006-09-03 Thread Marc ROGLIANO
The following bug has been logged online: Bug reference: 2606 Logged by: Marc ROGLIANO Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows XP Description:(libpq) incorrect function declaration in libpq-fe.h Details: Hello, In libpq

[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

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 #3502: pg_ctl register translates \ to /

2007-07-31 Thread Marc Frappier
The following bug has been logged online: Bug reference: 3502 Logged by: Marc Frappier Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: windows XP Description:pg_ctl register translates \ to / Details: I'm creating a windows se

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

[BUGS] BUG #3653: Database crash

2007-10-04 Thread Marc Munro
The following bug has been logged online: Bug reference: 3653 Logged by: Marc Munro Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Linux 2.6.15.6 #4 SMP PREEMPT i686 Description:Database crash Details: Also occurs on 8.2.3 and 8.1.4

[BUGS] BUG #3672: ALTER TYPE change the underlying index tablespace to default

2007-10-12 Thread Marc Mamin
The following bug has been logged online: Bug reference: 3672 Logged by: Marc Mamin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux Description:ALTER TYPE change the underlying index tablespace to default Details: steps to repeat

[BUGS] BUG #3697: utf8 issue: can not reimport a table that was successfully exported.

2007-10-25 Thread Marc Mamin
The following bug has been logged online: Bug reference: 3697 Logged by: Marc Mamin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: SuSE Linux 9.1 (i586) Description:utf8 issue: can not reimport a table that was successfully exported

Re: [BUGS] BUG #3697: utf8 issue: can not reimport a table that was successfully exported.

2007-10-25 Thread Marc Mamin
.3 ? Is there a recommendation how to clean these data (I know where to search for them) Thanks, Marc Mamin -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 6:08 PM To: Marc Mamin Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #369

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

2007-11-29 Thread Marc Schablewski
You probably don't have readline's header files installed. They are usually part of your linux distro, but not installed by default. Install the files and rerun configure. Marc paulo wrote: > The following bug has been logged online: > > Bug reference: 3787 > Log

[BUGS] BUG #3861: cannot cast type smallint to bit

2008-01-09 Thread Marc mamin
The following bug has been logged online: Bug reference: 3861 Logged by: Marc mamin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux Description:cannot cast type smallint to bit Details: Hello, This is more a feature request than

[BUGS] psql malloc problem

2008-02-13 Thread Marc Munro
Postgres version 8.3.0 on Mac OSX Version 10.4.11 Built from source with no parameters to configure script (ie a simple default build). Error occurs every time I exit psql: marc:[prototype]$ psql -d postgres Welcome to psql 8.3.0, the PostgreSQL interactive terminal. Type: \copyright for

Re: [BUGS] BUG #3958: Self-Join Group-By Clause Produces Incorrect Results

2008-02-14 Thread Marc SanF
I respectfully challenge that the aggregation is correct. In the where clause, I specify A2.AUDIT_TYPE_CODE = CONTENT_2, thus returning only 2 rows for A2 and not all of the rows in A2 which happen to have a TXN_COUNT of 1 / row but could in fact be any positive number. I used 1 for simplici

Re: [BUGS] BUG #3958: Self-Join Group-By Clause Produces Incorrect Results

2008-02-14 Thread Marc SanF
Please disregard the previous email. After rereading what you sent, I realized that I need an outer join to A2 and not simply a self join...thanks and my apologies! - Original Message From: Tom Lane <[EMAIL PROTECTED]> To: Heikki Linnakangas <[EMAIL PROTECTED]> Cc: Marcus Torres <[EMAI

[BUGS] Problem with sequence et rule

2004-07-31 Thread Marc Boucher
d in "album": id=8230, ... record in "album_edit_tst": alb_id=8231,isbn=8232,flags=8233 Now my questions are: - Is this an expected behavior ? - How can I bypass this problem and ensure that I use the correct value, and that it's not incremented once more ? Thanks -- Marc ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] Problem with sequence et rule

2004-08-05 Thread Marc Boucher
on an admin page that takes seconds to generate (hundreds of table lookups). Thanks for your help. -- Marc ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[BUGS] Problem with rule and null value

2004-10-22 Thread Marc Boucher
This is a resent. Wrong email account the first time. --- I'm using PostgreSQL 7.3.4. I've set up a series of rules and triggers to complete an intermediate table with similar informations from another table. This ensures better performance over a solution with views. Intermediate table: Tab

[BUGS] Problem with rule and null value

2004-10-23 Thread Marc Boucher
I'm using PostgreSQL 7.3.4. I've set up a series of rules and triggers to complete an intermediate table with similar informations from another table. This ensures better performance over a solution with views. Intermediate table: Table album_edit Field Type Length Not NullDe

[BUGS] BUG #1612: Problem with PGAPI_SetPos

2005-04-21 Thread Marc Soleda
The following bug has been logged online: Bug reference: 1612 Logged by: Marc Soleda Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Win XP SP2 Description:Problem with PGAPI_SetPos Details: Environment: WinXP SP2/Visual C++ 6/MFC

[BUGS] BUG #1631: pg_autovacuum fails when creating as a windows service

2005-04-27 Thread Marc Soleda
The following bug has been logged online: Bug reference: 1631 Logged by: Marc Soleda Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: WinXP SP2 Description:pg_autovacuum fails when creating as a windows service Details: I'm insta

[BUGS] BUG #2185: function compilation error with "Create [TEMP] table?

2006-01-19 Thread marc mamin
The following bug has been logged online: Bug reference: 2185 Logged by: marc mamin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: DB Server: Linux Client: windows XP Description:function compilation error with "Create [TEMP]

[BUGS] BUG #5801: characters not encoded properly for column names

2010-12-23 Thread Marc Cousin
The following bug has been logged online: Bug reference: 5801 Logged by: Marc Cousin Email address: cousinm...@gmail.com PostgreSQL version: 9.0.2 Operating system: Windows XP Description:characters not encoded properly for column names Details: I get a different

Re: [BUGS] BUG #5801: characters not encoded properly for column names

2010-12-23 Thread Marc Cousin
uldn't get into the database as UTF8, as it is 1252 (hence the error message). The Thursday 23 December 2010 11:24:21, Pavel Stehule wrote : > Hello Marc, > > It was entered from a windows cmd console? It doesn't use win > encodings as default. For example, it must be e

Re: [BUGS] BUG #5801: characters not encoded properly for column names

2010-12-23 Thread Marc Cousin
Le jeudi 23 décembre 2010 18:21:55, John R Pierce a écrit : > On 12/23/10 2:34 AM, Marc Cousin wrote: > > No, from a Linux psql client (inside a kde konsole). You can setup any > > charset in it. I have exactly the same behaviour with psql under windows > > anyway, with a

Re: [BUGS] BUG #5801: characters not encoded properly for column names

2010-12-28 Thread Marc Cousin
2010/12/27 Robert Haas : > On Thu, Dec 23, 2010 at 5:18 AM, Marc Cousin wrote: >> With the Windows server : >> test=# SET client_encoding TO 'win1252'; >> SET > > I have a vague recollection that the argument to SET client_encoding > isn't validated

Re: [BUGS] BUG #5801: characters not encoded properly for column names

2011-01-03 Thread Marc Cousin
The Tuesday 28 December 2010 12:49:20, Robert Haas wrote : > On Tue, Dec 28, 2010 at 4:01 AM, Marc Cousin wrote: > > 2010/12/27 Robert Haas : > >> On Thu, Dec 23, 2010 at 5:18 AM, Marc Cousin wrote: > >>> With the Windows server : > >>> test=# S

[BUGS] collation problem on 9.1-beta1

2011-05-11 Thread Marc Cousin
1 collate "es_ES.utf8"; ERROR: collations are not supported by type integer at character 74 STATEMENT: SELECT * from (values ('llegar'),('llorer'),('lugar')) as tmp order by 1 collate "es_ES.utf8";

Re: [BUGS] collation problem on 9.1-beta1

2011-06-02 Thread Marc Cousin
On 02/06/2011 14:09, Peter Eisentraut wrote: On ons, 2011-05-11 at 14:58 -0400, Tom Lane wrote: Marc Cousin writes: I've been starting to work on a 'what's new in 9.1' like i did last year, and am faced with what I feel is a bug, while building a demo case for coll

Re: [BUGS] BUG #5741: syslog line length

2011-06-10 Thread Marc Cousin
On 02/11/2010 17:17, heasley wrote: > The following bug has been logged online: > > Bug reference: 5741 > Logged by: heasley > Email address: h...@shrubbery.net > PostgreSQL version: 8.4 > Operating system: solaris > Description:syslog line length > Details: > > * Max

[BUGS] BUG #6057: regexp_replace & back references

2011-06-14 Thread Marc Mamin
The following bug has been logged online: Bug reference: 6057 Logged by: Marc Mamin Email address: m...@intershop.de PostgreSQL version: 9.0.4 Operating system: Windows Description:regexp_replace & back references Details: select regexp_replace ('a&#x

[BUGS] BUG #6168: db_link may generate additional unformatted log entries in stderr

2011-08-19 Thread Marc Mamin
The following bug has been logged online: Bug reference: 6168 Logged by: Marc Mamin Email address: m...@intershop.de PostgreSQL version: 9.1 Beta 3 Operating system: Linux Description:db_link may generate additional unformatted log entries in stderr Details: Hello

Re: [BUGS] BUG #6168: db_link may generate additional unformatted log entries in stderr

2011-08-19 Thread Marc Mamin
ppen in code called by the backend, and it's doing exactly >what it's supposed to. Thanks for the explanation, this issue has no impact on our application. best regards, Marc Mamin

[BUGS] BUG #6209: Invalid subquery is accepted within a IN() clause

2011-09-16 Thread Marc Mamin
The following bug has been logged online: Bug reference: 6209 Logged by: Marc Mamin Email address: m...@intershop.de PostgreSQL version: 9.1beta3 Operating system: Linux Description:Invalid subquery is accepted within a IN() clause Details: Hello, This is somehow

[BUGS] script for #6350

2011-12-21 Thread Marc Balmer
Attached script (run as psql -U postgres -f bug_6350.sql) shows the problem. Enjoy! create database problematic; \c problematic -- create three roles create role usr; create role adm; create role new_adm; create table foo (bar integer); alter table foo owner to adm; grant select(bar) on foo to

[BUGS] script for #6350

2011-12-21 Thread Marc Balmer
Attached script (run as psql -U postgres -f bug_6350.sql) shows the problem. Enjoy! create database problematic; \c problematic -- create three roles create role usr; create role adm; create role new_adm; create table foo (bar integer); alter table foo owner to adm; grant select(bar) on foo to

Re: [BUGS] Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"

2012-01-23 Thread Marc Balmer
Am 22.01.12 14:22, schrieb Giuseppe Sucameli: > Hi all, > > trying to create a table with a column xmin I get the > following error message: > > test=> create table lx (xmin int); > ERROR: column name "xmin" conflicts with a system > column name > > Instead I get a different (and less understan

Re: [BUGS] BUG #6454: Latest x64 msi does not recognize admin account

2012-02-13 Thread Marc Balmer
Am 13.02.12 00:09, schrieb the_r...@yahoo.com: > The following bug has been logged on the website: > > Bug reference: 6454 > Logged by: Paul Peterson > Email address: the_r...@yahoo.com > PostgreSQL version: 9.1.2 > Operating system: Windows 7 home > Description: > >

Re: [BUGS] BUG #6595: can't remote access

2012-04-17 Thread Marc Balmer
Am 17.04.12 12:10, schrieb li...@nway.com.cn: > The following bug has been logged on the website: > > Bug reference: 6595 > Logged by: lihao > Email address: li...@nway.com.cn > PostgreSQL version: 9.1.3 > Operating system: windows xp > Description: > > I has install

Re: [BUGS] BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"

2012-11-18 Thread Marc Balmer
http://www.postgresql.org/mailpref/pgsql-bugs Freundliche Grüsse, micro systems Marc Balmer -- Marc Balmer micro systems, Wiesendamm 2a, Postfach, 4019 Basel fon +41 61 383 05 10, fax +41 61 383 05 12, http://www.msys.ch/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

2013-01-22 Thread Marc Balmer
Am 22.01.2013 um 14:31 schrieb jan-peter.seif...@gmx.de: > The following bug has been logged on the website: > > Bug reference: 7820 > Logged by: Jan-Peter Seifert > Email address: jan-peter.seif...@gmx.de > PostgreSQL version: 9.1.7 > Operating system: Windows 7 64-bit > De

[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] ftp server symlink

2008-10-25 Thread Marc G. Fournier
ot where ftp.postgresql.org is pointed to. Marc? --- --- hubert depesz lubaczewski wrote: there is a typo on postgresql ftp server:

[BUGS] List archives moved and cleaned up ...

2001-08-28 Thread Marc G. Fournier
Finally figuring that enough is enough, I've been spending the past few days working on the list archives ... I've reformatted, so far, the following lists into a cleaner format: pgsql-hackers pgsql-sql pgsql-bugs pgsql-general pgadmin-hackers pga

[BUGS] Majordomo being upgraded ...

2001-08-30 Thread Marc G. Fournier
Its been much much too long since I've upgraded Majordomo2 on the server, so this is the last email I'm sending out prior to upgrading her today ... if anyone notices the lists go suddenly quiet, or the way it works changing, please let me know ... My main worry is that in the past 6+ months, so

[BUGS] Workaround for html output formatting feature?

2001-09-06 Thread Marc Howard Zuckman
e hex or octal character equivalents for the angle brackets produces the same results as does use of the 〈 / 〉 constructs. Short of outputing the query results as text and generating the html on my own, is there an intrinsic postgresql solution to this issue? -- Marc Zuckman [EMAIL PROTECTED]

Re: [BUGS] CVS rejected me

2001-09-18 Thread Marc G. Fournier
go to anoncvs.postgresql.org, not postgresql.org .. On Tue, 18 Sep 2001, John Summerfield wrote: > This worked 2-3 days ago: what's changed? > > vs -z9 -q update > cvs update: authorization failed: server postgresql.org rejected access to >/home/projects/pgsql/cvsroot for user anoncvs > summe

Re: [BUGS] Website, mailing list

2001-09-23 Thread Marc G. Fournier
developer.postgresql.org/subunsub.php > > > > > > It would seem that that page is out of date. Vince, can you fix it? > > > I have no idea where the website source files live... > > > > Actually the instructions are correct. Something happened in the > > la

Re: [BUGS] Website, mailing list

2001-09-23 Thread Marc G. Fournier
It used to work, recent upgrade broke it, it was/is a known bug that has been fixed since and I'm in the process of upgrading ... On Sun, 23 Sep 2001, John Summerfield wrote: > On Sat, 22 Sep 2001, Vince Vielhaber wrote: > > > > On Sat, 22 Sep 2001, Tom Lane wrote: > > > > > Vince Vielhaber <[E

Re: [BUGS] [HACKERS] [PG MAIL LISTS] SEND OUT ALL????

2001-11-16 Thread Marc G. Fournier
someone, either intentially or accidentally, sent out a load to the lists ... On Fri, 16 Nov 2001, Mike Rogers wrote: > Why did it just send out tons of mail since September of this year- every > message? > -- > Mike > > > ---(end of broadcast)--

Re: [BUGS] time's running short for you to reserve 5432/tcp!!!!

2001-09-27 Thread Marc G. Fournier
being worked on ... thanks for the reminder ... On Sat, 22 Sep 2001, Greg A. Woods wrote: > It's LONG past time you asked IANA to officially register the default > PGPORT you've been using unofficially for a very long time now! > > You are no longer in the middle of an officially unassigned blo

Re: [BUGS] Test suite fails on alpha architecture

2007-11-11 Thread Marc 'HE' Brockschmidt
Zobel-Helas or me. We have our own userdir-ldap setup, so please include a mail address and a verifiable GPG key in your ping, together with a short description what you want to do. Marc Footnotes: [1] And Debian contributors, as long as there is some sort of trust relationship -- BOFH #357: I&

Re: [BUGS] postgresql in FreeBSD jails: proposal

2008-01-17 Thread Marc G. Fournier
doing this since moving to FreeBSD 6.x ... no patches required ... -- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [EMAIL PROTECTED] MSN . [EMAIL PROTECTED] Yahoo . yscrappy Skype: hub.org

Re: [BUGS] Get a CD

2002-11-15 Thread Marc G. Fournier
fixed, thanks ... On Mon, 11 Nov 2002, web_admin wrote: > Regard must be paid to... > > This link is not available : > http://www.pgsql.com/cd-dist.html > > From url http://www3.ru.postgresql.org/software.html > > Best regards, > VVS. > > > > ---(end of broadcast)

[DOCS] Testing gateway

2003-08-08 Thread Marc G. Fournier
In theory, the news2mail gateway is back in place ... ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to th

Re: [HACKERS] [BUGS] postgresql-7.4RC1 - unrecognized privilege type

2003-11-08 Thread Marc G. Fournier
On Sat, 8 Nov 2003, Tom Lane wrote: > <[EMAIL PROTECTED]> writes: > >select * from information_schema.tables; > >ERROR: unrecognized privilege type: "RERERENCES" > > > Replacing the word "RERERENCES" with "REFERENCES" in > > the predicate "has_table_privilege(c.oid, > > 'RERERENCES'::te

Re: [BUGS] Wrong PG_VERSION number in pg_config.h.win32

2003-11-12 Thread Marc G. Fournier
did you update it on the branch? I saw just the commit on HEAD :) On Wed, 12 Nov 2003, Bruce Momjian wrote: > Tom Lane wrote: > > Sebastien FLAESCH <[EMAIL PROTECTED]> writes: > > > In candiate release 7.4RC2 you still have > > > PG_VERSION "7.3" > > > > We don't generally bother with updat

[BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
reebsd4.10, compiled by GCC 2.95.4 I haven't had a chance to upgrade it to 8.0.3 yet ... didn't realize we had any limits on stuff like this ... bug, or really a limit? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED]

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
On Thu, 11 Aug 2005, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: The table contains ~10 million rows: # time psql -c "UPDATE xa_url SET url = url;" -U pgsql pareto ERROR: out of memory DETAIL: Failed on request of size 32. If you've g

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
On Thu, 11 Aug 2005, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: On Thu, 11 Aug 2005, Tom Lane wrote: If you've got any AFTER UPDATE triggers on that table, you could be running out of memory for the pending-triggers list. Nope, only have a BEFORE

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
On Thu, 11 Aug 2005, Marc G. Fournier wrote: On Thu, 11 Aug 2005, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: On Thu, 11 Aug 2005, Tom Lane wrote: If you've got any AFTER UPDATE triggers on that table, you could be running out of memory for the

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
Just as a reminder, this is an 8.0.0 install, so if you think this might have been fixed in later sub-releases, plesae let me know and I'll upgrade/test again ... On Thu, 11 Aug 2005, Marc G. Fournier wrote: On Thu, 11 Aug 2005, Marc G. Fournier wrote: On Thu, 11 Aug 2005, Tom Lane

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
On Thu, 11 Aug 2005, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: 'k, does this help any? TopMemoryContext: 40960 total in 4 blocks; 8632 free (10 chunks); 32328 used SPI Plan: 3072 total in 2 blocks; 1728 free (0 chunks); 1344 used TopTransactionCon

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-12 Thread Marc G. Fournier
On Thu, 11 Aug 2005, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: On Thu, 11 Aug 2005, Tom Lane wrote: Are you *sure* there are no AFTER triggers here? (Don't forget foreign-key checking triggers.) This is all of them ... nothing AFTER, just ON or