[BUGS] BUG #8518: FreeBSD usage in 9.3.1

2013-10-11 Thread david . kumar
The following bug has been logged on the website: Bug reference: 8518 Logged by: david Email address: david.ku...@vsoftcorp.com PostgreSQL version: 9.3.1 Operating system: Windows 7 Description: Hi All, I had tried using FreeBSD disk encryption but unable to find

[BUGS] Re: BUG #8512: Can't use columns I can't read in the where clause of a select

2013-10-08 Thread David Johnston
contexts require SELECT-like privileges if the column is used there. But not if the column only exists as a target-column. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-8512-Can-t-use-columns-I-can-t-read-in-the-where-clause-of-a-select-tp5773752p5773757

Re: [BUGS] select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619

2013-09-26 Thread David Rennalls
David Fetter david at fetter.org writes: Upgrade to 9.1.3 and let us know whether that fixes the problem. I've run into this issue as well on postgres 8.4.14. Aside from upgrading to a newer release is there any manual fixup that can be done ? Thanks, David -- Sent via pgsql-bugs

Re: [BUGS] select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619

2013-09-26 Thread David Rennalls
INFO: analyzing information_schema.sql_features INFO: sql_features: scanned 7 of 7 pages, containing 649 live rows and 0 dead rows; 649 rows in sample, 649 estimated total rows ERROR: missing chunk number 0 for toast value 33255 in pg_toast_2619 - David -- Sent via pgsql-bugs mailing list

Re: [BUGS] select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619

2013-09-26 Thread David Rennalls
On Thu, Sep 26, 2013 at 4:19 PM, David Rennalls drenna...@gmail.com wrote: On Thu, Sep 26, 2013 at 3:40 PM, Kim Applegate kappleg...@apsalar.com wrote: I have seen this issue on a slave although it was in version 9.2. I ran oh ok. Looks like the issue was fixed in 8.2.23 according

[BUGS] Re: BUG #8444: ERROR: table name tblb specified more than once in subquery

2013-09-13 Thread David Johnston
Tom Lane-2 wrote David Johnston lt; polobo@ gt; writes: Here is a minimal query that demonstrates the problem. In 9.1 it works: chris=# select * FROM current_user u join (current_user u cross join current_user v) x on true; On 9.3 it fails: ERROR: table name u specified more than

[BUGS] Re: BUG #8444: ERROR: table name tblb specified more than once in subquery

2013-09-12 Thread David Johnston
A much more simple example courtesy of Chris Travers from the original -general thread that I suggested be moved to -bugs. Here is a minimal query that demonstrates the problem. In 9.1 it works: chris=# select * FROM current_user u join (current_user u cross join current_user v) x on true;

Re: [BUGS] BUG #8381: data base inconsistancy

2013-08-14 Thread David Fetter
level (Read Committed) PostgreSQL 8.1 has been unsupported since 2010. Once you've upgraded to a supported version, if the problem persists, we may be able to help. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [BUGS] with recursive ignores side effects?

2013-08-06 Thread David Johnston
hierarchical data but said hierarchy remains static for the duration of the query. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/with-recursive-ignores-side-effects-tp5766555p5766565.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com

Re: [BUGS] PGSQL Bug

2013-07-18 Thread David Johnston
am not that strong a linux user but it does seem you need to provide considerably more detail as to your install/configuration if you expect help resolving your issue. Specifically, HOW did you install PostgreSQL and what configuration steps have you performed. David J. -- View this message

[BUGS] BUG #8228: Unexpected set-valued function with varchar(n) but not varchar

2013-06-13 Thread david . g . johnston
The following bug has been logged on the website: Bug reference: 8228 Logged by: David Johnston Email address: david.g.johns...@gmail.com PostgreSQL version: 9.0.13 Operating system: Ubuntu Linux 10.04 Description: The following query results in SQL Error: ERROR: set

Re: [BUGS] BUG #8228: Unexpected set-valued function with varchar(n) but not varchar

2013-06-13 Thread David Johnston
one accepting the parameter is nice since you can toggle global/single within the same query - but in many use-cases only the single-match mode is desired. Are there any other functions that have this same risk profile that would increase the applicability of such a patch? David J.

Re: [BUGS] BUG #8211: Syntax error when creating index on expression

2013-06-05 Thread David Johnston
worth considering. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-8211-Syntax-error-when-creating-index-on-expression-tp5758030p5758040.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com. -- Sent via pgsql-bugs mailing list (pgsql

[BUGS] Re: 9.2.4: Strange behavior when wildcard is on left side of search string

2013-04-06 Thread David Johnston
via the full-text search capabilities. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/9-2-4-Strange-behavior-when-wildcard-is-on-left-side-of-search-string-tp5751086p5751095.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com. -- Sent

[BUGS] BUG #7885: postmaster panic on startup does not release shared memory

2013-02-15 Thread david . thomas
The following bug has been logged on the website: Bug reference: 7885 Logged by: David Thomas Email address: david.tho...@enterprisedb.com PostgreSQL version: 9.2.3 Operating system: CentOS 6.3 Description: It seems that if the postmaster encounters a PANIC condition

Re: [BUGS] BUG #7885: postmaster panic on startup does not release shared memory

2013-02-15 Thread David Thomas
and thus release the shmem segment.) Yup, if I attempt to start the cluster normally, it cleans up after itself, so this is specific to --single mode. -- David Thomas System Engineer EnterpriseDB - The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #7793: tsearch_data thesaurus size limit

2013-01-11 Thread David Boutin
(LexemeInfo *stored, *uint32* idsubst) { bool res = true; Kind regards. David On Mon, Jan 7, 2013 at 1:41 AM, Tom Lane t...@sss.pgh.pa.us wrote: dav...@gmail.com writes: [ thesaurus dictionary fails for more than 64K entries ] I see a whole bunch of uses of uint16 in src/backend

[BUGS] Re: BUG #7784: trouble with pl ERROR: missing FROM-clause entry for table

2013-01-03 Thread David Johnston
simply putting out the entire code without any commentary makes it more difficult for people to provide help. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-7784-trouble-with-pl-ERROR-missing-FROM-clause-entry-for-table-tp5738676p5738698.html Sent from

{Not A Bug} RE: [BUGS] BUG #7685: last_value() not consistent throughout window partition

2012-11-20 Thread David Johnston
and explore from there David J. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [GENERAL] [BUGS] Prepared Statement Name Truncation

2012-11-18 Thread David Johnston
- particularly around the usage of truncate/delete/drop. Thought: would there be some way to flag a table like this to always require the use of a schema prefix to be accessed (since right now truncated names only have to be schema unique) in certain conditions (drop, delete, truncate)? David J

[BUGS] BUG #7596: Problem with /etc/init.d/postgresql.9.x file

2012-10-11 Thread david . peyrieres
The following bug has been logged on the website: Bug reference: 7596 Logged by: David PEYRIERES Email address: david.peyrie...@meteo.fr PostgreSQL version: 9.1.4 Operating system: Red Hat Description: Hello. I found a little bug in /etc/init.d/postgresql-9.x file

[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

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

2012-06-11 Thread David Fetter
On Mon, Jun 11, 2012 at 05:51:06PM +0200, Magnus Hagander wrote: On Mon, Jun 11, 2012 at 5:14 PM, da...@fetter.org wrote: The following bug has been logged on the website: Bug reference:      6687 Logged by:          David Fetter Email address:      da...@fetter.org PostgreSQL

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

2012-06-11 Thread David Fetter
On Mon, Jun 11, 2012 at 06:04:22PM +0200, Magnus Hagander wrote: On Mon, Jun 11, 2012 at 6:01 PM, David Fetter da...@fetter.org wrote: On Mon, Jun 11, 2012 at 05:51:06PM +0200, Magnus Hagander wrote: On Mon, Jun 11, 2012 at 5:14 PM,  da...@fetter.org wrote: The following bug has been

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

2012-06-11 Thread David Fetter
On Mon, Jun 11, 2012 at 06:21:43PM +0200, Magnus Hagander wrote: On Mon, Jun 11, 2012 at 6:14 PM, David Fetter da...@fetter.org wrote: On Mon, Jun 11, 2012 at 06:04:22PM +0200, Magnus Hagander wrote: On Mon, Jun 11, 2012 at 6:01 PM, David Fetter da...@fetter.org wrote: On Mon, Jun 11, 2012

Re: [BUGS] BUG #6638: Casablanca timezone is wrong

2012-05-14 Thread David Chuet
Thanks guys for your prompt support! I'm going to update Olson library on the concerned computer using the latest files. Thanks again. David Chuet Odotech inc. -Original Message- From: Heikki Linnakangas [mailto:heikki.linnakan...@enterprisedb.com] Sent: May-14-12 11:51 AM To: David

Re: [BUGS] Re: select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619

2012-05-03 Thread David Fetter
Upgrade to 9.1.3 and let us know whether that fixes the problem. Cheers, David. On Wed, May 02, 2012 at 09:58:16PM -0700, leo xu wrote: pg version is 9.1.2 -- View this message in context: http://postgresql.1045698.n5.nabble.com/select-table-indicate-missing-chunk-number-0-for-toast-value

Re: [BUGS] [ADMIN] Repeatable crash in pg_dump (with -d2 info)

2012-01-17 Thread David Schnur
' binaries rather than compiling from source, or link against the dynamic runtime. Is this something I could expect to be fixed in the near future, or is it enough of an edge case that I should come up with some solution or work-around on my own? Thanks, David On Mon, Nov 28, 2011 at 8:00 PM, Tom Lane t

Re: [BUGS] Proble Postgre SQL version 7.4.1

2012-01-05 Thread David Fetter
, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

[BUGS] BUG #6292: java.sql.PreparedStatement.setNull() throws PSQLException

2011-11-14 Thread David Pinheiro
The following bug has been logged online: Bug reference: 6292 Logged by: David Pinheiro Email address: davidsantospinhe...@gmail.com PostgreSQL version: 8.4 Operating system: Linux Description:java.sql.PreparedStatement.setNull() throws PSQLException Details: I'm

[BUGS] reporting weirdness in configure output

2011-09-26 Thread David Baumgold
byte ordering is bigendian... universal snip The compilation finished successfully, in spite of this warning. This is on an early 2008 Macbook Pro, 2.4GHz Intel Core 2 Duo processor, running Mac OS X Lion 10.7.1. Please let me know if you need any more information. -David Baumgold -- Sent via

[BUGS] BUG #6131: Query Returning Incorrect Results

2011-07-26 Thread David Johnston
The following bug has been logged online: Bug reference: 6131 Logged by: David Johnston Email address: pol...@yahoo.com PostgreSQL version: 9.0.4 Operating system: Windows 7 64-bit Description:Query Returning Incorrect Results Details: The embedded script exhibits

Re: [BUGS] BUG #6131: Query Returning Incorrect Results

2011-07-26 Thread David Johnston
-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Tuesday, July 26, 2011 7:42 PM To: David Johnston Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6131: Query Returning Incorrect Results David Johnston pol...@yahoo.com writes: The embedded script exhibits

[BUGS] BUG #6113: SET DATESTYLE='European' does not set datestyle output correctly

2011-07-11 Thread David Carlos Manuelda
The following bug has been logged online: Bug reference: 6113 Logged by: David Carlos Manuelda Email address: stormb...@gmail.com PostgreSQL version: 9.0.4 Operating system: Gentoo Linux Description:SET DATESTYLE='European' does not set datestyle output correctly

[BUGS] BUG #6094: Streaming replication does not catch up when writing enough data

2011-07-07 Thread David Hartveld
The following bug has been logged online: Bug reference: 6094 Logged by: David Hartveld Email address: david.hartv...@mendix.com PostgreSQL version: 9.1-beta2 Operating system: Debian GNU/Linux 6.0.2 Squeeze Description:Streaming replication does not catch up when

Re: [HACKERS] [BUGS] BUG #6083: psql script line numbers incorrectly count \copy data

2011-07-04 Thread David Fetter
a separate file. The attached patch seems like an appropriate fix. However, I'm unsure whether to apply it to released branches ... does anyone think this might break somebody's application? No. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

[BUGS] ¿Está el servidor en ejecución localmente y aceptando conexiones en el socket de dominio Unix /tmp/.s.PGSQL.5432?

2011-06-20 Thread David Hernández
Hola, estoy desesperado, no consigo levantar postgresql en Opensuse, me sale el siguiente error al intentar levantar el servicio: psql: no se pudo conectar con el servidor: No exite el fichero o el directorio ¿Está el servidor en ejecución localmente y aceptando conexiones en el socket de

[BUGS] BUG #6067: In PL/pgsql, EXISTS(SELECT ... INTO...) fails

2011-06-18 Thread David Fetter
The following bug has been logged online: Bug reference: 6067 Logged by: David Fetter Email address: dfet...@vmware.com PostgreSQL version: 9.0.4 Operating system: Linux Description:In PL/pgsql, EXISTS(SELECT ... INTO...) fails Details: Here's some example code

Re: [BUGS] BUG #6051: wCTE query fail with wrong error text on a table with rules

2011-06-06 Thread David Fetter
rewrite rules isn't the right direction to go, as we're well on our way to phasing the user-modifiable part out. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal

[BUGS] BUG #6003: Cannot have a constraint foreign key on master class with inheritance

2011-05-03 Thread David carlos Manuelda
The following bug has been logged online: Bug reference: 6003 Logged by: David carlos Manuelda Email address: stormb...@gmail.com PostgreSQL version: 9.0.3 Operating system: Gentoo Linux Description:Cannot have a constraint foreign key on master class

Re: [BUGS] BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases

2011-03-03 Thread David Schmitt
On 03.03.2011 16:08, Robert Haas wrote: On Tue, Feb 8, 2011 at 2:19 AM, David Schmittda...@dasz.at wrote: Example query: SELECT column as zurück FROM table; results in corruption of the ü (umlaut u). This causes Npgsql to fail to match up the columns in the result set (see http

[BUGS] BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases

2011-02-08 Thread David Schmitt
The following bug has been logged online: Bug reference: 5869 Logged by: David Schmitt Email address: da...@dasz.at PostgreSQL version: 8.4.5 Operating system: Windows 7 Description:postgresql corrupts unquoted non-ascii chars in column aliases Details: Example

[BUGS] BUG #5846: Segfault Postgresql Built with --lib-libedit-preferred

2011-01-24 Thread David E. Wheeler
The following bug has been logged online: Bug reference: 5846 Logged by: David E. Wheeler Email address: da...@kineticode.com PostgreSQL version: 9.0.1 Operating system: Mac OS X 10.6.6 Description:Segfault Postgresql Built with --lib-libedit-preferred Details

Re: [BUGS] BUG #5846: Segfault Postgresql Built with --lib-libedit-preferred

2011-01-24 Thread David E. Wheeler
ago. Anyone got a test case that doesn't involve building PostgreSQL? Thanks, David -- 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] Regular issues faced on postgres 8.1

2011-01-21 Thread David Fetter
software or system. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

[BUGS] BUG #5836: Enum Support Functions don't work on empty tables

2011-01-13 Thread David Pinheiro
The following bug has been logged online: Bug reference: 5836 Logged by: David Pinheiro Email address: davidsantospinhe...@gmail.com PostgreSQL version: 8.4 Operating system: Centos Description:Enum Support Functions don't work on empty tables Details

[BUGS] BUG #5775: DBLINK Connection String Truncation

2010-11-29 Thread David Quinn-Jacobs
The following bug has been logged online: Bug reference: 5775 Logged by: David Quinn-Jacobs Email address: d...@ecornell.com PostgreSQL version: 9.0.1 Operating system: Cent OS 5 Description:DBLINK Connection String Truncation Details: Causes connection failure

Re: [BUGS] BUG #5754: CTE optimization fails to account for side effects

2010-11-20 Thread David Fetter
On Mon, Nov 15, 2010 at 06:55:47PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: CREATE SEQUENCE my_seq; WITH t AS (SELECT nextval('my_seq')) VALUES(1); SELECT currval('my_seq'); ERROR: currval of sequence my_seq is not yet defined in this session What's happened

[BUGS] BUG #5754: CTE optimization fails to account for side effects

2010-11-15 Thread David Fetter
The following bug has been logged online: Bug reference: 5754 Logged by: David Fetter Email address: da...@fetter.org PostgreSQL version: 8.4+ Operating system: All Description:CTE optimization fails to account for side effects Details: Here's how to reproduce

Re: [BUGS] rollback to savepoint leads to transaction already in progress

2010-10-14 Thread David Newall
On 14/10/10 12:14, Itagaki Takahiro wrote: Which solution is better? Or, another idea? This does seem to be an new bug in previously working code. While any solution that fixes the problem is good, it might pay to look the code that worked before. As reported, it worked for ecpg

Re: [BUGS] rollback to savepoint leads to transaction already in progress

2010-10-14 Thread David Newall
in progress Date: Thu, 14 Oct 2010 10:44:50 +0900 From: Itagaki Takahiroitagaki.takah...@gmail.com To: David Newallpostgre...@davidnewall.com, PostgreSQL Hackers pgsql-hack...@postgresql.org CC: pgsql-bugs@postgresql.org On Mon, Oct 11, 2010 at 7:42 AM, David Newall postgre...@davidnewall.com

[BUGS] rollback to savepoint leads to transaction already in progress

2010-10-10 Thread David Newall
with ecpg (PostgreSQL 8.3.8) 4.4.1 Regards, David -- 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 #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-24 Thread David Schmitt
On 9/23/2010 9:53 PM, Tom Lane wrote: David Schmittda...@dasz.at writes: Executing the attached example.sql on a fresh database demonstrates the problem I'm seeing: Found it. If you need a patch right away, it's a one-liner: diff --git a/src/backend/optimizer/path/allpaths.c b/src/backend

[BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-23 Thread David Schmitt
The following bug has been logged online: Bug reference: 5673 Logged by: David Schmitt Email address: da...@dasz.at PostgreSQL version: 8.4.4 Operating system: Windows 7 Description:Optimizer creates strange execution plan leading to wrong results Details

Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-23 Thread David Schmitt
On 9/23/2010 5:33 PM, Tom Lane wrote: David Schmittda...@dasz.at writes: Description:Optimizer creates strange execution plan leading to wrong results Please supply a self-contained example demonstrating the incorrect results. The information you've provided is completely inadequate

[BUGS] BUG #5647: COPY TO does not respect the [standard_conforming_strings] setting

2010-09-07 Thread David Sahagian
The following bug has been logged online: Bug reference: 5647 Logged by: David Sahagian Email address: david.sahag...@gmail.com PostgreSQL version: 9.0 beta4 Operating system: win XP Description:COPY TO does not respect the [standard_conforming_strings] setting

Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers

2010-09-07 Thread David Platt
the documentation indicated that the path to the shared library had to be declared because I don't remember any example showing $library. -Original Message- From: Bruce Momjian [mailto:br...@momjian.us] Sent: Tuesday, September 07, 2010 10:30 PM To: Tom Lane Cc: David Platt; pgsql-bugs

Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers

2010-09-07 Thread David Platt
. -Original Message- From: Bruce Momjian [mailto:br...@momjian.us] Sent: Tuesday, September 07, 2010 9:54 PM To: David Platt Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers David Platt wrote: The following bug has

[BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers

2010-09-04 Thread David Platt
The following bug has been logged online: Bug reference: 5642 Logged by: David Platt Email address: davidpl...@davidplatt.com PostgreSQL version: 9.0 RC1 Operating system: CentOS 5.5 Description:pg_upgrade does not handle shared libraries for language handlers

Re: [BUGS] BUG #5631: psql dumps core during command editing

2010-08-28 Thread David L Kensiski
| readline_echoing_p [866] |22165210|0010|OBJT |GLOB |0|19 | rl_readline_name On Aug 27, 2010, at 9:38 PM, Tom Lane wrote: David Kensiski da...@schoolloop.com writes: The psql binary (64-bit from binary install) dumps core when I attempt to edit the input line after a few

[BUGS] BUG #5631: psql dumps core during command editing

2010-08-27 Thread David Kensiski
The following bug has been logged online: Bug reference: 5631 Logged by: David Kensiski Email address: da...@schoolloop.com PostgreSQL version: 8.4 Operating system: Solaris 10 Description:psql dumps core during command editing Details: The psql binary (64-bit from

[BUGS] BUG #5616: psql Doesn't Change Log files on \c

2010-08-12 Thread David E. Wheeler
The following bug has been logged online: Bug reference: 5616 Logged by: David E. Wheeler Email address: da...@kineticode.com PostgreSQL version: 8.4 Operating system: Mac OS X 10.6.4 Description:psql Doesn't Change Log files on \c Details: I have this in my

Re: [HACKERS] Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-05 Thread David E. Wheeler
BY at the end ;-)) but at least it should get people pointed in the right direction when they do this. It confuses the shit out of me. It says string_agg(text) doesn't exist when that clearly is not the name of the function you've called. Best, David -- Sent via pgsql-bugs mailing list (pgsql

Re: [HACKERS] Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-05 Thread David E. Wheeler
when that clearly is not the name of the function you've called. What function name do you believe was called? The message says: string_agg(f1 order by f1, ',') That looks like string_agg(text, text) or string_agg(anyelement, text). Best, David -- Sent via pgsql-bugs mailing list

Re: [HACKERS] Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-05 Thread David E. Wheeler
was still a prerequisite thing, because without it there is no error that we can complain about. Yeah, understood. Best, David -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [HACKERS] Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-05 Thread David E. Wheeler
On Aug 5, 2010, at 12:16 PM, Tom Lane wrote: HINT: No aggregate function matches the given name and argument types. Perhaps you misplaced ORDER BY; ORDER BY must appear after all regular arguments of the aggregate. +1 David -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [HACKERS] Re: Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-04 Thread David Fetter
... er.. man witch... warlock? Witch. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote

Re: [HACKERS] Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-04 Thread David Fetter
an opinion on making this change: for: tgl, josh, badalex, mmoncure against: rhaas, thom Anybody else want to vote, or change their vote after seeing the patch? +1 for removing the single-argument version. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [BUGS] BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'

2010-07-12 Thread David Schmitt
On 7/9/2010 4:53 PM, Tom Lane wrote: David Schmittda...@dasz.at writes: This is not implemented: DECLARE working_cursor NO SCROLL CURSOR FOR EXECUTE $$SELECT something $$ || tbl || $$ ... $$; What's wrong with OPEN FOR EXECUTE? The proposed addition seems a bit weird anyway since

[BUGS] BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'

2010-07-09 Thread David Schmitt
The following bug has been logged online: Bug reference: 5549 Logged by: David Schmitt Email address: da...@dasz.at PostgreSQL version: 8 and 9 Operating system: n/a Description:Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...' Details

Re: [BUGS] BUG #5497: plpythonu gives cache lookup error

2010-06-10 Thread David Gardner
Thanks, was able to rebuild plpython.so and it works. Also mapping SQL Arrays to Python lists is awesome. On 06/09/2010 09:05 PM, Tom Lane wrote: David Gardnerdgard...@creatureshop.com writes: Description:plpythonu gives cache lookup error Fixed, thanks for the report

[BUGS] BUG #5497: plpythonu gives cache lookup error

2010-06-09 Thread David Gardner
The following bug has been logged online: Bug reference: 5497 Logged by: David Gardner Email address: dgard...@creatureshop.com PostgreSQL version: 9.0beta2 Operating system: Debian Linux Description:plpythonu gives cache lookup error Details: hdpsdb=# CREATE

Re: [BUGS] BUG #5488: pg_dump does not quote column names - pg_restore may fail when upgrading

2010-06-04 Thread David Fetter
to quote them too, which I doubt many do. It seems like something that's doable by pg_dump as a default off option. TODO for 9.1? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

[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

Re: [BUGS] bug or regression in plpgsql vs word window, your choice

2010-03-16 Thread David E. Wheeler
words. Best, David -- 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 #5356: citext not acting like case insensitive search

2010-03-01 Thread David E. Wheeler
from iss.citystateinfo where cityname = 'Jacksonville' and statecode = 'FL' The second query is how the data is actually stored. I've already forwarded our ddl to david wheeler. Michael managed to fix this issue by moving citext to the public schema. The question is, why would citext

Re: [BUGS] BUG #5356: citext not acting like case insensitive search

2010-03-01 Thread David E. Wheeler
would like. Yes, I suspect that he can solve his problem by adding the iss schema to search_path. Best, David -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[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
../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 t...@sss.pgh.pa.us wrote: David Andersen david.ander...@andersen-innovation.com writes: [ initdb fails with ] initdb: directory ../data exists

Re: [BUGS] New PL/Perl failure with Safe 2.2x due to recursion (8.x 9.0)

2010-02-25 Thread David E. Wheeler
out via straight Safe tonight. I think Tom meant, what sorts of changes to PostgreSQL do you think might solve the problem? Best, David -- 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] New PL/Perl failure with Safe 2.2x due to recursion (8.x 9.0)

2010-02-25 Thread David E. Wheeler
hope that Safe can be updated in the near future to give us both. There seem to be no good answers here. David -- 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] New PL/Perl failure with Safe 2.2x due to recursion (8.x 9.0)

2010-02-25 Thread David E. Wheeler
? I'm happy to rebuild Perl without threads, since I'm not going to use Padre after all. But that won't help the millions who rely on package-supplied Perls, which are nearly always threaded AFAICT. Best, David -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] New PL/Perl failure with Safe 2.2x due to recursion (8.x 9.0)

2010-02-25 Thread David E. Wheeler
when *not* under threads as well? I find this all very confusing, frankly. Best, David -- 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] New PL/Perl failure with Safe 2.2x due to recursion (8.x 9.0)

2010-02-25 Thread David E. Wheeler
hope that Safe can be updated in the near future to give us both. There seem to be no good answers here. David -- 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] New PL/Perl failure with Safe 2.2x due to recursion (8.x 9.0)

2010-02-24 Thread David E. Wheeler
. What you're saying, IIUC, is that if function A calls function B via a SPI command, and B wasn't executed previously in the current session, it would fail? Seems entirely unacceptable. Exactly what I was thinking. This fix is right out. Best, David -- Sent via pgsql-bugs mailing list (pgsql

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

2010-02-22 Thread David Fetter
something like the below? Basically If we find This is perl v4 we bail right then. Otherwise we use the version check I proposed up-thread? I may have inadvertently used some bash/gnu-isms... sorry about that. *** a/configure --- b/configure Edit configure.in, not configure :) Cheers, David

Re: [Tigerlead] [BUGS] BUG #5334: Version 2.22 of Perl Safe module breaks UTF8 PostgreSQL 8.4

2010-02-19 Thread David E. Wheeler
such that PostgreSQL would work without changes. Hrm. I don't have this bug with Safe 3.19, FWIW. Best, David -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [Tigerlead] [BUGS] BUG #5334: Version 2.22 of Perl Safe module breaks UTF8 PostgreSQL 8.4

2010-02-19 Thread David E. Wheeler
without a problem. Oh, so 2.19 is less secure in that regard, yes? David -- 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 #5277: plperl can't get args properly

2010-01-14 Thread David E . Wheeler
, you can downgrade to Safe.pm 2.19 and the problem will go away. Or just use PL/Perlu, which doesn't rely on Safe.pm. Best, David -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Termination When Switching between PL/Perl and PL/PerlU

2010-01-13 Thread David E. Wheeler
Found in 8.4.2, replicated in HEAD. Steps: 1. Create PL/Perl function. 2. Run it. 3. Create same function with PL/PerlU 4. Run it. 5. Create same function again with PL/Perl 6. Boom. Example on HEAD built today (ignore the error from the plperl version, that's the issue I'm trying to fix

[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

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

2009-12-15 Thread David Fetter
directly. In cases where you have a problem with things outside the PostgreSQL database itself, check the available a href=/community/listsmailing lists/a and see if there is a more appropriate list available. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

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

2009-12-15 Thread David Fetter
/a and see if there is a more apropriate list available. This is better than what I sent :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com

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

2009-12-03 Thread David Gardner
this works: 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 dgard...@creatureshop.com writes

[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

Re: [BUGS] BUG #5150: math bug

2009-10-30 Thread David Fetter
and hence has Lebesgue measure zero on the real line. /nit ;) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

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

2009-10-16 Thread David Fetter
| 1 | 2 3 | 1 | 3 (3 rows) fist_value - good, last_value - bad Looks ok to me. What did you expect? 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. Cheers, David. -- David

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 da...@fetter.org 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 as anybody here can

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

2009-09-29 Thread David Fetter
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 Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

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

2009-09-21 Thread David Fetter
hours after the rest of the code? Cheers, David. -- David Fetter da...@fetter.org 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://www.postgresql.org/about/donate

  1   2   3   >