Re: [BUGS] BUG #1638: ODBC driver problem

2005-04-29 Thread Mike G.
I believe the ODBC package is managed by a different group. Bugs can be viewed and added here: http://gborg.postgresql.org/project/psqlodbc/bugs/buglist.php Mike On Fri, Apr 29, 2005 at 04:31:02PM +0100, Vig Sandor wrote: > > The following bug has been logged online: > > Bug reference: 1

Re: [BUGS] BUG #1635: Failed to create process for initdb

2005-04-28 Thread Mike G.
Did you remove the postgres user account before reinstalling? On Wed, Apr 27, 2005 at 06:49:59PM +0100, Tom wrote: > > The following bug has been logged online: > > Bug reference: 1635 > Logged by: Tom > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating sy

Re: [BUGS] BUG #1629: subquery IN returns incorrect results

2005-04-27 Thread Mike G.
[snip] You are correct about the comma missing between the B and C in the query. It is turning it into B'C. I can't think of a good way for postgres to try and generate a warning in case a typo like this is made. Thank you. Mike > > Unless this is a copy/paste error, you have missed a , in

Re: [BUGS] BUG #1629: subquery IN returns incorrect results

2005-04-27 Thread Mike G.
Sorry, I used the online bug reporting form and it doesn't have an option to attach a file to it. If it had I would have attached a pg_dump file. Mike On Wed, Apr 27, 2005 at 10:57:42AM -0400, Tom Lane wrote: > "mike g" <[EMAIL PROTECTED]> writes: > > Descripti

[BUGS] BUG #1629: subquery IN returns incorrect results

2005-04-27 Thread mike g
The following bug has been logged online: Bug reference: 1629 Logged by: mike g Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2000 Description:subquery IN returns incorrect results Details: If I run this query: SELECT distinct

[BUGS] Substring function incorrect when searching for '@.'

2004-10-12 Thread Mike G.
To reproduce: create a table with a data type of varchar (50) and name it email insert into this table the following values: [EMAIL PROTECTED] Execute the following statement: SELECT CASE WHEN count(substring(email FROM '@.')) > 0 THEN count(substring(email FROM '@.')) ELSE 0 END, email FROM y

[BUGS] beta - win32, restore from pg_dump not possible

2004-08-09 Thread Mike G
Hello, Testing out beta version of 8.0 on XP Pro. I am trying to use psql to restore a dump of my database (prod. version runs under cygwin). Whenever I execute psql the password prompt is displayed and skipped right over which results in the command failing. psql.exe mydb < c:\mybackup file