[GENERAL] Fw: slony- No index found

2011-03-21 Thread basobdutta kar


--- On Mon, 3/21/11, basobdutta kar  wrote:

From: basobdutta kar 
Subject: Fw: slony- No index found
To: pgsql-general@postgresql.org
Date: Monday, March 21, 2011, 3:02 PM



--- On Mon, 3/21/11, basobdutta kar  wrote:

From: basobdutta kar 
Subject: slony- No index found
To: pgsqlgene...@postgresql.org
Date: Monday, March 21, 2011, 3:01 PM

Sir/Madam,

 I have two databases- db1  and db2
db1 is the master  and db2 is slave.

In db1,  create table t1(id integer  primary key);
In db2  , create table t1(id integer);

When i start replicating , why slony gives error cannot find index on id.
But in place of integer ,if i use int4 datatype,
 data is replicating properly.

How to solve the problem... Its urgent..




  








  


  

[GENERAL] Fw: slony- No index found

2011-03-21 Thread basobdutta kar


--- On Mon, 3/21/11, basobdutta kar  wrote:

From: basobdutta kar 
Subject: slony- No index found
To: pgsqlgene...@postgresql.org
Date: Monday, March 21, 2011, 3:01 PM

Sir/Madam,

 I have two databases- db1  and db2
db1 is the master  and db2 is slave.

In db1,  create table t1(id integer  primary key);
In db2  , create table t1(id integer);

When i start replicating , why slony gives error cannot find index on id.
But in place of integer ,if i use int4 datatype, data is replicating properly.

How to solve the problem... Its urgent..