Re: [BUGS] BUG #6318: pg_dump for non-template languages is broken

2011-12-02 Thread Tom Lane
have loaded them. (In this case * we will emit a parameterless CREATE LANGUAGE command, which will * require PL template knowledge in the backend to reload.) */ An actual add-on procedural language would not fall foul of this. regards, tom lane -- Sent via pgsq

Re: [BUGS] BUG #6316: function search_path causes set_config() is_local = true to have no effect

2011-12-01 Thread Tom Lane
e current transaction is rolled back. 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 #6315: FETCH NEXT :next ROWS ONLY fails

2011-12-01 Thread Tom Lane
says there are parsing conflicts if we try to not require the parens, and that SQL:2008 doesn't actually require anything beyond a simple integer constant here. 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 #6315: FETCH NEXT :next ROWS ONLY fails

2011-12-01 Thread Tom Lane
#x27;t a simple integer constant. I'll apply a patch to make that a bit more obvious. 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 #6314: The like command does not handle a long string of special chars

2011-12-01 Thread Tom Lane
forgetting that backslash is an escape character in Postgres string literals, and also for LIKE itself. You should reread the manual's discussion of LIKE: http://www.postgresql.org/docs/8.4/static/functions-matching.html regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] 9.1.1 hot standby startup gets sigbus

2011-12-01 Thread Tom Lane
fer pointer returned by BufHdrGetBlock is bad, and how could that happen? I'm suspicious that there must be something broken about your VM environment. Can you reproduce it outside the VM, or even better create a reproducible test case? regards, tom lane --

Re: [BUGS] BUG #6313: Deadlock reporting contains not enought details

2011-12-01 Thread Tom Lane
deadlock in the postmaster log. We're not going to change it in 8.3.x though. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] 9.1.1 hot standby startup gets sigbus

2011-11-30 Thread Tom Lane
Josh Kupershmidt writes: > On Wed, Nov 30, 2011 at 9:17 PM, Tom Lane wrote: >> Can you try that on 9.1 branch tip to see if it's already fixed? > Hrm, don't think that helped - I get the same error in the logs using > a checkout of branch REL9_1_STABLE. Well, was

Re: [BUGS] 9.1.1 hot standby startup gets sigbus

2011-11-30 Thread Tom Lane
Josh Kupershmidt writes: > I have a new 9.1.1 hot standby machine (VM). It consistently starts > up, goes through recovery through these same WAL segments, and then > gets a "Bus error": Can you try that on 9.1 branch tip to see if it's already fixed?

Re: [BUGS] possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs

2011-11-30 Thread Tom Lane
to do something about that. Best advice is to avoid ambiguous input, or if you can't, at least avoid flipping your datestyle on the fly. 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 #6307: intarray extention gin index does not work with Hot standby

2011-11-28 Thread Tom Lane
Maxim Boguk writes: > Is that fix will be included to the next minor versions releases? Yes, it's in already: http://git.postgresql.org/gitweb/?p=postgresql.git regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] [ADMIN] Repeatable crash in pg_dump (with -d2 info)

2011-11-28 Thread Tom Lane
= > prolang) as lanname FROM pg_catalog.pg_proc WHERE oid = > '16386'::pg_catalog.oid > LOG: statement: SELECT pg_catalog.format_type('1185'::pg_catalog.oid, NULL) > LOG: statement: SELECT pg_catalog.format_type('1022'::pg_catalog.oid, NULL) > LOG: st

Re: [BUGS] objects tied to missing extension

2011-11-28 Thread Tom Lane
. Committed at http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=871dd024a6adf7766702b1cdacfb02bd8002d2bb 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] objects tied to missing extension

2011-11-28 Thread Tom Lane
l fix it? I think you have some dangling entries in pg_depend --- manually deleting any rows that reference the missing pg_extension OID should fix it. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: ht

Re: [BUGS] objects tied to missing extension

2011-11-28 Thread Tom Lane
P on the object will encounter the extension at outermost recursion level.) So the problem seems to be only due to your ALTER EXTENSION DROP command having left an incomplete set of extension dependencies behind. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@p

Re: [BUGS] pg_dump - foreign table - server name is not quoted

2011-11-28 Thread Tom Lane
Ronan Dunklau writes: > How will this bug be handled with regards to releases ? It'll be fixed in next week's releases. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.p

Re: [BUGS] pg_dump - foreign table - server name is not quoted

2011-11-28 Thread Tom Lane
n pg_dump. Usually we prefer to retrieve names from the server as-is, then apply fmtId() when printing them --- this is more flexible than having possibly-pre-quoted names in pg_dump's internal state. Will fix it the latter way. Thanks for the report! regards, tom lane --

Re: [BUGS] BUG #6310: Startup Script

2011-11-26 Thread Tom Lane
"Sidar Lopez" writes: > Operating system: Mac OS X > Description:Startup Script > Log file is not being created at ${PGLOG} location. Hmm, yeah, that's overly-quoted. Will fix, thanks for the report! regards, tom lane -- Sent via

Re: [BUGS] BUG #6307: intarray extention gin index does not work with Hot standby

2011-11-25 Thread Tom Lane
might think that, but you'd be wrong :-(. ginRedoUpdateMetapage is failing to restore the contents of the pending-list correctly, which means this is broken for all types of GIN indexes. Will fix. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@p

Re: [BUGS] BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-19 Thread Tom Lane
lindebg writes: > On 11/19/2011 04:34 AM, Tom Lane wrote: >> Color me skeptical. Under what conceivable use-case could you have >> functions that were mutually dependent in that way? And actually did >> something useful (not recurse till stack overflow) when called? >

Re: [BUGS] BUG #6301: extra space in psql variable expansion

2011-11-19 Thread Tom Lane
;s not in any stable branch. It seemed like enough of a behavioral change to be too risky to put into minor releases. 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 #6301: extra space in psql variable expansion

2011-11-19 Thread Tom Lane
expect. In the new coding, an argument is considered terminated only by unquoted whitespace or backslash. 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 #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-19 Thread Tom Lane
u have functions that were mutually dependent in that way? And actually did something useful (not recurse till stack overflow) when called? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.po

Re: [BUGS] BUG #6300: duplicate key value violates unique constraint

2011-11-18 Thread Tom Lane
here are ways to do > that correctly - Has anybody suggested raising the log_min_messages setting? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-17 Thread Tom Lane
he next set of update releases, or if you're in a big hurry you can get the patch here: http://archives.postgresql.org/pgsql-committers/2011-10/msg7.php regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #6295: Update fails on empty concatenated strings

2011-11-16 Thread Tom Lane
I wrote: > You might possibly want to spell > the above as SET comment = '...' || coalesce(comment, null) ... Sheesh. coalesce(comment, '') of course. Need more caffeine. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postg

Re: [BUGS] BUG #6295: Update fails on empty concatenated strings

2011-11-16 Thread Tom Lane
red that concatenation of a null with something else yields null. You might possibly want to spell the above as SET comment = '...' || coalesce(comment, null) ..., if you want to pretend that a null is the same thing as an empty string. regards, tom lane -- Se

Re: [BUGS] Cannot dump 8.4.8 database using later versions

2011-11-15 Thread Tom Lane
command was: COPY public.new (f1, new) TO stdout; The least painful solution might be to always quote *every* identifier in commands sent to the source server, since we don't especially care how nice-looking those are. regards, tom lane -- Sent via pgs

Re: [BUGS] BUG #6291: Xid epoch is not updated properly

2011-11-13 Thread Tom Lane
ing at 0. I failed to reproduce this here, and a look at the code responsible for xid epoch maintenance reveals no obvious way that it could have been bypassed. So there's some fairly critical piece of context that you're not telling us ... regards, tom lane -- Sent vi

Re: [BUGS] BUG #6288: Is ALTER ROLE set client_encoding broken in 9.1?

2011-11-11 Thread Tom Lane
Peter Eisentraut writes: > On tor, 2011-11-10 at 19:30 -0500, Tom Lane wrote: >> I think psql only pays attention to its locale when stdout is a tty. >> Now *why* it acts like that, I'll leave for Peter to defend. > We would have to review the original discussion

Re: [BUGS] BUG #6288: Is ALTER ROLE set client_encoding broken in 9.1?

2011-11-10 Thread Tom Lane
-c 'show client_encoding' | head -10 > client_encoding > - > KOI8R > (1 row) I think psql only pays attention to its locale when stdout is a tty. Now *why* it acts like that, I'll leave for Peter to defend. regards, tom lane --

Re: [BUGS] BUG #6288: Is ALTER ROLE set client_encoding broken in 9.1?

2011-11-10 Thread Tom Lane
"Maksym Boguk" writes: > Description:Is ALTER ROLE set client_encoding broken in 9.1? No, but I think psql prefers to set its encoding according to its locale enviroment these days. regards, tom lane -- Sent via pgsql-bugs mailing lis

Re: [BUGS] BUG #6287: Unexpected protocol character during authentication

2011-11-04 Thread Tom Lane
etup64 = /usr/lib64/libodbcpsqlS.so FileUsage = 1 Depending on which build of postgresql-odbc you're using, the driver library file might be named psqlodbcw.so instead; but in any case libodbcpsql.so is not something to trust. regards, tom lane -- Sent

Re: [BUGS] BUG #6286: Table Partitioning - SQL/MED - interaction broken

2011-11-04 Thread Tom Lane
Robert Haas writes: > On Thu, Nov 3, 2011 at 5:07 PM, Tom Lane wrote: >> We probably ought to have something in there to throw an error ... > Probably not for rules in general, but we shouldn't let people turn > tables into views if they are involved in table inheritance,

Re: [BUGS] BUG #6286: Table Partitioning - SQL/MED - interaction broken

2011-11-03 Thread Tom Lane
r breath waiting for it to be. We probably ought to have something in there to throw an error ... 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 #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe

2011-11-03 Thread Tom Lane
o error. Right offhand I would guess that you are using an old JDBC driver that isn't prepared for standard_conforming_strings to be turned on. If that isn't it, I'd suggest asking for help on the pgsql-jdbc mailing list; I'm not sure how many of those guys read pgsql-bugs.

Re: [BUGS] BUG #6283: About the behavior of indexscan in case there are some NULL values.

2011-11-02 Thread Tom Lane
tch, and just say that the performance problem is only going to be addressed in HEAD. 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 #6280: adminpack.sql not found after postgresql-contrib has been installed

2011-10-31 Thread Tom Lane
pm into SUSE 11 SP > 1. > But adminpack.sql is not found. It's called adminpack--1.0.sql these days, and is installed using a different command than your version of pgAdmin is probably trying to use. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql

Re: [BUGS] BUG #6278: Index scans on '>' condition on field with many NULLS

2011-10-31 Thread Tom Lane
Robert Haas writes: > On Mon, Oct 31, 2011 at 12:43 PM, Tom Lane wrote: >> A patch along these lines should be pretty localized. Has anyone >> got an opinion on whether to back-patch or not? This seems like a >> performance bug, but given the lack of prior complaints,

Re: [BUGS] BUG #6278: Index scans on '>' condition on field with many NULLS

2011-10-31 Thread Tom Lane
ocalized. Has anyone got an opinion on whether to back-patch or not? This seems like a performance bug, but given the lack of prior complaints, maybe we shouldn't take any risks for 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 #6278: Index scans on '>' condition on field with many NULLS

2011-10-31 Thread Tom Lane
the zeroth-order version of recombining them). So either my analysis was wrong at the time, or some later change has eliminated the need for two flags, or the regression tests aren't covering the problematic case. Will investigate further once I've absorbed some caffeine.

Re: [BUGS] BUG #6277: Money datatype conversion wrong with Russian locale

2011-10-30 Thread Tom Lane
a value had been negative. AFAICT there are no such locales anyway, other than POSIX for which we definitely don't want to believe the empty-string setting. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your su

Re: [BUGS] BUG #6277: Money datatype conversion wrong with Russian locale

2011-10-29 Thread Tom Lane
ingle byte. Does anyone know of locales where the decimal point isn't a single byte? I'm wondering if that assumption needs to be got rid of 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] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

2011-10-28 Thread Tom Lane
;localhost" means the local machine; there are Internet standards saying so. On the other hand, client applications that assume the database server is on the same machine they are on are definitely broken, and need to be fixed. regards, tom lane -- Sent via pgs

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

2011-10-28 Thread Tom Lane
fundamental problem with that kluge (and yes, it's a kluge) is that it supposes that you migrated EVERY local service to the other machine. Which, obviously, you did not. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] Re: BUG #6264: Superuser does not have inherent Replication permission

2011-10-28 Thread Tom Lane
Robert Haas writes: > On Thu, Oct 27, 2011 at 6:15 PM, Tom Lane wrote: >> Noah Misch writes: >>> I think we should merge #3 into #2; nothing about the REPLICATION setting >>> justifies a distinct paradigm. >> Yeah, there's much to be said for that. I tho

Re: [BUGS] BUG #6275: Horrible performance regression

2011-10-27 Thread Tom Lane
f this much information. > btw: The database uses plpython and postgis. Hmm, did you change postgis versions at the same time? If so, which upgrade caused the problem, postgres or postgis? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql

Re: [BUGS] Re: BUG #6264: Superuser does not have inherent Replication permission

2011-10-27 Thread Tom Lane
privilege that superusers might not have was pretty bogus to start with. rolcatupdate isn't a very good precedent to rely on because it's never been documented or used to any noticeable extent, so there's no reason to think that it provides a tested-and-accepted behavior.

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

2011-10-27 Thread Tom Lane
iented standards. But it's wrong, no matter how many places say that. Ask an astronomer rather than a computer scientist, if you're not convinced. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your su

Re: [BUGS] BUG #6264: Superuser does not have inherent Replication permission

2011-10-27 Thread Tom Lane
atch the > docs. 9.1 hasn't been out for very long, so maybe expectations aren't > too settled yet, but changing security-critical behavior in back > branches doesn't seem like a wonderful idea; and I think I mildly > prefer the current semantics to the proposed ones.

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

2011-10-27 Thread Tom Lane
nd while searching the RFC archives.) And, given that we've been doing it this way since 2001 without previous complaints, the number of systems that fail to do it must be pretty small. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To ma

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

2011-10-25 Thread Tom Lane
y events as old as three days. > Can the second (16384 -> /db/base/main) link be safely deleted? If there's no matching entry in pg_tablespace then it should be junk. But you might want to check for pg_class entries with reltablespace = 16384 before pulling the trigger.

Re: [BUGS] auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)

2011-10-25 Thread Tom Lane
7;10s' > auto_explain.log_analyze = 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.

Re: [BUGS] BUG #6268: multiple update with on cascade

2011-10-25 Thread Tom Lane
ny freshly-created self-referential FK constraint is vulnerable to the same problem; 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] BUG #6270: Invalid string comparison if the string contains '+' or '-' sign.

2011-10-25 Thread Tom Lane
atabase with LC_COLLATE and LC_CTYPE set to 'C'. 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 #6269: Anomaly detection

2011-10-25 Thread Tom Lane
tly in Postgres, because there's no difference (in 8.3 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 #6267: Wrong results in pg_database_size

2011-10-25 Thread Tom Lane
"Maksym Boguk" writes: > Somehow pg_database_size producing results which are 2х more then reality. I can't reproduce any such problem here. I suspect you overlooked some tablespaces in your manual "du" commands. regards, tom lane -- Sent

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

2011-10-22 Thread Tom Lane
lative pathname to start the postmaster, unless you plan to start it from the same working directory every time. We could possibly avoid 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

Re: [BUGS] BUG #6264: Superuser does not have inherent Replication permission

2011-10-22 Thread Tom Lane
LTER them to be one, 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.

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

2011-10-20 Thread Tom Lane
the argument that people coming from Sybase-ish 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 (pgsq

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

2011-10-20 Thread Tom Lane
not me 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] BUG #6263: \l causes core dump with large database

2011-10-20 Thread Tom Lane
n the wrong place), 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, t

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

2011-10-20 Thread Tom Lane
"large 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/mailpref/pgsql-bugs

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

2011-10-20 Thread Tom Lane
d of SELECT. 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 #6262: while installing postgis in make install leavingdirectory

2011-10-20 Thread Tom Lane
/lib/pgxs/src/makefiles/pgxs.mk:164: warning: ignoring 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-b

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

2011-10-19 Thread Tom Lane
e functionality of executing 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?

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

2011-10-19 Thread Tom Lane
ldn't 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 (

Re: [BUGS] incompatible pointer type

2011-10-19 Thread Tom Lane
e responsibility of having a non-buggy bison 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] incompatible pointer type

2011-10-18 Thread Tom Lane
Robert Young 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?

Re: [BUGS] incompatible pointer type

2011-10-18 Thread Tom Lane
g some openbsd-specific 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 (

Re: [BUGS] incompatible pointer type

2011-10-18 Thread Tom Lane
Robert Young writes: > On Tue, Oct 18, 2011 at 18:22, Tom Lane 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. > Th

Re: [BUGS] incompatible pointer type

2011-10-18 Thread Tom Lane
posed 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 y

Re: [BUGS] char(0)

2011-10-18 Thread Tom Lane
be your worst problem. AFAICT the SQL 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

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

2011-10-17 Thread Tom Lane
. If that's the right guess, you need to do CREATE EXTENSION citext FROM unpackaged to fix 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 #6258: Lock Sequence

2011-10-17 Thread Tom Lane
Laerson keler writes: > 2011/10/17 Tom Lane >> "Laerson Keler" 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 block the sequence not to m

Re: [BUGS] BUG #6258: Lock Sequence

2011-10-17 Thread Tom Lane
can I enable 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 ch

Re: [BUGS] BUG #6238: ECPG converts "long long" to long on Windows

2011-10-16 Thread Tom Lane
ooked in the win64 patches. 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
ession=# \d foo 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 chan

Re: [BUGS] memory leak in postgresql

2011-10-11 Thread Tom Lane
, this is a "your transaction is holding too many locks" problem (namely, one lock for each transient table). Please follow the advice given in the error message. 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
t a feature. The only way to prevent it would be to not fire triggers 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 #6240: About - postgreswdinit.sql

2011-10-05 Thread Tom Lane
e targeting a nonempty 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 #6233: pg_dump hangs with Access Violation C0000005

2011-10-04 Thread Tom Lane
that was built separately from his pg_dump executable? 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
ions, and probably some other cases too because there seem 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 in dependency - there is possibility to break a system catalog

2011-10-03 Thread Tom Lane
Pavel Stehule 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://www.postgresql.

Re: [BUGS] Typo in nbtsort.c

2011-10-01 Thread Tom Lane
7;s 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 #6235: Delete fails with ON DELETE rule on inherited table

2011-09-30 Thread Tom Lane
eferenced from table "derived". The reason for that is that the DO ALSO action occurs before the main action, so you're trying to delete a "referenced" row that is in fact still referenced. One solution would be to declare the foreign key constraint as DEFERRABLE INITIA

Re: [BUGS] BUG #6236: Query execution bug

2011-09-30 Thread Tom Lane
ssuming that it will always be resolved the way you want ... but if you can't 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 pgsq

Re: [BUGS] "no relation entry for relid 1"

2011-09-29 Thread Tom Lane
Peter Geoghegan writes: > On 29 September 2011 23:15, Tom Lane 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 that this was an internal

Re: [BUGS] "no relation entry for relid 1"

2011-09-29 Thread Tom Lane
) sub > group 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

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

2011-09-28 Thread Tom Lane
trib regression tests, so there's 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 #6232: hstore operator ? no longer uses indexes

2011-09-28 Thread Tom Lane
ay to suppose that collation can 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 ...

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

2011-09-28 Thread Tom Lane
er disappear from the index, short of a REINDEX; and this is also the worst 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

Re: [BUGS] BUG #6231: weird to_timestamp behaviour with out of range values

2011-09-28 Thread Tom Lane
mp at all? The timestamp input converter is perfectly capable of dealing with standard formats like -mm-dd, and it does what most people expect in the way of data validation checks. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

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

2011-09-28 Thread Tom Lane
ID counter wrapped around, you'd be pretty well screwed. As Alvaro says, manual alterations of the system 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.

Re: [BUGS] BUG #6230: strange changes in behavior of string functions

2011-09-27 Thread Tom Lane
stgresql 9.1 - false. It sounds like 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-bugs

Re: [BUGS] BUG #6227: No arguments for COPY OIDS and HEADER

2011-09-27 Thread Tom Lane
header); COPY 1 regression=# copy tenk1 to '/dev/null' with (format csv, header true); COPY 1 regression=# copy tenk1 to '/dev/null' with (format csv, header false); COPY 1 Also, regression=# copy tenk1 to '/dev/null' with (oids fals); ERROR: oids r

Re: [BUGS] BUG #6229: Postgresql crashes after: LOG: statistics buffer is full

2011-09-27 Thread Tom Lane
3 is horribly obsolete, and you should at least update to the end 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] pg 9.1.1 - ERROR: could not find pathkey item to sort

2011-09-26 Thread Tom Lane
I wrote: > bricklen 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] pg 9.1.1 - ERROR: could not find pathkey item to sort

2011-09-26 Thread Tom Lane
bricklen 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] BUG #6218: TRAP: FailedAssertion( "!(owner->nsnapshots == 0)", File: "resowner.c", Line: 365)

2011-09-26 Thread Tom Lane
I work on a fix? I expect you are plenty busy 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 -- S

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