Re: [BUGS] LEFT OUTER JOIN and WHERE madness (8.3.3 bug?)

2008-06-27 Thread Tom Lane
: ((id IS NULL) OR (visible_for = ANY > ('{0,1}'::integer[]))) > Total runtime: 0.464 ms > (13 rows) Hmm, it shouldn't be pushing the OR qual down to the base scan like that ... Do you have an index on albums.visible_for? Experimenting here, it seems that this fail

Re: [BUGS] LEFT OUTER JOIN and WHERE madness (8.3.3 bug?)

2008-06-27 Thread Tom Lane
tgresql.org/pgsql-committers/2008-06/msg00336.php 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 #4271: dropped columns conflict with returning rules

2008-06-29 Thread Tom Lane
replace rule redirect as on insert to foo do instead insert into foo1 values(new.*) returning foo1.*; ERROR: RETURNING list has too few entries which does seem like a bug but it's not what you are describing. 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 #4271: dropped columns conflict with returning rules

2008-06-29 Thread Tom Lane
really necessary, or if renumbering the targetlist's resnos would be enough to make RETURNING work? I forget whether we select RETURNING elements by resno or physical position. Anyway, I have other things to do that strike me as higher priority. Anyone want to tackle this one?

Re: [BUGS] Recovery failed on a backup with " lock AccessShareLock on object 16477/244169/0 is already held"

2008-06-30 Thread Tom Lane
ust be set--see zic manual" where the timezone should be? Are you intentionally selecting the "Factory" zone? 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] Recovery failed on a backup with " lock AccessShareLock on object 16477/244169/0 is already held"

2008-06-30 Thread Tom Lane
ugh to make you set the zone correctly ;-) 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: FATAL: the database system is starting up

2008-06-30 Thread Tom Lane
ing an strace on this process shows that it is trying to write 8K of > zeros to a file called 023D in pg_clog but fails at 224K and it just keeps > trying forever. What PG version is this, exactly? What files did you delete (any of Postgres' files)? regards, t

Re: [BUGS] BUG #4275: Multicolumn subquery expression not allowed on both sides of IS DISTINCT FROM

2008-07-01 Thread Tom Lane
we do not claim support for feature F641. 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 #4277: Feature request inet type cast numeric values

2008-07-01 Thread Tom Lane
Pv4-only functionality, I think the inet4 type on pgfoundry has this behavior already. 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: FATAL: the database system is starting up

2008-07-02 Thread Tom Lane
Valentin Bogdanov <[EMAIL PROTECTED]> writes: >> What PG version is this, exactly? What files did you >> delete (any of Postgres' files)? > It's 8.1 and no I didn't delete any postgres files, just some old proxy logs. 8.1.what? regard

Re: [BUGS] BUG #4275: Multicolumn subquery expression not allowed on both sides of IS DISTINCT FROM

2008-07-02 Thread Tom Lane
Carl-Daniel Hailfinger <[EMAIL PROTECTED]> writes: > On 01.07.2008 16:32, Tom Lane wrote: >> This is not a bug, since we do not claim support for feature F641. > Thanks for the information. Is there any plan to support that feature in > 8.4? I don't know of anyone w

Re: [BUGS] BUG #4286: ORDER BY returns inconsistent results when using LIMIT on a integer column set to default values

2008-07-08 Thread Tom Lane
re's any plan change involved here. What I think is happening is that the first row is being selected as the quicksort pivot item.) 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 #4289: drop owned by report ERROR: cache lookup failed for relation 16390

2008-07-09 Thread Tom Lane
ay in CVS HEAD ... not sure if a small back-port is possible, though. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390

2008-07-09 Thread Tom Lane
mingly not so hard to fix. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390

2008-07-09 Thread Tom Lane
l in the RESTRICT case when there were dependencies between objects owned by different users. 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 #4289: drop owned by report ERROR: cache lookup failed for relation 16390

2008-07-09 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Actually, on looking closer, the problem is that recursiveDeletion fails >> to pass alreadyDeleted down to (and through) deleteDependentObjects. > Hmm, in this case I wonder if this could show up in othe

Re: [BUGS] BUG #4290: wrong double subselect with aggregate function

2008-07-09 Thread Tom Lane
aram/parParam signaling. Not sure yet if it's a planner or executor bug, but more likely the former. 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 #4290: wrong double subselect with aggregate function

2008-07-09 Thread Tom Lane
ent in subselect.c). I'm surprised we've not seen reports of it 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 #4291: Inheritance fails on column suppression

2008-07-10 Thread Tom Lane
itance state just to cover this.) > According to the documentation, this should not be the case. Please state where you think the documentation says that, so we can fix it. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make cha

Re: [BUGS] BUG #4294: XML support: name() xpath function not working

2008-07-10 Thread Tom Lane
ment to have any chance of working. In general, I think this has zero chance of working without implementing a pretty complete XPath parser. We need to find another way. 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 #4296: Server crashes by restoring database

2008-07-11 Thread Tom Lane
statements and watch the postmaster log). See if you can put together a self-contained script that causes the crash. That will let us fix the problem, and it might let you find a workaround to reload your data even in advance of a real fix. regards, tom lane -- Sent via p

Re: [BUGS] BUG #4296: Server crashes by restoring database

2008-07-14 Thread Tom Lane
bles involve non-built-in datatypes? An out-of-date .so file for an add-on datatype could easily lead to crashes in these operations. 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 #4296: Server crashes by restoring database

2008-07-15 Thread Tom Lane
=?iso-8859-2?q?Micha=B3_Szel=B1g?= <[EMAIL PROTECTED]> writes: > Dnia poniedzia³ek, 14 lipca 2008, Tom Lane napisa³: >> You still haven't given anywhere near enough information to identify the >> bug. I wonder though if any of these tables involve non-built-in >>

Re: [BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-15 Thread Tom Lane
ior is not a bug, it is the expected behavior of any program using a network connection. 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 #4307: INSERT fails with primary key contraint

2008-07-15 Thread Tom Lane
is, please put together a self-contained test case. Assuming it's real, perhaps a simple custom script for pgbench would serve to show the problem. 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 or test application hangs when interface is down for the DB server

2008-07-16 Thread Tom Lane
s not >> get blocked for ~15 minutes. > Absent threads I think you have to use alarm() and a SIGALRM signal handler. On most modern platforms you can adjust the TCP timeouts for the connection. There's no explicit support for that in libpq, but you can just get the socket FD from

Re: [BUGS] BUG #4317: problem with comparision of datatype date

2008-07-18 Thread Tom Lane
ute the below query > "select * from myTable where somedate = '2008-07-18'" > I only get 145 rows back from the database. Is there an index on somedate, and if so does reindexing it help? regards, tom lane -- Sent via pgsql-bugs mailing li

Re: [BUGS] Problem loading ispell affix file with apostrophes

2008-07-21 Thread Tom Lane
Looking at the code, apostrophe seems to be allowed as the first character of the REPL field, but not anywhere else (in particular, not after transitioning into PAE_INREPL state). Dunno if this is a bug or intentional. 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] LDAP Authentication with spaces in DN

2008-07-24 Thread Tom Lane
nf function reads > until it finds a blank space, tab or new line, so if the string contains any > blank space after the last ':' everything else is ignored! Fixed, thanks for the report! regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bug

Re: [BUGS] BUG #4324: Default value for a column is not returned in select when column has not been explicitly set

2008-07-26 Thread Tom Lane
ct * from foo; f1 | b +--- 1 | t 2 | t (2 rows) Please provide a concrete test case to demonstrate what you are seeing. 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 #4329: Transaction model changed?

2008-07-28 Thread Tom Lane
h postgresql > 8.0. It complains that the table test does not exist! I get the same complaint in both versions; which I find unsurprising because the whole querystring is parsed and planned before execution begins. regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #4327: Primary key not refresh after cascaded deleted

2008-07-28 Thread Tom Lane
can actually reproduce this problem, please show an exact test case, not hand-waving. 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 #4330: Bonjour connections ignore hba config METHOD and always trusted

2008-07-28 Thread Tom Lane
.conf? AFAIK there is no such thing as a "Bonjour connection"; Bonjour just provides a means for the server to advertise its IP address. I speculate that what it's advertising is a port that you have configured to be trusted. regards, tom lane -- Sent

Re: [BUGS] BUG #4330: Bonjour connections ignore hba config METHOD and always trusted

2008-07-28 Thread Tom Lane
27;d suggest enabling log_connections so you can see what address the connections are actually coming in on. 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 #4332: ERROR: invalid byte sequence for encoding "UTF8": 0xc3

2008-07-29 Thread Tom Lane
ttp://archives.postgresql.org/pgsql-bugs/2008-06/msg00110.php It's fixed in CVS but we haven't made a new release yet. If you need the patch right away, see http://archives.postgresql.org/pgsql-committers/2008-06/msg00226.php regards, tom lane -- Sent via pgsq

Re: [BUGS] Segfault manifesting in libm from cost_sort

2008-07-30 Thread Tom Lane
g, and/or put some debug logging into cost_sort to see what it's passing to log(), and see what you can learn. 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 #4337: psql -c case insensitive

2008-07-31 Thread Tom Lane
I speculate that your scripting language is losing the embedded double-quotes somewhere before psql gets them. I don't know much about Windows scripting so it's hard to say more than that; but an extra interpretation pass over the command string would probably cause such a problem.

Re: [BUGS] BUG #4338: Order by seems to trim some characters before sort

2008-08-02 Thread Tom Lane
nt locale setting, probably "C". Unfortunately, that requires dump, re-initdb with the correct locale option, 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 #4340: SECURITY: Is SSL Doing Anything?

2008-08-04 Thread Tom Lane
adjust your list of trusted CAs to determine whether you'll accept it or not. 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 #4340: SECURITY: Is SSL Doing Anything?

2008-08-04 Thread Tom Lane
re's really little reason > otherwise for the call to exist. Er, we don't *have* a verify_peer callback. 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

[BUGS] Hmm, nodeUnique doesn't really support backwards scan too well

2008-08-05 Thread Tom Lane
ase that no one has noticed in many years might be counterproductive. Thoughts? 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] Hmm, nodeUnique doesn't really support backwards scan too well

2008-08-05 Thread Tom Lane
from outside don't even know it exists, Say again? Both the SCROLL option to DECLARE CURSOR and FETCH PRIOR are straight out of the SQL92 spec. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: h

Re: [BUGS] Hmm, nodeUnique doesn't really support backwards scan too well

2008-08-06 Thread Tom Lane
not only complicate ExecUnique but back-patch the result clear back to 7.4. I'm not even sure how to fix it (the nasty case is changing directions partway through the scan); let alone how to fix it in a way that's obviously enough right to make me feel comfortable in back-patching.

Re: [BUGS] BUG #4341: planner doesn't using index for = operation

2008-08-06 Thread Tom Lane
cause '=' is not part of the varchar_pattern_ops operator class. (Things will be better in 8.4, but it's not possible to fix it in existing release branches.) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)

Re: [BUGS] Hmm, nodeUnique doesn't really support backwards scan too well

2008-08-06 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> writes: >> ... I'm not even sure how to fix it (the nasty case is >> changing directions partway through the scan); let alone how to fix it in a >> way that's obviousl

Re: [BUGS] Oder by not working

2008-08-06 Thread Tom Lane
-locale=C" might be what you want.) For comparison's sake, I get this on a modern Linux system: $ cat testdata Ta, A Ta, Z Tab, A $ LANG=C sort testdata Ta, A Ta, Z Tab, A $ LANG=en_US sort testdata Ta, A Tab, A Ta, Z regards, tom lane -- Sent via pgsql-b

Re: [BUGS] BUG #4345: ERROR: OUT OF MEMORY

2008-08-07 Thread Tom Lane
t; 8.2.what? If it's pre-8.2.5, I'd venture that the archive file has been truncated and you're seeing a variant of this problem: http://archives.postgresql.org/pgsql-patches/2007-08/msg00059.php regards, tom lane -- Sent via pgsql-bugs mailing lis

Re: [BUGS] BUG #4344: initdb -L timezone directory

2008-08-07 Thread Tom Lane
where specifying a different location wouldn't be broken? 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] Hmm, nodeUnique doesn't really support backwards scan too well

2008-08-07 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> writes: >> Well, if you think it's easy, the best form of criticism is a patch. >> The change-of-direction problem seems to me to be messy --- not >> insoluble, but messy

Re: [BUGS] ALTER TABLE name RENAME TO new_name; does notworkimmediately

2008-08-10 Thread Tom Lane
n the logic that manages REINDEX applied to pg_class itself. There's a mighty delicate dance that goes on there, and we haven't tested it too much lately. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to yo

Re: [BUGS] ALTER TABLE name RENAME TO new_name; does notworkimmediately

2008-08-10 Thread Tom Lane
t now. I'm sure this is related to the fancy dance we do for pg_class reindexing, but not sure yet where 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] ALTER TABLE name RENAME TO new_name; does notworkimmediately

2008-08-10 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > Uhm. Is it possible we're mistakenly doing a HOT update because we're lying > about what indexes exist? Yup, exactly. Here's my proposed fix... regards, tom lane Index:

Re: [BUGS] BUG #4351: Full text search performance

2008-08-11 Thread Tom Lane
u can't rely on a default TS configuration when using the functional-index approach to text searching, because of the restriction that index contents can't depend on mutable state. 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] return query with set-returning functions

2008-08-11 Thread Tom Lane
7;); sid | name | rollup_time | count_rows | avg_value -+--+-++--- (0 rows) It's possible that I'm missing the failure for lack of suitable test data, but right offhand I'd bet that the problem is that there are dropped columns in your copy

Re: [BUGS] BUG #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-11 Thread Tom Lane
ything in the subquery rtable, not just what was referenced? 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 #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-11 Thread Tom Lane
#x27;s a bit beyond my threshold of ugliness... 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 #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-12 Thread Tom Lane
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I think it might be better to fix the problem in >> pull_up_union_leaf_queries instead; given that it wasn't broken till >> recently, I think it's arguably t

Re: [BUGS] BUG #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-12 Thread Tom Lane
ding was guaranteed to visit only subquery-type RTEs but I'm much less convinced about this one. It might be better to say if (rte->rtekind == RTE_SUBQUERY) IncrementVarSublevelsUp(...); Or maybe it's okay; I'm too lazy to recheck the representation of UNI

Re: [BUGS] BUG #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-13 Thread Tom Lane
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Hm, the "Assert(rte->subquery != NULL)" doesn't seem right ... >> couldn't there be non-RTE_SUBQUERY rtes in the child? > Oh, indeed it's not okay. The original

Re: [BUGS] BUG #4355: TOKMAXLEN=10 to short for token strings

2008-08-14 Thread Tom Lane
hat would be 11 if they included a null terminator, but we don't require that. 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 #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-14 Thread Tom Lane
walker directly as you have here. Looks good except IncrementVarSublevelsUp_rtable really ought to have a comment. Please fix that, commit, and backpatch as needed. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #4362: Casts from base types to composite types don't work.

2008-08-17 Thread Tom Lane
xid(text) AS IMPLICIT; CREATE CAST regression=# select cast (text 'blabla' as pxgt_xid); pxgt_xid ------- (,blabla) (1 row) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4340: SECURITY: Is SSL Doing Anything?

2008-08-18 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: >> Tom Lane wrote: >>> Er, we don't *have* a verify_peer callback. >> >> Uh, the user reported running Postgres 7.3 and we have improved SSL >> quite a bit since then so perhaps an upgrade and reading the curr

Re: [BUGS] BUG #4340: SECURITY: Is SSL Doing Anything?

2008-08-19 Thread Tom Lane
At least the basic checks (expiration, chaining back to a valid root) > occur? [ shrug... ] We do whatever OpenSSL's default validation behavior is. If that's inadequate you probably ought to be taking it up with them, instead of trying to get downstream projects to fix it one at a time

Re: [BUGS] BUG #4340: SECURITY: Is SSL Doing Anything?

2008-08-19 Thread Tom Lane
requirement, we'd have to forbid naming the server by IP address or via a domain-search-path abbreviation. 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 #4340: SECURITY: Is SSL Doing Anything?

2008-08-20 Thread Tom Lane
ms a bit large/invasive/new-feature-ish for a backpatch. 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 #4340: SECURITY: Is SSL Doing Anything?

2008-08-20 Thread Tom Lane
archives from around then to see why this was considered a good 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 #4340: SECURITY: Is SSL Doing Anything?

2008-08-20 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I think the commit you're looking for is this one: >> 2002-09-26 00:41 momjian > No, that's not the one. It's the one after that one, at: No, that one is just fallout from having removed t

Re: [BUGS] BUG #4340: SECURITY: Is SSL Doing Anything?

2008-08-20 Thread Tom Lane
for thread-safety and Windows-portability issues ... 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 #4340: SECURITY: Is SSL Doing Anything?

2008-08-20 Thread Tom Lane
"didn't work according to Peter", but I can't find anything in Sept 2002 pgsql-hackers suggesting exactly what was wrong. 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] range value problem with double precision [PG 8.3.3]

2008-08-22 Thread Tom Lane
behavior on Fedora 9, but not on HPUX. Investigation shows that F9's strtod returns EDOM not ERANGE for this case. Seems like a glibc bug ... 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 #4281: some types of errors do not log statements

2008-08-22 Thread Tom Lane
tring back out for the client, and the worst would be one of those recursive encoding-error- during-error-reporting crashes. I think the short answer is that the OP needs to fix his client code to not generate queries that are illegally encoded according to what he has set client_encoding to be

Re: [BUGS] BUG #4294: XML support: name() xpath function not working

2008-08-22 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Is there any TODO here? It's clearly broken, if that's what you mean. I don't know enough XPath to speculate about an appropriate fix. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #4274: uuid returns duplicate values

2008-08-24 Thread Tom Lane
ldn't it? [ you just made me spill coffee all over my keyboard... ] It's never a good idea to use "Windows" and "robust" in the same sentence. Try googling for "windows duplicate guids" and similar phrases. I get 226000 hits on that one.

Re: [BUGS] BUG #4374: pg_restore does not restore public schema comment

2008-08-25 Thread Tom Lane
That assumption is false, so it's not entirely clear to me exactly what you are complaining about. Please provide a specific test case --- what did you do, what happened, what would you like to happen instead? regards, tom lane -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #4375: pg_dump documentation, -Z option

2008-08-25 Thread Tom Lane
"Daniel Migowski" <[EMAIL PROTECTED]> writes: > The option documentation misses the fact that you can produce gzipped output > files with text format. Huh, so you can. I wonder if anyone but Philip Warner ever knew that. Docs updated ... regards,

Re: [BUGS] non-deterministic error related to MIN/MAX optimization

2008-08-25 Thread Tom Lane
t bother me. It's mostly accidental that there are any variants that do work, I think. Why would you want a SRF in a sort key? 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 #4374: pg_restore does not restore public schema comment

2008-08-25 Thread Tom Lane
the whole, since "public" is a quasi-built-in object, it doesn't seem like a very good idea to depend on being able to alter its properties. Why not attach your version comment to some other, entirely user-defined object? "CREATE SCHEMA version" perhaps ...

Re: [BUGS] non-deterministic error related to MIN/MAX optimization

2008-08-25 Thread Tom Lane
Jeff Davis <[EMAIL PROTECTED]> writes: > On Mon, 2008-08-25 at 22:26 -0400, Tom Lane wrote: >> ... It's mostly accidental that there are any >> variants that do work, I think. Why would you want a SRF in a sort key? > The following line was added to the regressio

Re: [BUGS] Behavior change in PG8.3?

2008-08-26 Thread Tom Lane
he same > values  against PG 8.3.3 as well.but now this vaule is inserted > successfully.I was thinking is this expected ,or was broken in PG 8.2 ? It's not particularly surprising; we now allow denormalized numbers if the platform supports them. regards, tom lan

Re: [BUGS] BUG #4281: some types of errors do not log statements

2008-08-26 Thread Tom Lane
but not >> a computer in the general case. > How is that different from any other syntax error? It's not a syntax error, it's an encoding error, and we daren't try to spit the data back out for fear of getting more encoding errors and ending up in an infinite recursion in elo

Re: [BUGS] non-deterministic error related to MIN/MAX optimization

2008-08-26 Thread Tom Lane
aybe it's been masked for common uses. I'm not entirely sure if we should add SRF support to Agg/Group or just write it off as being a deprecated feature anyhow. Given the definitional issues involved with multiple SRFs in the same targetlist, putting more effort into the feature doesn&

Re: [BUGS] BUG #4377: casting result of timeofday() to timestamp fails in some timezones

2008-08-26 Thread Tom Lane
meantime, why aren't you just using clock_timestamp()? timeofday() is deprecated. 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 #4377: casting result of timeofday() to timestamp fails in some timezones

2008-08-26 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> It sounds like a mind-numbingly tedious task though :-( > Added to TODO: > {{TodoItemEasy > |Revise the src/timezone/tznames abbreviation files: BTW, it just occurred to me to wonder whether we couldn't

Re: [BUGS] BUG #4381: Postgresql daemon won't stay in the foreground

2008-08-27 Thread Tom Lane
s been set in one way or another. 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 #4383: operations in a certain row makes server process terminate with signal 11

2008-08-28 Thread Tom Lane
see what else is on that page first. Check the PG archives for discussions of recovering from corrupted-data scenarios. 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 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held

2008-08-29 Thread Tom Lane
lot of other things that likely would break first, though, so that doesn't seem very probable. Is this transaction longer than any comparable one you ever did before? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes t

Re: [BUGS] PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held

2008-08-29 Thread Tom Lane
Michael Milligan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Huh, that shouldn't happen. What object is that? The 16385 should be >> a database OID, and the 16467 is most likely a table's OID within that >> database. Please answer the above question.

Re: [BUGS] PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held

2008-08-29 Thread Tom Lane
Michael Milligan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Once you've determined which table the error message is talking about, >> please show us what the transaction does with that table. > You mean like: > BEGIN; > PREPARE msg (...) INSERT INT

Re: [BUGS] PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held

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

Re: [BUGS] Bug with FOR ... LOOP and composite types

2008-09-01 Thread Tom Lane
ink that's just a hack. A cleaner fix would be to teach exec_move_row to present the correct column type in all cases. 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 RETURN QUERY

2008-09-01 Thread Tom Lane
dropped columns in the right places. I think we'd consider adding such functionality as a new feature not a back-patchable bug fix. The best near-term workaround would be to handle changes like this by means of ALTER COLUMN TYPE rather than dropping and re-adding columns.

Re: [BUGS] Bug with FOR ... LOOP and composite types

2008-09-01 Thread Tom Lane
oduce that here, at least not with versions newer than 8.0. Maybe you were testing a case that also involved dropped columns? 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 #4393: failed toget system metics for terminal services:87

2008-09-02 Thread Tom Lane
/msg00241.php I believe this is something that's fixed as of 8.2. 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 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held

2008-09-02 Thread Tom Lane
, it'd behoove us to do something about that in 8.4 or beyond. 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 #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key

2008-09-03 Thread Tom Lane
t is that you've overlooked a trigger someplace...) 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 #4397: crash in tab-complete.c

2008-09-03 Thread Tom Lane
refix=/Users/rleitgeb/pq_x86_64 I don't think it's really as "easy" as all that with the 8.3 source tree. This might possibly work with CVS HEAD due to recent changes in our build process, but I'll bet that you simply aren't getting fully 64-bit executables this way in

Re: [BUGS] BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key

2008-09-03 Thread Tom Lane
pty database. A "pg_dump -s" script is usually a good starting place for making that. 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 #4397: crash in tab-complete.c

2008-09-03 Thread Tom Lane
d 8.3. I see no crash as described, and there are no unexpected compile warnings either. So I now concur with Euler's theory that there's something broken about your copy of libedit. (One possibility is that you're not using Apple's libedit, but a locally installed copy of lib

Re: [BUGS] BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key

2008-09-03 Thread Tom Lane
hem as soon as they're deleted, which seems a pretty odd choice. 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

  1   2   3   4   5   6   7   8   9   10   >