Re: [BUGS] to_char issue?

2010-02-22 Thread Bruce Momjian
the full hours of the interval. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do + If your life is a hard drive, Christ can be your backup. + Index

Re: [BUGS] BUG #5327: postgresql gives checksum error when upgrading 8.2.6 binaries to 8.2.14 in windows.

2010-02-16 Thread Bruce Momjian
@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup

Re: [BUGS] BUG #5315: Unlisted keyword WINDOW

2010-02-05 Thread Bruce Momjian
the keywords from our C code, and then compared the two. The two missing keywords were OVER, and WINDOW, as you mentioned. I have applied the attached patch to CVS HEAD and 8.4.X to properly document our keywords. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB

Re: [BUGS] BUG #5308: How to disable Case sensitivity on naming identifiers

2010-02-03 Thread Bruce Momjian
immediately clear, so I applied the attached documentation patch. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index: doc/src/sgml/syntax.sgml

Re: [BUGS] BUG #5308: How to disable Case sensitivity on naming identifiers

2010-02-03 Thread Bruce Momjian
Tom Lane wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Bruce Momjian escribi?: I found one place in the docs where this wasn't immediately clear, so I applied the attached documentation patch. I liked Tom's suggestion better, because then you don't start questioning about

Re: [BUGS] Status of submitted bugs

2010-01-28 Thread Bruce Momjian
but is the xml core support comparable to contrib/xml2? Is it already there in 8.4 or is scheduled for 8.5? It is in 8.4 and is superior to what was supported in contrib/xml2. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http

Re: [BUGS] BUG #5291: Password change restrictions

2010-01-19 Thread Bruce Momjian
Details: I would like to make an enhancement request to be able to restrict the amount of times a database account may have its password changed in one 24-hour period. Thank you. For such a case you would need to use ldap and configure that restriction in ldap. -- Bruce Momjian br

Re: [BUGS] BUG #5275: validate_exec in port/exec.c only reads u/g/o, not ACLs

2010-01-13 Thread Bruce Momjian
. (Processes designed to run setuid or setgid should call seteuid(2) or setegid(2) as needed to suspend their special privileges.) -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard

Re: [BUGS] BUG #5275: validate_exec in port/exec.c only reads u/g/o, not ACLs

2010-01-13 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: I think access's reputation as something to avoid caused us not to look at it. My old BSD manual says about access(): CAVEAT The access() function should be used rarely, if ever. Specifically, access() should never

Re: [BUGS] psql -1 -f - busted

2009-12-01 Thread Bruce Momjian
Applied. Thanks for the report. --- Bruce Momjian wrote: Robert Haas wrote: On Fri, Nov 27, 2009 at 1:42 AM, Peter Eisentraut pete...@gmx.net wrote: On tor, 2009-11-26 at 22:59 -0500, Robert Haas wrote: ISTM

Re: [BUGS] psql -1 -f - busted

2009-11-30 Thread Bruce Momjian
to me. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index: src/bin/psql/command.c

Re: [BUGS] Kerberos authentication, Active Directory, and PostgreSQL

2009-10-13 Thread Bruce Momjian
symbol from the GSS API. Agreed. In my first glance at the patch I thought GSS_MAX_TOKEN_LENGTH was defined in a system include file. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive

Re: [BUGS] BUG #5103: pg_ctl -w (re)start fails with custom unix_socket_directory

2009-10-10 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Tom Lane wrote: My current feeling about it is that setting unix_socket_directory as a configuration parameter is only useful to those who are deliberately trying to hide their postmaster from regular clients, in which case the fact

Re: [BUGS] BUG #5103: pg_ctl -w (re)start fails with custom unix_socket_directory

2009-10-09 Thread Bruce Momjian
. The way to make it work is of course the same as for any other client, eg put PGHOST=/socket/directory in your environment. Is this current TODO item incorrect? Should it be removed? Have pg_ctl look at PGHOST in case it is a socket directory? -- Bruce Momjian br...@momjian.us

Re: [BUGS] BUG #5053: domain constraints still leak

2009-09-21 Thread Bruce Momjian
* FROM test4 WHERE col1 IS NULL; col1 -- () (1 row) Here I am illustrating that NOT NULL and IS NULL have different ideas of what a NULL is? That seems odd too. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB

Re: [BUGS] pg_ctl infinite loop and memory leak

2009-09-17 Thread Bruce Momjian
. :-) -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription

Re: [BUGS] BUG #4965: missing tests in tools/fsync/test_fsync.c

2009-08-10 Thread Bruce Momjian
HEAD and 8.4.X. Thanks for the report and let me know if you think this can be improved further. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index

Re: [BUGS] BUG #4931: An error occured executing the Microsoft VC++ runtime installer

2009-08-09 Thread Bruce Momjian
: An error occured executing the Microsoft VC++ runtime installer and Windows XP ) I think this is an installer problem so you should contact EnterpriseDB, the installer builder, to report the problem. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB

Re: [BUGS] BUG #4961: pg_standby.exe crashes with no args

2009-08-09 Thread Bruce Momjian
? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [PERFORM] [BUGS] BUG #4919: CREATE USER command slows down system performance

2009-08-08 Thread Bruce Momjian
checking would have to be done a lot later in the startup sequence, with correspondingly more cycles wasted to reject bad passwords. Is this a TODO? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life

Re: [PERFORM] [BUGS] BUG #4919: CREATE USER command slows down system performance

2009-08-08 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Tom Lane wrote: Now that we have SQL-level CONNECT privilege, I wonder just how much functionality would be lost if we got rid of the flat files and told people they had to use CONNECT to do any per-user or per-database access

Re: [BUGS] BUG #4915: installation failure: Failure to set permissions on the installed files

2009-07-09 Thread Bruce Momjian
on the installed files error. What's going on? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB

Re: [BUGS] TH to_char modifier doesn't work with HH12

2009-07-06 Thread Bruce Momjian
right now: does anyone see a reason not to fix that? +1 for backpatching as far as you conveniently can. Will we be _forever_ fixing coding mistakes in formatting.c? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http

Re: [BUGS] TH to_char modifier doesn't work with HH12

2009-07-06 Thread Bruce Momjian
David Fetter wrote: On Mon, Jul 06, 2009 at 01:53:28PM -0400, Bruce Momjian wrote: Tom Lane wrote: Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: Looking at the code, that looks like an oversight and the fix is trivial: Yeah, I think you are right

Re: [BUGS] TH to_char modifier doesn't work with HH12

2009-07-06 Thread Bruce Momjian
we didn't do a thorough enough job. I am thinking there is something structurally/fundamentally wrong with a file that continually has so many bugs. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life

Re: [BUGS] BUG #4883: tar xf fails on NFS4 mounts

2009-07-01 Thread Bruce Momjian
disallows the ordering oxf that you suggest) and I see it in tar on HPUX 10.20, which ought to be about ancient enough for anybody. My old BSD has: -o Write very old style tar archive, omitting the storage of direc- tories. -- Bruce Momjian br...@momjian.ushttp

Re: [BUGS] BUG #4894: [patch] documentation bug on 'include' directive

2009-07-01 Thread Bruce Momjian
should have confirmed where the error message came from. Debian has frustrated us in the past with their imperfect modifications to our code, so you are not solely at fault. ;-) -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http

Re: [BUGS] BUG #4861: Incorrect log_line_prefix default value in postgresql.conf

2009-06-18 Thread Bruce Momjian
to look elsewhere about how that got set to '%%t'; I have no idea. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #4861: Incorrect log_line_prefix default value in postgresql.conf

2009-06-18 Thread Bruce Momjian
? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] Re: 42804: structure of query does not match error where using RETURN QUERY

2009-06-02 Thread Bruce Momjian
sure about how hard this is to fix, but in the meantime you will need to dump and recreate/reload that particular table in order to get it to work. Is this a TODO? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com

Re: [BUGS] BUG #4809: Missing Expected Operator

2009-06-02 Thread Bruce Momjian
, w.geocode ) and g.boundary @ w.geocode; This is already mentioned on the TODO list: Add missing operators for geometric data types Some geometric types do not have the full suite of geometric operators, e.g. box @ point -- Bruce Momjian br...@momjian.us

Re: [BUGS] [NOVICE] Workaround for bug #4608?

2009-04-22 Thread Bruce Momjian
one of our Win32 guys has an idea. I am moving this email over to the bugs list. Folks, here is a history of the bug report; it seems he can't install in /data on Windows: http://archives.postgresql.org//pgsql-novice/2009-04/msg00079.php -- Bruce Momjian br...@momjian.ushttp

Re: [BUGS] BUG #4773: Logging error

2009-04-22 Thread Bruce Momjian
of log_min_duration_statement would be showing you times as well as queries. The two settings do not control each other. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent

Re: [BUGS] BUG #4768: FATAL:could not reattach to shared memory:487

2009-04-21 Thread Bruce Momjian
= ''# list of custom variable class names -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB

Re: [BUGS] BUG #4768: FATAL:could not reattach to shared memory:487

2009-04-21 Thread Bruce Momjian
will be released ? Uh, have you tried rebooting the server? Here is our TODO item: Diagnose problem where shared memory can sometimes not be attached by postmaster children * FATAL: could not reattach to shared memory (Win32) -- Bruce Momjian br

Re: [BUGS] BUG #4768: FATAL:could not reattach to shared memory:487

2009-04-21 Thread Bruce Momjian
Bruce Momjian wrote: Ghislain ROUVIGNAC wrote: Thanks for your answer. Stoping/starting the server does not solve the problem. It reappears quickly. As a work around I still run my DB on Linux Red Hat with Postgres 8.1, but i would like to move to the new Windows 2008 server

Re: [BUGS] BUG #4768: FATAL:could not reattach to shared memory:487

2009-04-21 Thread Bruce Momjian
Ghislain ROUVIGNAC wrote: I didn't tried to reboot the windows server. I'll try it when i will have time. Thank you for the references to the problem. OK, let us know if it does not fix the problem. As you can see this bug has been around for a while. -- Bruce Momjian br

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-14 Thread Bruce Momjian
Magnus Hagander wrote: On 14 apr 2009, at 04.33, Bruce Momjian br...@momjian.us wrote: Magnus Hagander wrote: I would actually call the two parameters 'verify-cert' and 'verify- cn', and document that they also have require behavior. Obviously you can't verify certificates unless

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-14 Thread Bruce Momjian
Applied. Depending on how we handle this the error text might need to change but odds are we will still need to report something related to sslmode/sslverify when root.crt is missing. --- Bruce Momjian wrote: Peter

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-14 Thread Bruce Momjian
Bruce Momjian wrote: That's the intention. When you're turning off something, I think it makes sense to use no But that doesn't scale: sslmode currently has four options, soon perhaps to be six. The idea is that the items should be of increasing security, and adding

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-13 Thread Bruce Momjian
disable as the default *value* of the parameter) I think the no options are odd because they have _negative_ designations. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-12 Thread Bruce Momjian
that they also have require behavior. Obviously you can't verify certificates unless you require SSL. I am fine with changing the default sslmode. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-11 Thread Bruce Momjian
a trusted certificate. I will now look at improving the libpq error message. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-11 Thread Bruce Momjian
three lines? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index: src/interfaces/libpq/fe-secure.c

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-11 Thread Bruce Momjian
. The only other approach would be to add an sslverify value of 'try' that tries only if root.crt exists. A separate issue is if sslverify should default to 'cn'. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-11 Thread Bruce Momjian
require I don't see how we could use 'allow', but 'disable', 'prefer', and 'require' seem to work for sslverify, like sslmode. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-11 Thread Bruce Momjian
Bruce Momjian wrote: It would be nice if 'sslverify' mimicked 'sslmode', which has these values: disable allow prefer require I don't see how we could use 'allow', but 'disable', 'prefer', and 'require' seem to work for sslverify, like sslmode. OK, crazy idea

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-10 Thread Bruce Momjian
?). The problem is that libpq doesn't have any ability to warn/prompt like SSH and web browsers do, so I think Magnus patterned the libpq behavior around cases where warning/prompt failed in these environments. I am not saying the current behavior is correct, only why it was configured that way. -- Bruce

Re: [BUGS] possible bug not in open items

2009-04-09 Thread Bruce Momjian
set ImmediateInterruptOK there as well, for the sake of completeness. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life

Re: [BUGS] BUG #4738: Cannot reconnect to shared memory

2009-04-09 Thread Bruce Momjian
subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql

Re: [BUGS] Subbestions: 1) Query timeout 2) Session kill by same login

2009-03-14 Thread Bruce Momjian
statement_timeout in postgresql.conf is not recommended because it affects all sessions. **Need a job? Find employment help in your area. (http://yellowpages.aol.com/search?query=employment_agenciesncid=emlcntusyelp0005) See also ALTER USER SET ... -- Bruce Momjian br

Re: [BUGS] BUG #4675: FATAL: could not reattach to shared memory

2009-02-24 Thread Bruce Momjian
this: Diagnose problem where shared memory can sometimes not be attached by postmaster children * FATAL: could not reattach to shared memory (Win32) http://archives.postgresql.org/pgsql-general/2007-08/msg01377.php -- Bruce Momjian br...@momjian.ushttp

Re: [BUGS] BUG #4649: unclear in create trigger - complete example

2009-02-12 Thread Bruce Momjian
? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] pg_listener entries deleted under heavy NOTIFY load only on Windows

2009-02-09 Thread Bruce Momjian
, and the rest of the thread was posted in January. Is there any way to make the mailing list archives link these messages back to the rest of the thread? I am tracking this item and was waiting for someone to reply to it. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB

Re: [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY

2009-02-05 Thread Bruce Momjian
... ] -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life

Re: [HACKERS] [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY

2009-02-04 Thread Bruce Momjian
Robert Haas wrote: 2009/1/10 Tom Lane t...@sss.pgh.pa.us: Bruce Momjian br...@momjian.us writes: Uh, is this ready to be applied? I don't think any consensus has been reached on changing this behavior. I thing, so this is bug - RETURN QUERY has to supply FOR SELECT LOOP RETURN

Re: [BUGS] BUG #4621: Password is shown on the terminal

2009-01-19 Thread Bruce Momjian
in the plain text instead of in encrypted form or hidden from the user. Expected Result: - 1) Password should be hidden or *s should be shown. Note that I am using the Win XP with service pack 3. Hmmm. Please try specifying the file name with psql -f, rather than . -- Bruce Momjian br

Re: [BUGS] BUG #4562: ts_headline() adds space when parsing url

2009-01-15 Thread Bruce Momjian
list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can

Re: [BUGS] BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION

2009-01-15 Thread Bruce Momjian
the other way. The manual entry wasn't changed from my original submission unfortunately. OK, do you have updated wording? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ

Re: [BUGS] BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION

2009-01-15 Thread Bruce Momjian
TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center [ Attachment, skipping... ] -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp

Re: [BUGS] BUG #4562: ts_headline() adds space when parsing url

2009-01-14 Thread Bruce Momjian
@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent

Re: [BUGS] BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION

2009-01-14 Thread Bruce Momjian
Source Software Center [ Attachment, skipping... ] -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB

Re: [BUGS] Fall back to alternative tsearch dictionary directory

2009-01-14 Thread Bruce Momjian
| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) [ Attachment, skipping... ] -- End of PGP section, PGP failed! -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http

Re: [BUGS] BUG #4612: lc_numeric setting ignored

2009-01-13 Thread Bruce Momjian
Mark Hayen wrote: He Bruce, Thank you for replying. Does this mean that there is no way to do a \copy from using CSV files containing decimals with a comma? That is correct, sorry. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB

Re: [BUGS] BUG #4612: lc_numeric setting ignored

2009-01-12 Thread Bruce Momjian
totaalbedragaanslag from import.aanslag; totaalbedragaanslag - 33.33 (1 row) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br

Re: [HACKERS] [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY

2009-01-09 Thread Bruce Momjian
pgsql-hackers mailing list (pgsql-hack...@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life

Re: [BUGS] BUG #4494: Memory leak in pg_regress.c

2009-01-08 Thread Bruce Momjian
://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index: src/test/regress/pg_regress.c

Re: [BUGS] BUG #4509: array_cat's null behaviour is inconsistent

2009-01-08 Thread Bruce Momjian
://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] Debian Bug#506196: postgresql: consume too much power when idle (10 wakeups/second)

2009-01-05 Thread Bruce Momjian
. It'd be nice to have a plan for improving things though. Is this a TODO? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs

Re: [BUGS] BUG #4027: backslash escaping not disabled in plpgsql

2008-12-15 Thread Bruce Momjian
to be security definers. Is this actually true or did we just forget it? :-) Did we ever address this? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup

Re: [BUGS] BUG #3818: Cross compilation problems

2008-12-06 Thread Bruce Momjian
) @echo $(CURDIR) -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] BUG #4186: set lc_messages does not work

2008-12-06 Thread Bruce Momjian
://archives.postgresql.org/pgsql-patches/2008-02/msg00038.php purports to fix this. It doesn't seem to have gotten reviewed though. Where are we on this? -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your

Re: [BUGS] BUG #4186: set lc_messages does not work

2008-12-06 Thread Bruce Momjian
? --- Regards, Gevik. -Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 4:54 PM To: Bruce Momjian Cc: Tom Lane; Thomas H.; pgsql-bugs@postgresql.org; Gevik Babakhani Subject: Re: [BUGS] BUG #4186: set lc_messages does

Re: [BUGS] BUG #4529: lc_messages in config ignored

2008-11-20 Thread Bruce Momjian
: http://archives.postgresql.org/pgsql-bugs/2008-10/msg00026.php but never got any response. Yep, we know it is a bug but haven't found a fix yet. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life

Re: [BUGS] ftp server symlink

2008-10-23 Thread Bruce Momjian
://www.depesz.com/ jid/gtalk: [EMAIL PROTECTED] / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian [EMAIL PROTECTED]http

Re: [BUGS] ftp server symlink

2008-10-23 Thread Bruce Momjian
Bruce Momjian wrote: Thanks, fixed, sources - source. Oops, sorry, I did not fix it. I fixed it on developer.postgresql.org, but that is not where ftp.postgresql.org is pointed to. Marc

Re: [BUGS] ftp server symlink

2008-10-23 Thread Bruce Momjian
! --- On Thu, 23 Oct 2008, Bruce Momjian wrote: Bruce Momjian wrote: Thanks, fixed, sources - source. Oops, sorry, I did not fix it. I fixed it on developer.postgresql.org, but that is not where ftp.postgresql.org is pointed to. Marc

Re: [BUGS] BUG #4486: CSV feature request

2008-10-23 Thread Bruce Momjian
; COPY 3 where /rtmp/1 had: a, b a, b a, b and saw no errors or warnings. Are you saying we should complain, and if so, why? -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-14 Thread Bruce Momjian
? -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #4410: Indexes not seen right away

2008-10-02 Thread Bruce Momjian
. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + DROP TABLE test; CREATE TABLE test (x int); DROP SEQUENCE seq; CREATE SEQUENCE seq; INSERT INTO test SELECT nextval

Re: [BUGS] BUG #4436: (E'\\' LIKE E'\\') = f

2008-09-25 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Mathieu Fenniak wrote: I noticed that (SELECT E'\\' LIKE E'\\') returns false, I believe this is caused because backslash is the default escape character for LIKE, so you need: test= SELECT E'\\' LIKE E''; Yeah

Re: [BUGS] BUG #4436: (E'\\' LIKE E'\\') = f

2008-09-24 Thread Bruce Momjian
(1 row) -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

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

2008-09-07 Thread Bruce Momjian
or beyond. Is this a TODO? -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

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

2008-09-05 Thread Bruce Momjian
this. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription

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

2008-09-05 Thread Bruce Momjian
are clearer. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #4372: TO_DATE with ISO week and day

2008-08-22 Thread Bruce Momjian
to the existing TODO item. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

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

2008-08-22 Thread Bruce Momjian
Hiroshi Saito wrote: Hi. Yes, Finally Ralf-san adjusts this patch. http://winpg.jp/~saito/pg_work/OSSP_win32/. Therefore, it is contained in the next release.(1.6.3/4) OK, good. Does any of this get applied to contrib/uuid-ossp? -- Bruce Momjian [EMAIL PROTECTED]http

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

2008-08-22 Thread Bruce Momjian
get very difficult to find the point of failure without more information. I am unclear what would cause this. Is the STATEMENT: line coming from log_statement? What is the query that is not showing? -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB

Re: [BUGS] FAQ 1.1 has wrong developer's FAQ address

2008-08-22 Thread Bruce Momjian
the main FAQ to a wiki at some point. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

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

2008-08-22 Thread Bruce Momjian
pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive

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

2008-08-21 Thread Bruce Momjian
Hiroshi Saito wrote: Hi. This can obtain a comfortable result. http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-20080706.zip I will adjust with Rarf-san. Has this been completed? -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB

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

2008-08-20 Thread Bruce Momjian
this up. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

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

2008-08-20 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I found the reason for the patch; the SSL guy at that time, Bear, disappeared, and our code required SSL certificates at that point, so I removed the requrement: Hmm, according to that thread the code that got diked out didn't work

Re: [BUGS] BUG #4271: dropped columns conflict with returning rules

2008-08-20 Thread Bruce Momjian
subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list

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

2008-08-15 Thread Bruce Momjian
would help the user. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #4186: set lc_messages does not work

2008-07-15 Thread Bruce Momjian
://archives.postgresql.org/pgsql-patches/2008-02/msg00038.php purports to fix this. It doesn't seem to have gotten reviewed though. Agreed. Magnus, someone, can we get feedback on the patch at this URL? http://archives.postgresql.org/pgsql-patches/2008-02/msg00038.php -- Bruce Momjian

Re: [BUGS] BUG #4191: Include hint for Windows-like locals in documentation

2008-07-14 Thread Bruce Momjian
patch. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index: doc/src/sgml/charset.sgml

Re: [BUGS] BUG #4266: regress test: could not dump unrecognized node type: 925

2008-06-26 Thread Bruce Momjian
tests are pointing out? -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #4266: regress test: could not dump unrecognized node type: 925

2008-06-26 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Oh, you've got debug_print_parse turned on. But doesn't the failure indicate a potential problem that the regression tests are pointing out? Only that outfuncs.c has very incomplete coverage of utility statements

Re: [BUGS] BUG #4053: libpq documentation should express clearly, that integers are passed in network octet order

2008-06-23 Thread Bruce Momjian
this libpq documentation paragraph about how to determine how to pass binary values. I also added a few comments to the libpq C code. Thanks for the report; please let me know if I can improve it more. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB

<    1   2   3   4   5   6   7   8   9   10   >