Mike Landis wrote:
> At 09:09 PM 1/7/2010, you wrote:
>
>>
>> I suspect they do not. Its all in the permissions.
>
> There's no user account control enabled on this Vista machine,
> therefore effectively wide open, hence different platform behavior or
> at least a difference between the behavior in pgAdmin and client program.
>
The lack of os level permissions is not relevant to this issue - I was
referring to database level users and their permissions on tables. It
does look like you are somehow running your c program as a different
(db) user from who you are using in Pgadmin. As Robert suggested, try
doing 'SELECT user' in both.
Also note that Pgadmin user PQexec and PQgetValue...
Cheers
Mark