Would yer man in the new York pub ban this version? (probably older than Danny Boy), same tune, also a wee bit sentimental, but IMHO, a preferable set of words. (Is this the one you meant, Skarpi?)The tune itself may be up to 4 centuries old: Sibelius attribute it to Rory Dall O'Cahan (1560-1660)

LONDONDERRY AIR (IN DERRY VALE)
W.G.Rothery

In Derry Vale, beside the singing river,
So oft I strayed, ah, many years ago,
And culled at morn the golden daffodillies
That came with Spring to set the world aglow.

Oh, Derry Vale, my thoughts are ever turning
To your broad stream and fairy-circled lea,
For your green isles my exiled heart is turning,
So far awa-a-ay acro-oss the-e sea.

In Derry Vale, amid the Foyle's dark waters,
The salmon leap above the surging weir,
The seabirds call – I still can hear them calling
In night's long dreams of tho-o-ose so dear.

Oh, tarrying years, fly faster, ever faster,
I long to see the vale belov'd so well,
I long to know that I am not forgotten,
And there at ho-o-ome in pe-eace to-o dwell.



And Giok is right about the "Wild Rover" and the Middle Bar at Sidmouth; £5 fine for singing it. Last time I remember someone getting caught it was a somewhat nervous Antipodean singer, who was cajoled into singing, and said he would do the only song he could remember. Another singer got away unfined after singing the chorus in German.(Nein, nicht, nieber)
I'm tempted to try out the trad version of Wild Rover (minor key and none of that no, nay, never, no, nay, never no more nonsense)to see if they'd notice, or impose the fine.