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

2011-06-07 Thread Robert Haas
a brief history of how I ended up where I am. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 Robert Haas
On Fri, Jun 3, 2011 at 2:21 PM, Tom Lane t...@sss.pgh.pa.us wrote: 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

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

2011-06-07 Thread Robert Haas
On Tue, Jun 7, 2011 at 11:50 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: Patch along these lines attached. Frankly, I find this quite ugly, and much prefer the general approach of your previous patch in banlktim433vf5hwjbj0fswm_-xa8dda...@mail.gmail.com

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

2011-06-07 Thread Robert Haas
On Tue, Jun 7, 2011 at 11:41 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: If your point here is that you don't want to spend time hacking on this because it's a fairly marginal feature and therefore not terribly high on your priority list, I can understand

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

2011-06-07 Thread Robert Haas
On Tue, Jun 7, 2011 at 2:05 PM, Robert Haas robertmh...@gmail.com wrote: On Tue, Jun 7, 2011 at 11:50 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: Patch along these lines attached. Frankly, I find this quite ugly, and much prefer the general approach

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

2011-06-07 Thread Robert Haas
On Tue, Jun 7, 2011 at 3:53 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: I found a few other holes in my previous patch as well.  I think this plugs them all, but it's hard to be sure there aren't any other calls to RelationGetNumberOfBlocks() that could

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

2011-06-07 Thread Robert Haas
On Tue, Jun 7, 2011 at 5:05 PM, Tom Lane t...@sss.pgh.pa.us wrote: 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

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

2011-06-07 Thread Robert Haas
On Tue, Jun 7, 2011 at 6:06 PM, Robert Haas robertmh...@gmail.com wrote: But for the planner, why not just put the same kind of test in get_relation_info, just after it does heap_open? OK, let me try that. Seems to work beautifully, so committed that way. -- Robert Haas EnterpriseDB: http

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

2011-06-06 Thread Robert Haas
On Fri, Jun 3, 2011 at 1:01 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Robert Haas's message of vie jun 03 12:44:45 -0400 2011: On Wed, Jun 1, 2011 at 2:28 PM, Robert Haas robertmh...@gmail.com wrote: (4) It strikes me that it might be possible to address this problem

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

2011-06-03 Thread Robert Haas
On Wed, Jun 1, 2011 at 2:28 PM, Robert Haas robertmh...@gmail.com wrote: On Thu, May 26, 2011 at 12:34 PM, Tom Lane t...@sss.pgh.pa.us wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Excerpts from Euler Taveira de Oliveira's message of jue may 26 12:00:05 -0400 2011: I think we

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

2011-06-03 Thread Robert Haas
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 that doesn't involve USING. I proposed that a while ago and you shot it down, but I didn't find the reasoning very compelling. -- Robert Haas

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

2011-06-03 Thread Robert Haas
On Fri, Jun 3, 2011 at 1:19 PM, Tom Lane t...@sss.pgh.pa.us wrote: 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

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

2011-06-02 Thread Robert Haas
On Wed, May 25, 2011 at 7:29 AM, Susanne Ebrecht susa...@2ndquadrant.com wrote: I think we should fix the documentation here. Patch? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

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

2011-06-02 Thread Robert Haas
is almost certainly gone in more recent versions. It would be nice to track done and fix whatever is wrong in the older branches, but we'd probably need a reproducible test case of some sort. I don't think it craps out like that EVERY time you interrupt it... -- Robert Haas EnterpriseDB: http

Re: [BUGS] Unlogged tables cannot be truncated twice

2011-06-02 Thread Robert Haas
On Wed, Jun 1, 2011 at 1:15 PM, Robert Haas robertmh...@gmail.com wrote: 2011/5/31 Andres Freund and...@anarazel.de: On Tuesday, May 31, 2011 03:27:22 Alvaro Herrera wrote: Excerpts from Andres Freund's message of lun may 30 20:47:49 -0400 2011: On Tuesday, May 31, 2011 02:35:58 AM Andres

Re: [BUGS] BUG #6048: TRUNCATE vs TRUNCATE CASCADE: misleading message

2011-06-02 Thread Robert Haas
disinclined to put in the time to fix this. However, patches are welcome... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [BUGS] Unlogged tables cannot be truncated twice

2011-06-02 Thread Robert Haas
patch... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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] Unlogged tables cannot be truncated twice

2011-06-01 Thread Robert Haas
that's a 9.2 project. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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] Unlogged tables cannot be truncated twice

2011-06-01 Thread Robert Haas
to fix this. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5903: Turkish encoding problem

2011-06-01 Thread Robert Haas
locale-aware functions on Windows, or just different ones, but I wouldn't even know where to start looking for that sort of problem. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

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

2011-06-01 Thread Robert Haas
? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company reject-unlogged-during-recovery.patch Description: Binary data -- 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 #6042: unlogged table with Streaming Replication

2011-06-01 Thread Robert Haas
I think the current default is good, because it means you only need to change ONE parameter to switch from async rep to sync rep (namely, synchronous_standby_names). -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #6022: Postgre84+RHEL6+Veritas file system?

2011-06-01 Thread Robert Haas
they're doing), and to get stack traces of where they are stuck using gdb. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [BUGS] BUG #5984: Got FailedAssertion(!(opaque-btpo_prev == target), File: nbtpage.c, Line: 1166)

2011-06-01 Thread Robert Haas
and the integrity of your hardware. This kind of thing usually means that corruption is happening somewhere, and if you don't track it down and fix it, eventually it will probably add up to something serious. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [BUGS] BUG #6021: There is no difference between default and empty access privileges with \dp

2011-05-23 Thread Robert Haas
On Sun, May 15, 2011 at 5:02 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Thu, May 12, 2011 at 6:20 PM, Tom Lane t...@sss.pgh.pa.us wrote: One possibility is to start showing default when the ACL is null, which would be quite easy to implement

Re: [BUGS] BUG #6028: age() function output contracts months, but not any other units.

2011-05-23 Thread Robert Haas
anyone feel this is worth changing?  I am concerned such a change would break many user applications. The backward compatibility problem is pretty icky, but I don't much like the idea of leaving it as-is, either. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL

Re: [BUGS] BUG #6027: OLE DB Provider not available

2011-05-23 Thread Robert Haas
://archives.postgresql.org/ -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #6021: There is no difference between default and empty access privileges with \dp

2011-05-15 Thread Robert Haas
'), 'default') But that might be too big a change. I don't think that's too big a change. ISTM we ought to change something. Another idea would be to always show the permissions, even if nothing has been changed from the defaults. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com

Re: [BUGS] Plperl trigger variables no longer global

2011-05-15 Thread Robert Haas
, test recursive trigger calls). Although Ill admit, given the point we are in the release I could see a revert also being justified. Greg, big thanks for testing! keep it up! :) Do we need to apply this patch? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL

Re: [BUGS] Adding a user without expiration date using pgAdmin III causes postgresql Beta1 to crash

2011-05-12 Thread Robert Haas
.  Could someone reproduce this and get a stack trace? http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows Based on Tom's recent commits, this might now be fixed in the latest sources. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com

Re: [BUGS] BUG #6010: booting problem

2011-05-12 Thread Robert Haas
or remove any of your data. Improving things so that sysctl.conf is less likely to require alteration is on our radar screen, but changing that file is not normally a dangerous operation. I am not sure what went wrong for you. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise

Re: [BUGS] BUG #6022: Postgre84+RHEL6+Veritas file system?

2011-05-12 Thread Robert Haas
does not shut down You may want to try shutting down with -m fast. Without that, it waits for all clients to disconnect before shutting down, and sometimes clients don't do that quickly, or at all. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [BUGS] [GENERAL] postgresql-8.4 error - BUG

2011-05-11 Thread Robert Haas
/postgresql/8.4/bin/pg_ctl? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5962: Problem Acessing Network Path

2011-05-11 Thread Robert Haas
\lo_import instead. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5980: Installation can't running

2011-05-11 Thread Robert Haas
? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5984: Got FailedAssertion(!(opaque-btpo_prev == target), File: nbtpage.c, Line: 1166)

2011-05-11 Thread Robert Haas
virtualization tool you are using. Any way to get a stack trace on the assertion failure? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] help

2011-05-11 Thread Robert Haas
for instructions on what to put in there, or here: http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #5996: CURRENT_TIMESTAMP uses often undesired TRANSACTION_TIMESTAMP, instead of STATEMENT_TIMESTAMP

2011-05-11 Thread Robert Haas
sessions while leaving a transaction open. Presumably each client should commit after it finishes its own work. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install

2011-05-11 Thread Robert Haas
2e82d0b396473b595a30f68b37b8dfd41c37dff8 have possibly fixed this? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5800: corrupted error messages (encoding problem ?)

2011-05-09 Thread Robert Haas
-obvious aspect of your configuration. The EnterpriseDB team has made multiple attempts to reproduce this internally, and while we've managed to create various weird behaviors, they aren't obviously the same as what's happening to you. :-( -- Robert Haas EnterpriseDB: http://www.enterprisedb.com

Re: [BUGS] BUG #5992: The database cluster initialisation failed

2011-05-09 Thread Robert Haas
it. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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] Upgrading from 1.10 to 1.12 - cannot set up server

2011-05-09 Thread Robert Haas
suggestions? If you haven't already, you might want to try this question on the pgadmin-support mailing list. http://archives.postgresql.org/pgadmin-support/ -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #5994: Can't excute DBI-connect to oracle by client site

2011-05-09 Thread Robert Haas
anywhere(server or client). My guess is that, depending on how you connect, something in your environment is different, and that is what is making the Oracle connection succeed or fail. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs

Re: [BUGS] BUG #5988: CTINE duplicates constraints

2011-04-25 Thread Robert Haas
information leak. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5963: make -j4 check fails

2011-04-25 Thread Robert Haas
'. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5965: PostgreSQL crashes during connection

2011-04-25 Thread Robert Haas
, then it would be helpful if you could attempt to obtain a stack backtrace. http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #5988: CTINE duplicates constraints

2011-04-25 Thread Robert Haas
On Mon, Apr 25, 2011 at 11:06 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Wed, Apr 20, 2011 at 7:13 PM, Tom Lane t...@sss.pgh.pa.us wrote: I have stated previously my opinion that this is a misconceived feature, and it's now apparent

Re: [BUGS] [JDBC] [ADMIN] Missing documentation for error code: 80S01

2011-04-25 Thread Robert Haas
a C funcion: elog(FATAL, Terminating connection...);) then no. A smart shutdown waits for clients to exit on their own. A fast or immediate shutdown kills them immediately, even mid-query. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via

Re: [BUGS] BUG #5952: SetRWConflict assertion failure

2011-04-05 Thread Robert Haas
bouncing out from under us, so if we release it, aren't we potentially point off into thin air? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5952: SetRWConflict assertion failure

2011-04-05 Thread Robert Haas
On Tue, Apr 5, 2011 at 11:18 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Robert Haas robertmh...@gmail.com wrote: This patch looks reasonable, but I'm a bit concerned about the chunk immediately preceding the patched area. When we do this:     LWLockRelease

Re: [BUGS] BUG #5960: No rule to make target 'libpq.a', needed by 'all-static-lib'

2011-04-05 Thread Robert Haas
to work on MacOS X, but I don't have a mingw environment handy. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company disable-shared.patch Description: Binary data -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #5952: SetRWConflict assertion failure

2011-04-05 Thread Robert Haas
On Tue, Apr 5, 2011 at 12:13 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: I wrote: Robert Haas robertmh...@gmail.com wrote: If you could send a revised patch, that would be great. Attached.  I put it in the same spot relative to the lock acquisition that was used earlier

Re: [BUGS] BUG #5946: Long exclusive lock taken by vacuum (not full)

2011-03-28 Thread Robert Haas
On Mon, Mar 28, 2011 at 12:29 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: I think we've had a number of pieces of evidence that suggest that extending 8kB at a time is too costly, but I agree with Greg that the idea of extending an arbitrarily large table

Re: [BUGS] BUG #5946: Long exclusive lock taken by vacuum (not full)

2011-03-27 Thread Robert Haas
contiguously on disk. But I'd want to see some careful testing that reveals exactly what is needed to get that benefit before we go too crazy with it. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #5946: Long exclusive lock taken by vacuum (not full)

2011-03-27 Thread Robert Haas
, in this case, we could cache the table size, or the fact that vacuum has just truncated away N blocks, or, uh, something. *waves hands* But it's hard to know how such an area could reasonably be sized or managed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL

Re: [BUGS] checking on bug #5917

2011-03-26 Thread Robert Haas
to try and understand why configure does not see these libraries. Maybe you have the readline and zlib packages installed, but not readline-devel and zlib-devel? That's usually what bites me. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via

Re: [BUGS] BUG #5938: PostgreSQL Installer outputs log file with superuser password in clear text

2011-03-22 Thread Robert Haas
in a surprising way. .pgpass files are explicitly put there by a user, so they know what they've done. Putting a password in cleartext somewhere is an issue if people don't know about it. I agree completely. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [BUGS] BUG #5941: i don t understand

2011-03-22 Thread Robert Haas
this form: http://www.postgresql.org/community/lists/subscribe and selecting pgsql-general list. Or better yet, contact Poker Tracker, since this doesn't actually appear to be a question about PostgreSQL. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [BUGS] TO_CHAR(timestamptz,datetimeformat) wrong after DST change

2011-03-21 Thread Robert Haas
command. You may want to update it in postgresql.conf (and then reload the config using pg_ctl reload). Or you could use ALTER ROLE .. SET or ALTER DATABASE .. SET, if you don't want to change it globally. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [BUGS] Problem with ALTER TABLE - occasional tuple concurrently updated

2011-03-18 Thread Robert Haas
On Fri, Mar 11, 2011 at 9:31 AM, Bruce Momjian br...@momjian.us wrote: Robert Haas wrote: On Thu, Mar 10, 2011 at 10:37 PM, Bruce Momjian br...@momjian.us wrote: Robert Haas wrote: On Thu, Mar 10, 2011 at 4:08 PM, Bruce Momjian br...@momjian.us wrote: Was this fixed? Not yet. ?I can

Re: [BUGS] Problem with ALTER TABLE - occasional tuple concurrently updated

2011-03-11 Thread Robert Haas
On Thu, Mar 10, 2011 at 10:37 PM, Bruce Momjian br...@momjian.us wrote: Robert Haas wrote: On Thu, Mar 10, 2011 at 4:08 PM, Bruce Momjian br...@momjian.us wrote: Was this fixed? Not yet.  I can probably fix it, if nobody else wants to do it. Well, it has languished for five months, so

Re: [BUGS] BUG #5837: PQstatus() fails to report lost connection

2011-03-11 Thread Robert Haas
On Fri, Mar 11, 2011 at 5:56 AM, Bruce Momjian br...@momjian.us wrote: Robert Haas wrote: On Tue, Jan 25, 2011 at 10:54 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Robert Haas robertmh...@gmail.com wrote: I think this patch would only be adding to the confusion. ?When

Re: [BUGS] BUG #5814: documentation bug

2011-03-11 Thread Robert Haas
to create more new roles? (y/n) Sorry for the late reply.  If you press enter, no is the default. That's a lame answer. Surely this is a documentation bug. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #5814: documentation bug

2011-03-11 Thread Robert Haas
On Fri, Mar 11, 2011 at 10:05 AM, Bruce Momjian br...@momjian.us wrote: Also, it seems this was addressed in January:        commit af84bee43e356866dc46c95ae5bf77996a8237ff        Author: Robert Haas rh...@postgresql.org        Date:   Sat Jan 8 06:12:05 2011 -0500            Remove bogus

Re: [BUGS] BUG #5927: PostgreSQL8.2

2011-03-11 Thread Robert Haas
:        PostgreSQL8.2 Details: I am getting an error in my PostGreSQL8.2 Error 1053: The service did not respond to the start or control request in a timely fashion What do you see in the server log file? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [BUGS] Problem with ALTER TABLE - occasional tuple concurrently updated

2011-03-10 Thread Robert Haas
On Thu, Mar 10, 2011 at 4:08 PM, Bruce Momjian br...@momjian.us wrote: Was this fixed? Not yet. I can probably fix it, if nobody else wants to do it. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] CREATEROLE does not permit commenting on newly-created roles

2011-03-09 Thread Robert Haas
changed it to check for language ownership. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5889: Intersects for polygons broken

2011-03-09 Thread Robert Haas
scaling/rotation. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5889: Intersects for polygons broken

2011-03-08 Thread Robert Haas
for 8.3 and 8.4)? I think a lot of these things are already documented. Aren't they? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] CREATEROLE does not permit commenting on newly-created roles

2011-03-08 Thread Robert Haas
it's a good change, but we should make sure to release-note it properly, along with the change you made for PLs. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] Corrupted index on 9.0.3 streaming hot standby

2011-03-07 Thread Robert Haas
happened. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 build contrib/uuid-ossp

2011-03-03 Thread Robert Haas
## configure: WARNING:     ## ## checking for uuid.h... yes Hmm. What platform is this on? And what's in config.log? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #5891: Unique index is not unique

2011-03-03 Thread Robert Haas
)? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5861: lo_import and lo_export methods not working from the client side if database is at remote

2011-03-03 Thread Robert Haas
from your side. This isn't a bug. You should try your question on pgsql-general or pgsql-novice, with a lot more detail. http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs

Re: [BUGS] BUG #5863: help message report 5433 as default port

2011-03-03 Thread Robert Haas
message report 5433 as default port Details: running  postgresql-9.0.3-1-windows.exe --help tells the default port for postgres is 5433 (supposed to be 5432). I can reproduce this. It appears to be an installer bug. Dave? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Robert Haas
could just call that function and pass it an SQL query every time you want to do this. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5871: database connecting failed

2011-03-03 Thread Robert Haas
in that version also..there was the same problem. its there anyway to solve this problem or reset this password This report is missing a few key details, such as exactly how you are trying to connect, and the exact text of whatever error message you are getting. -- Robert Haas EnterpriseDB

Re: [BUGS] BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases

2011-03-03 Thread Robert Haas
this has been fixed. Please let me know if not. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5870: Cannot get the first popup window during install

2011-03-03 Thread Robert Haas
? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5874: pg_dumpall CREATE DATABASE statements 'missing' parameters

2011-03-03 Thread Robert Haas
if one could specify a comma separated list of databases to skip (e.g. template1, postgres etc.) Seems like it could be useful, or maybe a list of databases to include would be better, not sure. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via

Re: [BUGS] BUG #5895: Ability to match more than just CN in client certificate

2011-03-03 Thread Robert Haas
. It seems like there are a lot of possible combinations here that could be useful, so we'd want something that allowed a fairly flexible specification of what to match. Is this a problem you're interested in working on (i.e. contributing code)? -- Robert Haas EnterpriseDB: http

Re: [BUGS] Corrupted index on 9.0.3 streaming hot standby

2011-03-03 Thread Robert Haas
to explain. It'd be interesting to compare the disk blocks in the index on the standby with the disk blocks in the index on the master and figure out which ones are different and in what way. pg_filedump might be useful. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL

Re: [BUGS] BUG #5907: ODBC % bug

2011-03-03 Thread Robert Haas
worked as it should.  It was only the usage of the % that failed to work properly while authenticatin via the ODBC driver. You may want to try this question on the ODBC list, if you don't get a response here. http://archives.postgresql.org/pgsql-odbc/ -- Robert Haas EnterpriseDB: http

Re: [BUGS] BUG #5707: Cross compilation for windows is broken

2011-03-03 Thread Robert Haas
On Sat, Feb 26, 2011 at 2:14 AM, Bruce Momjian br...@momjian.us wrote: Has this been addressed? Not me. Sounds like no one cares enough to figure out how to do this. Perhaps this should be a TODO. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: [BUGS] BUG #5899: Memory corruption when running psql

2011-03-03 Thread Robert Haas
install PostgreSQL? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5897: INSTALACAO

2011-03-03 Thread Robert Haas
list. You might try here: https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

2011-03-03 Thread Robert Haas
On Tue, Feb 8, 2011 at 7:23 PM, mark dvlh...@gmail.com wrote: (~two weeks and it dies) keepalives_idle=30 keepalives_interval=30 keepalives_count=30 Maybe something like this: keepalives_idle=60 keepalives_interval=5 keepalives_count=10 -- Robert Haas EnterpriseDB: http

Re: [BUGS] BUG #5908: PgOleDb 1.0.0.20 returns values without the digits after the dot.

2011-03-03 Thread Robert Haas
version. This list is only for bugs in core PostgreSQL, not PgOleDb. Also, this sounds like it's more likely to be a configuration problem than a bug. You'll need to contact whoever is responsible for PgOleDb, or peruse the appropriate documentation. -- Robert Haas EnterpriseDB: http

Re: [BUGS] BUG #5843: documentation error

2011-03-03 Thread Robert Haas
this, and it's fixed now. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5827: no consigo instalarlo

2011-03-03 Thread Robert Haas
://archives.postgresql.org/pgsql-es-ayuda/ It'd also probably be helpful to provide more details about the problelm. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription

Re: [BUGS] BUG #5818: initdb lose the single quote of locale

2011-03-03 Thread Robert Haas
responses to this bug. Do we have a quoting problem somewhere? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [BUGS] Problem with ALTER TABLE - occasional tuple concurrently updated

2011-03-03 Thread Robert Haas
instead of AccessShareLock to prevent this. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 build contrib/uuid-ossp

2011-03-03 Thread Robert Haas
figure out how to get it working, I think we'd be happy to accept a patch that fixes it, unless it's only failing due to some funky detail of your configuration, which I suspect isn't the case based on a quick look at my system. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise

Re: [BUGS] BUG #5863: help message report 5433 as default port

2011-03-03 Thread Robert Haas
On Thu, Mar 3, 2011 at 11:38 AM, Dave Page dp...@pgadmin.org wrote: On Thu, Mar 3, 2011 at 8:30 PM, Robert Haas robertmh...@gmail.com wrote: On Wed, Feb 2, 2011 at 4:06 PM, R. Engmann rengm...@web.de wrote: The following bug has been logged online: Bug reference:      5863 Logged

Re: [BUGS] BUG #5899: Memory corruption when running psql

2011-03-03 Thread Robert Haas
the problem by deleting my .pg_history file. Perhaps it is more accurate that this is a problem with termcap? More likely libedit, which FWICT seems to be riddled with bugs. :-( -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Robert Haas
for debugging. Or at least it's never bothered me. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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 #5903: Turkish encoding problem

2011-03-03 Thread Robert Haas
think this behavior is determined by the operating system behavior of the locale you've selected, and we just believe whatever the OS says. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Robert Haas
) NOTICE: (2,Robert) NOTICE: (3,Tom) debug_query - (1 row) -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [BUGS] BUG #5679: pgAdminIII 1.12.0 hangs

2011-02-22 Thread Robert Haas
was typing in a query (not running it), and I had to hard-reboot...now i can't run the query tool. You probably need to try the pgadmin-support list: http://www.pgadmin.org/support/list.php This list is for bugs in core PostgreSQL. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com

Re: [BUGS] Hung Vacuum in 8.3

2011-02-22 Thread Robert Haas
, but we already can't do that if there are any bits set in the visibility map. It could also leave some bloat in the table, but probably not much (he says hopefully). -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list

<    1   2   3   4   5   6   7   8   >