We have a curtain rail that was held up by two small brackets, screwed to the wall using Redidrive plasterboard fixings - the sorts of things in this image: .
Then my daughter decided to swing on the curtains.... So now we have a plasterboard wall (brick behind) with two holes, just bigger...