[BUGS] Tab completion issue in 9.0 beta1

2010-05-18 Thread Devrim GÜNDÜZ
I just noticed this:

bodhi=# INSERT INTO release SAVEPOINT 

When there is a table called "release", even if I press V (for VALUES),
psql replaces it with SAVEPOINT.

Regards,
-- 
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part


Re: [BUGS] Tab completion issue in 9.0 beta1

2010-05-18 Thread Alvaro Herrera
Excerpts from Devrim GÜNDÜZ's message of mar may 18 05:17:00 -0400 2010:
> I just noticed this:
> 
> bodhi=# INSERT INTO release SAVEPOINT 
> 
> When there is a table called "release", even if I press V (for VALUES),
> psql replaces it with SAVEPOINT.

uh.  Yeah, you can also try "insert into commit" and it offers
completion with PREPARED, TRANSACTION and WORK.

I think those rules are lacking a check that they are anchored at the
start of the string.

This completion stuff is rather primitive.  I wonder if this could be
rewritten with a bison parser or something ... maybe even hook it on the
main parser, like the ecpg parser does.
-- 

-- 
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] Error in ODBC

2010-05-18 Thread Robert Haas
On Wed, May 12, 2010 at 10:52 AM, Osvaldor Ramirez
 wrote:
> I dont know if it count but
>
> I had installed in my pc the ODBC Drivers of Postgresql version 8.03.01 but I 
> saw an new version ( 8.03.02 ) but with this driver show my this error:
>
> Windows Vista 06.00 Build 06000, SQLXpp: 3.1.24, Runtime: 1.90.355
> SQLState: 07009,  ErrorCode:13
> Invalid column number in DescribeCol.
>
> I am using Postgresql 8.4 in my Windows Vista Ultimate
>
> Anyway, I did an uninstall and install the old version and All work fine.

You probably need to provide a few more details for someone to help
you, like what you were doing when you got the error.

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

You might also want to try the pgsql-odbc mailing list, rather than here.

http://archives.postgresql.org/pgsql-odbc/

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

-- 
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 #5463: incorrect password when downloading/installing

2010-05-18 Thread David Orr

The following bug has been logged online:

Bug reference:  5463
Logged by:  David Orr
Email address:  david_or...@hotmail.com
PostgreSQL version: 8.3.11 or 8.4.4
Operating system:   Windows 7 Starter
Description:incorrect password when downloading/installing
Details: 

I have previously downloaded v 8.3.11 for use with a program called "Poker
Tracker 3" which uses postgreSQL as a database for online poker hand
listings. The program wasn't working correctly so I uninstalled it and
postgreSQL. I removed the user profile accounts the program had created as
well as doing an uninstall through control panel/programs.
I then tried a similar program called "Holdem Manager" whichruns postgreSQL
v 8.4.4. Again, there were problems with the program so I uninstalled Holdem
Manager and postgreSQL as described earlier.

Now, when I try and install postgreSQL (either 8.3.11 or 8.4.4) it says I am
using the wrong password and the instalation fails. The only password I have
ever used for both 8.3.11 and 8.4.4 is "dbpass". But it's not working when I
instal the program. I have never changed the password to anything else and
I'm not sure what's happening and why I can't instal the program.

Thanks, Dave.

-- 
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 #5463: incorrect password when downloading/installing

2010-05-18 Thread Craig Ringer
On 19/05/10 09:40, David Orr wrote:

> Now, when I try and install postgreSQL (either 8.3.11 or 8.4.4) it says I am
> using the wrong password and the instalation fails. The only password I have
> ever used for both 8.3.11 and 8.4.4 is "dbpass". But it's not working when I
> instal the program. I have never changed the password to anything else and
> I'm not sure what's happening and why I can't instal the program.

This isn't really a bug (unless maybe it was in the installer) ... but
anyway, to get it to install you can probably just delete the `postgres'
user account. Do so through Control Panel -> Administrative Tools ->
Computer Management.

-- 
Craig Ringer

Tech-related writing: http://soapyfrogs.blogspot.com/

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs