Re: [BUGS] Botched estimation in eqjoinsel_semi for cases without reliable ndistinct

2012-01-11 Thread Tom Lane
to estimate with inadequate stats. regards, tom lane -- 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] Botched estimation in eqjoinsel_semi for cases without reliable ndistinct

2012-01-11 Thread Tom Lane
Andres Freund and...@anarazel.de writes: On Thursday, January 12, 2012 01:01:01 AM Tom Lane wrote: Looks pretty bogus to me. You're essentially assuming that the side of the join without statistics is unique, which is a mighty dubious assumption. It sure is a bit dubious. But assuming

Re: [BUGS] BUG #6390: maximum data limit of Postgres.

2012-01-10 Thread Tom Lane
regards, tom lane -- 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 #6385: extract epoch at timezone returns wrong value

2012-01-08 Thread Tom Lane
-8601 convention that positive timezone offsets are east of Greenwich. This is not a bug, or at least not our bug --- we're just doing the best we can to cope with inconsistent standards documents. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] [PATCH v3] Use CC atomic builtins on ARM

2012-01-07 Thread Tom Lane
Martin Pitt mp...@debian.org writes: Tom Lane [2011-12-21 10:55 -0500]: For the moment I'm inclined to consider using these functions *only* on ARM, so as to limit our exposure to such bugs. That would also limit the risk of using an inappropriate choice of lock width. OK, fair enough. New

Re: [BUGS] BUG #6384: pg_types_date.h does not exist

2012-01-06 Thread Tom Lane
be pgtypes_date.h Fixed, thanks for the report! regards, tom lane -- 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 #6381: Incorrect greediness behavior in certain regular expressions

2012-01-05 Thread Tom Lane
-- {,:,//,blahblah.com,/} although I cannot tell whether that generalizes to your real problem. regards, tom lane -- 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 #6378: exceeding memory usage while creating index in pg-9.1.2

2012-01-04 Thread Tom Lane
in a hurry the patch is here: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6cf639dfbddbc44d027730ad1504886312bc905a regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [BUGS] BUG #6379: SQL Function Causes Back-end Crash

2012-01-04 Thread Tom Lane
it by keeping a separate private copy of the dest pointer. However, it would also be fair to ask whether there's not a cleaner solution. Perhaps the intoRel stuff should be saving/restoring the original destreceiver instead of just blindly overwriting it. regards, tom lane -- Sent

Re: [BUGS] BUG #6379: SQL Function Causes Back-end Crash

2012-01-04 Thread Tom Lane
I wrote: Perhaps the intoRel stuff should be saving/restoring the original destreceiver instead of just blindly overwriting it. I concluded that was the best fix, and have committed it. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] [PATCH] Prevent hanging on unreachable hosts on startup

2012-01-04 Thread Tom Lane
not sure how much there is to be done about that case, since there's probably no good way to distinguish it from a query that takes a really long time. But if we're going to think about this, we might as well think about all the cases. regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #6372: Error while creating database with fsync parameter as on incase of CIFS

2012-01-02 Thread Tom Lane
for asserting we don't support CIFS in general? It's probably not terribly bulletproof, but any worse than NFS? regards, tom lane -- 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 #6372: Error while creating database with fsync parameter as on incase of CIFS

2012-01-02 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Mon, Jan 2, 2012 at 21:14, Tom Lane t...@sss.pgh.pa.us wrote: I'm wondering what's your basis for asserting we don't support CIFS in general? It's probably not terribly bulletproof, but any worse than NFS? Yes, it is a lot worse than NFS from

Re: [BUGS] BUG #6372: Error while creating database with fsync parameter as on incase of CIFS

2012-01-02 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Mon, Jan 2, 2012 at 21:28, Tom Lane t...@sss.pgh.pa.us wrote: it seems like EINVAL is a considerably more reasonable thing to return than EBADF, if the filesystem is trying to tell you that it won't fsync a directory. So I'm a bit surprised

Re: [BUGS] BUG #6372: Error while creating database with fsync parameter as on incase of CIFS

2012-01-02 Thread Tom Lane
moments before. regards, tom lane -- 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 #6365: Memory leak in insert and update

2011-12-29 Thread Tom Lane
. regards, tom lane -- 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 #6365: Memory leak in insert and update

2011-12-29 Thread Tom Lane
Merlin Moncure mmonc...@gmail.com writes: On Thu, Dec 29, 2011 at 2:10 PM, Tom Lane t...@sss.pgh.pa.us wrote: I see no memory leak with this example. This is by the way a FAQ: http://wiki.postgresql.org/wiki/FAQ#Why_does_PostgreSQL_use_so_much_memory.3F Well, to be fair, the FAQ entry didn't

Re: [BUGS] simultaneous autovacuum and postmaster crash

2011-12-28 Thread Tom Lane
. (Speaking of which, does that box have ECC memory?) regards, tom lane -- 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 #6362: pg_ctl register puts wrong slash in

2011-12-28 Thread Tom Lane
tracy.ander...@teamquest.com writes: Intermixed slashes caused Backup Exec to fail. That sounds like Symantec's bug, not ours. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #6360: with hold cursor, cause function executed twice and wrong results

2011-12-27 Thread Tom Lane
rewind and rescan the cursor (ie, MOVE BACKWARD ALL and re-fetch), the function would be executed multiple times too. If you don't want that to happen, the best way would be to commit the transaction immediately, not fetch some rows and then commit. regards, tom lane

Re: [BUGS] converting between infinity timestamp and float8 (epoch)

2011-12-27 Thread Tom Lane
calculation steps as-is, whereas NaN might have less predictable behavior. There was also some support for throwing an error in the previous thread, though I can't say I like that answer myself. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] Cannot drop database because of AUTOVACUUM

2011-12-24 Thread Tom Lane
issue a DROP against its database (or table, for that matter). If there's a bug here, you've not explained what it is. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [BUGS] BUG #6341: Packaging - virtual provides postgres without version

2011-12-23 Thread Tom Lane
things depending on usage regarding this methodology). The PostgreSQL project doesn't have any direct control over Red Hat's spec files, although Tom Lane, a PostgreSQL core team member, also works at Red Hat. I would suggest that you take this up with Red Hat directly

Re: [BUGS] BUG #6351: ERROR: btree index keys must be ordered by attribute

2011-12-22 Thread Tom Lane
the possibility of exclusion constraints naming the same column more than once, which may explain why nobody tried using such an index for queries. I'll see about fixing this in HEAD, although my initial guess is that it will be too invasive to back-patch. regards, tom lane

Re: [BUGS] BUG #6353: If there is invalid line in pg_hba.conf, DB start fails without any nofice and no logs in pgstartup.

2011-12-22 Thread Tom Lane
some very old versions of selinux policy would sometimes block postgres log messages, for example. If you've got selinux enabled it'd be worth checking for avc messages in the kernel logs. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] [PATCH v2] Use CC atomic builtins as a fallback

2011-12-21 Thread Tom Lane
Martin Pitt mp...@debian.org writes: Tom Lane [2011-12-20 21:14 -0500]: Another thing that is bothering me is that according to the gcc manual, eg here, http://gcc.gnu.org/onlinedocs/gcc-4.1.2/gcc/Atomic-Builtins.html __sync_lock_test_and_set is nominally provided for datatypes 1, 2, 4, or 8

Re: R: R: R: R: R: [BUGS] BUG #6342: libpq blocks forever in poll function

2011-12-21 Thread Tom Lane
regards, tom lane -- 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 #6350: Delete a role which is still in use

2011-12-21 Thread Tom Lane
m...@msys.ch writes: A role can be deleted although it is still referenced in a column privilege. Hmm, it looks like ALTER TABLE OWNER forgets to update the grantors in column privileges. Table privileges are processed properly, but not columns. regards, tom lane

Re: R: R: R: [BUGS] BUG #6342: libpq blocks forever in poll function

2011-12-20 Thread Tom Lane
? libpq clearly thinks it's waiting for a message from the server, but I wonder what the server thinks. Also, what connection status does netstat show on each side? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: R: R: R: R: [BUGS] BUG #6342: libpq blocks forever in poll function

2011-12-20 Thread Tom Lane
queue? Surely the kernel should be reporting that the socket is read-ready, if it's got some data. I think you've found an obscure kernel bug somehow it's failing to wake the poll() caller. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] Incorrect comment in heapam.c

2011-12-20 Thread Tom Lane
it missed this comment. regards, tom lane -- 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] Security definer generated column function used in index

2011-12-20 Thread Tom Lane
in your trigger logic. regards, tom lane -- 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] Security definer generated column function used in index

2011-12-20 Thread Tom Lane
, resulting in catastrophic degradation of the generated plans, such that they took a lot longer than you were accustomed to (they shouldn't have been hung though). regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] [PATCH v2] Use CC atomic builtins as a fallback

2011-12-20 Thread Tom Lane
/boost/ticket/2525 Google is also finding some rather worrisome suggestions that __sync_lock_test_and_set might involve a kernel call on some flavors of ARM. That would be pretty disastrous from a performance standpoint. regards, tom lane -- Sent via pgsql-bugs mailing

Re: [BUGS] [PATCH] Use CC atomic builtins if available [was: Re: TAS patch for building on armel/armhf thumb]

2011-12-19 Thread Tom Lane
our Itanium (and possibly ARM, too) implementation of S_UNLOCK() is wrong as it is. Hmm. Anybody got a large itanium box we could play with? If it is wrong, I'd expect it would show up pretty quickly under pgbench or similar. regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] Re: [PATCH] Use CC atomic builtins if available [was: Re: TAS patch for building on armel/armhf thumb]

2011-12-19 Thread Tom Lane
that this applies to Itanium, because I don't see any memory fence instruction in the TAS macro. If we needed one in S_UNLOCK I'd rather expect there to be one in TAS as well. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] fatal flex error in guc-file.l kills the postmaster

2011-12-17 Thread Tom Lane
this. regards, tom lane -- 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 #6335: Weird planner decision with exists (a join b) condition

2011-12-15 Thread Tom Lane
of constraint whatsoever on aas is going to end up with the crummy plan where the whole lower join gets computed. regards, tom lane -- 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 #6340: to_timestamp() miscalculates

2011-12-15 Thread Tom Lane
in your timezone, then this behavior is neither surprising nor a bug. regards, tom lane -- 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] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

2011-12-13 Thread Tom Lane
)::text 'DEPLOZ'::text)) Filter: ((discriminator)::text ~~ 'DEPLOY%'::text) (4 rows) count --- 500 (1 row) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

2011-12-13 Thread Tom Lane
this on, exactly? I tried it on Fedora 14. What are the values of relevant locale-type env vars when you ran initdb on your test sys? Shrug ... C. That's my normal working environment. I did try it with en_US.utf8 too, just for grins. regards, tom lane -- Sent via pgsql

Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

2011-12-12 Thread Tom Lane
and LC_CTYPE set to C? I am not sure that createdb pays attention to those as locale settings. regards, tom lane -- 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 #6331: Cross compile error/aborts. Works if '--disable-spinlock' is used

2011-12-12 Thread Tom Lane
evidently isn't, even if it calls itself an ARM. It's also possible that his target processor actually can do swpb, but he needs to use some other gcc flags to persuade gcc of that. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] Postgresql 9.1.2 - abnormal memory usage

2011-12-11 Thread Tom Lane
functions than strictly necessary but I guess thats ok. Seems like the correct fix is to revert these functions to the former behavior, ie they should be using the PP macros not the unpacking ones. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

2011-12-10 Thread Tom Lane
collation to use for string comparison HINT:  Use the COLLATE clause to set the collation explicitly. FWIW, I tried to replicate this on the basis of the limited information you gave, and could not. Can you provide a self-contained test case? regards, tom lane -- Sent via

Re: [BUGS] BUG #6330: Incorrect select results when using mutually exclusive conditions for nullable column with index

2011-12-07 Thread Tom Lane
it on PostgreSQL 9.0.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-50), 64-bit Yeah, this is fixed as of 9.0.5: http://git.postgresql.org/gitweb/?p=postgresql.gita=commitdiffh=bbfcc7149 regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] copy cmd err

2011-12-06 Thread Tom Lane
. regards, tom lane -- 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 #6327: Prefix full-text-search fails for hosts with complicated names

2011-12-05 Thread Tom Lane
this by hacking the ts parser so that it would also apply the hyphenated-word rules to a hostname containing a dash. In general though, there are always going to be cases where prefix match doesn't work because of dictionary transformations ... regards, tom lane -- Sent via

Re: [BUGS] possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs

2011-12-05 Thread Tom Lane
Jeff Davis pg...@j-davis.com writes: On Wed, Nov 30, 2011 at 5:10 PM, Tom Lane t...@sss.pgh.pa.us wrote: The result of parse analysis for that query is a stored date constant (in a Const node) with a cast-to-text on top of it. The system is aware that cast-date-to-text isn't immutable, so

Re: [BUGS] BUG #6326: SELECT ARRAY(SELECT ...) syntax and array[] results doesn't work

2011-12-04 Thread Tom Lane
maxim.bo...@gmail.com writes: SELECT ARRAY(SELECT ...) doesn't work when subselect return any array. Is that syntax supposed to work with anyarray types? No. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #6318: pg_dump for non-template languages is broken

2011-12-02 Thread Tom Lane
* we will emit a parameterless CREATE LANGUAGE command, which will * require PL template knowledge in the backend to reload.) */ An actual add-on procedural language would not fall foul of this. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #6313: Deadlock reporting contains not enought details

2011-12-01 Thread Tom Lane
not going to change it in 8.3.x though. regards, tom lane -- 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] 9.1.1 hot standby startup gets sigbus

2011-12-01 Thread Tom Lane
be something broken about your VM environment. Can you reproduce it outside the VM, or even better create a reproducible test case? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #6314: The like command does not handle a long string of special chars

2011-12-01 Thread Tom Lane
. You should reread the manual's discussion of LIKE: http://www.postgresql.org/docs/8.4/static/functions-matching.html regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [BUGS] BUG #6315: FETCH NEXT :next ROWS ONLY fails

2011-12-01 Thread Tom Lane
to make that a bit more obvious. regards, tom lane -- 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 #6315: FETCH NEXT :next ROWS ONLY fails

2011-12-01 Thread Tom Lane
:2008 doesn't actually require anything beyond a simple integer constant here. regards, tom lane -- 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 #6316: function search_path causes set_config() is_local = true to have no effect

2011-12-01 Thread Tom Lane
is rolled back. regards, tom lane -- 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] possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs

2011-11-30 Thread Tom Lane
interpreted differently. You could argue it either way as to which result is more correct, but I doubt we're going to try to do something about that. Best advice is to avoid ambiguous input, or if you can't, at least avoid flipping your datestyle on the fly. regards, tom lane

Re: [BUGS] 9.1.1 hot standby startup gets sigbus

2011-11-30 Thread Tom Lane
? regards, tom lane -- 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] 9.1.1 hot standby startup gets sigbus

2011-11-30 Thread Tom Lane
Josh Kupershmidt schmi...@gmail.com writes: On Wed, Nov 30, 2011 at 9:17 PM, Tom Lane t...@sss.pgh.pa.us wrote: Can you try that on 9.1 branch tip to see if it's already fixed? Hrm, don't think that helped - I get the same error in the logs using a checkout of branch REL9_1_STABLE. Well

Re: [BUGS] pg_dump - foreign table - server name is not quoted

2011-11-28 Thread Tom Lane
in pg_dump. Usually we prefer to retrieve names from the server as-is, then apply fmtId() when printing them --- this is more flexible than having possibly-pre-quoted names in pg_dump's internal state. Will fix it the latter way. Thanks for the report! regards, tom lane

Re: [BUGS] pg_dump - foreign table - server name is not quoted

2011-11-28 Thread Tom Lane
Ronan Dunklau rdunk...@gmail.com writes: How will this bug be handled with regards to releases ? It'll be fixed in next week's releases. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] objects tied to missing extension

2011-11-28 Thread Tom Lane
at outermost recursion level.) So the problem seems to be only due to your ALTER EXTENSION DROP command having left an incomplete set of extension dependencies behind. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] objects tied to missing extension

2011-11-28 Thread Tom Lane
some dangling entries in pg_depend --- manually deleting any rows that reference the missing pg_extension OID should fix it. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [BUGS] objects tied to missing extension

2011-11-28 Thread Tom Lane
/gitweb/?p=postgresql.git;a=commitdiff;h=871dd024a6adf7766702b1cdacfb02bd8002d2bb regards, tom lane -- 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] [ADMIN] Repeatable crash in pg_dump (with -d2 info)

2011-11-28 Thread Tom Lane
refused it. LOG: unexpected EOF on client connection regards, tom lane -- 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 #6307: intarray extention gin index does not work with Hot standby

2011-11-28 Thread Tom Lane
Maxim Boguk maxim.bo...@gmail.com writes: Is that fix will be included to the next minor versions releases? Yes, it's in already: http://git.postgresql.org/gitweb/?p=postgresql.git regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] BUG #6310: Startup Script

2011-11-26 Thread Tom Lane
Sidar Lopez sidar.lo...@gmail.com writes: Operating system: Mac OS X Description:Startup Script Log file is not being created at ${PGLOG} location. Hmm, yeah, that's overly-quoted. Will fix, thanks for the report! regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-19 Thread Tom Lane
functions that were mutually dependent in that way? And actually did something useful (not recurse till stack overflow) when called? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #6301: extra space in psql variable expansion

2011-11-19 Thread Tom Lane
, an argument is considered terminated only by unquoted whitespace or backslash. regards, tom lane -- 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 #6301: extra space in psql variable expansion

2011-11-19 Thread Tom Lane
stable branch. It seemed like enough of a behavioral change to be too risky to put into minor releases. regards, tom lane -- 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 #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-19 Thread Tom Lane
lindebg lind...@gmail.com writes: On 11/19/2011 04:34 AM, Tom Lane wrote: Color me skeptical. Under what conceivable use-case could you have functions that were mutually dependent in that way? And actually did something useful (not recurse till stack overflow) when called? Does this mean

Re: [BUGS] BUG #6300: duplicate key value violates unique constraint

2011-11-18 Thread Tom Lane
anybody suggested raising the log_min_messages setting? regards, tom lane -- 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 #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-17 Thread Tom Lane
of update releases, or if you're in a big hurry you can get the patch here: http://archives.postgresql.org/pgsql-committers/2011-10/msg7.php regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #6295: Update fails on empty concatenated strings

2011-11-16 Thread Tom Lane
with something else yields null. You might possibly want to spell the above as SET comment = '...' || coalesce(comment, null) ..., if you want to pretend that a null is the same thing as an empty string. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #6295: Update fails on empty concatenated strings

2011-11-16 Thread Tom Lane
I wrote: You might possibly want to spell the above as SET comment = '...' || coalesce(comment, null) ... Sheesh. coalesce(comment, '') of course. Need more caffeine. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] Cannot dump 8.4.8 database using later versions

2011-11-15 Thread Tom Lane
) TO stdout; The least painful solution might be to always quote *every* identifier in commands sent to the source server, since we don't especially care how nice-looking those are. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #6291: Xid epoch is not updated properly

2011-11-13 Thread Tom Lane
to reproduce this here, and a look at the code responsible for xid epoch maintenance reveals no obvious way that it could have been bypassed. So there's some fairly critical piece of context that you're not telling us ... regards, tom lane -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #6288: Is ALTER ROLE set client_encoding broken in 9.1?

2011-11-11 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On tor, 2011-11-10 at 19:30 -0500, Tom Lane wrote: I think psql only pays attention to its locale when stdout is a tty. Now *why* it acts like that, I'll leave for Peter to defend. We would have to review the original discussion about that. I can see

Re: [BUGS] BUG #6288: Is ALTER ROLE set client_encoding broken in 9.1?

2011-11-10 Thread Tom Lane
Maksym Boguk maxim.bo...@gmail.com writes: Description:Is ALTER ROLE set client_encoding broken in 9.1? No, but I think psql prefers to set its encoding according to its locale enviroment these days. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql

Re: [BUGS] BUG #6288: Is ALTER ROLE set client_encoding broken in 9.1?

2011-11-10 Thread Tom Lane
' | head -10 client_encoding - KOI8R (1 row) I think psql only pays attention to its locale when stdout is a tty. Now *why* it acts like that, I'll leave for Peter to defend. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #6286: Table Partitioning - SQL/MED - interaction broken

2011-11-04 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Thu, Nov 3, 2011 at 5:07 PM, Tom Lane t...@sss.pgh.pa.us wrote: We probably ought to have something in there to throw an error ... Probably not for rules in general, but we shouldn't let people turn tables into views if they are involved in table

Re: [BUGS] BUG #6287: Unexpected protocol character during authentication

2011-11-04 Thread Tom Lane
/libodbcpsqlS.so FileUsage = 1 Depending on which build of postgresql-odbc you're using, the driver library file might be named psqlodbcw.so instead; but in any case libodbcpsql.so is not something to trust. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe

2011-11-03 Thread Tom Lane
would guess that you are using an old JDBC driver that isn't prepared for standard_conforming_strings to be turned on. If that isn't it, I'd suggest asking for help on the pgsql-jdbc mailing list; I'm not sure how many of those guys read pgsql-bugs. regards, tom lane

Re: [BUGS] BUG #6286: Table Partitioning - SQL/MED - interaction broken

2011-11-03 Thread Tom Lane
for it to be. We probably ought to have something in there to throw an error ... regards, tom lane -- 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 #6278: Index scans on '' condition on field with many NULLS

2011-10-31 Thread Tom Lane
). So either my analysis was wrong at the time, or some later change has eliminated the need for two flags, or the regression tests aren't covering the problematic case. Will investigate further once I've absorbed some caffeine. regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #6278: Index scans on '' condition on field with many NULLS

2011-10-31 Thread Tom Lane
of pessimizing normal cases. A patch along these lines should be pretty localized. Has anyone got an opinion on whether to back-patch or not? This seems like a performance bug, but given the lack of prior complaints, maybe we shouldn't take any risks for it. regards, tom lane

Re: [BUGS] BUG #6278: Index scans on '' condition on field with many NULLS

2011-10-31 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Mon, Oct 31, 2011 at 12:43 PM, Tom Lane t...@sss.pgh.pa.us wrote: A patch along these lines should be pretty localized. Has anyone got an opinion on whether to back-patch or not? This seems like a performance bug, but given the lack of prior

Re: [BUGS] BUG #6280: adminpack.sql not found after postgresql-contrib has been installed

2011-10-31 Thread Tom Lane
. But adminpack.sql is not found. It's called adminpack--1.0.sql these days, and is installed using a different command than your version of pgAdmin is probably trying to use. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] BUG #6277: Money datatype conversion wrong with Russian locale

2011-10-30 Thread Tom Lane
. AFAICT there are no such locales anyway, other than POSIX for which we definitely don't want to believe the empty-string setting. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #6277: Money datatype conversion wrong with Russian locale

2011-10-29 Thread Tom Lane
of locales where the decimal point isn't a single byte? I'm wondering if that assumption needs to be got rid of too. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [BUGS] Re: BUG #6264: Superuser does not have inherent Replication permission

2011-10-28 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Thu, Oct 27, 2011 at 6:15 PM, Tom Lane t...@sss.pgh.pa.us wrote: Noah Misch n...@leadboat.com writes: I think we should merge #3 into #2; nothing about the REPLICATION setting justifies a distinct paradigm. Yeah, there's much to be said

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of localhost

2011-10-28 Thread Tom Lane
(and yes, it's a kluge) is that it supposes that you migrated EVERY local service to the other machine. Which, obviously, you did not. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of localhost

2011-10-28 Thread Tom Lane
the local machine; there are Internet standards saying so. On the other hand, client applications that assume the database server is on the same machine they are on are definitely broken, and need to be fixed. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of localhost

2011-10-27 Thread Tom Lane
while searching the RFC archives.) And, given that we've been doing it this way since 2001 without previous complaints, the number of systems that fail to do it must be pretty small. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] BUG #6264: Superuser does not have inherent Replication permission

2011-10-27 Thread Tom Lane
hasn't been out for very long, so maybe expectations aren't too settled yet, but changing security-critical behavior in back branches doesn't seem like a wonderful idea; and I think I mildly prefer the current semantics to the proposed ones. +1 regards, tom lane

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of localhost

2011-10-27 Thread Tom Lane
of later computer-oriented standards. But it's wrong, no matter how many places say that. Ask an astronomer rather than a computer scientist, if you're not convinced. /pedantry regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] Re: BUG #6264: Superuser does not have inherent Replication permission

2011-10-27 Thread Tom Lane
bogus to start with. rolcatupdate isn't a very good precedent to rely on because it's never been documented or used to any noticeable extent, so there's no reason to think that it provides a tested-and-accepted behavior. regards, tom lane -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #6275: Horrible performance regression

2011-10-27 Thread Tom Lane
: The database uses plpython and postgis. Hmm, did you change postgis versions at the same time? If so, which upgrade caused the problem, postgres or postgis? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription

Re: [BUGS] BUG #6267: Wrong results in pg_database_size

2011-10-25 Thread Tom Lane
Maksym Boguk maxim.bo...@gmail.com writes: Somehow pg_database_size producing results which are 2х more then reality. I can't reproduce any such problem here. I suspect you overlooked some tablespaces in your manual du commands. regards, tom lane -- Sent via pgsql

<    3   4   5   6   7   8   9   10   11   12   >