[BUGS] BUG #5113: Postgres not scanning indexes

2009-10-13 Thread dan
The following bug has been logged online: Bug reference: 5113 Logged by: dan Email address: dan.boe...@roost.com PostgreSQL version: 8.4.1 Operating system: redhat 5.3 Description:Postgres not scanning indexes Details: Let's say I have a table t with 5 colum

[BUGS] BUG #1701: Installer problem w/ encryption

2005-06-05 Thread Dan
The following bug has been logged online: Bug reference: 1701 Logged by: Dan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows XP Professional Description:Installer problem w/ encryption Details: My Documents was encrypted. The

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

2008-08-04 Thread Dan Kaminsky
The following bug has been logged online: Bug reference: 4340 Logged by: Dan Kaminsky Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3 Operating system: Any Description:SECURITY: Is SSL Doing Anything? Details: http://www.google.com/codesearch?hl=en&a

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

2008-08-04 Thread Dan Kaminsky
Tom Lane wrote: "Dan Kaminsky" <[EMAIL PROTECTED]> writes: Clearly, this is handling self-signed certs. Great. But what I really want to know is, is verify_peer accepting a self-signed identity assertion? Because that'd be remote EoP. I'm just guess

[BUGS] BUG #4363: ts_query bug

2008-08-19 Thread Dan Boeriu
The following bug has been logged online: Bug reference: 4363 Logged by: Dan Boeriu Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Redhat Linux Description:ts_query bug Details: In 8.3.3 select to_tsquery('') is null returns

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

2008-08-19 Thread Dan Kaminsky
ackend.com, do you actually validate that: 1) The subject name of the certificate you're connecting to is database.backend.com, and 2) At least the basic checks (expiration, chaining back to a valid root) occur? I've gotten some reasonable hints that #2 happen, but I don't know i

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

2008-08-19 Thread Dan Kaminsky
Tom Lane wrote: Dan Kaminsky <[EMAIL PROTECTED]> writes: My question has been: When you attempt to create an SSL connection to database.backend.com, do you actually validate that: 1) The subject name of the certificate you're connecting to is database.backend.com

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

2008-08-19 Thread Dan Kaminsky
explicitly say "however I reach that host over there, I expect database.backend.com". --Dan -- 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-19 Thread Dan Kaminsky
d issues. It's pretty embarrassing to find out that even SSL VPN's aren't checking certs. So, yeah, I'm looking to see what level of protection is out there. So, not caring *why* things are broken -- is it fair to say that libpq's use of SSL didn't defend aga

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

2008-08-19 Thread Dan Kaminsky
Good, then we're in agreement that far. Cool! (FWIW, I don't think I've ever seen a PostgreSQL server with a certificate off a global root. I've seen plenty off a corporate root though, which could in theory have similar issues - but at least you're in control of your own problem in that c

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

2008-08-19 Thread Dan Kaminsky
nect out to arbitrary machines on the PostgreSQL port, it can easily be argued that you have a lot of homework to do elsewhere as well ;-) But that's just a mitigating factor, and not a solution. It's hard enough to manage inbound firewall rules. Outbound? Fuggetaboutit :) --D

[BUGS] BUG #4479: Incorrect TSearch2 results when inserting after deleting

2008-10-21 Thread Dan Fabulich
The following bug has been logged online: Bug reference: 4479 Logged by: Dan Fabulich Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: OS X 10.5.5 Description:Incorrect TSearch2 results when inserting after deleting Details: Run the

[BUGS] BUG #4914: uuid_generate_v4 not present in either source or yum/rpm

2009-07-09 Thread Dan Boeriu
The following bug has been logged online: Bug reference: 4914 Logged by: Dan Boeriu Email address: dan.boe...@roost.com PostgreSQL version: 8.4 Operating system: Red Hat 5.3 Description:uuid_generate_v4 not present in either source or yum/rpm Details: I tried

[BUGS] BUG #4945: Parallel update(s) gone wild

2009-07-27 Thread dan boeriu
The following bug has been logged online: Bug reference: 4945 Logged by: dan boeriu Email address: dan.boe...@roost.com PostgreSQL version: 8.3.6 8.3.7 8.4 Operating system: Redhat Linux Description:Parallel update(s) gone wild Details: In my update I use one table

Re: [BUGS] BUG #4945: Parallel update(s) gone wild

2009-07-28 Thread Dan Boeriu
rough in 20 secs. The second will not finish in 24h but the CPU stays at 100% and iostat shows no IO other than the checkpoints. IF I cancel the second UPDATE (pg_cancel_backend) and restart it (new pgsql invocation) ASAP it goes through in 20 secs. Dan Boeriu Senior Architect - Roost.com P:

Re: [BUGS] BUG #4945: Parallel update(s) gone wild

2009-07-29 Thread Dan Boeriu
let me know if you were able to reproduce the problem. Dan Boeriu Senior Architect - Roost.com P: (415) 742 8056 Roost.com - 2008 Inman Award Winner for Most Innovative New Technology bla.tar.gz Description: bla.tar.gz -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] BUG #4945: Parallel update(s) gone wild

2009-07-30 Thread Dan Boeriu
fixed (I understand it has pretty low priority...) ? Thanks a bunch for your time, Dan Boeriu Senior Architect - Roost.com P: (415) 742 8056 Roost.com - 2008 Inman Award Winner for Most Innovative New Technology -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Thu

[BUGS] BUG #4990: JDBC batch insert blocks

2009-08-17 Thread dan boeriu
The following bug has been logged online: Bug reference: 4990 Logged by: dan boeriu Email address: dan.boe...@roost.com PostgreSQL version: 8.3.6 8.3.7 8.4 Operating system: Redhat Linux 5.3 Description:JDBC batch insert blocks Details: After I sent 250 records to

[BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores

2009-08-28 Thread Dan O'Hara
The following bug has been logged online: Bug reference: 5021 Logged by: Dan O'Hara Email address: danarasoftw...@gmail.com PostgreSQL version: 8.3.7 Operating system: win32 Description:ts_parse doesn't recognize email addresses with underscores Details

[BUGS] BUG #5092: to_ascii(); ascii() don't work with bytea

2009-10-01 Thread Dan French
The following bug has been logged online: Bug reference: 5092 Logged by: Dan French Email address: bomarc_...@yahoo.com PostgreSQL version: 8.4 Operating system: Windows 2003 Description:to_ascii(); ascii() don't work with bytea Details: Version 8

Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores

2009-10-22 Thread Dan O'Hara
nd in the query. Regards Dan On Thu, Oct 22, 2009 at 12:29 PM, Robert Haas wrote: > On Fri, Aug 28, 2009 at 9:59 AM, Dan O'Hara wrote: >> >> The following bug has been logged online: >> >> Bug reference:      5021 >> Logged by:          Dan O'Hara >

Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores

2009-10-22 Thread Dan O'Hara
email from "Resume" cheers Dan On Thu, Oct 22, 2009 at 3:39 PM, Euler Taveira de Oliveira wrote: > Robert Haas escreveu: >> I'm not real familiar with ts_parse(), but I'm thinking that it >> doesn't have any special casing for email addresses

[BUGS] BUG #5312: I NEED HELP

2010-02-03 Thread Dan Baldev
The following bug has been logged online: Bug reference: 5312 Logged by: Dan Baldev Email address: dbal...@msn.com PostgreSQL version: 8.4 Operating system: Windows Vista Description:I NEED HELP Details: I USE POSTGRES AND I AM A LAYMAN. I HAVE TRIED LOOKING

[BUGS] PostgreSQL 7.0RC1 access control bug with references

2000-04-27 Thread Dan Franklin
== POSTGRESQL BUG REPORT TEMPLATE == Your name : Dan Franklin Your email address : [EMAIL PROTECTED] System

[BUGS] makefile broken...

2001-02-23 Thread Dan Pereira
bc/port to ./include/port and make: make[1]: Leaving directory `/tmp/postgresql-7.0.3/src/backend' make -C interfaces all make: *** interfaces: No such file or directory. Stop. make: *** [all] Error 2 Thanks, Dan Pereira [EMAIL PROTECTED] (530)406-3548

[BUGS] Table restriction problems

2001-03-07 Thread Dan McGrath
putting my latest project on halt until I find a way to stop this. Also, do you plan on any kind of space/db/table size restrictions any time soon? Thanks Dan McGrath ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

[BUGS] BUG #2579: initcap should not capitalize letter after apostrophe

2006-08-17 Thread Dan Franklin
The following bug has been logged online: Bug reference: 2579 Logged by: Dan Franklin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: GNU/Linux Fedora Core 5 Description:initcap should not capitalize letter after apostrophe Details: The

Re: [BUGS] BUG #2579: initcap should not capitalize letter

2006-08-19 Thread Dan Franklin
Good point. It is probably not possible to get it perfect. But I think that possessives and contractions occur more often in a typical body of text than Irish names. So it would be right more often, even if it is still wrong some of the time. Dan Franklin At 03:08 PM 8/17/2006

[BUGS] BUG #2871: LDAP authentication problem

2007-01-03 Thread Dan Horacek
The following bug has been logged online: Bug reference: 2871 Logged by: Dan Horacek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 - 1 Operating system: windows Description:LDAP authentication problem Details: I've just installed postgres 8.2.0-

[BUGS] BUG #2982: Install broken when not installed as a service

2007-02-08 Thread Dan Armbrust
The following bug has been logged online: Bug reference: 2982 Logged by: Dan Armbrust Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows XP Description:Install broken when not installed as a service Details: If you try to install

[BUGS] BUG #3944: Unable to create a database using SQL_ASCII encoding

2008-02-08 Thread Dan Hrabarchuk
The following bug has been logged online: Bug reference: 3944 Logged by: Dan Hrabarchuk Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Linux, Fedora Core 8 Description:Unable to create a database using SQL_ASCII encoding Details: I can

Re: [BUGS] Bug #865: PostgreSQL 7.3 and 7.3.1 fails to compile

2003-01-10 Thread Dan Wright
d the conftest.c which tests getopt_long in that section of the code does indeed complie without errors. I'm a bit stumped as to what to check next. -Dan ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send a

[BUGS] 7.3 GROUP BY differs from 7.2

2003-02-21 Thread Dan Langille
I notice this today when migrating an application from 7.2 to 7.3. The column name is not being recognized. See also: http://archives.postgresql.org/pgsql-sql/2003-02/msg00480.php This is the query in question: SELECT element_id as wle_element_id, COUNT(watch_list_id) FROM watch_list JOIN wat

[BUGS] pg_dumpall ignores --globals-only

2003-03-06 Thread Dan Langille
roblem exists in 7.3. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] pg_dumpall ignores --globals-only

2003-03-07 Thread Dan Langille
On Thu, 6 Mar 2003, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > > $ pg_dumpall --globals_only > > pg_dumpall: unrecognized option `--globals_only' > > There seems to be a bit of a disconnect between the code, the usage > mess

[BUGS] man pg-dump + triggers

2003-03-10 Thread Dan Langille
I found this hard to comprehend upon the first reading: When doing a data only dump, pg_dump emits queries to disable triggers on user tables before inserting the data and queries to re-enable them after the data has been inserted. If the restore is stopped in the middle, the system catalogs m

Re: [BUGS] Backend crashe with signal 11 wher restoring big database.

2003-03-25 Thread Dan Langille
11 normally indicates a hardware problem, such as faulty RAM. Have you tested the RAM? NOTE: I'm guessing. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[BUGS] Qube2

2003-06-01 Thread Dan Higham
SEMMAP=256 but this doesn't seem to work, although I have not rebuilt a kernel before, I am fairly sure I am doing this the correct way. I would be grateful of any advice you can spare. Thanks Dan Higham ---(e

[BUGS] BUG #1553: Function arguments and table fields

2005-03-20 Thread Dan Black
The following bug has been logged online: Bug reference: 1553 Logged by: Dan Black Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: MS Windows 2000 sp4 Description:Function arguments and table fields Details: 1) Here is simple function

[BUGS] could not connect to server: [then mess]

2005-06-12 Thread Dan Jacobson
It's my first time using postgresql, and I might as well tell you my first impressions. I am reading /usr/share/doc/postgresql/html/tutorial-createdb.html and try $ createdb mydb 2>&1|cat -v createdb: could not connect to database template1: could not connect to server: [EMAIL PROTECTED]&@^S

[BUGS] BUG #1552 followup

2005-08-02 Thread Dan Armbrust
f? 2) Is there a bug tracker somewhere, or do you just track bugs on the mailing list? I haven't been able to find anything on your site. Thanks, Dan -- Daniel Armbrust Biomedical Informatics Mayo Clinic Rochester daniel.armbrust(at)mayo.edu ht

[BUGS] BUG #2326: Problems Upgrading from 8.0.2

2006-03-16 Thread Dan B.
The following bug has been logged online: Bug reference: 2326 Logged by: Dan B. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Mac OS X 10.4.1 Description:Problems Upgrading from 8.0.2 Details: I'm trying to restore a database du

[BUGS] BUG #5668: initdb failed to create postgres database

2010-09-20 Thread Dan Posey
The following bug has been logged online: Bug reference: 5668 Logged by: Dan Posey Email address: dan.po...@gmail.com PostgreSQL version: 9.0 Operating system: Ubuntu 10.04 LTS Server Description:initdb failed to create postgres database Details: initdb did create

Re: [BUGS] BUG #5668: initdb failed to create postgres database

2010-09-21 Thread Dan Posey
Got the pgAdminIII .12. Connects fine. Thanks. On Mon, Sep 20, 2010 at 9:07 PM, Tom Lane wrote: > "Dan Posey" writes: > > initdb did create the directory structure and and files but there is no > > postgres database. > > > Can login using psql but no post

Re: [BUGS] BUG #5918: SummarizeOldestCommittedSxact assertion failure

2011-03-08 Thread Dan Ports
On Tue, Mar 08, 2011 at 01:22:20PM +0200, Heikki Linnakangas wrote: > I think we need to just treat an empty list as normal in > SummarizeOldestcommittedSxact(), patch attached. I just hit the same assertion. Testing this patch now. Dan -- Dan R. K. Ports MIT

Re: [BUGS] BUG #5918: SummarizeOldestCommittedSxact assertion failure

2011-03-08 Thread Dan Ports
Looks good -- with this patch I didn't hit any assertion failures or other errors during an hour of stress testing with DBT-2. Dan -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #8175: Check constraint fails for valid data. ( rounding related? )

2013-05-22 Thread dan . libby
The following bug has been logged on the website: Bug reference: 8175 Logged by: Dan Libby Email address: dan.li...@gmail.com PostgreSQL version: 9.1.6 Operating system: Linux ( Ubuntu 12.04 ) Description: -- Try this script -- create table test1 ( val1 numeric

[BUGS] BUG #2917: spi_prepare doesn't accept typename aliases such as 'integer'

2007-01-22 Thread Vlad Dan Dascalescu
The following bug has been logged online: Bug reference: 2917 Logged by: Vlad Dan Dascalescu Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: RHEL AS 4 Description:spi_prepare doesn't accept typename aliases such as 'integer'