Hi John,
Thanks much for your response. Yes I am using the JDBC Jar file from
supplied from
http://jdbc.postgresql.org/download/postgresql-8.4-703.jdbc4.jar
Could you please help me provide a link so that i can post my question to
the required support group.
Thanks
Paul
On Tue, Sep 30, 2014 at 3:10 PM, John R Pierce <pierce@hogranch.com> wrote:
> On 9/30/2014 11:44 AM, pdasari@mdsol.com wrote:
>
>> We are using Amazon Redshift postgreSQL. no matter what jar file we use it
>> gives the following error message.
>>
>
> jar file? what is this jar file? Do you mean JDBC ? The
> PostgreSQL JDBC driver is its own project, has its own mailling lists.
> The bug report form you used is for the core database server, which has no
> Java components.
>
> Upon browsing, found that the source code is reading the max_index_keys
>> should be greater than 0. However the redshift database does not require
>> indexing. I really appreciate your assistance if there is any specific jar
>> to use to avoid using the max_index_keys function while executing the
>> query
>>
>> Below is the error we encountered:
>>
>> Unable to determine a value for MaxIndexKeys due to missing system catalog
>> data
>>
>
> While PostgreSQL doesn't require indexes, its standard practice in
> relational databases to always define a primary key for every table.
> I'm not sure why JDBC would be enforcing this.
>
>
>
> --
> john r pierce 37N 122W
> somewhere on the middle of the left coast
>
>