Re: BUG #5268: PQgetvalue incorrectly returns 0 (corrected) - Mailing list pgsql-bugs

From Mark Kirkwood
Subject Re: BUG #5268: PQgetvalue incorrectly returns 0 (corrected)
Date
Msg-id 4B46B8DE.9010403@catalyst.net.nz
Whole thread Raw
List pgsql-bugs
(I forgot to cc -bugs...)

Mike Landis wrote:
>
> Two things strike me as odd about that...
> 1) What's the logic behind the owner of a table not automatically
> getting a readonly privilege like SELECT?

Owner always has select on a table they have created.

> 2) I think it would be more logical to refuse to return a NULL result
> from PQexec() than to return a result with the proper number of tuples
> and columns, but inaccurate contents.

COUNT always returns a number (never null). Recall you are select from
the information schema table.

>
> It's also strange that Linux and Vista would produce different answers.

I suspect they do not. Its all in the permissions.

Cheers

Mark

pgsql-bugs by date:

Previous
From: Michael Felt
Date:
Subject: Re: email addresses
Next
From: Mark Kirkwood
Date:
Subject: Re: BUG #5268: PQgetvalue incorrectly returns 0