FUDforum: FUDforum Installation Issues » Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9

Home » FUDforum » FUDforum Installation Issues » Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9

Show: Today's Messages :: Polls :: Message Navigator

Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 [message #169209 is a reply to message #169208]

Sat, 07 September 2013 08:39

naudefj

Messages: 3771
Registered: December 2004

Karma:

Senior Member
Administrator
Core Developer

Possible solution from http://postgres.cz/wiki/PostgreSQL_SQL_Tricks

DELETE FROM tableX WHERE NOT ctid = (SELECT ctid FROM tableX i WHERE colX=i.colX LIMIT 1);

Can you please test this query for us to confirm:

DELETE FROM fud28_thread_notify WHERE NOT ctid = (SELECT ctid FROM fud28_thread_notify i WHERE i.user_id = fud28_thread_notify.user_id AND i.thread_id = fud28_thread_notify.thread_id LIMIT 1)

Report message to a moderator

[Message index]

		Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: now_what on Mon, 15 July 2013 11:50
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Fri, 19 July 2013 14:49
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Fri, 19 July 2013 15:13
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: now_what on Mon, 12 August 2013 16:24
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Sat, 17 August 2013 18:20
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: now_what on Mon, 19 August 2013 07:33
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: cpreston on Sat, 24 August 2013 17:42
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Sat, 07 September 2013 08:00
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Sat, 07 September 2013 08:39

Previous Topic:	Register + Activate Account
Next Topic:	Error upgrade from 3.0.0 to 3.0.5

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 14:51:55 GMT 2024

Total time taken to generate the page: 0.03932 seconds