[BUGS] BUG #4369: connectby method

2008-08-22 Thread Derek & Bob
The following bug has been logged online: Bug reference: 4369 Logged by: Derek & Bob Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Linux Description:connectby method Details: I've got a question about table connectby method. Say, we ha

[BUGS] BUG #4370: connectby method

2008-08-22 Thread Derek & Bob
The following bug has been logged online: Bug reference: 4370 Logged by: Derek & Bob Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Linux Description:connectby method Details: I've got a question about table connectby method. Say, we ha

Re: [BUGS] Postgresql v8.3.3 + Perl v5.10

2008-08-22 Thread Eugen.Konkov
1. Install Perl v5.10 2. Install PG 3. PG does not see that machine has Perl 4. Remove Perl and PG 5. Instll Perl v5.8 6. Install PG 7. PG work fine Problem is that PG does not recognize Perl v5.10 =( - Original Message - From: "Euler Taveira de Oliveira" <[EMAIL PROTECTED]> To: <[EMAIL

Re: [BUGS] Postgresql v8.3.3 + Perl v5.10

2008-08-22 Thread Peter Eisentraut
[EMAIL PROTECTED] wrote: > 1. Install Perl v5.10 > 2. Install PG > 3. PG does not see that machine has Perl > 4. Remove Perl and PG > 5. Instll Perl v5.8 > 6. Install PG > 7. PG work fine > Problem is that PG does not recognize Perl v5.10 =( Please provide the actual commands and the actual output

Re: [BUGS] Postgresql v8.3.3 + Perl v5.10

2008-08-22 Thread Magnus Hagander
Peter Eisentraut wrote: > [EMAIL PROTECTED] wrote: >> 1. Install Perl v5.10 >> 2. Install PG >> 3. PG does not see that machine has Perl >> 4. Remove Perl and PG >> 5. Instll Perl v5.8 >> 6. Install PG >> 7. PG work fine >> Problem is that PG does not recognize Perl v5.10 =( > > Please provide the

Re: [BUGS] Postgresql v8.3.3 + Perl v5.10

2008-08-22 Thread Pavel Stehule
2008/8/22 Peter Eisentraut <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: >> 1. Install Perl v5.10 >> 2. Install PG >> 3. PG does not see that machine has Perl >> 4. Remove Perl and PG >> 5. Instll Perl v5.8 >> 6. Install PG >> 7. PG work fine >> Problem is that PG does not recognize Perl v5.10 =(

Re: [BUGS] Postgresql v8.3.3 + Perl v5.10

2008-08-22 Thread Eugen.Konkov
Yes, I am ActivePerl and Win32 Binary PG Is it scheduled to fix? - Original Message - From: "Pavel Stehule" <[EMAIL PROTECTED]> To: "Peter Eisentraut" <[EMAIL PROTECTED]> Cc: ; <[EMAIL PROTECTED]>; "Euler Taveira de Oliveira" <[EMAIL PROTECTED]> Sent: Friday, August 22, 2008 12:20 PM

[BUGS] BUG #4371: Foreign Key constraints not working with ODBC

2008-08-22 Thread Zahid Khan
The following bug has been logged online: Bug reference: 4371 Logged by: Zahid Khan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Linux Description:Foreign Key constraints not working with ODBC Details: I am unable to get the foreign k

[BUGS] range value problem with double precision [PG 8.3.3]

2008-08-22 Thread Zahid Khan
Hi ,  I see one issue pg 8.3.3 . 1. According to the documentation of pg "The double precision type typically has a range of around 1E-307 to 1E+308 with a precision of at least 15 digits". ref:-  http://www.postgresql.org/docs/8.3/static/datatype-numeric.html but in PG8.3 the values less then

Re: [BUGS] range value problem with double precision [PG 8.3.3]

2008-08-22 Thread Peter Eisentraut
Zahid Khan wrote: > Hi , > >  I see one issue pg 8.3.3 . > > 1. > According to the documentation of pg "The double precision type > typically has a range of around 1E-307 to 1E+308 with a precision of at > least 15 digits". > > ref:- >  http://www.postgresql.org/docs/8.3/static/datatype-numeric.htm

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

2008-08-22 Thread Kees Westerlaken
The following bug has been logged online: Bug reference: 4372 Logged by: Kees Westerlaken Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Windows Description:TO_DATE with ISO week and day Details: The TO_DATE conversion with ISO week (IW

[BUGS] Installation Problems

2008-08-22 Thread Bernard Stewe
Hi We are trying to install postgres 8.3.0 on solaris 9. The installation process comes up with the following error. Please mail [EMAIL PROTECTED] as I will be out of the office for a month bash-2.05$ ldd initdb libxslt.so.1 => /lib/libxslt.so.1 libxml2.so.2 => /lib/libx

Re: [BUGS] range value problem with double precision [PG 8.3.3]

2008-08-22 Thread Zahid Khan
hmmm,What I see is, I was getting error  of underflow valuein PG8.2  when i tried to insert '1E-307' in table with double precision.And my application was expecting the same error condition with the same values  against PG 8.3.3 as well.but now thats not the case? Thanks, Zahid K. --- On Fri,

Re: [BUGS] BUG #4371: Foreign Key constraints not working with ODBC

2008-08-22 Thread Hiroshi Saito
Hi. Ahh ...Probably, It will solve by the next release. http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/docs/release.html.diff?r1=1.37&r2=1.38 4.) Change the implemetatin of SQLForeignKeys() for 8.3+ servers. It is still under adjustment with a check now. and a little patch are due

Re: [BUGS] range value problem with double precision [PG 8.3.3]

2008-08-22 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > The following, however, appears to be a bug: > peter=# select '1E-324'::float8; > ERROR: 22P02: invalid input syntax for type double precision: "1E-324" > LOCATION: float8in, float.c:431 I see this behavior on Fedora 9, but not on HPUX. Investigat

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

2008-08-22 Thread Bruce Momjian
Kees Westerlaken wrote: > > The following bug has been logged online: > > Bug reference: 4372 > Logged by: Kees Westerlaken > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3.3 > Operating system: Windows > Description:TO_DATE with ISO week and day > Details

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
thomas wrote: > > The following bug has been logged online: > > Bug reference: 4281 > Logged by: thomas > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3.3 > Operating system: Windows 2003 > Description:some types of errors do not log statements > Details:

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

2008-08-22 Thread Eric P. Melbardis
Hi I downloaded the latest version from the specified url. Put dll in the postgres "C:\Program Files\PostgreSQL\8.3\lib" directory, and restarted postgres service Sorry, still does not work! nkworks3=# SELECT test_uuid(10); INFO: uuid = a1942895-bdb4-484a-a3fd-6b90e7652d8c INFO: uuid = f2b4a

Re: [BUGS] BUG #4370: connectby method

2008-08-22 Thread Euler Taveira de Oliveira
Derek & Bob escreveu: > I've got a question about table connectby method. Say, we have five elements > which are 1,2,3,4,5. Each of them are the roots in the tree.Instead of using > five connectby methods to generate them all in the table, I assume there is > a element 0, which is the parent of the

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

2008-08-22 Thread Alvaro Herrera
Hi, It says here http://www.postgresql.org/docs/faqs.FAQ.html that the developer's FAQ is at http://www.postgresql.org/docs/faqs.FAQ_DEV.html which is very outdated. The new location is http://wiki.postgresql.org/wiki/Developer_FAQ -- Alvaro Herrerahttp://www.Com

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

2008-08-22 Thread Bruce Momjian
Alvaro Herrera wrote: > Hi, > > It says here http://www.postgresql.org/docs/faqs.FAQ.html that the > developer's FAQ is at http://www.postgresql.org/docs/faqs.FAQ_DEV.html > which is very outdated. The new location is > http://wiki.postgresql.org/wiki/Developer_FAQ Fixed, but I think we need to

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

2008-08-22 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > thomas wrote: >> 2008-07-05 02:16:15 CEST 6644 486ebab4.19f4 127.0.0.1(1616)ERROR: invalid >> byte sequence for encoding "UTF8": 0xc474 > I am unclear what would cause this. An encoding violation in an incoming SQL command would cause it, because we wo

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

2008-08-22 Thread Bruce Momjian
Is there any TODO here? --- Tom Lane wrote: > "Enrico Sirola" <[EMAIL PROTECTED]> writes: > > -- bad > > select xpath('name(/my:a/*[last()])', test, ARRAY[ARRAY['my', > > 'http://myns.com/ns']]) from test; > > You could bar

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@postgresql.org) To make c

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 about so I added this report to that list. -- Bru