Re: [BUGS] BUG #2996: to_char( timestamp, 'DD-Mon-YYYY HH24:MI:SS.MS' ) reports .1000 ms

2007-02-13 Thread Tom Lane
"Anthony Taylor" <[EMAIL PROTECTED]> writes: > When using the "to_char" function to output timestamps, some timestamps > report .1000 milliseconds. Confirmed here: using your test case, successive timestamps look like 14-Feb-2007 02:44:04.998 14-Feb-2007 02:44:04.998 14-Feb-2007 02:44:04.998

Re: [BUGS] BUG #3002: PQexecParams only supports some commands; needs improved error reporting, documenting or fixing

2007-02-13 Thread Tom Lane
"Phil Endecott" <[EMAIL PROTECTED]> writes: > I understand that PQexecParams may only be used for SELECT, INSERT, DELETE > and UPDATE commands, but not for other commands where parameter substitution > might be useful such as CREATE VIEW and CREATE TABLE AS SELECT. When I used > PQexecParams with

Re: [BUGS] BUG #3000: Linking problem

2007-02-13 Thread Tom Lane
"laurent faillie" <[EMAIL PROTECTED]> writes: > Even if the compilation succeed, psql binary will core dump on HP-UX 11.11 > if compiled with readline support. > To prevent this problem, termcap library has to be linked with this binary. That should happen automatically, and does on my HPUX machin

Re: [BUGS] BUG #2995: PSQLRestore crash and MemoryLeaks!

2007-02-13 Thread Pavel Golub
Hello, Bruno. This is not an PostgreSQL team product, But MicroOLAP! Use MicroOLAP support system to solve this! You wrote: B> The following bug has been logged online: B> Bug reference: 2995 B> Logged by: Bruno B> Email address: [EMAIL PROTECTED] B> PostgreSQL version: 8.2.

[BUGS] BUG #3002: PQexecParams only supports some commands; needs improved error reporting, documenting or fixing

2007-02-13 Thread Phil Endecott
The following bug has been logged online: Bug reference: 3002 Logged by: Phil Endecott Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: All? Description:PQexecParams only supports some commands; needs improved error reporting, documenting o

[BUGS] BUG #3000: Linking problem

2007-02-13 Thread laurent faillie
The following bug has been logged online: Bug reference: 3000 Logged by: laurent faillie Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: HP-UX 11.11 Description:Linking problem Details: Hello, Even if the compilation succeed, psql binar

[BUGS] BUG #2995: PSQLRestore crash and MemoryLeaks!

2007-02-13 Thread Bruno
The following bug has been logged online: Bug reference: 2995 Logged by: Bruno Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows XP SP2 Description:PSQLRestore crash and MemoryLeaks! Details: Hello, We see many memory leaks using

[BUGS] BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)

2007-02-13 Thread Floyd Shackelford
The following bug has been logged online: Bug reference: 2997 Logged by: Floyd Shackelford Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: windows xp Description:parse error: setObject("2004-August-15",java.sql.Types.DATE) Details: jdbc:

[BUGS] BUG #3005: please help

2007-02-13 Thread roland diaz
The following bug has been logged online: Bug reference: 3005 Logged by: roland diaz Email address: [EMAIL PROTECTED] PostgreSQL version: 6 Operating system: linux Description:please help Details: hello why i cant crate a table in postgress

[BUGS] BUG #2998: Installation Failed due to Permissions

2007-02-13 Thread Michael
The following bug has been logged online: Bug reference: 2998 Logged by: Michael Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows XP SP2 Description:Installation Failed due to Permissions Details: I tried installing but I get Fa

Re: [BUGS] BUG #2993: The program "postgres" is needed by initdb but was not found ...

2007-02-13 Thread Filippo Toso
Dear Magnus, > Can you check the permissions on your pgsql directory? If your account > only has permissions through the admin or power users group, you will > need to grant it explicit permissions (since it gives up admin and power > users when it starts) > > //Magnus The pgsql directory privile

[BUGS] BUG #2996: to_char( timestamp, 'DD-Mon-YYYY HH24:MI:SS.MS' ) reports .1000 ms

2007-02-13 Thread Anthony Taylor
The following bug has been logged online: Bug reference: 2996 Logged by: Anthony Taylor Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: Linux kernel 2.6.11 (based on Gentoo) Description:to_char( timestamp, 'DD-Mon- HH24:MI:SS.MS' ) rep