[BUGS] BUG #6329: ODBC ANSI driver psqlODBC v09.00.0310.1

2011-12-06 Thread eboisen
The following bug has been logged on the website: Bug reference: 6329 Logged by: Erik Boisen Email address: eboi...@hotmail.com PostgreSQL version: 9.0.3 Operating system: Windows XP Description: ODBC ANSI driver psqlODBC v09.00.0310.1 does not properly pass values wh

Re: [BUGS] copy cmd err

2011-12-06 Thread Tom Lane
Jivendra writes: > Server Ver : psql (PostgreSQL) 8.1.11 > OS Platform : Red Hat Enterprise Linux Server release 5.3 (Tikanga) > COPY (SELECT * from function_name (2, 0, '-mm-dd','-mm-dd')) TO > STDOUT That COPY syntax doesn't exist in PG 8.1 --- the option to have a parenthesized q

Re: [BUGS] BUG #6328: Wrong error message for insert-sql

2011-12-06 Thread Kevin Grittner
wrote: >INSERT INTO auftragpos (orderno,position,item) VALUES > (testorder18,1,00123); > brings error: > FEHLER: Spalte *testorder18* existiert nicht (Column > *testorder18* not exists) > LINE 1: ...T INTO auftragpos (orderno,position,item) VALUES > (testorder1... > > But *testorder18* is

[BUGS] copy cmd err

2011-12-06 Thread Jivendra
Helo After running below command am getting error had run this command before but now am not able to run it any suggestion ? Server Ver : psql (PostgreSQL) 8.1.11 OS Platform : Red Hat Enterprise Linux Server release 5.3 (Tikanga) COPY (SELECT * from function_name (2, 0, '-mm-dd','yyy

[BUGS] BUG #6328: Wrong error message for insert-sql

2011-12-06 Thread eikenberg
The following bug has been logged on the website: Bug reference: 6328 Logged by: Rigoletto Eikenberg Email address: eikenb...@golze.de PostgreSQL version: 9.0.0 Operating system: windows server 2008 R2 Description: The sql INSERT INTO auftragpos (orderno,position,i

Re: [BUGS] BUG #6327: Prefix full-text-search fails for hosts with complicated names

2011-12-06 Thread Oleg Bartunov
On Mon, 5 Dec 2011, Tom Lane wrote: marcin.kasper...@mekk.waw.pl writes: Synopsis = 'goog:*' matches google.com but 'e-goog:*' does not match e-google.com The reason for this seems to be that the pattern is treated as a hyphenated word: regression=# select TO_TSQUERY('english',

Re: [BUGS] BUG #6325: Useless Index updates

2011-12-06 Thread Daniel Migowski
Thank you all for your explanations. I will continue this on pgsql-general. Daniel Migowski Von: Craig Ringer [ring...@ringerc.id.au] Gesendet: Sonntag, 4. Dezember 2011 15:02 Bis: Daniel Migowski Cc: pgsql-bugs@postgresql.org Betreff: Re: [BUGS] BUG #6325