[BUGS] BUG #5259: the table name double

2010-01-03 Thread David
The following bug has been logged online: Bug reference: 5259 Logged by: David Email address: goodom...@21cn.com PostgreSQL version: 8.0 Operating system: RHEL5 Description:the table name double Details: hi the table name double,why

[BUGS] BUG #2597: windows installer error

2006-08-30 Thread David
The following bug has been logged online: Bug reference: 2597 Logged by: David Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: XP Home Description:windows installer error Details: Hi, I'm istalling postgresql on an xp (home) ma

[BUGS] BUG #2889: Syntax error: WHERE ANY(arrayfield) = N

2007-01-13 Thread David
The following bug has been logged online: Bug reference: 2889 Logged by: David Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: OpenBSD 3.9 Description:Syntax error: WHERE ANY(arrayfield) = N Details: In reference to the array

[BUGS] BUG #6687: initdb -A ident can almost never be correct

2012-06-11 Thread david
The following bug has been logged on the website: Bug reference: 6687 Logged by: David Fetter Email address: da...@fetter.org PostgreSQL version: 9.1.4 Operating system: All Description: When calling initdb -A, it is assumed--wrongly in the case of ident, that every

[BUGS] BUG #4284: Optimizer chooses bad plan with LEFT join

2008-07-05 Thread David Rowley
The following bug has been logged online: Bug reference: 4284 Logged by: David Rowley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Windows XP and 2003 Description:Optimizer chooses bad plan with LEFT join Details: I was asked a few

[BUGS] Re: [GENERAL] different results based solely on existence of index (no, seriously)

2008-08-12 Thread David Fetter
g isn't a bug unless you can reproduce it on the latest minor version, in this case 8.3.3, of the major version, in this case 8.3, that the bug appears in. Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype:

Re: [BUGS] BUG #4354: Text Type converted to Memo

2008-08-14 Thread David Fetter
t I don't think it is. Delphi's memo type corresponds (roughly) to PostgreSQL's TEXT/VARCHAR one, so it's your expectations that were off. Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfett

[BUGS] BUG #4387: UNION in Crosstab - missing rows

2008-08-29 Thread David Chen
The following bug has been logged online: Bug reference: 4387 Logged by: David Chen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.9 Operating system: Windows 2003 Description:UNION in Crosstab - missing rows Details: Hi, I wish to report a bug in

[BUGS] BUG #4386: UNION in Crosstab - missing rows

2008-08-29 Thread David Chen
The following bug has been logged online: Bug reference: 4386 Logged by: David Chen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.9 Operating system: Windows 2003 Description:UNION in Crosstab - missing rows Details: Hi, I wish to report a bug in

[BUGS] BUG #4413: LEFT JOIN not working as expected

2008-09-09 Thread David Jaquay
The following bug has been logged online: Bug reference: 4413 Logged by: David Jaquay Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Ubuntu Heron Description:LEFT JOIN not working as expected Details: I'm seeing a problem with a

Re: [BUGS] ERROR: unexpected data beyond EOF in block XXXXX of relation "file"

2008-09-29 Thread David Fetter
gt; what software layer to look at. Hopefully it's just a configuration > issue. It's not. The issue is that NFS is broken garbage from a DBMS, and, it's pretty easy to argue, just about any other perspective. Cheers, David. > > Tom Lane-2 wrote: > > > > austijc <

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-15 Thread David Fetter
iant than MySQL, > but Postgres is not 100% compliant either. Is any database system > 100% compliant? No. Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECT

[BUGS] BUG #4483: setAutoCommit false shouldn't be necessary for fetchSize to work

2008-10-17 Thread David Smiley
The following bug has been logged online: Bug reference: 4483 Logged by: David Smiley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Mac OS X Description:setAutoCommit false shouldn't be necessary for fetchSize to work Details: No m

[BUGS] BUG #4608: postgresql.conf and other .conf not created

2009-01-09 Thread David Slayter
The following bug has been logged online: Bug reference: 4608 Logged by: David Slayter Email address: slay...@lettis.com PostgreSQL version: 8.3.5 Operating system: Windowns XP Professional SP3 Description:postgresql.conf and other .conf not created Details: During

[BUGS] Lost search_path after transaction fails

2009-02-14 Thread David Newall
copy me in replies. David -8<8<8<8<8<8<8<--- ECPG demonstratiion of PostgreSQL losing 'search_path' [18457]: ECPGdebug: set to 1 Setting up table [18457]: ECPGconnect: opening database circle on port [18457]: ECPGexec

Re: [BUGS] Lost search_path after transaction fails

2009-02-16 Thread David Newall
Heikki Linnakangas wrote: > ecpg implicitly runs everything inside transactions. You don't need to > run START TRANSACTION, that's implicit. Therefore the "set > search_path" command is in fact run in the same transaction as the > failing insert, as also hinted by the warning "there is already a >

[BUGS] RPostgreSQL

2009-02-25 Thread David Seres
Hello! I encountered a problem trying to install the RPostgreSQL package for R. I get an error message whenever I try to load the package, namely that it doesn't find the reference number 108 in the LIBPQ.dll. What does this problem mean? Greetings, David Seres

[BUGS] BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)

2009-05-20 Thread David Blewett
The following bug has been logged online: Bug reference: 4817 Logged by: David Blewett Email address: da...@dawninglight.net PostgreSQL version: 8.4beta2 Operating system: Gentoo Linux Description:Dump of 8.3 hstore not restorable to 8.4 (RECHECK) Details: In

Re: [BUGS] BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)

2009-05-20 Thread David Blewett
On Wed, May 20, 2009 at 8:48 AM, David Blewett wrote: > > In testing the beta to see if my planner issues might be resolved, I ran > into a situation where the 8.4 pg_dump created a dump for the hstore > contrib > module which would not restore against 8.4. It looks like this

[BUGS] BUG #4835: psql server crashes when using non-existing functions

2009-06-03 Thread David Sommerseth
The following bug has been logged online: Bug reference: 4835 Logged by: David Sommerseth Email address: d...@users.sourceforge.net PostgreSQL version: 8.3.7 Operating system: Linux (Gentoo Hardened 2008 / x86 - 32bit) Description:psql server crashes when using non

[BUGS] BUG #4837: initdb segv's if getpwuid fails

2009-06-03 Thread David Vitek
The following bug has been logged online: Bug reference: 4837 Logged by: David Vitek Email address: dvi...@grammatech.com PostgreSQL version: 8.3 Operating system: Non-Windows Description:initdb segv's if getpwuid fails Details: We've seen this h

[BUGS] BUG #4849: intermittent future timestamps

2009-06-10 Thread David Leppik
The following bug has been logged online: Bug reference: 4849 Logged by: David Leppik Email address: dlep...@vocalabs.com PostgreSQL version: 8.3.5 Operating system: Linux (CentOS 5.2) Description:intermittent future timestamps Details: We are intermittently

Re: [BUGS] BUG #4849: intermittent future timestamps

2009-06-10 Thread David Leppik
decide to blame it on someone else? David On Jun 10, 2009, at 11:58 AM, Tom Lane wrote: "David Leppik" writes: We are intermittently getting results from now() which are around 10 minutes in the future. Most calls return a reasonable value. Because the erroneous timestamps are

Re: [BUGS] BUG #4849: intermittent future timestamps

2009-06-10 Thread David Leppik
My typo. Converting java.sql.Timestamp to java.util.Date was buggy on my end. David On Jun 10, 2009, at 1:00 PM, Kevin Grittner wrote: David Leppik wrote: Never mind. Turns out the bug was in our own code (read: me, personally, being stupid) to convert a java.sql.Timestamp to

[BUGS] PGOLEDB Error Fillinvalues failed

2009-06-16 Thread David Tandwe
I am using postgreSQL with the OLEDB provider but I am failing to update data in a database. I reports the error indicated in the subject of this message. Is there any solution to this problem? Please help David Tandwe -- Scanned on: ESCOM mailserver ESCOM Staus: Clean

Re: [BUGS] TH to_char modifier doesn't work with HH12

2009-07-06 Thread David Fetter
fixing coding mistakes in formatting.c? That depends on whether the project lasts forever ;) Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres

Re: [BUGS] TH to_char modifier doesn't work with HH12

2009-07-06 Thread David Fetter
the file, but the whole question of date and time handling has been tricky and complicated for all of human history. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vot

Re: [BUGS] BUG #4914: uuid_generate_v4 not present in eithersource or yum/rpm

2009-07-13 Thread David Kerr
On Fri, Jul 10, 2009 at 12:31:05PM -0400, Alvaro Herrera wrote: - Dan Boeriu wrote: - > Could you please tell me how you installed it? What exact version did you download? Was it source or yum/rpm? - > I tried both with source compiling with the flags for oops-uuid and still didn't get the functi

Re: [BUGS] BUG #4914: uuid_generate_v4 not present in eithersource or yum/rpm

2009-07-13 Thread David Kerr
On Tue, Jul 14, 2009 at 01:18:55AM +0300, Peter Eisentraut wrote: - On Monday 13 July 2009 19:17:49 David Kerr wrote: - > We're using SLES 11, and uuid-ossp isn't delivered in the - > postgresql-contrib package, we opened a case with Novell and this was their - > reply:

Re: [PERFORM] [BUGS] BUG #4919: CREATE USER command slows down system performance

2009-07-15 Thread David Wilson
relevant.. DoS attacks. The longer it takes to reject an invalid login, the fewer invalid login attempts it takes to DoS the server. -- - David T. Wilson david.t.wil...@gmail.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [BUGS] BUG #5009: Loss of information

2009-08-25 Thread David Fetter
uniqueness, and only that. If you wish to create some entity which has some other properties, be aware that such entities require locking, which sharply limits their speed. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidf

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-21 Thread David Fetter
for the same reasons that "end of transaction" triggers do. What happens when there are two different END blocks in a session? With connection poolers, backends can last quite awhile. Is it OK for the END block to run hours after the rest of the code? Cheers, David. -- David Fet

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-21 Thread David Fetter
On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote: > David Fetter escribió: > > > Taken literally, that would mean, "the last action before the > > backend exits," but at least to me, that sounds troubling for the > > same reasons that "end of

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-21 Thread David Fetter
On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote: > David Fetter escribió: > > On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote: > > > David Fetter escribió: > > > > > > > Taken literally, that would mean, "the last acti

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-21 Thread David Fetter
On Mon, Sep 21, 2009 at 02:28:11PM -0400, Robert Haas wrote: > On Mon, Sep 21, 2009 at 2:17 PM, David Fetter wrote: > > On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote: > >> David Fetter escribió: > >> > On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro

Re: [BUGS] BUG #5087: Submitted bug reports not showing up in a timely manner (or at all)

2009-09-29 Thread David Fetter
ts there... We're probably just back in the situation where > we need more moderators for it... I'd be happy to be added as moderator for -bugs or any other list that needs love. I already do -general and sfpug, so this shouldn't be much extra work :) Cheers, David. -- David Fe

Re: [BUGS] BUG #5123: bug in window function "last_value"

2009-10-16 Thread David Fetter
have the last value be 3 instead of changing. This is at least a POLA violation. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://

Re: [BUGS] BUG #5123: bug in window function "last_value"

2009-10-16 Thread David Fetter
On Fri, Oct 16, 2009 at 01:28:57PM -0400, Tom Lane wrote: > David Fetter writes: > > I think what the OP was expecting was to have the last value be 3 > > instead of changing. This is at least a POLA violation. > > [ shrug... ] It's what the spec requires, as far

Re: [BUGS] BUG #5150: math bug

2009-10-30 Thread David Fetter
braic numbers, of which rational numbers are a proper subset, is countable and hence has Lebesgue measure zero on the real line. ;) Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

[BUGS] BUG #5161: tome nota del siguiente error un error ha ocurrido 999

2009-11-03 Thread christian david
The following bug has been logged online: Bug reference: 5161 Logged by: christian david Email address: chrisdav8...@hotmail.com PostgreSQL version: 08_02_0400 Operating system: windows xp Description:tome nota del siguiente error un error ha ocurrido 999 Details

[BUGS] BUG #5232: plpythonu s=s.op() raises an exception

2009-12-03 Thread David Gardner
The following bug has been logged online: Bug reference: 5232 Logged by: David Gardner Email address: dgard...@creatureshop.com PostgreSQL version: 8.4.1 Operating system: Debian, amd64 Description:plpythonu s=s.op() raises an exception Details: If I create the

Re: [BUGS] BUG #5232: plpythonu s=s.op() raises an exception

2009-12-03 Thread David Gardner
: CREATE OR REPLACE FUNCTION pyreplacenoreassign(src text, s text) RETURNS text AS $BODY$ return src.replace(s,'') $BODY$ LANGUAGE 'plpythonu' VOLATILE COST 100; ALTER FUNCTION pyreplacenoreassign(text, text) OWNER TO dgardner; Tom Lane wrote: "David Gardner" writ

[BUGS] BUG #5240: Stable Functions that return a table type with a dropped column fail

2009-12-11 Thread David Gardner
The following bug has been logged online: Bug reference: 5240 Logged by: David Gardner Email address: dgard...@creatureshop.com PostgreSQL version: 8.4.1 Operating system: Debian Linux, amd64 2.6.30 Description:Stable Functions that return a table type with a dropped

Re: [BUGS] BUG #5242: ODBC driver v8.4.1 crashed

2009-12-15 Thread David Fetter
oblems with the PostgreSQL database, for problems with database connectors like JDBC and ODBC, graphical administration tools like pgAdmin and phpPgAdmin, or other external projects like Slony, Bucardo, etc., please report to them directly. In cases where you have a problem with things outside

Re: [BUGS] BUG #5242: ODBC driver v8.4.1 crashed

2009-12-15 Thread David Fetter
t report them here; please report to those > projects directly. Alternatively you can look at the available href='/community/lists'>mailing lists and see if there is a more > apropriate list available." This is better than what I sent :) Cheers, David. -- David Fetter http

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread David Fetter
read? I may have inadvertently used some > bash/gnu-isms... sorry about that. > > *** a/configure > --- b/configure Edit configure.in, not configure :) Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: dav

[BUGS] BUG #5347: initdb does not work when a data directory has been deleted

2010-02-26 Thread David Andersen
The following bug has been logged online: Bug reference: 5347 Logged by: David Andersen Email address: david.ander...@andersen-innovation.com PostgreSQL version: 8.4.2 Operating system: Windows 7 64-bit Description:initdb does not work when a data directory has been

Re: [BUGS] BUG #5347: initdb does not work when a data directory has been deleted

2010-02-26 Thread David Andersen
uot; or run initdb with an argument other than "../data". The first part of this sentence is what I attempted to do, and it did not work. Regards, David On Fri, Feb 26, 2010 at 16:52, Tom Lane wrote: > "David Andersen" writes: > > [ initdb fails with ] > >

[BUGS] BUG #5463: incorrect password when downloading/installing

2010-05-18 Thread David Orr
The following bug has been logged online: Bug reference: 5463 Logged by: David Orr Email address: david_or...@hotmail.com PostgreSQL version: 8.3.11 or 8.4.4 Operating system: Windows 7 Starter Description:incorrect password when downloading/installing Details: I

[BUGS] Problems building on IRIX 6.x

2000-03-29 Thread David Kaelbling
idTypeRelid: Invalid type - oid = 0" followed by "ERROR: random_tbl: Table does not exist." diffs. - misc: random_tbl missing from user_relns - rules: the final two queries returned empty results. Are these particular tests supposed to succeed? Thanks, David PS: I'm not on the mailing list, so please include me on any replies. -- David KAELBLING <[EMAIL PROTECTED]> Silicon Graphics Computer Systems 1 Cabot Rd, suite 250; Hudson, MA 01749 781.839.2157, fax ...2357

Re: [BUGS] Problems building on IRIX 6.x

2000-03-30 Thread David Kaelbling
Tom Lane wrote: > > David, 6.5.2 is pretty much ancient history for us. Some of the > problems you mention have been addressed in current sources, but > I'm not sure if they all have been. Yes, sorry -- that was a typo. I was building 6.5.3. > > I also had s

Re: [BUGS] Problems building on IRIX 6.x

2000-03-30 Thread David Kaelbling
Peter Eisentraut wrote: > > On Wed, 29 Mar 2000, David Kaelbling wrote: > > > "info.c", line 2142: warning(1551): variable "htbl_stmt" is used before > > its value is set > > > There were some "pointless comparison of unsigned integ

[BUGS] bug

2000-10-31 Thread David Orr
Your name : Dave Orr Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) :Intel Pentium Operating System (example: Linux 2.0.26 ELF) :Linux 2-2.14-lmdklinus PostgreSQL version (exa

[BUGS] Bug #194 and #195 missing version

2001-02-16 Thread David Lynn
Sorry... forgot to add version. For bug #194 and #195 in the BugTool the version is: PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3 --d

Re: [BUGS] segmentation fault in psql

2001-03-31 Thread David George
puts the following: test=# select current_user; current_user -- david (1 row) Then it doesn't echo what I type. Without exiting, I typed select current_user; again and it did output the following even though it didn't echo what I was typing: current_user -- david

Re: [BUGS] segmentation fault in psql

2001-03-31 Thread David George
Tom Lane wrote: > Uh, what are sfio and stdio anyway, and why would we want them? putc is > in plain old libc in every system I've dealt with. If you remove both > sfio and stdio from configure, does it work any better? Thanks. Removing sfio from configure.in and reconfiguring/making did the

[BUGS] three VERY minor things with 7.1 final

2001-04-17 Thread David George
I want to thank you for the excellent and fast responses I have received in the past. Especially while troubleshooting the sfio problem. These problems are VERY minor and easily worked around. Part of the reason I am posting them is just in case someone else runs across the same things. I am r

Re: [BUGS] Bug #428: Another security issue with the JDBC driver.

2001-08-27 Thread David Daney
at: http://candle.pha.pa.us/cgi-bin/pgpatchesI will try to apply it within the next 48 hours. David Daney ([EMAIL PROTECTED]) reports a bug with a severity of 3The lower the number the more severe it is.Short DescriptionAnother security issue with the JDBC driver.Long DescriptionThe

Re: [BUGS] Bug #428: Another security issue with the JDBC driver.

2001-08-27 Thread David Daney
wrong thing to do. Perhaps I should look into this a bit further. David Daney. Bruce Momjian wrote: [EMAIL PROTECTED]"> Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatchesI will try to apply it within the next 48 hours.

Re: [JDBC] Re: [BUGS] Bug #428: Another security issue with the JDBC driver.

2001-08-29 Thread David Daney
Sorry about that, things are never as easy as they seem.  The answer appears to be to filter PG_Stream.java in a similar manner as is done to Driver.java Attached please find two files. 1) diffs for build.xml. 2) PG_Stream.java.in I hope this can now be put to bed. David Daney. Bruce

[BUGS] (JDBC) KEY_SEQ in Foreign Key result set starts at 0, should be 1

2002-02-19 Thread David Goodenough
Using the JDBC interface to inspect the metadata in a table, the ResultSet returned from using DatabaseMetaData.getImportedKeys includes values for KEY_SEQ. This is an integer value and in the case of Postgreql starts at zero. I can find no formal definition of where this value should start but

[BUGS] BUG #2539: PL/PgSQL doesn't disallow COPY commands on compile, even though it disallows them.

2006-07-19 Thread David Fetter
The following bug has been logged online: Bug reference: 2539 Logged by: David Fetter Email address: [EMAIL PROTECTED] PostgreSQL version: All Operating system: Linux and OSX that I've tested Description:PL/PgSQL doesn't disallow COPY commands on compile, e

Re: [BUGS] BUG #2539: PL/PgSQL doesn't disallow COPY commands on compile, even though it disallows them.

2006-07-19 Thread David Fetter
On Wed, Jul 19, 2006 at 07:02:15PM -0400, Tom Lane wrote: > "David Fetter" <[EMAIL PROTECTED]> writes: > > Description:PL/PgSQL doesn't disallow COPY commands on > > compile, even though it disallows them. > > There are many many things that wo

[BUGS] BUG #2542: ALTER USER foo SET bar = func(baz) errors out

2006-07-20 Thread David Fetter
The following bug has been logged online: Bug reference: 2542 Logged by: David Fetter Email address: [EMAIL PROTECTED] PostgreSQL version: All Operating system: All Description:ALTER USER foo SET bar = func(baz) errors out Details: foo=> ALTER USER foo

Re: [BUGS] BUG #2542: ALTER USER foo SET bar = func(baz) errors out

2006-07-20 Thread David Fetter
On Thu, Jul 20, 2006 at 10:46:27PM -0400, Tom Lane wrote: > "David Fetter" <[EMAIL PROTECTED]> writes: > > is there some way to let the right hand side of SET be the (TEXT) > > output of a function? > > No. SET is a utility command and utility commands gener

Re: [BUGS] Restoring 7.4.2 pg_dumpall output in 8.1.4 fails

2006-08-10 Thread David Fetter
On Thu, Aug 10, 2006 at 11:44:31AM -0700, Jie Liang wrote: > Tom, > I used: > pg_dumpall > db.out on my 7.4.2 server It's not a bug. Use the pg_dumpall from 8.1.4 to talk to the still-live 7.4.2 server :) Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/

[BUGS] BUG #2581: Statistics buffer is full

2006-08-19 Thread David Azevedo
The following bug has been logged online: Bug reference: 2581 Logged by: David Azevedo Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: windows 2003 server Description:Statistics buffer is full Details: Guys my problem is that my postgre

Re: [BUGS] BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8

2006-10-15 Thread David Fetter
system or other so ancient that Perl 5.8 did not come pre-installed with it, but we can't be supporting other projects backwards into eternity. Supporting our own is already plenty of work. Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1

Re: [BUGS] BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8

2006-10-15 Thread David Fetter
On Sun, Oct 15, 2006 at 04:43:17PM -0400, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > I'd like to suggest that raise that minimum requirement for Perl > > to 5.8 for 8.3, as Perl 5.8 will be about five years old by then. > > Well, we're s

Re: [HACKERS] [BUGS] BUG #2683: spi_exec_query in plperl returns

2006-10-15 Thread David Fetter
ck is mighty ugly. > > I am also wondering, now that it's been raised, if we need to issue > a "use utf8;" in the startup code, so that literals in the code get > the right encoding. That would be a reason to go to 5.8, as 'use utf8;' is tricky at best in 5.6. Cheer

Re: [BUGS] BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8

2006-10-15 Thread David Fetter
On Sun, Oct 15, 2006 at 06:12:43PM -0400, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > On Sun, Oct 15, 2006 at 04:43:17PM -0400, Tom Lane wrote: > >> ISTM the real question is what do we buy if we make such a > >> restriction? Getting rid of a f

Re: [BUGS] BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8

2006-10-15 Thread David Fetter
On Sun, Oct 15, 2006 at 07:07:18PM -0400, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > At some point, we will find something where we will have to duplicate > > some large hunk of 5.8's functionality to support 5.6. > > No, we won't; we a

Re: [BUGS] BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8

2006-10-15 Thread David Fetter
On Mon, Oct 16, 2006 at 12:10:42AM -0400, Bruce Momjian wrote: > David Fetter wrote: > > On Sun, Oct 15, 2006 at 07:07:18PM -0400, Tom Lane wrote: > > > David Fetter <[EMAIL PROTECTED]> writes: > > > > At some point, we will find something where we will have to

Re: [BUGS] BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8

2006-10-16 Thread David Fetter
On Mon, Oct 16, 2006 at 10:00:13AM -0400, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > 1. We can continue to support 5.6 until we can't any more, and > > statistically speaking that "can't any more" is quite likely to > > happen

[BUGS] BUG #2703: Cosmetic documentation error

2006-10-19 Thread David Begley
The following bug has been logged online: Bug reference: 2703 Logged by: David Begley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: n/a Description:Cosmetic documentation error Details: The release notes here: http

Re: [BUGS] Operator Classes and ANALYZE

2006-11-06 Thread David Fetter
ixed > * someday, but for now, punt. > */ > > It's in the analyze.c code, but not in the docs. Should a doc patch be in the offing here? Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666

[BUGS] JDBC driver bug PreparedStatement.setNull(int,Types.BOOLEAN)

2006-11-09 Thread David Green
the JDBC driver does not handle setNull for boolean types.   the switch statement in setNull should be expanded with a case that checks for Types.BOOLEAN  

Re: [BUGS] BUG #2889: Syntax error: WHERE ANY(arrayfield) = N

2007-01-15 Thread David Higgs
On 1/13/07, Tom Lane <[EMAIL PROTECTED]> wrote: "David" <[EMAIL PROTECTED]> writes: > This statement works: > => SELECT * FROM sal_emp WHERE 1 = ANY (pay_by_quarter); > But this does not: > => SELECT * FROM sal_emp WHERE ANY (pay_by_quarter) = 1

[BUGS] BUG #2908: ISO8601 Date / Time Format Incompatibility

2007-01-19 Thread David Lloyd
The following bug has been logged online: Bug reference: 2908 Logged by: David Lloyd Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Solaris 10 Description:ISO8601 Date / Time Format Incompatibility Details: According to the ISO standard

[BUGS] BUG #2983: Nonsense error: "Table has type interval, but query expects interval"

2007-02-11 Thread David Flater
The following bug has been logged online: Bug reference: 2983 Logged by: David Flater Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.2 Operating system: Linux Description:Nonsense error: "Table has type interval, but query expects interval&quo

[BUGS] Continuous archiving fails

2007-04-12 Thread David Darville
h exit code 1 LOG: aborting startup due to startup process failure --- David Darville ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [BUGS] Continuous archiving fails

2007-04-16 Thread David Darville
On Thu, Apr 12, 2007 at 11:05:40AM -0400, Tom Lane wrote: > David Darville <[EMAIL PROTECTED]> writes: > > While testing a continuous archiving setup using PostgreSQL 8.2.3, on Debian > > Etch amd64, I found out that the slave database crashed when I did a 'DROP &

Re: [BUGS] BUG #3228: Linux/M32R project

2007-04-17 Thread David Fetter
m: linux > Description:Linux/M32R project > Details: > > Developing Linux/M32R. Inoaka-san, Please consider submitting this as a pgfoundry project or as a porting issue on the pgsql-hackers mailing list. Regards, David. -- David Fetter <[EMAIL PROTECTED]> http://fet

Re: [BUGS] Plperl functions not re-entrant, wrong results

2007-04-30 Thread David Fetter
ded. There's a setting you can set in your postgresql.conf that will help you find these problems more automatically: custom_variable_classes = 'plperl' plperl.use_strict = true Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778

Re: [BUGS] BUG #3320: Error when using INSERT...RETURNING as a subquery

2007-05-29 Thread David Fetter
G is only supported at the top level of a query. What would be involved with making this possible? What we have at the moment is a pretty clear POLA violation because unlike the rest of the row-returning objects (tables, views, SRFs and VALUES() clauses), only RETURNING can't be used in a sub

[BUGS] BUG #3417: Foreign key constraint violation occurs unexpectedly

2007-06-28 Thread David Boesch
The following bug has been logged online: Bug reference: 3417 Logged by: David Boesch Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux Redhat Linux linux2 2.4.20-8 #1 Thu Mar 13 17:54:28 EST 2003 i686 i686 i386 GNU/Linux Description

Re: [BUGS] BUG #3417: Foreign key constraint violation occurs unexpectedly

2007-06-29 Thread David Boesch
n the result of the query brings back the one row as expected. I'll search around and try to find when and if inhertance will be supported with RI. Thanks again. Regards David On Thu, 2007-06-28 at 22:48, Gregory Stark wrote: > "David Boesch" <[EMAIL PROTECTED]>

[BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread David Flater
The following bug has been logged online: Bug reference: 3426 Logged by: David Flater Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: GNU/Linux Description:Rows disappear from complex join Details: Hello, I am getting NO DATA on

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread David Flater
> From: Tom Lane [mailto:[EMAIL PROTECTED] > > "David Flater" <[EMAIL PROTECTED]> writes: > > I installed postgresql-snapshot.tar.bz2 2007-07-03 10:18:42 from > > stable_snapshot and confirm that the problem does not reproduce there. (I > > assume t

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread David Flater
> From: Tom Lane [mailto:[EMAIL PROTECTED] > > "David Flater" <[EMAIL PROTECTED]> writes: > > I am getting NO DATA on queries that attempt to match one of the "outer" > > rows generated by an outer join. > > Your test case works fine fo

[BUGS] BUG #3606: Query Plan Failure or Index Corruption?

2007-09-07 Thread David Tulloss
The following bug has been logged online: Bug reference: 3606 Logged by: David Tulloss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows Description:Query Plan Failure or Index Corruption? Details: I have a very complex view that is

[BUGS] BUG #3661: Missing equality comparator: string = integer

2007-10-09 Thread David Bachmann
The following bug has been logged online: Bug reference: 3661 Logged by: David Bachmann Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3-beta1 Operating system: Windows XP Description:Missing equality comparator: string = integer Details: This does not

Re: [BUGS] The PostgreSQL Data directory Must be on an NTFS formatted Volume

2007-10-26 Thread David Fetter
t you need to do. Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate ---

Re: [BUGS] BUG #3729: Query doesn't return the right answer

2007-11-08 Thread David Fetter
ou don't know whether they will be NULL when you write the SQL, use constructs like WHERE foo IS NOT DISTINCT FROM $1 Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTE

[BUGS] BUG #3873: Install error - could not load pljava.dll

2008-01-14 Thread David Gradwell
The following bug has been logged online: Bug reference: 3873 Logged by: David Gradwell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3rc1 Operating system: Windows Server 2003 Description:Install error - could not load pljava.dll Details: While running

[BUGS] BUG #3879: OS X Start Script should not `cd /Users/postgres`

2008-01-16 Thread David Wheeler
The following bug has been logged online: Bug reference: 3879 Logged by: David Wheeler Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC1 Operating system: Mac OS X 10.5.1 Description:OS X Start Script should not `cd /Users/postgres` Details: The Mac OS X

[BUGS] BUG #3872: backslash_quote = off doesn't work any more

2008-01-16 Thread David Gradwell
The following bug has been logged online: Bug reference: 3872 Logged by: David Gradwell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3-beta3 Operating system: Windows Server 2003 Description:backslash_quote = off doesn't work any more Details:

Re: [BUGS] BUG #3891: Multiple UPDATE doesn't handle UNIQUE constraint correctly

2008-01-21 Thread David Fetter
2 X > > Now, we update table A with values from temporary table temp_A doing > something like > > UPDATE "A" SET "Name" = "temp_A"."Name" FROM "temp_A" WHERE "A".record_id = > "temp_A".record_id

[BUGS] BUG #3897: plJava dll still doesn't load

2008-01-23 Thread David Gradwell
The following bug has been logged online: Bug reference: 3897 Logged by: David Gradwell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3rc2 Operating system: Windows Server 2003 Description:plJava dll still doesn't load Details: I've successfully

[BUGS] BUG #3905: configure cannot find ossp UUID libs and/or includes

2008-01-27 Thread David Wheeler
The following bug has been logged online: Bug reference: 3905 Logged by: David Wheeler Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC2 Operating system: Mac OS X 10.5 Description:configure cannot find ossp UUID libs and/or includes Details: I&#x

  1   2   3   4   >