Re: [BUGS] BUG #6270: Invalid string comparison if the string contains '+' or '-' sign.

2011-10-25 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 #6268: multiple update with on cascade

2011-10-25 Thread Tom Lane
; in particular the problem would come back if you did a dump and reload. 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] auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)

2011-10-25 Thread Tom Lane
= true auto_explain.log_buffers = true As the postgres user, issue pg_ctl reload pg_ctl status will now show that there is no running postmaster. This looks like the same thing as bug #6097, which is fixed in 9.0.5. regards, tom lane -- Sent via pgsql-bugs mailing

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

2011-10-25 Thread Tom Lane
might want to check for pg_class entries with reltablespace = 16384 before pulling the trigger. 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 #6264: Superuser does not have inherent Replication permission

2011-10-22 Thread Tom Lane
, they will NOT have the replication permission and cannot be used as a replication user until you explicitly grant that permission. That doesn't sound to me like a bug. These flags are independent, we just provide a certain default at role creation time. regards, tom

Re: [BUGS] 'pg_ctl restart' confused about pathname to postgresql.conf

2011-10-22 Thread Tom Lane
this by having pg_ctl try to absolute-ify the -D setting during postmaster start, but I'm not convinced it's worth the trouble, or even that it's appropriate for pg_ctl to editorialize on the user's choice of absolute vs relative path. regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #6262: while installing postgis in make install leavingdirectory

2011-10-20 Thread Tom Lane
old recipe for target `uninstall' make[1]: Nothing to be done for `all'. You probably need to report that to the postgis folk, not here. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] Can't use WITH in a PERFORM query in PL/pgSQL?

2011-10-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 #6263: \l causes core dump with large database

2011-10-20 Thread Tom Lane
database means little, and it certainly doesn't explain why you're seeing it when nobody else has reported any such thing. 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 #6263: \l causes core dump with large database

2011-10-20 Thread Tom Lane
), the command works. In that case you're dealing with a libedit bug. libedit has a lot of known problems, especially if you're trying to use an old version as it sounds like you might be. There's not a lot we can do about that. regards, tom lane -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #6263: \l causes core dump with large database

2011-10-20 Thread Tom Lane
personally, so replying only to me isn't going to get you anywhere. Please keep the list cc'd when replying. 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] Can't use WITH in a PERFORM query in PL/pgSQL?

2011-10-20 Thread Tom Lane
DBs might be confused by this; but the current arrangement is also confusing lots of people, so I don't think that argument has all that much weight. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription

Re: [BUGS] incompatible pointer type

2011-10-19 Thread Tom Lane
available. 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] Can't use WITH in a PERFORM query in PL/pgSQL?

2011-10-19 Thread Tom Lane
be an unreasonable thing to just interpret a SELECT with no INTO clause as being a PERFORM (ie execute and discard results). Then we'd not have to do anything magic for commands starting with WITH. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] Can't use WITH in a PERFORM query in PL/pgSQL?

2011-10-19 Thread Tom Lane
a SELECT and discarding the result simply isn't there. So at this point it looks like we made up PERFORM out of whole cloth, and we could just as easily choose to do it another way. Jan, do you remember anything about the reasoning for PERFORM? regards, tom lane -- Sent

Re: [BUGS] char(0)

2011-10-18 Thread Tom Lane
standard is perfectly clear on this. *Values* of type varchar can be of zero length, but that does not mean that you can *declare* a column to be varchar(0), and that NOTE says specifically that you can't. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] incompatible pointer type

2011-10-18 Thread Tom Lane
proposed patch seems to me to be making more assumptions about what bison will emit (specifically, about the ordering of various code blocks) than what we're doing now. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] incompatible pointer type

2011-10-18 Thread Tom Lane
Robert Young yay...@gmail.com writes: On Tue, Oct 18, 2011 at 18:22, Tom Lane t...@sss.pgh.pa.us wrote: Hmm, what version of bison are you using? # /usr/bin/bison -V bison (GNU Bison) 2.3 Written by Robert Corbett and Richard Stallman. Copyright (C) 2006 Free Software Foundation, Inc

Re: [BUGS] incompatible pointer type

2011-10-18 Thread Tom Lane
copy of m4, but GNU m4 1.4.4, and that the problem is not reproducible with newer versions of m4. So what it seems to boil down to is get a newer m4. Especially if you've got 1.4.4. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] incompatible pointer type

2011-10-18 Thread Tom Lane
Robert Young yay...@gmail.com writes: I've update my m4 to version 1.4.13 from: http://ftp.openbsd.org/pub/OpenBSD/4.9/packages/amd64/m4-1.4.13.tgz the problem solved perfectly! Just for the archives' sake, can you confirm which m4 version you had before? regards, tom

Re: [BUGS] BUG #6258: Lock Sequence

2011-10-17 Thread Tom Lane
the blocking of the sequence? Why did you do that, that is what were you trying to accomplish? It never did block nextval() on the sequence, for example. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription

Re: [BUGS] BUG #6258: Lock Sequence

2011-10-17 Thread Tom Lane
Laerson keler laerson.ke...@lkmc.com.br writes: 2011/10/17 Tom Lane t...@sss.pgh.pa.us Laerson Keler laerson.ke...@lkmc.com.br writes: Why did you do that, that is what were you trying to accomplish? It never did block nextval() on the sequence, for example. Tom Lane, good afternoon, I

Re: [BUGS] BUG #6259: Collation Error with Citext fields

2011-10-17 Thread Tom Lane
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 #6238: ECPG converts long long to long on Windows

2011-10-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] psql's \copy incompatible with :variables

2011-10-13 Thread Tom Lane
Did not find any relation named foo. regression=# \d :foo Did not find any relation named bar. \copy is different because it uses OT_WHOLE_LINE mode to read the argument, and that doesn't expand :variable references. I'd be a bit leery of changing that. regards, tom lane

Re: [BUGS] memory leak in postgresql

2011-10-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] BUG #6240: About - postgreswdinit.sql

2011-10-05 Thread Tom Lane
subdirectory of $PGDATA/base to create a new database 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 #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update)

2011-10-05 Thread Tom Lane
for updates caused by FK actions, which would be a cure worse than the disease. 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 #6233: pg_dump hangs with Access Violation C0000005

2011-10-04 Thread Tom Lane
to be multiple instances of the dubious coding. It's a bit hard to believe that nobody's noticed that before. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-10-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] bug in dependency - there is possibility to break a system catalog

2011-10-03 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com writes: [ we forgot to record dependencies on function default expressions ] 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] Typo in nbtsort.c

2011-10-01 Thread Tom Lane
the standard contraction for if and only if. 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 #6236: Query execution bug

2011-09-30 Thread Tom Lane
be bothered to do that, using text instead of varchar as the column type would avoid most of the cases where you'll see something like this. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #6235: Delete fails with ON DELETE rule on inherited table

2011-09-30 Thread Tom Lane
trying to delete a referenced row that is in fact still referenced. One solution would be to declare the foreign key constraint as DEFERRABLE INITIALLY DEFERRED. (The same would be the case for a trigger, unless you made it an AFTER trigger.) regards, tom lane -- Sent via

Re: [BUGS] no relation entry for relid 1

2011-09-29 Thread Tom Lane
by schemaname This produces the internal error message no relation entry for relid 1. Why is that? Looks like I broke it here: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1cb108efb0e60d87e4adec38e7636b6e8efbeb57 Fixed, thanks for the report! regards, tom lane

Re: [BUGS] no relation entry for relid 1

2011-09-29 Thread Tom Lane
Peter Geoghegan pe...@2ndquadrant.com writes: On 29 September 2011 23:15, Tom Lane t...@sss.pgh.pa.us wrote: Looks like I broke it here: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1cb108efb0e60d87e4adec38e7636b6e8efbeb57 Hmm. Although it was obvious to me

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-28 Thread Tom Lane
catalogs never have been supported, meaning that we will never offer a guarantee that something that (more or less) worked in a previous release will still work in newer ones. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-28 Thread Tom Lane
case for index corruption, since we must be able to compare other OID values to the non-leaf-page entry to figure out which leaf page to descend to in searches. In short, the reason why this type of code hasn't been adopted into core is that it doesn't work. regards, tom

Re: [BUGS] BUG #6232: hstore operator ? no longer uses indexes

2011-09-28 Thread Tom Lane
be ignored when matching to a collation-less index? If not, what's the correct rule? I don't like the idea of concluding that hstore has to be forcibly assigned a collation just because it has some operators that accept text ... regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #6232: hstore operator ? no longer uses indexes

2011-09-28 Thread Tom Lane
not anything too obviously broken about the idea. 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 #6229: Postgresql crashes after: LOG: statistics buffer is full

2011-09-27 Thread Tom Lane
of the 8.1 release branch if you can't easily migrate to a supported branch. 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 #6227: No arguments for COPY OIDS and HEADER

2011-09-27 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 #6230: strange changes in behavior of string functions

2011-09-27 Thread Tom Lane
you didn't use the same locale settings when creating your 9.1 database. Check LC_CTYPE and LC_COLLATE settings. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [BUGS] BUG #6213: COPY does not work as expected in a plpgsql function

2011-09-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 #6218: TRAP: FailedAssertion( !(owner-nsnapshots == 0), File: resowner.c, Line: 365)

2011-09-26 Thread Tom Lane
good reason to think that someone might not ask for a snapshot during commit processing. Alvaro, do you happen to remember why this got designed as an early transaction shutdown action, rather than delaying it as long as possible? regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #6222: Segmentation fault on unlogged table

2011-09-26 Thread Tom Lane
, but I see you beat me to the deduction. Will commit it (with more than zero comments) in a moment. 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 in plancache.c

2011-09-26 Thread Tom Lane
! (But a fix like this really requires a comment IMO.) 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 #6218: TRAP: FailedAssertion( !(owner-nsnapshots == 0), File: resowner.c, Line: 365)

2011-09-26 Thread Tom Lane
with commitfest stuff, but please let me know otherwise. I have what-I-think-is-the-fix pretty clear in my own mind, so let me give it a try. If it doesn't work I'll bounce it back to you. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] pg 9.1.1 - ERROR: could not find pathkey item to sort

2011-09-26 Thread Tom Lane
bricklen brick...@gmail.com writes: Is this a bug, Yes. Thanks for the test case, 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/mailpref/pgsql-bugs

Re: [BUGS] pg 9.1.1 - ERROR: could not find pathkey item to sort

2011-09-26 Thread Tom Lane
I wrote: bricklen brick...@gmail.com writes: Is this a bug, Yes. Thanks for the test case, will look. Fixed, patch is at http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1679e9feddc94bd7372a6829db92868e55ef7177 regards, tom lane -- Sent via pgsql

Re: [BUGS] BUG #6218: TRAP: FailedAssertion( !(owner-nsnapshots == 0), File: resowner.c, Line: 365)

2011-09-25 Thread Tom Lane
the following patch make sense? Maybe, but I'd still like to see a test case, because I can't reproduce any such problem by preparing ROLLBACK in an aborted transaction. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #6216: Calling PQconnectdbParams from C++ with a char**

2011-09-25 Thread Tom Lane
* like elsewhere in the same file instead of char const* const*. Yep, I'm happy with that. It does what it says and no more. I went ahead and committed this, since there seems no very good reason to make it wait for the next commitfest. regards, tom lane -- Sent via

Re: [BUGS] Timezone issues with Postrres

2011-09-23 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Thu, Sep 22, 2011 at 07:42, Tom Lane t...@sss.pgh.pa.us wrote: I think we ought to map Central America Standard Time to plain CST6. Magnus, AFAICT from the commit logs, that lookup table was your work to begin with --- do you remember anything

Re: [BUGS] BUG #6205: ERROR: temporary tables cannot specify a schema name

2011-09-21 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Sun, Sep 18, 2011 at 5:10 PM, Robert Haas robertmh...@gmail.com wrote: On Thu, Sep 15, 2011 at 12:05 AM, Tom Lane t...@sss.pgh.pa.us wrote: In that case I'm betting Robert broke it somewhere in the unlogged-table changes. Yeah, looks like

Re: [BUGS] BUG #6218: TRAP: FailedAssertion(!(owner-nsnapshots == 0), File: resowner.c, Line: 365)

2011-09-21 Thread Tom Lane
: resowner.c, Line: 365) LOG: server process (PID 16832) was terminated by signal 6: Abort trap There isn't terribly much we can do with this report unless you can provide a complete test case to reproduce it. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] Timezone issues with Postrres

2011-09-21 Thread Tom Lane
and then changed their laws. 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] Broken selectivity with special inet operators

2011-09-21 Thread Tom Lane
| scalargtsel | scalargtjoinsel (inet,inet) | network_sub | - | - =(inet,inet) | network_subeq | - | - (inet,inet) | network_sup | - | - =(inet,inet) | network_supeq | - | - (10 rows) regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] Broken selectivity with special inet operators

2011-09-21 Thread Tom Lane
Josh Berkus j...@agliodbs.com writes: On 9/21/11 1:56 PM, Tom Lane wrote: A look in pg_operator will show you that these operators have no associated selectivity estimators at all. It's not so much broken as unimplemented. Oh! I was assuming that the special case code kicked in regardless

Re: [BUGS] Broken selectivity with special inet operators

2011-09-21 Thread Tom Lane
is *not* a substitute for providing a selectivity estimator. It's possible that we could build simple estimators for these operators that just turn the problem into a range estimation and then pass it off to somewhere else, but nobody has tried. regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] Timezone issues with Postrres

2011-09-21 Thread Tom Lane
the reasoning for the Central America entries? 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 #6217: to_char() gives incorrect output for very small float values

2011-09-20 Thread Tom Lane
, the reason you just get 0. is that it's rounding off after 15 digits to ensure it doesn't print garbage. Maybe it could be a bit smarter for cases where the value is very much smaller than 1, but it wouldn't be a simple change.) regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #6217: to_char() gives incorrect output for very small float values

2011-09-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 #6217: to_char() gives incorrect output for very small float values

2011-09-20 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: Tom Lane t...@sss.pgh.pa.us wrote: If we're gonna fix it, we should just fix it, I think. I was considering taking a stab at it, but if someone else would like to, that's fine too. I wouldn't mind doing it, but not until after the CF wraps

Re: [BUGS] BUG #6217: to_char() gives incorrect output for very small float values

2011-09-20 Thread Tom Lane
Greg Stark st...@mit.edu writes: On Tue, Sep 20, 2011 at 8:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: However, it would be interesting to know what Oracle etc do with NaN and Infinity, assuming they even support such numbers. Note that it looks like NUMBER cannot store either Infinity or NaN

Re: [BUGS] BUG #6216: Calling PQconnectdbParams from C++ with a char**

2011-09-20 Thread Tom Lane
you're supposed to put static, but in any case char const * looks pretty weird to me.) Also, the existing usages in libpq-fe.h look like that, and there's no good reason for these to be randomly different. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #6214: can't change Column COLLATE

2011-09-19 Thread Tom Lane
yulin liu e9320...@gmail.com writes: can't change Column COLLATE pg_catalog.default to pg_catalog.zh_TW.euctw Use ALTER TABLE ... ALTER COLUMN ... TYPE ... COLLATE ... regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #6214: can't change Column COLLATE

2011-09-19 Thread Tom Lane
probably trying to tell you is that you can't use an EUC_TW based locale in a database with UTF8 encoding. Try zh_TW.utf8. 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 #6212: PREPARE(pseudotype) should be blocked off

2011-09-16 Thread Tom Lane
it just to prevent peculiar errors. Can you point to any worse consequences? 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 #6212: PREPARE(pseudotype) should be blocked off

2011-09-16 Thread Tom Lane
caleb.wel...@emc.com writes: On Sep 16, 2011, at 11:11 AM, Tom Lane wrote: Hmm. It would require an extra catalog lookup per parameter to enforce that. Not sure that it's worth it just to prevent peculiar errors. Can you point to any worse consequences? I haven't found any more severe

Re: [BUGS] BUG #5800: corrupted error messages (encoding problem ?)

2011-09-16 Thread Tom Lane
to the name of the database encoding (or more likely, some suitable abbrevation). The logging collector protocol would have to be expanded to include that information, but that seems do-able. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] Dropped index on table preventing rule creation

2011-09-14 Thread Tom Lane
got exactly the same issue. One related thing that seems worth doing is ripping out relhaspkey, Having a hard time getting excited about that either ... regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] segfault using pg_options_to_table(), v9.0.4

2011-09-13 Thread Tom Lane
no value. Will fix, thanks. 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] Dropped index on table preventing rule creation

2011-09-13 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Sep 10, 2011, at 11:26 PM, Tom Lane t...@sss.pgh.pa.us wrote: (IOW, rather than fix this I'd prefer to rip out the code altogether. But maybe we should wait a couple more years for that.) IIRC, it's not dead code. I think you can still generate

Re: [BUGS] Dropped index on table preventing rule creation

2011-09-10 Thread Tom Lane
years obsolete at this point. We don't even document that you can do the above, do we? (IOW, rather than fix this I'd prefer to rip out the code altogether. But maybe we should wait a couple more years for that.) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql

Re: [BUGS] BUG #6200: standby bad memory allocations on SELECT

2011-09-09 Thread Tom Lane
if it crashes? 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] psql doesn't reuse -p after backend fail

2011-09-06 Thread Tom Lane
hubert depesz lubaczewski dep...@depesz.com writes: On Mon, Sep 05, 2011 at 02:27:23PM -0400, Tom Lane wrote: It's not just the port, it's all the connection parameters --- do_connect relies on the PGconn object to remember those, and in this case there no longer is a PGconn object. We

Re: [BUGS] BUG #6199: Can't install datatype hstore

2011-09-06 Thread Tom Lane
. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] psql doesn't reuse -p after backend fail

2011-09-05 Thread Tom Lane
--- do_connect relies on the PGconn object to remember those, and in this case there no longer is a PGconn object. We could have psql keep that information separately, but I'm not sure it's really worth the trouble. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql

Re: [BUGS] BUG #6198: init-po fails for plperl due to invalid xsubpp path (contains ExtUtils)

2011-09-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] BUG #6192: Incorrect result from operator overlaps

2011-09-01 Thread Tom Lane
, ie ['2011-08-01', '2011-08-31'). So that does not overlap the point '2011-08-31'. 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 #6186: out of memory while analyze

2011-08-31 Thread Tom Lane
of default_statistics_target to point out that it costs not only more time but more memory in ANALYZE. 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 #6186: out of memory while analyze

2011-08-30 Thread Tom Lane
Lampa lamp...@gmail.com writes: Trying analyze table (ANALYZE TABLE table or VACUUM ANALYZE table) with 3051316 rows (displayed size 2521MB in \dt+) What have you got maintenance_work_mem set to? shared_buffers might also be interesting. regards, tom lane -- Sent via

Re: [BUGS] the '::' cast doesn't work in the FROM clause

2011-08-29 Thread Tom Lane
create view vv as select val from CAST(random() as integer) as val; you will find that the system prints it out with the :: syntax, which won't work. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #6181: concat_ws() incompatibility with MySQL

2011-08-29 Thread Tom Lane
', NULL) - array_to_string(ARRAY[NULL, 'X'], '/') Yeah, I think you're right. Fortunately it's not too late to change this without introducing backwards-compatibility issues of our own. Will fix. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #6182: /etc/init.d/postgresql-8.4 is incomplete for chkconfig

2011-08-29 Thread Tom Lane
Steven Williams stwilli...@novell.com writes: Description:/etc/init.d/postgresql-8.4 is incomplete for chkconfig This file is not distributed by us. You probably need to contact the SUSE packager of postgresql. regards, tom lane -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #6183: FATAL: canceling authentication due to timeout

2011-08-29 Thread Tom Lane
that access pg_authid, and for some reason aren't releasing their locks promptly? 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] pgbench -T isn't a hard cutoff.

2011-08-26 Thread Tom Lane
resolutions are different on different 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] libber library not found on RC1

2011-08-25 Thread Tom Lane
have (specifically, wanting different revision numbers of some shared libraries). If so, you may need to build the software locally to get something that will work for you. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #6176: pg_dump dumps pg_catalog tables

2011-08-25 Thread Tom Lane
how that switch interacts with wildcard --table specs ... 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 #6171: Sockets Issue

2011-08-22 Thread Tom Lane
. The configuration file option does have use-cases, just not yours. 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 #6172: DROP EXTENSION error without CASCADE

2011-08-22 Thread Tom Lane
. On the whole I'm starting to think that throwing an error is the best thing. We could always relax that later, but going the other way might be problematic. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #6165: documentation bug in plpgsql-declarations.html and plpgsql-statements.html (or plpgsql parser bug)

2011-08-22 Thread Tom Lane
discussed. I've seen at least a few people saying that they do rely on 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] Segfault with before triggers and after triggers with a WHEN clause.

2011-08-21 Thread Tom Lane
, in that es_trig_tuple_slot is mainly meant for the use of the layer of functions that are calling TriggerEnabled --- it's not hard to foresee other bugs if we rearrange the timing of the existing ExecStoreTuple calls in ExecBRUpdateTriggers and friends. regards, tom lane -- Sent via pgsql

Re: [BUGS] BUG #6172: DROP EXTENSION error without CASCADE

2011-08-21 Thread Tom Lane
something to do with http://git.postgresql.org/gitweb/?p=postgresql.gita=commitdiffh=eb15f26d577a11319b9429fb84f752a0135918db 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 #6166: configure from source fails with 'This platform is not thread-safe.' but was actually /tmp perms

2011-08-20 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Tom Lane wrote: (The error message seems to be suffering from a bad case of copy-and- paste-itis, too.) Actually, it is accurate. The code is: #ifdef WIN32 h1 = CreateFile(TEMP_FILENAME_1, GENERIC_WRITE, 0, NULL, OPEN_ALWAYS, 0

Re: [BUGS] BUG #6168: db_link may generate additional unformatted log entries in stderr

2011-08-19 Thread Tom Lane
that might happen in code called by the backend, and it's doing exactly what it's supposed to. 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 #6167: pg_dump fails on table lock

2011-08-18 Thread Tom Lane
... if you know it's a transient table, why do you care about backing it 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 #6166: configure from source fails with 'This platform is not thread-safe.' but was actually /tmp perms

2011-08-17 Thread Tom Lane
using. 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 #6166: configure from source fails with 'This platform is not thread-safe.' but was actually /tmp perms

2011-08-17 Thread Tom Lane
seems to be suffering from a bad case of copy-and- paste-itis, too.) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] ISBN: dump from 64bits and restore on 32 bits fail, Datum?

2011-08-10 Thread Tom Lane
, then source the dump, ignoring the object-already-exists errors you get for the module's objects. 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

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