Re: [BUGS] BUG #5795: 9.0.2 PDF needs editing

2010-12-20 Thread Tom Lane
not be present in the PDF generation process. 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 #5797: Strange bug with hstore

2010-12-20 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 #5794: 'explain' fails, but executing sql is ok.

2010-12-19 Thread Tom Lane
workaround you could just omit TRUE from CASE TRUE WHEN ... it's a pretty redundant way to write the expression. 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 #5793: tsquery error

2010-12-18 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] index corruption on composite primary key indexes

2010-12-16 Thread Tom Lane
of the table's indexes may have entries for it while others don't. The correct invariant is that (a) if an index entry exists, there must be a heap tuple for it to point at, and (b) a live tuple must have all the index entries it should have. regards, tom lane -- Sent via

Re: [BUGS] [Fwd: DBD::Pg on HP-UX 11.31 64bit]

2010-12-16 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] [Fwd: DBD::Pg on HP-UX 11.31 64bit]

2010-12-16 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] [Fwd: DBD::Pg on HP-UX 11.31 64bit]

2010-12-16 Thread Tom Lane
H.Merijn Brand h.m.br...@xs4all.nl writes: On Thu, 16 Dec 2010 12:31:21 -0500, Tom Lane t...@sss.pgh.pa.us wrote: So what I'm thinking is happening is that libpq expects size_t as the argument type, but it's getting linked against a libc that expects int as the argument type, and whatever HP

Re: [BUGS] memory leaks? using savepoint

2010-12-16 Thread Tom Lane
I'm not particularly excited about fixing this one ... especially not in a stable branch that's not getting a lot of developer testing anymore. I'm inclined to leave this alone --- I think the risks of patching only an old branch will outweigh the benefits. regards, tom lane

Re: [BUGS] [Fwd: DBD::Pg on HP-UX 11.31 64bit]

2010-12-14 Thread Tom Lane
about which it should use? 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] not all pg_stat_database fields reset after pg_stat_reset()

2010-12-12 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Sat, Dec 11, 2010 at 18:31, Tom Lane t...@sss.pgh.pa.us wrote: Hmm.  I think that not resetting the n_tuples_xxx fields was simply an oversight in Magnus' patch that added them, http://archives.postgresql.org/pgsql-committers/2007-03/msg00144.php

Re: [BUGS] BUG #5788: I can drop table , with other user's table

2010-12-11 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] not all pg_stat_database fields reset after pg_stat_reset()

2010-12-11 Thread Tom Lane
/msg00144.php Magnus, was this intentional by any chance? However, I disagree with resetting last_autovac_time ... that's not a counter, so there's no particularly good reason to discard its value. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] not all pg_stat_database fields reset after pg_stat_reset()

2010-12-11 Thread Tom Lane
-table last-vacuum times, so maybe discarding the database-level value too is more consistent. Not sure. 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] variadic flag doesn't work with any type

2010-12-10 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com writes: 2010/12/9 Tom Lane t...@sss.pgh.pa.us: What exactly is the use-case for that? I am working on function that can help with record updating. It's based on polymorphic types. I would to allow a multiple modification per one call - like UPDATE

Re: [BUGS] variadic flag doesn't work with any type

2010-12-09 Thread Tom Lane
that we should do something special with a parameter that happens to be an array. Possibly variadic anyarray will do what you are after. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] variadic flag doesn't work with any type

2010-12-09 Thread Tom Lane
]) --- real call foo(10,20,20) -- but it doesn't work now. I'm not convinced it should work that way. Even if you had convinced me that this was sensible and had a real use-case, making it work like that would take a whole bunch of mechanism that doesn't exist. regards, tom

Re: [BUGS] Problems with max_connections parameter

2010-12-06 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] BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist

2010-12-05 Thread Tom Lane
it wouldn't get indexed. So: commit. 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 #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist

2010-12-05 Thread Tom Lane
Andres Freund and...@anarazel.de writes: On Sunday 05 December 2010 17:42:59 Tom Lane wrote: I think the reason the given example fails is just that it's all being done in one transaction. If the null-containing row were known dead it wouldn't get indexed. So: commit. Um I doubt

Re: [BUGS] BUG #5781: unaccent() function should be marked IMMUTABLE

2010-12-04 Thread Tom Lane
Greg Stark gsst...@mit.edu writes: On Fri, Dec 3, 2010 at 4:50 AM, Tom Lane t...@sss.pgh.pa.us wrote: Even if you're willing to assume that the dictionary being used is the one defined by this module, that dictionary depends on external configuration files which are easily changeable. Don't

Re: [BUGS] Bug: table inheritance. Trigger before DELETE for each statement is ignored

2010-12-03 Thread Tom Lane
misunderstand how triggers on inherited tables work. A row-level trigger is fired for events on rows *in its 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] Bug: table inheritance. Trigger before DELETE for each statement is ignored

2010-12-02 Thread Tom Lane
as target. 2. If i create trigger FOR EACH STATEMENT, it will work ok for insert, update and delete. You mean FOR EACH ROW, no? 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 #5781: unaccent() function should be marked IMMUTABLE

2010-12-02 Thread Tom Lane
are easily changeable. Arguably it'd be reasonable to change the function's marking from volatile to stable, but that's not going to be enough to allow use in indexes. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #5777: Server crash with function out params returned as record

2010-11-30 Thread Tom Lane
noticed before. 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 #5761: In 'dblink' function connection string truncated

2010-11-29 Thread Tom Lane
that, or it's not going to get fixed. 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 #5775: DBLINK Connection String Truncation

2010-11-29 Thread Tom Lane
are getting is *not* about a bad password. It looks like you've neglected to provide a pg_hba.conf entry that will allow dblink connections. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-28 Thread Tom Lane
download and compile all my needed functions, The core uuid type has all that stuff except newid(), which we judged not to be standardizable. You can find a few different uuid-creation functions in contrib/uuid-ossp. regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #5763: pg_hba.conf not honored

2010-11-28 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Tue, Nov 23, 2010 at 10:29 AM, Tom Lane t...@sss.pgh.pa.us wrote: I believe the definition of in role we use here is has the privileges of role.  Since kaiting.chen is a superuser, all privilege tests will succeed for him, including that one.  IOW

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-27 Thread Tom Lane
a third party module that you didn't recompile for 9.0? The magic-block mechanism should prevent that. What I'm wondering about is whether the input function is (a) careless about null input and (b) not marked STRICT. regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-27 Thread Tom Lane
Joshua Tolley eggyk...@gmail.com writes: On Sat, Nov 27, 2010 at 11:23:46AM -0500, Tom Lane wrote: There used to be a project of that name on gborg. I can't find the source code anymore though. How about http://www.postgresql.org/ftp/projects/gborg/uniqueidentifier/stable/ Ah, thanks

Re: [BUGS] BUG #5769: Problem with SPI_getvalue

2010-11-25 Thread Tom Lane
to return a constant string? 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 #5770: Foreign key violation after insert

2010-11-25 Thread Tom Lane
INTO tmp.amavis_user (id, email, priority, policy_id) VALUES (NEW.id, quote_literal(NEW.email), prio, 1); Perhaps you tried to migrate away from using EXECUTE at the same time you were converting to 9.0? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #5766: regexp \y doesn't work properly when a word starts on ends with a UTF-8 char

2010-11-24 Thread Tom Lane
regex operations that depend on locale-specific character classification also not work for you? 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 #5763: pg_hba.conf not honored

2010-11-23 Thread Tom Lane
is has the privileges of role. Since kaiting.chen is a superuser, all privilege tests will succeed for him, including that one. IOW, a superuser is automatically a member of every role. This isn't a bug. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #5761: In 'dblink' function connection string truncated

2010-11-22 Thread Tom Lane
port=5432 will be truncated to dbname=somebase host=xx.xxx.xx.xx user=iamuser password=somepas' Does this actually break anything, or is it just an annoying NOTICE? When I try it here, I get the NOTICE as described, but the connection string still works. regards, tom lane

Re: [BUGS] temporary tables, and lots of 0 byte files

2010-11-22 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] BUG #5759: Autovacuum cost limit trends to 1, using default config

2010-11-19 Thread Tom Lane
worker). So you can end up computing a smaller value on the next round. Lather, rinse, repeat. Will fix. 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

Re: [BUGS] BUG #5757: PL/PGSQL composite variable field error reporting

2010-11-18 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 #5757: PL/PGSQL composite variable field error reporting

2010-11-18 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 #5755: Query Optimzer Bug

2010-11-17 Thread Tom Lane
update customer set login_name = (select NESSOuserName from person where person.cac_cert=customer.cac_cert); That's not 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

Re: [BUGS] BUG #5753: Existing Functions No Longer Work

2010-11-16 Thread Tom Lane
, if the gripe is specifically about what happens in the pgAdmin UI, another possible explanation is that pgAdmin changed. Can you reproduce a change of behavior using just psql? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #5748: Invalid oidvector data during binary recv

2010-11-15 Thread Tom Lane
this should be fixed locally to those two types, rather than changing the behavior of regular arrays. 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 #5748: Invalid oidvector data during binary recv

2010-11-15 Thread Tom Lane
arrays might have been unsupported at one time, but they're certainly considered valid now. 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 #5748: Invalid oidvector data during binary recv

2010-11-15 Thread Tom Lane
be too painful to tweak it to allow the case. It appears to be fairly hard to actually get a non-zero-D empty array into the system, so while this is pretty ugly I think it wouldn't affect common usage. Comments? regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #5753: Existing Functions No Longer Work

2010-11-13 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 #5753: Existing Functions No Longer Work

2010-11-13 Thread Tom Lane
a level of indirect fetch from your client code? 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 #5751: pg_restore does not work correctly with BLOBs

2010-11-12 Thread Tom Lane
Michael Feldmann michael.feldm...@uni-muenster.de writes: [ pg_dump -c doesn't delete BLOBs ] This appears to be fixed in 9.0. I fear it's impractical to do anything about it before that, because pg_dump didn't treat BLOBs as first-class objects before 9.0. regards, tom

Re: [BUGS] WARNING: 01000: could not dump unrecognized node type: 928

2010-11-12 Thread Tom Lane
CREATE TABLE LIKE a lot? 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 #5748: Invalid oidvector data during binary recv

2010-11-11 Thread Tom Lane
the use-case where this would come up? 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 #5748: Invalid oidvector data during binary recv

2010-11-11 Thread Tom Lane
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: On 11.11.2010 17:48, Tom Lane wrote: The problem seems to be that array_recv passes back a zero-dimensional array, *not* a 1-D array, when it observes that the input has no elements. A zero-D array is not part of the subset

Re: [BUGS] BUG #5748: Invalid oidvector data during binary recv

2010-11-11 Thread Tom Lane
of the former's maximum, but I'm worried about whether any code is dependent on an assumption that oidvectors can't get toasted. The type's marked untoastable in pg_type, so maybe enforcing the same limit in the latter is a safer idea. regards, tom lane -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #5748: Invalid oidvector data during binary recv

2010-11-11 Thread Tom Lane
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: On 11.11.2010 18:17, Tom Lane wrote: BTW ... it strikes me there's another inconsistency between oidvectorin and oidvectorrecv, namely that the former enforces a maximum of FUNC_MAX_ARGS elements whereas the latter has

Re: [BUGS] BUG #5748: Invalid oidvector data during binary recv

2010-11-11 Thread Tom Lane
Yeb Havinga yebhavi...@gmail.com writes: If there is going to be a patch fixing things, the value '{1}'::oidvector[] can't be exported and imported through binary send recv as well. That's pilot error, nothing more nor less. (oidvector != oidvector[]) regards, tom

Re: [BUGS] BUG #5748: Invalid oidvector data during binary recv

2010-11-11 Thread Tom Lane
, the apparent value of the lbound would be indeterminate because it's off the end of the allocated space for a zero-D array. But the code wouldn't be reaching that test. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #5745: geometry bug?

2010-11-10 Thread Tom Lane
the perpendicular would have infinite slope, and it is falling through to the take the nearer endpoint case when it shouldn't. 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 #5747: TimeStamps too far into the future are invalid

2010-11-10 Thread Tom Lane
. If you'd like us to believe we have something to fix, please exhibit some SQL commands that deliver an incorrect result. 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 #5745: geometry bug?

2010-11-10 Thread Tom Lane
for the case of infinite slope. 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 #5735: pg_upgrade thinks that it did not start the old server

2010-11-09 Thread Tom Lane
. I think the default is to avoid conversion, so this might be a dead end --- but if for instance you had PGCLIENTENCODING set in the client environment, it could bite you. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #5735: pg_upgrade thinks that it did not start the old server

2010-11-09 Thread Tom Lane
configuration for certain settings like integer_datetimes. Can anyone suggest a way pg_upgrade could detect an upgrade from a 32-bit to 64-bit cpu and throw an error? Surely it does that already, as a result of comparing pg_control contents. regards, tom lane -- Sent via

Re: [BUGS] [PERFORM] typoed column name, but postgres didn't grump

2010-11-05 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: Tom Lane t...@sss.pgh.pa.us wrote: Here's a proposed patch, sans documentation as yet. I see you took the surgical approach -- only a cast from a record to a character string type is affected. I agree that will fix the complaints I've seen

Re: [BUGS] [PERFORM] typoed column name, but postgres didn't grump

2010-11-04 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] [PERFORM] typoed column name, but postgres didn't grump

2010-11-04 Thread Tom Lane
Merlin Moncure mmonc...@gmail.com writes: On Thu, Nov 4, 2010 at 12:14 PM, Tom Lane t...@sss.pgh.pa.us wrote: Kevin Grittner kevin.gritt...@wicourts.gov writes: Merlin Moncure mmonc...@gmail.com wrote: create type x as (a int, b int); select f((1,2)); I think Merlin probably meant to write

Re: [BUGS] BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.

2010-11-04 Thread Tom Lane
Dirk Heinrichs dirk.heinri...@altum.de writes: Am 04.11.2010 04:55, schrieb Tom Lane: I don't actually see any point in having two functions at all. Since the trigger is examining the column type internally, it could perfectly well do the right thing at runtime depending on column type. Got

Re: [BUGS] BUG #5743: Regexp engine fails to case-insensitively match multi-byte codepoints

2010-11-03 Thread Tom Lane
for cases using UTF8 encoding. 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 #5740: contrib/spi/moddatetime.c doesn't work with timezones.

2010-11-03 Thread Tom Lane
actually see any point in having two functions at all. Since the trigger is examining the column type internally, it could perfectly well do the right thing at runtime depending on column type. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] index on function confuses drop table cascade on child

2010-11-02 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: Tom Lane t...@sss.pgh.pa.us wrote: 3. Or, perhaps we could change recordDependencyOnSingleRelExpr so that it generates a whole-table dependency on the target relation even if there are no Vars in the expression. This would make it act much

Re: [BUGS] BUG #5738: btree index search bug

2010-11-01 Thread Tom Lane
spche sp...@163.com writes: Description:btree index search bug I see no bug here. The cursor is opened at a time when there is one row with a=3, so it can find only that one row because of its snapshot. regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] index on function confuses drop table cascade on child

2010-11-01 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] index on function confuses drop table cascade on child

2010-11-01 Thread Tom Lane
too cute about eliminating redundant dependencies. But at the same time, predicting what behavior such uses might need is a tough game in itself, and maybe one that we shouldn't get into now. Any thoughts out there? regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #5733: Strange planer behaviour with inherited tables

2010-10-31 Thread Tom Lane
unlikely that discussing trivial examples like this will help get to the bottom of it. We'd need to look at example tables that have realistic statistics. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription

Re: [BUGS] BUG #5734: autovacuum_enabled input should be validated, standardized.

2010-10-30 Thread Tom Lane
other boolean parameter. What I think you are complaining about is not that, but that we don't rewrite the source string into some standard format. That seems rather impractical though. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] BUG #5736: 9.0.1 segmentation fault (sig11) during long-lived update

2010-10-30 Thread Tom Lane
in ~postgres/.bash_profile. 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] What happened to SSL_CIPHERS?

2010-10-29 Thread Tom Lane
branches. 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] [PERFORM] typoed column name, but postgres didn't grump

2010-10-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] [PERFORM] typoed column name, but postgres didn't grump

2010-10-29 Thread Tom Lane
-standing behaviors than things we just recently introduced. 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] Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby

2010-10-28 Thread Tom Lane
partially completed operations. Were there similar warnings on the master? Uninitialized-page warnings are expected in certain error-recovery scenarios, but I'd be a little worried if the slave appeared to be out of sync with the master. regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #5732: parsing of: WHERE mycol=123AND ...

2010-10-28 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 #5732: parsing of: WHERE mycol=123AND ...

2010-10-28 Thread Tom Lane
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] BUG #5732: parsing of: WHERE mycol=123AND ...

2010-10-28 Thread Tom Lane
. Might be a good idea to change generally to usually, though, since generally might be read as implying that that's the exact and only rule. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5725: server couldn't start when installing on liveCD

2010-10-26 Thread Tom Lane
anyway on their platform. 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 #5725: server couldn't start when installing on liveCD

2010-10-26 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 #5727: Indexes broken in streaming replication

2010-10-26 Thread Tom Lane
in practice, because they also have no WAL protection and don't perform very well anyway. Why did you pick a hash index for a production application? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5728: Unexpected behavior comparing result of age() to an interval

2010-10-26 Thread Tom Lane
further arithmetic with 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 #5729: psql stopped after invalid surrogate pair

2010-10-26 Thread Tom Lane
Alan Choi alan.c...@emc.com writes: psql stopped and quit if it encountered an invalid surrogate pair. 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 #5722: vacuum full does not update last_vacuum statistics

2010-10-25 Thread Tom Lane
behavior is reasonable. VACUUM FULL is (still) not intended as a routine maintenance operation, and the point of that column is to track routine maintenance operations. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #5722: vacuum full does not update last_vacuum statistics

2010-10-25 Thread Tom Lane
) is to change the documentation :-) Yeah, that part of the docs will require editing no matter what we do. I'm just trying to get some clarity on what the most reasonable behavior is. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] Segfault in 9.0 inlining SRF

2010-10-25 Thread Tom Lane
Brendan Jurd dire...@gmail.com writes: On 25 October 2010 07:36, Tom Lane t...@sss.pgh.pa.us wrote: I'm guessing it was modified in the temporary memory context and not properly copied out to the parent context when we finished inlining the function. Thanks for the hint; I found

Re: [BUGS] Segfault in 9.0 inlining SRF

2010-10-25 Thread Tom Lane
to use a temporary memory context during function inlining, and just accept that whatever memory we chew up there is going to be leaked for the duration of planning. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] Segfault in 9.0 inlining SRF

2010-10-24 Thread Tom Lane
guessing it was modified in the temporary memory context and not properly copied out to the parent context when we finished inlining the function. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5720: Bug for PQescapeByteaConn (libpq)

2010-10-22 Thread Tom Lane
, it is not suggested anywhere that it should have an effect on clients. 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 #5720: Bug for PQescapeByteaConn (libpq)

2010-10-22 Thread Tom Lane
Craig Ringer cr...@postnewspapers.com.au writes: On 23/10/2010 1:11 AM, Tom Lane wrote: Why do you expect that? The parameter only controls the *server*'s output, it is not suggested anywhere that it should have an effect on clients. I'm not at all sure what the right answer is here. I just

Re: [BUGS] BUG #5718: Cannot start postgres (FATAL: invalid cache id: 19)

2010-10-20 Thread Tom Lane
frozenxid values into the new catalogs, anyway? 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 #5716: Regression joining tables in UPDATE with composite types

2010-10-19 Thread Tom Lane
comparing plain ints would be. I'm sure that coding technique looks cute, but you're paying through the nose for it. Consider making price_key a simple domain over int. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #5705: btree_gist: Index on inet changes query result

2010-10-19 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Mon, Oct 11, 2010 at 7:50 PM, Tom Lane t...@sss.pgh.pa.us wrote: Well, actually the btree_gist implementation for inet is a completely broken piece of junk: it thinks that convert_network_to_scalar is 100% trustworthy and can be used as a substitute

Re: [BUGS] BUG #5715: man pages missing after compiling PostgreSQL 9.0.1 sources on OS X 10.6

2010-10-18 Thread Tom Lane
to speculate without facts as to what you did. 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 #5715: man pages missing after compiling PostgreSQL 9.0.1 sources on OS X 10.6

2010-10-18 Thread Tom Lane
Joel Lopes Da Silva j...@lopes-da-silva.com writes: On Oct 18, 2010, at 7:16 AM, Tom Lane wrote: What commands did you issue, exactly? I did: ./configure --enable-thread-safety \ --with-openssl \ --with-perl

Re: [BUGS] Empty bytea format - 9.1devel pg_dump and psql

2010-10-18 Thread Tom Lane
as soon as it sees a non-empty bytea, so what's the use of trying to make the empty-string case backwards compatible? It's probably better you find out about the incompatibility sooner, so you can get on with fixing the real problem. regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #5714: TZ pattern error on to_timestamp

2010-10-17 Thread Tom Lane
of the error message varies a bit, but they all agree that a TZ format spec isn't supported. I don't know what changed in your installation, but it wasn't this. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #5714: TZ pattern error on to_timestamp

2010-10-17 Thread Tom Lane
hubert depesz lubaczewski dep...@depesz.com writes: On Sun, Oct 17, 2010 at 11:10:09AM -0400, Tom Lane wrote: Testing shows that that example fails in every Postgres release back to 7.1. The spelling of the error message varies a bit, but they all agree that a TZ format spec isn't supported

<    8   9   10   11   12   13   14   15   16   17   >