Re: [BUGS] BUG #6158: documentation error (grammar/typo)

2011-08-09 Thread Tom Lane
raf r...@raf.org writes: the sentence: This is an facility independent of the collector process. should be: This is a facility independent of the collector process. Seems to be fixed already in the 9.1 docs, but thanks for the report! regards, tom lane -- Sent

Re: [BUGS] BUG #6154: wrong result with nested left-joins

2011-08-08 Thread Tom Lane
is in 8.4.5, which makes me doubt the OP's report of his server version. http://git.postgresql.org/gitweb/?p=postgresql.gita=commitdiffh=dc9cc887b74bfa0d40829c4df66dead509fdd8f6 regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] Help-PGRES_FATAL_ERROR

2011-08-08 Thread Tom Lane
in the timezone abbrevation configurations on the two machines. 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 #6154: wrong result with nested left-joins

2011-08-08 Thread Tom Lane
wrong to me. Yeah, I see it too. It seems to be evaluating the placeholder for the COALESCE expression at the wrong join level. Not sure why, yet. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #6154: wrong result with nested left-joins

2011-08-08 Thread Tom Lane
, not ON or WHERE). Patch committed, 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 #6155: literal definition of arrays with double qoutes leads to error

2011-08-08 Thread Tom Lane
quotes} (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/mailpref/pgsql-bugs

Re: [BUGS] BUG #6152: possibly wrong display of pg_settings.enumvals for default_transaction_isolation

2011-08-05 Thread Tom Lane
mean entirely different things in SQL commands. 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 #5741: syslog line length

2011-08-05 Thread Tom Lane
shows this is still the case in Fedora 15. So I'm not convinced that nearly every is anywhere near true. How about 896? But having said that, I could go with 896 (or perhaps 900, which seems a shade less weird). regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #5741: syslog line length

2011-08-05 Thread Tom Lane
Noah Misch n...@2ndquadrant.com writes: On Fri, Aug 05, 2011 at 06:46:21PM -0400, Tom Lane wrote: But having said that, I could go with 896 (or perhaps 900, which seems a shade less weird). That works for me. OK, applied to HEAD and 9.1. regards, tom lane -- Sent

Re: [BUGS] BUG #6153: possible typo in the local_preload_libraries documentation

2011-08-05 Thread Tom Lane
shared_preload_libraries here. Yeah, I think you're right. 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 #6151: documentation claims that default value for log_timezone is unknown

2011-08-04 Thread Tom Lane
. 9.1 will be a bit cleaner in this regard, see http://git.postgresql.org/gitweb/?p=postgresql.gita=commitdiffh=1453cd8f8 http://git.postgresql.org/gitweb/?p=postgresql.gita=commitdiffh=2594cf0e8 regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] Postgres running but no postmaster.pid

2011-08-03 Thread Tom Lane
of that much information, I'd bet on accidental invocation of a postmaster startup script that thinks it should remove the postmaster.pid file before trying to launch a new postmaster. I've seen a lot of those, and every one of them is dangerously broken. regards, tom lane

Re: [BUGS] BUG #6145: Drop View hangs on lock

2011-08-03 Thread Tom Lane
a self-contained example? Also, 8.4 is by no means an adequate identification of the PG version. 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_restore silently chokes on object comments/descriptions ending in a backslash

2011-07-28 Thread Tom Lane
whatever the real problem is. I've applied a patch along those lines. 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] pg_restore silently chokes on object comments/descriptions ending in a backslash

2011-07-27 Thread Tom Lane
that pg_restore produces by default seems to be valid, so you could pipe that into psql. 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_restore silently chokes on object comments/descriptions ending in a backslash

2011-07-27 Thread Tom Lane
send you an extra copy, I believe, but I don't know the incantation offhand. Tom Lane wrote: Not sure about a simple fix, and I rather wonder if we shouldn't try to remove that code entirely instead of fix it. What would removing that code entirely mean? I was wondering why it's necessary

Re: [BUGS] BUG #6133: -lpq frees unallocated memory on exit

2011-07-27 Thread Tom Lane
or (recently) free'd Can't reproduce this on my own Red Hat machines ... 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 #6086: Segmentation fault

2011-07-26 Thread Tom Lane
libpthread.so when starting postgresql. Linking pthreads into the backend is likely to cause more problems than it solves, especially if you're proposing that we do that everywhere. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

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

2011-07-26 Thread Tom Lane
is that it affects the size of the hash table that the HashAggregate step uses. That's not tremendously relevant to fixing the problem, but just in case you were wondering. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] TOAST tables bug restoring to PostgreSQL 9.0.4

2011-07-25 Thread Tom Lane
-Index-relations))! This isn't a bug, it just indicates no ANALYZE has happened yet. 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 #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

2011-07-21 Thread Tom Lane
on the client end of it? 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 #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

2011-07-21 Thread Tom Lane
Greg Johnson greg.john...@interprose.com writes: On Thu, Jul 21, 2011 at 11:44 AM, Tom Lane t...@sss.pgh.pa.us wrote: This looks like pg_restore is terminating unexpectedly. What do you see on the client end of it? pg_restore: [custom archiver] could not read from input file: end of file

Re: [BUGS] BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

2011-07-21 Thread Tom Lane
the data loaded. Let me know if there is any other info I get you. Parallel restore? You didn't mention using parallel restore before. Were the failed pg_restore runs using parallelism? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] BUG #6128: A boolean variable doesn't evaluate properly in an IF conditional...

2011-07-21 Thread Tom Lane
. Selectively quoting from your function does not provide anything anyone could investigate. Please see http://wiki.postgresql.org/wiki/Guide_to_reporting_problems regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #6124: overlaps

2011-07-20 Thread Tom Lane
work through that you'll see that indeed these values should produce a false result: we have S2 S1, S2 = T1, T2 = T1. 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 #6123: DELETE fails if before trigger causes another trigger to UPDATE

2011-07-19 Thread Tom Lane
of the DELETE to be obsoleted, so heap_delete finds it has nothing to do. I'm disinclined to mess with that 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

Re: [BUGS] BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE

2011-07-19 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: Tom Lane t...@sss.pgh.pa.us wrote: The update causes the already-selected target row version of the DELETE to be obsoleted, so heap_delete finds it has nothing to do. I'm disinclined to mess with that logic. It's pretty astonishing behavior

Re: [BUGS] Spurious errors relating to escaped single quotes

2011-07-15 Thread Tom Lane
on building an explicit partitioning mechanism to handle the common cases more simply and efficiently, instead of continuing to add frammishes to the inheritance mechanism. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #6117: psql -c does not work as expected. a documentation bug? a program bug?

2011-07-14 Thread Tom Lane
on the current behavior. We could possibly address Aleksey's complaint without changing the behavior otherwise, but I'm not sure it's worth the trouble. So I vote for document-and-move-on. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] Spurious errors relating to escaped single quotes

2011-07-14 Thread Tom Lane
is OFF. As of 9.1 it's ON by default. 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] Window function bug

2011-07-12 Thread Tom Lane
within aggregates. Perhaps also omit those only used within volatile sort expressions, though I think that would just be an efficiency issue not a correctness issue, and it may be unreasonably expensive to determine that. regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] Window function bug

2011-07-12 Thread Tom Lane
row. That seems pretty useless, so I'm thinking it's not worth back-patching a fix for. Comments? 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 #6115: Two similar object giving slightly different results

2011-07-12 Thread Tom Lane
://wiki.postgresql.org/wiki/Guide_to_reporting_problems We'd also need to know what locale (lc_collate, lc_ctype) and encoding you are using, because that could easily affect the behavior of ILIKE. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] Window function bug

2011-07-12 Thread Tom Lane
Jeff Davis pg...@j-davis.com writes: On Tue, 2011-07-12 at 11:20 -0400, Tom Lane wrote: So far as I can see, the failure only occurs if we have a plain (non-grouping) Agg node, which implies that the user is trying to use windowing functions on a result set that's guaranteed to contain

Re: [BUGS] BUG #6111: ftell mismatch error

2011-07-11 Thread Tom Lane
to see a more complete test example. 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 #6097: Server crash when enabling custom_variable_classes

2011-07-08 Thread Tom Lane
: unrecognized configuration parameter something.location Nonetheless, it's clearly not the desired behavior :-(. Will look. 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 #6097: Server crash when enabling custom_variable_classes

2011-07-08 Thread Tom Lane
Maxim Boguk maxim.bo...@gmail.com writes: Description:Server crash when enabling custom_variable_classes 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

Re: [BUGS] BUG #6095: Misleading error message: INSERT has more expressions than target columns

2011-07-07 Thread Tom Lane
: INSERT INTO wage (id. pay) ^ This *is* valid syntax, if id is a composite-type column. 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: PG regression with row comparison when btree_gist is enabled (BUG)

2011-07-06 Thread Tom Lane
Jeff Davis pg...@j-davis.com writes: On Tue, 2011-07-05 at 13:56 -0400, Tom Lane wrote: Yeah, I had been thinking along the same lines. It will require duplicating the search loop, which is a bit annoying, but perhaps that could be factored out as a subroutine. Patch attached. The logic

Re: [BUGS] Re: PG regression with row comparison when btree_gist is enabled (BUG)

2011-07-06 Thread Tom Lane
Jeff Davis pg...@j-davis.com writes: On Wed, 2011-07-06 at 13:25 -0400, Tom Lane wrote: Actually, I'd just been working on this myself. I think the cleanest solution will be to get rid of the duplicative logic by making predtest.c use get_op_btree_interpretation(). That will require

Re: [BUGS] BUG #6092: specific casting required for gist indexing of bigint

2011-07-06 Thread Tom Lane
Jeff Frost j...@pgexperts.com writes: On 07/05/11 17:06, Tom Lane wrote: Jeff Frost j...@pgexperts.com writes: Ran into a situation with a customer who is using the btree_gist contrib module to allow combined index of some tsearch data and two other columns. One of these other columns

Re: [BUGS] [HACKERS] COPY .... WITH (FORMAT binary) causes syntax error at or near binary

2011-07-05 Thread Tom Lane
we still support for backwards compatibility with versions 7.3. We can fix the immediate problem with something like the attached. (a) Should we do that? That seems like a horrid crock ... regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] [HACKERS] COPY .... WITH (FORMAT binary) causes syntax error at or near binary

2011-07-05 Thread Tom Lane
of the double-quote workaround, I feel little need to have a back-patchable 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 #6080: information_schema.columns.column_default contains NULL inconsistently

2011-07-05 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Sun, Jul 3, 2011 at 12:31 PM, Tom Lane t...@sss.pgh.pa.us wrote: The code that recognizes a default expression as being just constant NULL doesn't think this is a constant NULL.  In principle it could recognize that, since the cast function

Re: [BUGS] Re: PG regression with row comparison when btree_gist is enabled (BUG)

2011-07-05 Thread Tom Lane
out as a subroutine. 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 #6092: specific casting required for gist indexing of bigint

2011-07-05 Thread Tom Lane
by the planner unless you specifically cast the bare number to a bigint. If memory serves, the btree_gist opclasses don't include any cross-type operators, so int8 = int4 doesn't work here. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

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

2011-07-04 Thread Tom Lane
. However, I'm unsure whether to apply it to released branches ... does anyone think this might break somebody's application? regards, tom lane diff --git a/src/bin/psql/copy.c b/src/bin/psql/copy.c index 5e69d29b6cbeab56aa0c85e85c3edce46d06efac

Re: [BUGS] BUG #6080: information_schema.columns.column_default contains NULL inconsistently

2011-07-03 Thread Tom Lane
Chris Bandy bandy.ch...@gmail.com writes: On Fri, Jul 1, 2011 at 10:35 PM, Tom Lane t...@sss.pgh.pa.us wrote: But AFAICS there is room for implementation dependency in other cases. In the particular cases you show here, PG recognizes some of them as being equivalent to not having a default

Re: [BUGS] Re: PG regression with row comparison when btree_gist is enabled (BUG)

2011-07-02 Thread Tom Lane
use seem negligible, and not at all adequate to warrant adding extra cycles into mainstream code paths. It's not too late to rip that out of 9.1, and that's what I think we should do. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] BUG #6088: copy to stdout cannot be stopped with kill(pid) or pg_terminate_backend

2011-07-02 Thread Tom Lane
worrying about interrupt response latency is worthwhile. 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] view + explain + index scan - bogus varno: 65001 (with some variations)

2011-07-02 Thread Tom Lane
Jon Nelson jnelson+pg...@jamponi.net writes: On Fri, Jul 1, 2011 at 3:27 PM, Tom Lane t...@sss.pgh.pa.us wrote: FWIW, I can't reproduce such a failure with current 8.4 branch (nor any other). Try adding: set enable_mergejoin = false; Thanks, that did it. I've repaired the symptom exposed

Re: [BUGS] view + explain + index scan - bogus varno: 65001 (with some variations)

2011-07-01 Thread Tom Lane
on those to work (or rather, not work). 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 with plpgsql, temp tables and TOAST?

2011-07-01 Thread Tom Lane
to this issue. I don't recall that anyone liked his hack 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] BUG #6080: information_schema.columns.column_default contains NULL inconsistently

2011-07-01 Thread Tom Lane
bound to make every such case work like that, 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] BUG #6088: copy to stdout cannot be stopped with kill(pid) or pg_terminate_backend

2011-07-01 Thread Tom Lane
Maksym Boguk maxim.bo...@gmail.com writes: But I found I can not stop COPY bill.changes (id, cdate, mdate, status, table_name, pk_id, old_row, new_row) TO stdout; with pg_terminate_backend(procpid) or kill (procpid). Works for me ... regards, tom lane -- Sent via

Re: [BUGS] BUG #6082: server segfault - pg_stat_reset_shared(null)

2011-06-29 Thread Tom Lane
the function strict in pg_proc.h. 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 #6079: Wrong select result

2011-06-29 Thread Tom Lane
, 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] Did this report get lost?

2011-06-26 Thread Tom Lane
Jeff Davis pg...@j-davis.com writes: http://archives.postgresql.org/pgsql-bugs/2011-06/msg00167.php It's on my to-look-at list. Your patch looked to me like it would add extra syscache fetches in typical cases, and I was hoping to find a way that didn't. regards, tom

Re: [BUGS] BUG #6076: Unexpected Security Definer / invoker interaction

2011-06-24 Thread Tom Lane
) is used. You did not provide any evidence of that. Please show a *complete* self-contained 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] Where is pg_create_restore_point funciton in 9.1a2 ?

2011-06-22 Thread Tom Lane
(I must force with * to do that). i can confirm this This is allegedly a feature, not a bug, and it's been that way for a couple releases now: \df with no argument prints only user-defined functions. I will let those who advocated that behavior defend it. regards, tom

Re: [BUGS] BUG #6072: VPATH build fails in src/backend/port for src tarball, errcodes.h not found

2011-06-22 Thread Tom Lane
is a different situation (because of some files being provided rather than built on-the-fly) and it doesn't get tested regularly. Anyway, I've applied fixes and verified that a build works now. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] BUG #6074: postgresql service script

2011-06-22 Thread Tom Lane
/sysconfig/pgsql/ if you need to change 'em. It's intentional that those settings win out over postgresql.conf. I'm not entirely sure that the OP is using the RHEL RPMs, though, because the fragment he quoted didn't quite match this. regards, tom lane -- Sent via pgsql

Re: [BUGS] BUG #6068: automatic analyze runs endlessly

2011-06-19 Thread Tom Lane
, all right, but I don't see that happening here. At least I don't see any indication of it in pg_stat_all_tables.last_autoanalyze. Are you looking at that, or some other evidence? Do you have any nondefault settings? regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #6068: automatic analyze runs endlessly

2011-06-19 Thread Tom Lane
different about those two tables: they have no analyzeable columns. I thinko'd what to do in that situation. 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

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

2011-06-18 Thread Tom Lane
, and in general I doubt that we ever will, since in most cases the behavior wouldn't be very well-defined. It might be worth a TODO to provide a better error message than syntax error, though. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] BUG #6065: FATAL: lock 0 not held

2011-06-17 Thread Tom Lane
various other theories about PG portability problems. 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] Ident authentication fails due to bind error on server (8.4.8)

2011-06-17 Thread Tom Lane
speculation at this point. (BTW, is it really sane to be using ident auth over a high latency connection? That would certainly suggest to me that you could be getting connections from untrustworthy machines ...) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql

Re: [BUGS] Ident authentication fails due to bind error on server (8.4.8)

2011-06-17 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] Postgresql 9.0.4 initdb bug on solaris 64 bit

2011-06-15 Thread Tom Lane
the rest. 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] [GENERAL] psql \s not working - OS X

2011-06-15 Thread Tom Lane
the pager. 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 #6060: does not work -z option of pg_basebackup

2011-06-15 Thread Tom Lane
pg_basebackup.c.DIST pg_basebackup.c BTW, plain diffs are just about useless, since patch can't apply them safely if the code has changed at all. Please send -c or -u format diffs in future. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] BUG #6061: Progresql.exe memory usage using HOLD cursor.

2011-06-15 Thread Tom Lane
to do so. So data loads that go through that particular API would miss incrementing the space counter. 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 #6062: psql terminates on auto-complete

2011-06-15 Thread Tom Lane
-04/msg00127.php Aside from pestering Apple to fix it, there's not much you can do except install GNU libreadline and link against that instead. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5798: Some weird error with pl/pgsql procedure

2011-06-14 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] expanded mode + wrapping in psql

2011-06-10 Thread Tom Lane
Denis de Bernardy ddeberna...@yahoo.com writes: Wrapping apparently doesn't want to work in expanded mode... No, it's not supposed to. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5926: information schema dtd_identifier for element_types, columns, parameters views inconsistent

2011-06-08 Thread Tom Lane
analysis is correct, we really ought to try to fix this in time for beta2, since there's no way to fix it without a forced initdb. Comments? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view

2011-06-07 Thread Tom Lane
Greg Stark gsst...@gmail.com writes: On Jun 3, 2011 4:20 PM, Tom Lane t...@sss.pgh.pa.us wrote: I'm inclined to write this off as so don't do that. There's nothing that pg_dump can do to make this work: it has to use the USING syntax for the join, and that doesn't offer any way to qualify

Re: [BUGS] BUG #6041: Unlogged table was created bad in slave node

2011-06-07 Thread Tom Lane
want to be testing this in the parser. It has to be done at plan or execute time. 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] ON DELETE CASCADE with multiple paths in PostgreSQL 9.x

2011-06-07 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 #6050: Dump and restore of view after a schema change: can't restore the view

2011-06-07 Thread Tom Lane
the fact that USING is fragile *by definition*. Complain to the standards committee about that. (Question: would you also have us try to work around the fact that USING stops working if you rename one of the join columns?) regards, tom lane -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #6041: Unlogged table was created bad in slave node

2011-06-07 Thread Tom Lane
put it in ExecOpenScanRelation instead, so that it covers both seqscan and indexscan accesses. 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 #6041: Unlogged table was created bad in slave node

2011-06-07 Thread Tom Lane
on unlogged tables, rather than rejiggering pieces of the planner to sort-of not fail on an unlogged table. 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] Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view

2011-06-07 Thread Tom Lane
have gone down any ... I had in mind for pg_dump to decide to use the non-standard syntax iff it was necessary at dump time. Maybe. I'm concerned about the cost of determining whether it's necessary (cost meaning both runtime and code complexity). regards, tom lane

Re: [BUGS] BUG #6041: Unlogged table was created bad in slave node

2011-06-07 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Tue, Jun 7, 2011 at 3:53 PM, Tom Lane t...@sss.pgh.pa.us wrote: It might be that it'd be best just to have both the planner and executor throwing errors on unlogged tables, rather than rejiggering pieces of the planner to sort-of not fail

Re: [BUGS] MACADDR parsing issues

2011-06-06 Thread Tom Lane
like RFC says it should. 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 #6051: wCTE query fail with wrong error text on a table with rules

2011-06-06 Thread Tom Lane
David Fetter da...@fetter.org writes: On Sat, Jun 04, 2011 at 05:24:22PM -0400, Tom Lane wrote: We could paste a copy of the original's cteList into the rule action, but there are still issues: * If there's more than one rule action, we could end up executing multiple copies of the same CTE

Re: [BUGS] BUG #6049: Can't load dumped view with VALUES and ORDER BY

2011-06-04 Thread Tom Lane
Dylan Adams dad...@bybaxter.com writes: If you create a view based on a VALUES statement with an ORDER BY clause, the SQL produced by pg_dump can't be loaded back into the database. I've applied a patch for this. Thanks for the report! regards, tom lane -- Sent via

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

2011-06-04 Thread Tom Lane
rule action without risking a conflict. Ideas anybody? 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 #6050: Dump and restore of view after a schema change: can't restore the view

2011-06-03 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 #6050: Dump and restore of view after a schema change: can't restore the view

2011-06-03 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Fri, Jun 3, 2011 at 10:59 AM, Tom Lane t...@sss.pgh.pa.us wrote: Personally my advice is to avoid USING: it wasn't one of the SQL committee's better ideas. I don't understand why we can't just translate the USING into some equivalent construct

Re: [BUGS] BUG #6050: Dump and restore of view after a schema change: can't restore the view

2011-06-03 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: Tom Lane t...@sss.pgh.pa.us wrote: Personally my advice is to avoid USING: it wasn't one of the SQL committee's better ideas. There's no query you can write with USING that you can't write in a longer form with ON; but a query of moderate

Re: [BUGS] BUG #6050: Dump and restore of view after a schema change: can't restore the view

2011-06-03 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Fri, Jun 3, 2011 at 1:19 PM, Tom Lane t...@sss.pgh.pa.us wrote: Now, if the query doesn't involve any explicit reference to joinalias.*, we could probably fake it with some ugly thing involving COALESCE(leftcol, rightcol) ... but I don't think

Re: [BUGS] BUG #6047: prepare p1 as select 'now'::timestamp; then execute p1 many times, they return the same time

2011-06-02 Thread Tom Lane
() is not a builtin function, we can't change it to select today()::timestamp; You can get that by using date_trunc on the result of now(); or there's current_date, which is actually SQL-standard unlike these other things. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql

Re: [BUGS] UTC4115FATAL: the database system is in recovery mode

2011-06-02 Thread Tom Lane
in the version the OP is running. 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 #6045: Compilation of contribs fail

2011-05-29 Thread Tom Lane
. Use CREATE EXTENSION. 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] [PATCH] ident authentication fails on kFreeBSD/x86-64 due to wrong struct size

2011-05-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] [PATCH] ident authentication fails on kFreeBSD/x86-64 due to wrong struct size

2011-05-29 Thread Tom Lane
around of the backend cmsgmem declaration was documented as fixing problems on NetBSD and then OpenBSD. If it's true as per the libpq comment that only FreeBSD needs the client-side cmsgmem buffer, this might not have gotten retested. regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] Failed pgbench: setrandom invalid maximum number 0

2011-05-28 Thread Tom Lane
, and not the next. Here's what I now get on 8.4, 9.0, and 9.1: $ pgbench btest1 -n setrandom: invalid maximum number 0 That's not valid syntax. Some versions of getopt() take it upon themselves to rearrange the switch order, some do not ... regards, tom lane -- Sent via pgsql

Re: [BUGS] BUG #6044: Access violation on XML decl with standalone

2011-05-27 Thread Tom Lane
. AFAIK there isn't any way to exercise the receive functions via psql. You need a client that will send data as binary parameters. But it's obvious by inspection of the code that it's broken. Will fix, thanks for the report! regards, tom lane -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #6041: Unlogged table was created bad in slave node

2011-05-26 Thread Tom Lane
much pain. 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

<    5   6   7   8   9   10   11   12   13   14   >