[BUGS] BUG #1612: Problem with PGAPI_SetPos

2005-04-21 Thread Marc Soleda

The following bug has been logged online:

Bug reference:  1612
Logged by:  Marc Soleda
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system:   Win XP SP2
Description:Problem with PGAPI_SetPos
Details: 

Environment: 
WinXP SP2/Visual C++ 6/MFC
PostgreSQL 8.0.1 db
ODBC 8.00.01.01

I'm accessing the Postgres from a VC++ application using the ODBC driver
mentioned.
All works fine (open the db, SELECT, ...) until I try to insert a row using
the CRecordset::Update() class method. This method is intended to insert to
the db all the records previously added in the recordset object.
Postgres returns the exception:
"Only SQL_POSITION/REFRESH is supported for PGAPI_SetPos"

Anybody has encountered with the same problem?

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[BUGS] BUG #1631: pg_autovacuum fails when creating as a windows service

2005-04-27 Thread Marc Soleda

The following bug has been logged online:

Bug reference:  1631
Logged by:  Marc Soleda
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system:   WinXP SP2
Description:pg_autovacuum fails when creating as a windows service
Details: 

I'm installing pg_autovacuum as a windows service. The windows user account
used is a local one and it has admin privileges:

pg_autovacuum -I -N winuser -W pwdwinuser -U pguser -P pwdpguser

and I get:

ERROR: The account name is invalid or does not exist, or the password is
invalid for the account name specified.

I've tried with different admin users but the answer is always the same. 

Any ideas?

If I execute pg_autovacuum as standalone, all works fine.

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq