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

2008-07-14 Thread Bruce Momjian
German_Germany" rather than "de_DE". Yep. I have improved the documentation with the attached patch. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your

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

2008-07-15 Thread Bruce Momjian
someone, can we get feedback on the patch at this URL? http://archives.postgresql.org/pgsql-patches/2008-02/msg00038.php -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard dri

Re: [BUGS] BUG #4321: 8.3 installer shortens allowable BASE_DIR path length?

2008-08-11 Thread Bruce Momjian
clear from the comments why this change was needed, but if someone > could change mybuf back to 8192 bytes (or something significantly more than > MAX_PATH+1 (which on windows is only 260)) - I think it would be a good > thing? > Regards, > Bob > > -- > Sent via pgsql-bugs m

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

2008-08-15 Thread Bruce Momjian
ted running Postgres 7.3 and we have improved SSL quite a bit since then so perhaps an upgrade and reading the current docs would help the user. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If y

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

2008-08-20 Thread Bruce Momjian
me, "Bear", disappeared, and our code required SSL certificates at that point, so I removed the requrement: http://archives.postgresql.org/pgsql-hackers/2002-09/msg01522.php I will work with Magnus on cleaning this up. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjia

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, accor

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

2008-08-20 Thread Bruce Momjian
foo add column f5 int; > ALTER TABLE > regression=# alter table foo drop column f5; > ALTER TABLE > regression=# create or 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 lik

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://m

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

2008-08-22 Thread Bruce Momjian
r version it > works, but the result is wrong. > select to_date('2008-31-4','IYYY-IW-ID') > in version 8.2.6 results in "2004-07-26", which is wrong. Yes, we have fixed some of this in 8.3. I have added your report to the existing TODO item. -- Bruce M

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 PROTE

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

2008-08-22 Thread Bruce Momjian
olled by "client_encoding". > > > it would be usefull to always see the sql statement that provoked the error. > especially in the case of wrong utf byte sequences it can get very difficult > to find the point of failure without more information. I am unclear what would cau

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

2008-08-22 Thread Bruce Momjian
but I think we need to move 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-

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

2008-08-22 Thread Bruce Momjian
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: > htt

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

2008-08-22 Thread Bruce Momjian
Tom Lane wrote: > 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. The XML wiki already had bug reports abo

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

2008-09-05 Thread Bruce Momjian
ely user-defined > object? "CREATE SCHEMA version" perhaps ... I have added a comment in the source code about this. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a h

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

2008-09-05 Thread Bruce Momjian
t is deprecated. Uh, we will probably never remove timeofday() but the new functions are clearer. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your ba

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

2008-09-07 Thread Bruce Momjian
e. > > In any case, now that we know that nLocks overflow is actually possible > within real-world transaction lengths, it'd behoove us to do something > about that in 8.4 or beyond. Is this a TODO? -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us Ente

Re: [BUGS] [HACKERS] 0x1A in control file on Windows

2008-09-23 Thread Bruce Momjian
is an end-of-file marker on Windows. > > Well, why is that a bug? If the platform is so silly as to define text > files that way, who are we to argue? The problem is that our pg_controldata might have binary values that contain 0x1a that will be confused by the operating system as end-of-

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

2008-09-24 Thread Bruce Momjian
or change the escape character: test=> SELECT E'\\' LIKE E'\\' escape 'a'; ?column? -- t (1 row) -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://ente

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 > > characte

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

2008-10-02 Thread Bruce Momjian
d README.HOT, patch attached. -- 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 SEQ

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

2008-10-14 Thread Bruce Momjian
compliant than MySQL, but Postgres is not 100% compliant either. Is any database system 100% compliant? -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your

Re: [BUGS] ftp server symlink

2008-10-23 Thread Bruce Momjian
gsql-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 lif

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

Re: [BUGS] ftp server symlink

2008-10-23 Thread Bruce Momjian
now --- thanks! --- > > 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, > >

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

2008-10-23 Thread Bruce Momjian
I tried this: test=> create table test (x text, y text); test=> copy test from '/rtmp/1' with csv; COPY 3 where /rtmp/1 had: "a", "b" a, "b" a, b and saw no errors or warnings.

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

2008-11-20 Thread Bruce Momjian
gt;lc_messages = 'C' > >or > >lc_messages = 'english.english' > > > >in freebsd i have no this bug. > > I have reported this bug about a month ago: > <http://archives.postgresql.org/pgsql-bugs/2008-10/msg00026.php> b

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

2008-12-06 Thread Bruce Momjian
> > > > > What does $(CURDIR) resolve to on mingw? Try the following makefile: > > > > default: > > @echo $(shell pwd) > > @echo $(shell pwd -W) > > @echo $(CURDIR) > > > > -- Bruce Momjian <[EMAIL PROTECTE

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

2008-12-06 Thread Bruce Momjian
at didn't look at the same info as the current code? > > Anyway the patch mentioned at the start of the thread > http://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

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

2008-12-06 Thread Bruce Momjian
posting on the topic, I think. Status? --- > > Regards, > Gevik. > > > > -Original Message- > > From: Magnus Hagander [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, August 05, 2008 4:54 PM > > To: Bruce Momjian > > Cc: Tom Lan

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

2008-12-15 Thread Bruce Momjian
t; functions, with potentially nasty consequences if they chanced to be > > security definers. > > Is this actually true or did we just forget it? :-) Did we ever address this? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterpri

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

2009-01-05 Thread Bruce Momjian
> The short answer is "don't hold your breath". It'd be nice to have a > plan for improving things though. Is this a TODO? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard dr

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

2009-01-08 Thread Bruce Momjian
ot;, tmp, i, last_dot + 1); > free(tmp); > return s; > } > > -- > 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 http:

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

2009-01-08 Thread Bruce Momjian
ld, for consistency. > > Kev > > -- > 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 http://momjian.us EnterpriseDB http

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

2009-01-09 Thread Bruce Momjian
> (3 rows) > > > > Since GET DIAGNOSTICS is documented as working for every SQL query > > executed in the function, rather than for a specific list of > > constructs, this is clearly a bug. > > > > -- > > Andrew (irc:RhodiumToad) > > > > -- > >

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

2009-01-12 Thread Bruce Momjian
.UTF-8 > (1 row) > > dimpact=# select 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:

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 http://momjian.us EnterpriseDB

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

2009-01-14 Thread Bruce Momjian
gt; But it seems to me to be at least as plausible that you should get > nothing as that you should get a space for a removed tag. > > Comments? > > regards, tom lane > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make cha

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

2009-01-14 Thread Bruce Momjian
hat we should > also backport. > > Regards, > > -- > Fujii Masao > NIPPON TELEGRAPH AND TELEPHONE CORPORATION > NTT Open Source Software Center [ Attachment, skipping... ] > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To mak

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

2009-01-14 Thread Bruce Momjian
ystem_ll_cc.affix, that would still work for > > me. > > Right, so I changed the patch accordingly. > > Thanks, > > Martin > -- > Martin Pitt| http://www.piware.de > Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian

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

2009-01-15 Thread Bruce Momjian
blah > (1 row) > > But it seems to me to be at least as plausible that you should get > nothing as that you should get a space for a removed tag. > > Comments? > > regards, tom lane > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgr

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

2009-01-15 Thread Bruce Momjian
t; I agree. It might have been better to define it the other way > > originally, but the risks of changing it now outweigh any likely > > benefit. > > Agreed. It's too confusing the other way. > > The manual entry wasn't changed from my original submission > u

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

2009-01-15 Thread Bruce Momjian
Attached is a patch against HEAD. I think that we should > also backport. > > Regards, > > -- > Fujii Masao > NIPPON TELEGRAPH AND TELEPHONE CORPORATION > NTT Open Source Software Center [ Attachment, skipping... ] > > -- > Sent via pgsql-bugs mailing list (pgs

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

2009-01-19 Thread Bruce Momjian
vice pack 3. Hmmm. Please try specifying the file name with psql -f, rather than <. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bug

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 : > >> Bruce Momjian 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 - RETU

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

2009-02-05 Thread Bruce Momjian
> (3 rows) > > > > Since GET DIAGNOSTICS is documented as working for every SQL query > > executed in the function, rather than for a specific list of > > constructs, this is clearly a bug. > > > > -- > > Andrew (irc:RhodiumToad) > > > > --

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

2009-02-09 Thread Bruce Momjian
e it was issued in February, 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

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

2009-02-12 Thread Bruce Momjian
until i found the link above. So what changes do you suggest? -- Bruce Momjian 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@post

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

2009-02-24 Thread Bruce Momjian
> What is this? How can I repair this? Our TODO list has 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-gen

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

2009-03-14 Thread Bruce Momjian
l) > Setting 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_agencies&ncid=emlcntusyelp0005) See also ALTER US

Re: [BUGS] possible bug not in open items

2009-04-09 Thread Bruce Momjian
protocol. That has got to be deprecated > enough to not worry about :-). Then again, it wouldn't be hard to put > set ImmediateInterruptOK there as well, for the sake of completeness. > > -- >Heikki Linnakangas >EnterpriseDB http://www.enterprisedb.com -- Bru

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

2009-04-09 Thread Bruce Momjian
ng up > other order dependant code. > > -- > 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 http://momjian.us EnterpriseDB htt

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

2009-04-10 Thread Bruce Momjian
owsers 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 Momjian http://momjian.us EnterpriseDB

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

2009-04-11 Thread Bruce Momjian
e file is named %APPDATA%\postgresql\root.crt.) libpq will then verify that the server's certificate is signed by one of the trusted certificate authorities. The SSL connection will fail if the server does not present a trusted certificate. I will now look at improvin

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

2009-04-11 Thread Bruce Momjian
Type "help" for help. I had to add a second error message line; I didn't see us doing a second line anywhere else in libpq, but it seemed to be the only solution. Should I use three lines? -- Bruce Momjian http://momjian.u

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

2009-04-11 Thread Bruce Momjian
if there is no root.crt file. 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 http://momjian.us EnterpriseDB

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

2009-04-11 Thread Bruce Momjian
on". l1 and 0O where taken? ;-) 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

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',

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

2009-04-12 Thread Bruce Momjian
e is just too much risk of misconfiguration with two parameters. 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 you require SSL. I am fine wit

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

2009-04-13 Thread Bruce Momjian
ify. Or they could be "require-no-cn" > and "require-no-cert" perhaps? > > ("default choice" only for those using ssl of course - we'd still have > "disable" as the default *value* of the parameter) I think the "no" options are

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 wrote: > > > Magnus Hagander wrote: > >>> I would actually call the two parameters 'verify-cert' and 'verify- > >>> cn', > >>> and document that they also hav

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: > Pe

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 shou

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

2009-04-21 Thread Bruce Momjian
# encoding > > # These settings are initialized by initdb, but they can be changed. > lc_messages = 'C'# locale for system error message > # strings > lc_monetary = 'C'# locale for monetary formatting &

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

2009-04-21 Thread Bruce Momjian
. > > > How can I know when a fix 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 mem

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

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 wh

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

2009-04-22 Thread Bruce Momjian
on IM now but I am hoping 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

Re: [BUGS] BUG #4773: Logging error

2009-04-22 Thread Bruce Momjian
are from log_statement = all. The output of log_min_duration_statement would be showing you times as well as queries. The two settings do not control each other. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard

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

2009-06-02 Thread Bruce Momjian
tion result type. I'm not too 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 http://momjian.us EnterpriseDB

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

2009-06-02 Thread Bruce Momjian
around with, the following, but it is really a kludge. > > WHERE >g.box_boundary @> box( w.geocode, 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

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

2009-06-18 Thread Bruce Momjian
ook at share/postgresql.conf.sample you will see that line too. I think you need to look elsewhere about how that got set to '%%t'; I have no idea. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life i

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

2009-06-18 Thread Bruce Momjian
# special values: so I am unclear why Windows would have a different default. How are you viewing this default? From the command line? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard dri

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

2009-07-01 Thread Bruce Momjian
(although that specifically 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- to

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

2009-07-01 Thread Bruce Momjian
; > You are entirely correct, it was the Debian init scripts trying to > parse the config file. My apologies for wasting your time. I should > have confirmed where the error message came from. Debian has frustrated us in the past with their imperfect modifications to o

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

2009-07-06 Thread Bruce Momjian
led 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 http://momjian.us EnterpriseDB http://enterpri

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 writes: > > > > Looking at the code, that looks like an oversight and the fix is > > > > trivial: > > > > >

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

2009-07-06 Thread Bruce Momjian
Greg Stark wrote: > On Mon, Jul 6, 2009 at 7:20 PM, Bruce Momjian wrote: > > I feel like someone should take a flame-thrower to that file. ?;-) > > If you were half the man you used to be would you? I thought we had flame-throwed it a couple of of times, with overhauls, but obvi

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

2009-07-09 Thread Bruce Momjian
ty tab on the Program Files folder where the > PostgreSQL folder resides, and I have Full Control on all the permissions. > > Not sure why I keep getting this "Failed to set permissions on the installed > files" error. What's going on? > > -- > Sent via pgsql

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

2009-08-07 Thread Bruce Momjian
> The main point I can see offhand is that password 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 http://momjian.us EnterpriseDB

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

2009-08-08 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian 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

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

2009-08-09 Thread Bruce Momjian
t; (WSH aktivatet !) > > Check on the TODO list and in the FAQ is negatve ! > ( Search: " 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 instal

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

2009-08-09 Thread Bruce Momjian
e command and the crash text? -- Bruce Momjian 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

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

2009-08-10 Thread Bruce Momjian
e omitted on systems without an o_sync. Yea, that C file needed some help. I have applied the attached patch to CVS HEAD and 8.4.X. Thanks for the report and let me know if you think this can be improved further. -- Bruce Momjian http://momjian.us EnterpriseDB

Re: [BUGS] pg_ctl infinite loop and memory leak

2009-09-17 Thread Bruce Momjian
hought I knew the libc API pretty well, but I learned something new here. :-) -- Bruce Momjian 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

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

2009-09-21 Thread Bruce Momjian
TE TABLE test4(col1 xx NOT NULL); CREATE TABLE test=> INSERT INTO test4 VALUES (ROW(NULL)); INSERT 0 1 test=> SELECT * FROM test4 WHERE col1 IS NULL; col1 -- () (1 row) Here I am illustrating that NOT NULL and

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

2009-10-09 Thread Bruce Momjian
re not a bug. > 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 Mom

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 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

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

2009-10-13 Thread Bruce Momjian
nstant should be named > something like PG_...; otherwise it looks like we are defining or > overriding an official 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 http://momji

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

2009-11-30 Thread Bruce Momjian
than earlier. The attached patch accomplishes this. The code still goes into interactive mode, though: $ psql -f - test test=> Should that prompt not appear? Seems OK to me. -- Bruce Momjian http://momjian.u

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 wrote: > > > On tor, 2009-11-26 at 22:59 -0500, Robert Haas wrote: &

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

2010-01-13 Thread Bruce Momjian
iming race applies to all uses of access(), so it is better to attempt the operation itself to see if it will succeed. (Processes designed to run setuid or setgid should call seteuid(2) or setegid(2) as needed to suspend their special privileges.) -- Bruce Momjian

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 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, >

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

2010-01-19 Thread Bruce Momjian
ion:Password change restrictions > 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 configur

Re: [BUGS] Status of submitted bugs

2010-01-28 Thread Bruce Momjian
end migrating to > > the core XML support instead. > > Ok, sorry for the silly question 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

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

2010-02-03 Thread Bruce Momjian
e this wasn't immediately clear, so I applied the attached documentation patch. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backu

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

2010-02-03 Thread Bruce Momjian
Tom Lane wrote: > Alvaro Herrera 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

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

2010-02-05 Thread Bruce Momjian
s, and then ran "SELECT word FROM pg_get_keywords() WHERE catcode != 'U'" to get all 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

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
8 > Blocks per segment of large relation: 0 > WAL block size: 0 > Bytes per WAL segment:1093850759 > Maximum length of identifiers:8192 > Maximum columns in an index: 131072 > Date/time type storage: 64-bit in

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2010-02-18 Thread Bruce Momjian
the docs so they don't say that binary distros > will include the pre-built tutorial binaries, and then we can consider > shipping the source files in the installers/rpms etc. I have applied the attached patch which removes the mention that the tutorial files are precompiled. -- Br

  1   2   3   4   5   6   7   8   9   10   >