[BUGS] BUG #5153: Problem configuring postgresql-8.5alpha2 with SSL

2009-10-30 Thread Pierre
The following bug has been logged online: Bug reference: 5153 Logged by: Pierre Email address: pierre...@9online.fr PostgreSQL version: 8.5a2 Operating system: GNU/Linux Description:Problem configuring postgresql-8.5alpha2 with SSL Details: [...] checking for

[BUGS] BUG #5155: Error compiling postgresql-8.5alpha2

2009-10-30 Thread Pierre
The following bug has been logged online: Bug reference: 5155 Logged by: Pierre Email address: pierre...@9online.fr PostgreSQL version: 8.5a2 Operating system: GNU/Linux Description:Error compiling postgresql-8.5alpha2 Details: [...] make -C ../../src/timezone all

[BUGS] BUG #5156: Problem compiling postgresql-8.5alpha2

2009-10-31 Thread Pierre
The following bug has been logged online: Bug reference: 5156 Logged by: Pierre Email address: pierre...@9online.fr PostgreSQL version: 8.5a2 Operating system: GNU/Linux Description:Problem compiling postgresql-8.5alpha2 Details: [...] make -C ../../../src/port all

[BUGS] postgresql v7.1.3 bug report

2001-09-04 Thread pierre
ression or subexpression in DB/pgsql.php on line 163ERROR: Invalid regular expression: empty expression or subexpression would you give some advise to solve this problem??   Thank you very much   Best Rgds. Pierre Ho

[BUGS] BUG #2485: Problem configuring postgresql 8.1.4

2006-06-21 Thread Pierre
The following bug has been logged online: Bug reference: 2485 Logged by: Pierre Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: GNU/Linux Description:Problem configuring postgresql 8.1.4 Details: [...] checking security/pam_appl.h

[BUGS] Problem compiling postgresql 7.3b2

2002-10-06 Thread Pierre
1 exit status gmake[2]: *** [postgres] Error 1 gmake[2]: Leaving directory `/tmp/postgresql-7.3b2/src/backend' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/tmp/postgresql-7.3b2/src' gmake: *** [all] Error 2 It would be great if you could help me with t

Re: [BUGS] Problem compiling postgresql 7.3b2

2002-10-08 Thread Pierre
;s in it? And can you show us the config.log file? > > Pierre writes: > > > I try to compile postgresql-7.3b2 on my GNU/Linux system with > gcc-3.2 > > There was no problem with the configure but for the make i got this > : > > > > [...] > > gmake[

[BUGS] BUG #5618: restore won't work with files transferred with NFS

2010-08-13 Thread Pierre
The following bug has been logged online: Bug reference: 5618 Logged by: Pierre Email address: pma...@neuf.fr PostgreSQL version: 8.4.4 Operating system: Linux Description:restore won't work with files transferred with NFS Details: Computer A running Ubuntu

[BUGS] BUG #5619: restore won't work with files transferred with NFS

2010-08-13 Thread Pierre
The following bug has been logged online: Bug reference: 5619 Logged by: Pierre Email address: pma...@neuf.fr PostgreSQL version: 8.4.4 Operating system: Linux Description:restore won't work with files transferred with NFS Details: Sorry, my previous repor

[BUGS] BUG #2730: strange query performance !

2006-11-02 Thread Baudracco Pierre
The following bug has been logged online: Bug reference: 2730 Logged by: Baudracco Pierre Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: Linux Debian unstable (SID) Description:strange query performance ! Details: Debian : ii

[BUGS] BUG #2078: lock freeing problem in transaction (?)

2005-11-30 Thread Pierre Beyssac
The following bug has been logged online: Bug reference: 2078 Logged by: Pierre Beyssac Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: FreeBSD 4.11 Description:lock freeing problem in transaction (?) Details: The following code causes

[BUGS] Solaris cc compiler on amd: PostgreSQL does not have native spinlock support on this platform

2005-12-16 Thread Pierre Girard
Hello, I'm trying to compile postgresql and I got this message telling me to inform you: "../../../../src/include/storage/s_lock.h", line 806: #error: PostgreSQL does not have native spinlock support on this platform. To continue the compilation, rerun configure using --disable-spinlocks.

Re: [BUGS] Solaris cc compiler on amd: PostgreSQL does not have native

2005-12-16 Thread Pierre Girard
Tom Lane wrote: You'd need to do something about adapting src/backend/port/tas/solaris_i386.s It's possible that the assembly code would work as-is on amd, in which case you'd just need a one-liner change in s_lock.h and maybe some adjustment of the template file. It doesn't compile with th

[BUGS] BUG #6232: hstore operator ? no longer uses indexes

2011-09-28 Thread Pierre Ducroquet
The following bug has been logged online: Bug reference: 6232 Logged by: Pierre Ducroquet Email address: p.p...@pinaraf.info PostgreSQL version: 9.1.1 Operating system: Linux Debian, amd64 Description:hstore operator ? no longer uses indexes Details: The following

[BUGS] config.h inclusion conflict

2001-08-13 Thread Jean Pierre LeJacq
ize that C compilers have different interpertations of where to search for this inclusion. A solution would be to disambiguate the file using: #include -- Jean Pierre ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] Problem in postgresql installation

2002-04-03 Thread Pierre-Alexis Paquin
Hi   I have installed a 7.1.3 postgresql version on my linux server. When I type "createuser " it asks me :  Shall the new user allowed to create databases (y/n)?                                                                         Shall the new user allowed to create more

[BUGS] Bugs report

2002-04-04 Thread Pierre-Alexis Paquin
Hi   I have installed a 7.1.3 postgresql version on my linux server. When I type "createuser " it asks me :  Shall the new user allowed to create databases (y/n)?                                                                         Shall the new user allowed to create more ne

[BUGS] Problem in Postgresql installation

2002-04-08 Thread Pierre-Alexis Paquin
Hi   I have installed a 7.1.3 postgresql version on my linux server. (RedHat 7.2)   When I type "createuser " it asks me :  Shall the new user allowed to create databases (y/n)?                                                                         Shall the new user allowed

[BUGS] ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL 8.2 beta1

2006-10-24 Thread JEAN-PIERRE PELLETIER
ct 1 as col) t3 on t1.col = t3.col and t2.col = t3.col and 1 = t3.col left outer join (select 1 as col) t4 on t3.col = t4.col I am on PostgreSQL 8.2 beta1 under Windows XP Service Pack 2. Thanks, Jean-Pierre Pelletier e-djuster

Re: [BUGS] ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL

2006-11-08 Thread JEAN-PIERRE PELLETIER
This is just to confirm that 8.2 beta3 fixes that problem. Thanks again, Jean-Pierre Pelletier From: Tom Lane <[EMAIL PROTECTED]> To: "JEAN-PIERRE PELLETIER" <[EMAIL PROTECTED]> CC: pgsql-bugs@postgresql.org Subject: Re: [BUGS] ERROR: failed to build any 4-way j

[BUGS] server process exited with exit code -1073741819 on 8.2 Windows

2006-12-20 Thread JEAN-PIERRE PELLETIER
within another plpgsql function but then it got back to crashing. Thanks, Jean-Pierre Pelletier e-djuster To Reproduce: CREATE TABLE Claim ( ClaimIdINTEGER NOT NULL, AssociatePersonId INTEGER NULL, IsOnSite BOOLEAN NOT NULL ); CREATE TABLE SubTask

Re: [BUGS] server process exited with exit code -1073741819 on 8.2 Windows

2006-12-20 Thread JEAN-PIERRE PELLETIER
I've compiled the 8.2.0 sources from http://www.postgresql.org/ftp/source/v8.2/ and when run, it crash by logging the same messages. I'll compile from the nightly snapshot tarball (which is probably 8.3 ?) and will post the result. Jean-Pierre Pelletier From: Alvaro Herre

Re: [BUGS] server process exited with exit code -1073741819 on 8.2 Windows

2006-12-20 Thread JEAN-PIERRE PELLETIER
I've compiled 8.3 devel from the latest nightly snapshot tarball, did an initdb and when run, it crash by logging the same messages. Jean-Pierre Pelletier From: Alvaro Herrera <[EMAIL PROTECTED]> To: JEAN-PIERRE PELLETIER <[EMAIL PROTECTED]> CC: pgsql-bugs@postgresql.org S

[BUGS] BUG #2963: PQprepare and transactions.

2007-02-05 Thread DUVAL Jean-Pierre
The following bug has been logged online: Bug reference: 2963 Logged by: DUVAL Jean-Pierre Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Windows XP Description:PQprepare and transactions. Details: To speed up programs, I call: 1

[BUGS] BUG #3696: FK integrity check bypassed using rules.

2007-10-25 Thread Pierre-yves Strub
The following bug has been logged online: Bug reference: 3696 Logged by: Pierre-yves Strub Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 / 8.3b Operating system: Linux 2.6 Description:FK integrity check bypassed using rules. Details: Hello. Here is a

Re: [BUGS] BUG #3696: FK integrity check bypassed using rules.

2007-10-25 Thread Pierre-Yves Strub
On 10/25/07, Tom Lane <[EMAIL PROTECTED]> wrote: > Yes, a poorly designed rule can invalidate all kinds of expectations > about behavior. This isn't a bug in my humble opinion. Yes, this was my first impression. I was just surprised because of this: the script CREATE TABLE dat

[BUGS] Bug in select to_char(now(), 'YYYY/MM/DD HH24:MI:SS:MS')

2008-06-11 Thread Pierre Le Mouëllic
/ws/on10-tools/SUNWspro/SS11/bin/cc -Xa Thanks for your prompt answer. Pierre Le Mouëllic -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] could not read from statistics collector pipe, Windows 2000, PostgreSQL 8.0.1

2005-02-15 Thread Jean-Pierre Pelletier
this normal and if not, how do we fix that?   ThanksJean-Pierre Pelletier

[BUGS] could not read, could not write, could not fsync, Windows 2000, PostgreSQL 8.0.1

2005-02-18 Thread Jean-Pierre Pelletier
have done a vacuum, analyze and reindex on pgdepend and pgtype and restarted PostgreSQLa few times, we had no problems doing that but the error messages are still there.   Is this normal and if not, how do we fix that? ThanksJean-Pierre Pelletier   p.s.: We also have messages "FATAL:  c

[BUGS] BUG #1585: could not read from statistics collector pipe

2005-04-06 Thread Jean-Pierre Pelletier
The following bug has been logged online: Bug reference: 1585 Logged by: Jean-Pierre Pelletier Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Windows 2000 Server, Service Pack 4 Description:could not read from statistics collector pipe

[BUGS] Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2

2005-10-03 Thread Jean-Pierre Pelletier
we weren't using it back then. We are using Windows 2000 Server, Service Pack 4. Thanks Jean-Pierre Pelletier e-djuster ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan

Re: [BUGS] Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2

2005-10-03 Thread Jean-Pierre Pelletier
We were running 7.4 under Cygwin with Windows 2000 Service Pack 4. - Original Message - From: "Jim C. Nasby" <[EMAIL PROTECTED]> To: "Jean-Pierre Pelletier" <[EMAIL PROTECTED]> Cc: Sent: Monday, October 03, 2005 6:00 PM Subject: Re: [BUGS] Unreliabl

[BUGS] Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2

2005-10-04 Thread Jean-Pierre Pelletier
we weren't using it back then. We are using Windows 2000 Server, Service Pack 4. Thanks Jean-Pierre Pelletier e-djuster ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail co

[BUGS] Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000

2005-10-04 Thread Jean-Pierre Pelletier
backup but created from .sql scripts for DDL, and data from user tables were reloaded from files with "copy from". We are using Windows 2000 Server, Service Pack 4. Thanks, Jean-Pierre Pelletier e-djuster ---(end of broadcast)--- TIP

Re: [BUGS] Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000

2005-10-05 Thread Jean-Pierre Pelletier
inserts but no bulk inserts, the biggest load would come from select statements. Jean-Pierre Pelletier - Original Message - From: "Qingqing Zhou" <[EMAIL PROTECTED]> To: Sent: Wednesday, October 05, 2005 3:03 AM Subject: Re: [BUGS] Possibly corrupted shared memory,

Re: [BUGS] Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000

2005-10-05 Thread Jean-Pierre Pelletier
ent without the server crashing. After two days, if I haven't seen any of these error messages there is a very high chance that it's been fixed by turning off the antivirus. Jean-Pierre Pelletier - Original Message - From: "Qingqing Zhou" <[EMAIL PROTECTED]> To

Re: [BUGS] Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000

2005-10-07 Thread Jean-Pierre Pelletier
being restarted many times every day. Any idea what might be causing that? Jean-Pierre Pelletier - Original Message - From: "Jean-Pierre Pelletier" <[EMAIL PROTECTED]> To: "Qingqing Zhou" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, October 05, 2005 2:58 PM S

Re: [BUGS] Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000

2005-10-11 Thread Jean-Pierre Pelletier
The antivirus is CA eTrust EZ v 7.0.6.7. I cannot put back the antivirus on that server because it is now in production mode. Jean-Pierre Pelletier - Original Message - From: "Qingqing Zhou" <[EMAIL PROTECTED]> To: Sent: Friday, October 07, 2005 3:08 PM Subject: Re:

[BUGS] function currval(character varying) does not exist, PostgreSQL 8.1 beta3

2005-10-20 Thread Jean-Pierre Pelletier
ce Pack 2 with JDBC3 8.1 Build 402.    It worked fine with PostgreSQL 8.1 beta2 and with 8.0.*   Thanks, Jean-Pierre Pelletier e-djuster

[BUGS] RIGHT JOIN is only supported with merge-joinable join conditions, PostgreSQL 8.1 beta3

2005-10-25 Thread Jean-Pierre Pelletier
t1id and table1.extension in (table2.original, table2.replacement) left outer join table3 on table2.t3id = table3.t3id and table1.extension in (table2.replacement); I am on PostgreSQL 8.1 beta3 under Windows XP Service Pack 2. Thanks Jean-Pierre Pelletier

[BUGS] Variable not found in subplan target lists, PostgreSQL 8.1 beta3

2005-10-25 Thread Jean-Pierre Pelletier
le2; -- Now that we have Row constructor, I can get rid of my function udftable1row() and this works ok select udf(t1) from (select (cast(row(1,2) as table1)).*) t1 cross join table2; I am on PostgreSQL 8.1 beta3 under Windows XP Service Pack 2. Thanks, Jean-Pierre

Re: [BUGS] RIGHT JOIN is only supported with merge-joinable join conditions, PostgreSQL 8.1 beta3

2005-10-25 Thread Jean-Pierre Pelletier
ement)". - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Jean-Pierre Pelletier" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, October 25, 2005 4:34 PM Subject: Re: [BUGS] RIGHT JOIN is only supported with merge-joinable join conditions, PostgreSQL 8.1

Re: [BUGS] BUG #2178: NOT IN command don't work

2006-01-24 Thread Jean-Pierre Pelletier
It's not clear to me why "not exists" and "not in" return a different result but it must be per SQL spec as all DBMS I have seen do that (Oracle, SQL Server, MYSQL, ...) In most queries I have seen column1 is NOT NULL so IN or EXISTS can both be u

[BUGS] postmaster ?????

2004-03-13 Thread Pierre Marie OUM SACK
start because of an unknown reason. Thank in advance. -- Regards, Pierre Marie. _ Pierre Marie OUM OUM SACK