problems with housekeeping

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

problems with housekeeping

Postby berendey4 » Sat Jan 07, 2012 7:31 pm

Hello

I cant housekeeping my database..Many mistakes.
Reindex have not helped me.
Image
berendey4
 
Posts: 11
Joined: Sat Jun 04, 2011 3:45 pm

Re: problems with housekeeping

Postby kraada » Sun Jan 08, 2012 10:57 am

The end of that error is what is most important - could you paste that bit for me here?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: problems with housekeeping

Postby berendey4 » Sun Jan 08, 2012 5:01 pm

kraada wrote:The end of that error is what is most important - could you paste that bit for me here?


Image
berendey4
 
Posts: 11
Joined: Sat Jun 04, 2011 3:45 pm

Re: problems with housekeeping

Postby WhiteRider » Sun Jan 08, 2012 5:20 pm

You have at least one column which has a duplicate name except for case.
Here it is cnt_p_3bet_bb, and there is probably a _BB version too.
You will need to delete one of the duplicate columns - when we've seen this before the definitions of those columns have been the same so it shouldn't matter which you remove.

Tutorial: Custom Reports and Statistics
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: problems with housekeeping

Postby berendey4 » Sat Jan 14, 2012 7:04 pm

WhiteRider wrote:You have at least one column which has a duplicate name except for case.
Here it is cnt_p_3bet_bb, and there is probably a _BB version too.
You will need to delete one of the duplicate columns - when we've seen this before the definitions of those columns have been the same so it shouldn't matter which you remove.

Tutorial: Custom Reports and Statistics


Heh... try delete colums, but had any problems. now reinstal soft and play with enjoy!
berendey4
 
Posts: 11
Joined: Sat Jun 04, 2011 3:45 pm

Re: problems with housekeeping

Postby Guest » Thu Jan 26, 2012 9:39 pm

Hi,

thanks for advice. I had exactly the same problem and the solution works. In my case, there were more than just one duplicate column, so a litlle bit of hide and seek, but now all works. ;)
Guest
 


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 33 guests

cron
highfalutin