Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-11 Thread Tom Lane
g them. To do that it'd have to be volatile, so if we had a restriction like this the function would fail when invoked within a stable function. You can imagine various ways around such issues, but it would add a lot of complication. regards, tom lane -- Sent via p

Re: [BUGS] Bit String expand bug

2013-10-11 Thread Tom Lane
s fix anything. 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] abort()/segfault when starting postgres in inaccessible CWD

2013-10-03 Thread Tom Lane
t, even if we fixed the CWD issue. So I'm inclined to think this scenario is a "don't do that". Having said that, though, it seems like a bad idea to be calling set_pglocale_pgservice() before palloc is functional. It's not at all obvious that that function can't be

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

2013-09-13 Thread Tom Lane
efer to? (I think there was some discussion of this in the pgsql-hackers list about a year ago, but I couldn't find it in a desultory search.) 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 #8441: Recursive function in plpgsql does not seem to handle null values correctly

2013-09-09 Thread Tom Lane
nshtein(null, 'foobar') > I get a ERROR: stack depth limit exceeded Worksforme. You sure you transcribed the function accurately? Note however that sufficiently long input strings *will* drive this function to stack overrun, if you don't run out of heap memory first (I think the hea

Re: [BUGS] BUG #8436: Heisenbug: random: relation "XXX" does not exist on 3 tables/views

2013-09-04 Thread Tom Lane
bles --- perhaps you added some kind of background maintenance task that wasn't there before? You might try enabling query logging (log_statement = all) to see exactly what's happening at the time you get one of these errors. regards, tom lane -- Sent via

Re: [BUGS] BUG #8435: PGAdmin backup: obect list missing objects

2013-09-04 Thread Tom Lane
icious there's a LIKE test coded as LIKE 'pg_%', which is wrong because "_" is a metacharacter in LIKE patterns ... 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 #8410: out of binary heap slots

2013-08-30 Thread Tom Lane
point --- pushed. 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 #8410: out of binary heap slots

2013-08-30 Thread Tom Lane
Andres Freund writes: > On 2013-08-30 18:55:53 -0400, Tom Lane wrote: >> Not sure. It's pretty disturbing that this wasn't caught earlier; >> it seems to me that means there's no regression coverage that hits >> ExecReScanMergeAppend. However, I don

Re: [BUGS] BUG #8410: out of binary heap slots

2013-08-30 Thread Tom Lane
hitting the bug could depend on what series of random values you get. 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 #8410: out of binary heap slots

2013-08-30 Thread Tom Lane
Andres Freund writes: > Terje, do you use read committed or repeatable read/serializable? Or even more to the point, can you apply the just-posted patch and see if the problem goes away for you? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-b

Re: [BUGS] BUG #8410: out of binary heap slots

2013-08-30 Thread Tom Lane
report. The thing this theory doesn't explain is why would Terje be having trouble reproducing the failure? Seems like re-running the same query ought to produce the same failure. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql

Re: [BUGS] BUG #8396: Window function results differ when selecting from table and view, with where clause

2013-08-25 Thread Tom Lane
s isn't smart enough to do that --- and even if it were, it would not push down the WHERE clause in either this example or the stackoverflow one, because it could/would change the results. Or in short, this isn't a bug, but a counterexample to the stackoverflow discussion.

Re: [BUGS] BUG #8393: "ERROR: failed to locate grouping columns" on grouping by varchar returned from function

2013-08-23 Thread Tom Lane
he result column type, and it's the discrepancy between that and the declaration of the constant that's tickling the 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] BUG #8387: Error while make of the source code

2013-08-19 Thread Tom Lane
mutex hints (see the comment for USE_PPC_LWARX_MUTEX_HINT in pg_config_manual.h). We do have a configure-time check for that, but maybe it's not working for him? Without any info as to the compiler or assembler in use, nor a look at the failing bits of assembly code, we're just guessing

Re: [BUGS] BUG #8385: greek symbols as function name

2013-08-18 Thread Tom Lane
you are seeing. Hmm ... identifier case-folding isn't really supposed to do anything to multibyte characters. I wonder if this isn't a variant of the issue recently fixed in commit d535136b5d60b19f7ffa777b97ed301739c15a9d. regards, tom lane -- Sent via pgsql

Re: [BUGS] pg_stat_statements produces multiple entries for a single query with track = 'top'

2013-08-10 Thread Tom Lane
ctions? At least, if we change pg_stat_statements so it doesn't break out SQL-language functions, I'm sure somebody's gonna complain. 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 #8335: trim() un-document behaviour

2013-08-09 Thread Tom Lane
tactic sugar). To say nothing of existing applications that may be relying on calling the underlying functions with their existing argument order. The inconsistency in argument order is unfortunate but we're long since stuck with it, I'm afraid. regards, tom lan

Re: [BUGS] BUG #8375: pg_hba.conf: Include_dir like in postgresql.conf

2013-08-08 Thread Tom Lane
conf.d-like directory could produce unexpected results --- and in this case, "unexpected result" probably means "security failure". regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://ww

Re: [BUGS] Reltuples/n_live_tup values wrong

2013-08-07 Thread Tom Lane
to close these xa transactions without > restarting the whole db? Just use ROLLBACK PREPARED with the ID you see in pg_prepared_xacts. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.pos

Re: [BUGS] Reltuples/n_live_tup values wrong

2013-08-07 Thread Tom Lane
ing those rows from getting vacuumed away. Perhaps you have a prepared transaction lying around? 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 #8367: wrong example in 8.17.10

2013-08-06 Thread Tom Lane
dalone example --- Jeff, what do you think? 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 #8361: 9.3~beta2-2: Wrong `interval' format with aggregate functions.

2013-08-03 Thread Tom Lane
the other. If you want that sort of conversion, see the justify_days(), justify_hours(), and justify_interval() functions. 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 #8355: PL/Python 3 can't convert infinity to PostgreSQL's value

2013-08-03 Thread Tom Lane
e "", line 1, in ValueError: invalid literal for float(): inf Now, I seriously doubt that the Python guys will give a darn about a 15-year-old version of HPUX, but if you can reproduce the above on your Windows machine, I'd suggest filing a bug about it with them.

Re: [BUGS] BUG #8355: PL/Python 3 can't convert infinity to PostgreSQL's value

2013-08-02 Thread Tom Lane
cases: NaN Infinity -Infinity but the wording of the spec clearly requires +Infinity as well as the forms with just "inf". (It also appears to require +/- NaN to be accepted, but I have no idea what that would mean and suspect it to be a thinko.) Barring obje

Re: [BUGS] BUG #8355: PL/Python 3 can't convert infinity to PostgreSQL's value

2013-08-02 Thread Tom Lane
HPUX box; and you're complaining about Windows. So what we've got here is a platform dependency in the behavior of strtod(). I don't think we can promise to hide all such dependencies, but maybe it'd be a good idea to take care of this particular one.

Re: [BUGS] Incorrect response code after XA recovery

2013-07-29 Thread Tom Lane
y case that's outside Postgres' purview. It's barely possible that the Postgres JDBC driver has something to do with that, but it sounds more like the XA manager's turf. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.or

Re: [BUGS] Incorrect response code after XA recovery

2013-07-29 Thread Tom Lane
Tom Jenkinson writes: > On Mon 29 Jul 2013 15:46:12 BST, Tom Lane wrote: >> No idea, but in any case that's outside Postgres' purview. It's barely >> possible that the Postgres JDBC driver has something to do with that, >> but it sounds more like the XA manag

Re: [BUGS] Incorrect response code after XA recovery

2013-07-29 Thread Tom Lane
x their bug/shortcoming rather than claim it's our 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] pgsql 8.4 "not" + "is contained by" operators return wrong result

2013-07-25 Thread Tom Lane
"ARRAY[1] <@ NULL" yields NULL. NOT (NULL) is still NULL. WHERE treats a NULL result as FALSE. It might help you to consider that NULL means "unknown". It does not mean "empty array". regards, tom lane -- Sent via pgsql-bugs mailing l

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Tom Lane
Andres Freund writes: > On 2013-07-25 11:50:47 -0400, Tom Lane wrote: >> So on an OpenBSD build that code wouldn't be used anyway (not even >> when talking to a pre-9.1 server, if I'm interpreting the comment >> correctly). > As far as I understood it, it woul

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Tom Lane
by libc). So on an OpenBSD build that code wouldn't be used anyway (not even when talking to a pre-9.1 server, if I'm interpreting the comment correctly). regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Tom Lane
Andres Freund writes: > On 2013-07-25 09:48:31 -0400, Tom Lane wrote: >> The proposed patch seems a bit overcomplicated --- isn't the real >> problem that I changed the ordering of the header probes in >> be4585b1c27ac5dbdd0d61740d18f7ad9a00e268? I think I just alphab

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Tom Lane
, not realizing that there were order dependencies on some platforms. 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 #8274: Wildly insane boolean selectivity estimates

2013-07-23 Thread Tom Lane
of brain fade there :-( > Suggested fix at: > https://gist.github.com/RhodiumToad/5901567 Seems reasonable, will fix. 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.3beta2 unrecognized node type in join alias vars when retrieving view definition

2013-07-22 Thread Tom Lane
ts can only contain Vars or COALESCE expressions :-(. Will fix. 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 #8315: GRANTS allowed on extension functions, but not dumped by pg_dump

2013-07-18 Thread Tom Lane
Jeff Frost writes: > On Jul 18, 2013, at 11:47 AM, Tom Lane wrote: >> I see no bug here. This is not different from any other >> property-alteration you might do on an extension member object. >> We allow that (if you have privileges), but it's up to you to keep it >

Re: [BUGS] BUG #8315: GRANTS allowed on extension functions, but not dumped by pg_dump

2013-07-18 Thread Tom Lane
e allow that (if you have privileges), but it's up to you to keep it in sync with the extension definition file. 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] COPY process hung in 9.2.x (9.2.4)

2013-07-17 Thread Tom Lane
op the 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 #8289: pg_stat_statements incorrect query text when executing multiple queries in a single PQexec

2013-07-09 Thread Tom Lane
t's what's going to happen, because there is no infrastructure for determining which portion of the source text string belongs to which query. I suspect there are some other infelicities in pg_stat_statements' behavior for multi-query strings, too. At least for now, that combination

Re: [BUGS] BUG #8287: select distinct / select group by - Invalid result

2013-07-06 Thread Tom Lane
=commitdiff;h=841c9b6ba151ed5a41733ec345bf9bf32a55f4dc 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] Concurrent CREATE USER MAPPING and DROP SERVER

2013-07-04 Thread Tom Lane
I can't get particularly excited about this one compared to the rest. We could try to extend the table-locking protocols to apply to all object types ... but from here, the amount of work and complexity involved seems far out of proportion to the benefit. regards, tom

Re: [BUGS] BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement

2013-07-03 Thread Tom Lane
tached is an updated patch for HEAD, with regression tests. This > should also be applied to the 9.3beta branch. Applied with minor adjustments --- mainly, I took out the inFromCl twiddling, which AFAICS is neither necessary (nothing downstream of this looks at inFromCl) nor clearly correct

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-01 Thread Tom Lane
Peter Eisentraut writes: > On 7/1/13 9:19 AM, Tom Lane wrote: >> AFAICT, the result in this case would be that the script comes to the >> wrong conclusion about whether ucred.h is available. Wouldn't that >> result in a build failure, or at least missing features? IO

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-01 Thread Tom Lane
ile and not two, then +1 for updating. Should help a bit with configure's speed 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 #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-06-30 Thread Tom Lane
## Report this to pgsql-bugs@postgresql.org ## configure: WARNING: ## ## that that ought to be treated as a failure not a success. I'm not entirely sure that I agree, but it's an arguable position. regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #8257: Multi-Core Restore fails when containing index comments

2013-06-27 Thread Tom Lane
g ] Applied with minor cosmetic changes. 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 #8257: Multi-Core Restore fails when containing index comments

2013-06-27 Thread Tom Lane
Andres Freund writes: > On 2013-06-27 10:29:14 -0400, Tom Lane wrote: >> Your proposed patch will only fix the problem for dumps created after >> it ships. In the past, we've tried to deal with this type of issue by >> having pg_restore fix up the dependencies when rea

Re: [BUGS] BUG #8260: problem with sequence and tablename

2013-06-27 Thread Tom Lane
equence: > CREATE SEQUENCE > t2345678901234567890123456789012345678901234567890_t1234_id_seq That's operating as designed. > The table-part in the sequence name was truncated. Would you rather it failed entirely? You're up against the limit on name length (63 bytes in a standard Postgres build). regards, t

Re: [BUGS] BUG #8257: Multi-Core Restore fails when containing index comments

2013-06-27 Thread Tom Lane
way to do that in this case --- it doesn't look like there's enough info in the dump to tell where the dependency link should have led. But we should think about it a little before taking the easy way out. regards, tom lane -- Sent via pgsql-bugs mailing lis

Re: [BUGS] Postgres crash? could not write to log file: No space left on device

2013-06-26 Thread Tom Lane
ery single write() call. But if we can identify specific call sites that seem at more risk than most, I'm okay with adding extra logic there. 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] Postgres crash? could not write to log file: No space left on device

2013-06-25 Thread Tom Lane
Jeff Davis writes: > On Tue, 2013-06-25 at 09:46 -0400, Tom Lane wrote: >> That's definitely telling you it got ENOSPC from a write in >> $PGDATA/pg_xlog. > Either that, or write() wrote less than expected but did not set errno. Good point. I wonder if he's using

Re: [BUGS] Postgres crash? could not write to log file: No spaceleft on device

2013-06-25 Thread Tom Lane
? The given error message is definitely complaining about being unable to write a pg_xlog file --- stats or other temp files are not relevant. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://

Re: [BUGS] Postgres crash? could not write to log file: No space left on device

2013-06-25 Thread Tom Lane
> length 1392640: No space left on device That's definitely telling you it got ENOSPC from a write in $PGDATA/pg_xlog. Maybe you have a user-specific space quota affecting the postgres account? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bu

Re: [BUGS] BUG #8238: duplicate of bug #6372 on panffs

2013-06-22 Thread Tom Lane
t CIFS couldn't be considered a supported filesystem anyway. Do you find that panfs works all right for Postgres other than this issue? 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 #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559

2013-06-21 Thread Tom Lane
to a PANIC so we could get a stack trace :-( 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 #8247: Duplicate database names - pg_dump backup fails

2013-06-21 Thread Tom Lane
M FULL pg_database" makes things any saner. (Delete the one database that you're able to get rid of first.) 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 #8242: No way to debug "subquery must return only one column" error

2013-06-20 Thread Tom Lane
er, it's the fault of whatever client-side software you're working in. 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 #8237: CASE Expression - Order of expression processing

2013-06-18 Thread Tom Lane
on't have a lot of control over order of evaluation of subexpressions. > So it seems we need to stop processing after finding a single WHEN > that's not const? That's not an acceptable "fix". regards, tom lane -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #8225: logging options don't change after reload

2013-06-13 Thread Tom Lane
ill silently fail to rotate if it gets ENFILE while trying to open the new log file. That doesn't look like it'd explain the lack of log_checkpoint activity, though. Also, usually people notice this state because everything else on the box starts to fall over ...

Re: [BUGS] BUG #8225: logging options don't change after reload

2013-06-13 Thread Tom Lane
Jeff Frost writes: > On Jun 13, 2013, at 4:50 PM, Tom Lane wrote: >> ... So one theory about this would be that those processes >> aren't absorbing the GUC updates, perhaps because the SIGHUP signals the >> postmaster should be sending them are getting lost. > Inte

Re: [BUGS] BUG #8225: logging options don't change after reload

2013-06-13 Thread Tom Lane
processes aren't absorbing the GUC updates, perhaps because the SIGHUP signals the postmaster should be sending them are getting lost. I'm not sure how we might track down the cause though. How "various" are the platforms you're seeing this on? rega

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

2013-06-13 Thread Tom Lane
7;t that well thought out, but it's really not regexp_matches()'s fault that you're running into this problem --- rather, it's the fact that one arm of the CASE can return a set while the other can't. regards, tom lane -- Sent via pgsql-bugs mailing l

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

2013-06-13 Thread Tom Lane
urn-a-set statically instead of believing the first execution result, but that might add an unpleasant amount of startup overhead. 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] [ODBC] Segmentation Fault in Postgres server when using psqlODBC

2013-06-13 Thread Tom Lane
gt; The program uses libpq and a hack. I've committed a fix for this. Thanks again for the test case. 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] [ODBC] Segmentation Fault in Postgres server when using psqlODBC

2013-06-13 Thread Tom Lane
Hiroshi Inoue writes: > OK I made a test C program which reproduces the crash. > The program uses libpq and a hack. Oh, thank you, I was just about to go spend an hour doing that ... regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.o

Re: [BUGS] BUG #8227: referential integrity problem

2013-06-12 Thread Tom Lane
g...@antrez.pl writes: > Is it ok that we loose referential integrity by locking DELETE on table > test_item ? Yes. If you put a trigger on a table involved in an FK constraint, it's your responsibility that the trigger doesn't break FK update operations.

Re: [BUGS] Completely broken replica after PANIC: WAL contains references to invalid pages

2013-06-11 Thread Tom Lane
or severe enough) fixes have accumulated since the last time. Historically we've averaged about four minor releases a year, but that's not set in stone anywhere. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-06-10 Thread Tom Lane
triction to getting RETURNING results back from only the primary query. We ought to fix that. 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] pg_dump is O(N) in DB table count N even if dumping only one table

2013-06-10 Thread Tom Lane
say, getTableAttrs. OTOH, if that makes the normal dump-everything case noticeably slower, it's unlikely such a patch would get accepted. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: h

Re: [BUGS] BUG #8198: ROW() literals not supported in an IN clause

2013-06-09 Thread Tom Lane
this patch some and committed it. 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 #8218: Error when querying an JSON data, 9.3beta

2013-06-09 Thread Tom Lane
is no "json_has_field" test function, nor any nice way to build one from the provided functions. It's probably too late to address this for 9.3, but we ought to put it on the to-do list for 9.4. 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 #8216: TO_DATE does not support th format provided

2013-06-07 Thread Tom Lane
te/time field value out of range: "10-30-2012" LINE 1: select '10-30-2012'::date; ^ HINT: Perhaps you need a different "datestyle" 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 #8215: pg_dump includes table out of order in SQL dump

2013-06-06 Thread Tom Lane
d enough info to tell whether there's such a constraint in your case ... 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 #8213: Set-valued function error in union

2013-06-05 Thread Tom Lane
fined, it's not implemented). Shouldn't be too hard to fix though. I'm thinking of moving most of the detection logic for this into subquery_is_pushdown_safe, and having it return an additional flag array that says "this output column is unsafe to reference in quals at all&q

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

2013-06-05 Thread Tom Lane
org/docs/9.2/static/sql-createindex.html points this out both in the syntax diagram and the text. 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] Memory-leak in BackgroundWriter(and Checkpointer)

2013-06-04 Thread Tom Lane
Stephen Frost writes: > * Tom Lane (t...@sss.pgh.pa.us) wrote: >> I think the proposed fix is fine code-wise; the real problem here is >> crummy commenting. GetRunningTransactionLocks isn't documented as >> returning a palloc'd array, and why the heck do we h

Re: [BUGS] Memory-leak in BackgroundWriter(and Checkpointer)

2013-06-04 Thread Tom Lane
tRunningTransactionLocks isn't documented as returning a palloc'd array, and why the heck do we have a long comment about its implementation in LogStandbySnapshot? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to

Re: [BUGS] BUG #8191: Wrong bit conversion

2013-05-31 Thread Tom Lane
ous of the details above, but in the end they are all arbitrary decisions. We've made them that way, and it would take a pretty impressive argument to persuade us to break existing applications by changing them. regards, tom lane -- Sent via pgsql-bugs maili

Re: [BUGS] BUG #8191: Wrong bit conversion

2013-05-31 Thread Tom Lane
0001" I believe those are all operating as intended. 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: [HACKERS] [BUGS] COPY .... (FORMAT binary) syntax doesn't work

2013-05-27 Thread Tom Lane
Simon Riggs writes: > On 26 May 2013 17:10, Tom Lane wrote: >> More readable would be to invent an intermediate nonterminal falling >> between ColId and ColLabel, whose expansion would be "IDENT | >> unreserved_keyword | col_name_keyword | type_func_name_key

Re: [BUGS] BUG #8176: problem with the "ALTER TYPE name RENAME TO new_name [ CASCADE | RESTRICT ]" syntax

2013-05-27 Thread Tom Lane
rammar for it was > broken during refactoring to have all the ALTER .. RENAME operations go > through the same code paths. Are we sure the documentation's not wrong? A quick test says this syntax isn't accepted in *any* existing release, and I can't say I understand what it should

Re: [HACKERS] [BUGS] COPY .... (FORMAT binary) syntax doesn't work

2013-05-26 Thread Tom Lane
erminal? BTW, I tried just replacing ColId with ColLabel here, and that *almost* works, but there are some places where we can see either ColId_or_Sconst or DEFAULT. I don't know of any sane way to express "all reserved keywords except DEFAULT" to bison, so the best we can real

Re: [BUGS] BUG #8175: Check constraint fails for valid data. ( rounding related? )

2013-05-22 Thread Tom Lane
k( product = (val1 * val2)::numeric(23,8) ) Otherwise, the check will always fail when the product has more than 8 fractional digits. It's not Postgres' place to decide that that wasn't what you wanted to happen. regards, tom lane -- Sent via pgsql-bugs mailing l

Re: [BUGS] BUG #8170: alter user does not accept timestamp output format in certain datestyles and timezones.

2013-05-20 Thread Tom Lane
; this failing? You need to add WIT to the timezone abbreviation list to allow it to be used as input: http://www.postgresql.org/docs/9.2/static/datetime-config-files.html Or perhaps better, use the ISO datestyle to eliminate the whole issue of timezone abbreviations. reg

Re: [BUGS] BUG #8169: change in bytea value in postgresql 8.3 and 9.2.4

2013-05-18 Thread Tom Lane
YTEA-OUTPUT 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 #8168: duplicated function signature

2013-05-17 Thread Tom Lane
s "\df > sp_get_league_prediction" return? If they are in different schemas, you'd probably need \df *.sp_get_league_prediction to see both. 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] pg_ctl -D "/absolute/path" -m fast restart - doesn't work in some cases

2013-05-16 Thread Tom Lane
wrong with that. 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] easy crash on HEAD

2013-05-16 Thread Tom Lane
_foo_updates AS ON UPDATE TO foo DO NOTIFY foo; > \d foo Thanks, will fix. 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 #8167: false EINVAL -22 for opening a file

2013-05-16 Thread Tom Lane
that stuff out entirely --- I've sure never built this code with FDDEBUG set, has anyone else? 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 #8163: simultaneous nearly identical update queries execute extremely slowly

2013-05-15 Thread Tom Lane
"Todd A. Cook" writes: > On 05/15/13 16:10, Tom Lane wrote: >> Given the reference to EvalPlanQual in your stack trace, I'm thinking >> the explanation is this 9.0 fix: > Thanks for the explanation. Is there any chance of that fix being backpatched > into 8.

Re: [BUGS] BUG #8163: simultaneous nearly identical update queries execute extremely slowly

2013-05-15 Thread Tom Lane
our in production, and the contrived test case below >> reproduces the issue. > I've repeated the test below on a 9.1.9 installation, and it works fine there. Given the reference to EvalPlanQual in your stack trace, I'm thinking the explanation is this 9.0 fix: Author: Tom Lane

Re: [BUGS] BUG #8152: strange behavior regarding after triggers and inheritance

2013-05-13 Thread Tom Lane
oved trigger processing into ModifyTable plan nodes. Anyway, I doubt we'd consider changing trigger behavior in 8.4.x at this late date. You should update to a newer release series if this is a problem for you. regards, tom lane -- Sent via pgsql-bugs mailing list (p

Re: [BUGS] BUG #8154: pg_dump throws error beacause of field called "new".

2013-05-13 Thread Tom Lane
#x27;2'); INSERT 0 1 regression=# copy new(f1,new) to stdout; 1 2 You sure the server is 9.1? 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] Inconsistency between TO_CHAR() and TO_NUMBER()

2013-05-13 Thread Tom Lane
y locales can you point to where neither the decimal point nor thousands_sep is "."? It certainly wouldn't be enough to noticeably reduce the potential pain from this change, so I decided that it'd be better to keep the behavior straightforward and as-documented.

Re: [BUGS] BUG #8150: NULL emements lost when casting result of unnest()

2013-05-11 Thread Tom Lane
eTableFunctionResult appear to get this right. The attached patch fixes it. This is another case where I'm not too sure if we ought to back-patch. The current behavior is clearly wrong, but perhaps some application out there will be unhappy if we change it in back branches?

Re: [BUGS] Inconsistency between TO_CHAR() and TO_NUMBER()

2013-05-10 Thread Tom Lane
d though about whether this might break any existing applications that are (incorrectly) depending on a D format specifier being able to match '.' regardless of locale. Perhaps we should only apply this to HEAD and not back-patch? regards, tom lane diff --git a/src

Re: [BUGS] Strange time zone +00:53:28

2013-05-10 Thread Tom Lane
the timezone definition says. If you're inextricably wedded to using '0001-01-01 00:00:00+01', you might consider building yourself a custom timezone database that has an entry defined the way you want. But personally I'd recommend changing to something less randomly chosen.

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

2013-05-09 Thread Tom Lane
ry, the rank() function does see them. 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 #8143: Backend segmentation fault in pg_trgm

2013-05-09 Thread Tom Lane
not work if more than one scankey refers to the same consistentFn, ie, the same index column. A bit surprising we've not seen this before, because I think that code has been like that for awhile. Will fix, thanks for the report! regards, tom lane -- Sent via pgsql-bug

  1   2   3   4   5   6   7   8   9   10   >