GitHub user 1984shekhar opened a pull request:
https://github.com/apache/activemq/pull/260
AMQ-6826
This fix adds the table-prefix to the activemq_acks_pkey. This is because
for postgresql if we use table-prefix statement than Indexes are also created
using table-prefix. This table-prefix is empty-string if table-prefix is not
used so shouldn't affect normal scenario when table-prefix is not used.
{code}
Output from postegre db.
activemq=# \d local_activemq_acks
Table "public.local_activemq_acks"
Column | Type | Modifiers
---------------+------------------------+--------------------
container | character varying(250) | not null
sub_dest | character varying(250) |
client_id | character varying(250) | not null
sub_name | character varying(250) | not null
selector | character varying(250) |
last_acked_id | bigint |
priority | bigint | not null default 5
xid | character varying(250) |
Indexes:
"local_activemq_acks_pkey" PRIMARY KEY, btree (container, client_id,
sub_name)
"local_activemq_acks_xidx" btree (xid)
{code}
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/1984shekhar/activemq master
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/activemq/pull/260.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #260
----
commit aa72fface4bac3cb799c57eba74e2f6c5aae0fb1
Author: cpandey <[email protected]>
Date: 2017-10-03T12:41:27Z
AMQ-6826:
PostgresqlJDBCAdapter with table prefix errors when executing
createSchemaStatements for creating Indexes.
commit 783062dab79c89cfdd042e0313742510174a6e6b
Author: cpandey <[email protected]>
Date: 2017-10-03T12:43:27Z
AMQ-6826 :
PostgresqlJDBCAdapter with table prefix errors when executing
createSchemaStatements for creating Indexes.
----
---
