From: | Paul Dasari <pdasari(at)mdsol(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #11528: Max Index Keys |
Date: | 2014-09-30 19:16:10 |
Message-ID: | CAFgphJpHyz5KHayQj8g3JS+7Aa5kjhWeiZTgYFE-YVV+Gq-L1A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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(at)hogranch(dot)com> wrote:
> On 9/30/2014 11:44 AM, pdasari(at)mdsol(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2014-09-30 19:20:02 | Re: BUG #11528: Max Index Keys |
Previous Message | John R Pierce | 2014-09-30 19:10:54 | Re: BUG #11528: Max Index Keys |