pkg upgrade not working properly [was: pkgng messed up]

[Nagy László Zsolt]

Running "pkg upgrade -y "  on  9.2-RELEASE gives lots of warning 
messages, but does not try to upgrade anything. If I understand 
correctly, warnings are just warnings. They should not prevent the 
upgrade. But then why it is not doing anything?

Details below.

root at backup:~ # pkg upgrade -y | & more
Updating repository catalogue
Upgrades have been requested for the following 298 packages:

         Installing xf86vidmodeproto: 2.3.1
         Installing dri2proto: 2.8
         Installing pciids: 20140502
         Installing perl5: 5.16.3_9
         Installing giflib-nox11: 4.2.3_2

         <... many more packages here ...>

         Upgrading inkscape: 0.48.2_2 -> 0.48.4_4
         Installing dvipdfmx: 20110311
         Upgrading teTeX: 3.0_6 -> 3.0_7

The upgrade will require 312 MB more space

0 B to be downloaded
Checking integrity...pkg: WARNING: locally installed perl-5.12.4_4 
conflicts on /usr/local/bin/a2p with:
         - perl5-5.16.3_9

<...many more warnings here ...>

pkg: WARNING: locally installed postgresql93-client-9.3.4 conflicts on 
/usr/local/share/postgresql/psqlrc.sample with:
         - postgresql90-client-9.0.17

root at backup:~ #