Re: BUG #5268: PQgetvalue incorrectly returns 0

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5268: PQgetvalue incorrectly returns 0
Date: 2010-01-08 05:51:19
Message-ID: 4B46C7D7.1090603@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Meskes 2010-01-08 09:27:45 Re: BUG #5236: Aparent bug in ecpg (postgresql 8.4 )
Previous Message Mark Kirkwood 2010-01-08 04:47:26 Re: BUG #5268: PQgetvalue incorrectly returns 0 (corrected)