Обсуждение: Unable to d/l pgAdmin3
Hi FOlks This is for Debian etch. I followed these instructions: <----><8----> * From: Raphaël Enrici <blacknoz ( at ) club-internet ( dot ) fr> * To: Vince Ieraci <vince ( at ) rocktown( dot ) com ( dot ) au> * Subject: Re: Debian etch download doesn't work * Date: Sun, 28 Oct 2007 14:21:16 +0100 Vince Ieraci wrote: > Oh, forgot to mention the sources.list line: > > deb > http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/dists/ > etch pgadmin Hi Vince, you should remove the "dists" from the URL. This should give the following line in your sources.list: <on one line :> deb http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/ etch pgadmin </on one line> <----><8----> but for this: sudo aptitude install pgadmin3 I get (for Australia): Selecting previously deselected package pgagent. (Reading database ... 78137 files and directories currently installed.) Unpacking pgagent (from .../pgagent_1.8.0-1~pgaoetch1_i386.deb) ... Setting up pgagent (1.8.0-1~pgaoetch1) ... E: Failed to fetch http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1~pgaoetch1_all.deb: Sizemismatch and (for Argentina): Get:1 http://ftp2.au.postgresql.org etch/pgadmin pgadmin3-data 1.8.0-1~pgaoetch1 [1070kB] Fetched 1B in 0s (2B/s) E: Failed to fetch http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1~pgaoetch1_all.deb: Sizemismatch and for this (for Germany): aptitude update I get: Get:5 ftp://ftp.de.postgresql.org etch/pgadmin Packages [1745B] Fetched 4353B in 22s (197B/s) Reading package lists... Done W: GPG error: ftp://ftp.de.postgresql.org etch Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY AE9545D6FC0564BE W: You may want to run apt-get update to correct these problems Very frustrating... Any ideas? -- Ron Savage ron@savage.net.au http://savage.net.au/index.html
Hi Ron, can you try to follow these steps please: a) wget -q -O - http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg | sudo apt-key add - (if you don't have sudo, run the following as root: wget -q -O - http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg | apt-key add - ) b) retry your installation with the german mirror, it should be ok. The first two errors need investigation (size mismatch). Regards, Raphaël Ron Savage a écrit : > Hi FOlks > > This is for Debian etch. > > I followed these instructions: > > <----><8----> > * From: Raphaël Enrici <blacknoz ( at ) club-internet ( dot ) fr> > * To: Vince Ieraci <vince ( at ) rocktown ( dot ) com ( dot ) au> > * Subject: Re: Debian etch download doesn't work > * Date: Sun, 28 Oct 2007 14:21:16 +0100 > > Vince Ieraci wrote: > >> Oh, forgot to mention the sources.list line: >> >> deb >> >> > http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/dists/ > >> etch pgadmin >> > > Hi Vince, > > you should remove the "dists" from the URL. This should give the > following line in your sources.list: > <on one line :> > deb > http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/ > etch pgadmin > </on one line> > <----><8----> > > but for this: > > sudo aptitude install pgadmin3 > > I get (for Australia): > > Selecting previously deselected package pgagent. > (Reading database ... 78137 files and directories currently installed.) > Unpacking pgagent (from .../pgagent_1.8.0-1~pgaoetch1_i386.deb) ... > Setting up pgagent (1.8.0-1~pgaoetch1) ... > E: Failed to fetch > http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1~pgaoetch1_all.deb: Sizemismatch > > and (for Argentina): > > Get:1 http://ftp2.au.postgresql.org etch/pgadmin pgadmin3-data > 1.8.0-1~pgaoetch1 [1070kB] > Fetched 1B in 0s (2B/s) > E: Failed to fetch > http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1~pgaoetch1_all.deb: Sizemismatch > > and for this (for Germany): > > aptitude update > > I get: > > Get:5 ftp://ftp.de.postgresql.org etch/pgadmin Packages [1745B] > Fetched 4353B in 22s (197B/s) > Reading package lists... Done > W: GPG error: ftp://ftp.de.postgresql.org etch Release: The following > signatures couldn't be verified because the public key is not available: > NO_PUBKEY AE9545D6FC0564BE > W: You may want to run apt-get update to correct these problems > > Very frustrating... > > Any ideas? > >
On Mon, 2007-12-03 at 09:34 +0100, Raphaël Enrici wrote: Hi Raphael Many thanx for your reply, but it still fails. In /etc/apt/sources.list I tried these, one at a time: deb ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org//pgadmin3/release/debian etch pgadmin deb ftp://ftp.de.postgresql.org/mirror/postgresql/pgadmin3/release/debian etch pgadmin ron@zoe:~/Ron$ wget -q -O - http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg | sudo apt-key add - Password: OK ron@zoe:~/Ron$ ron@zoe:~/Ron$ sudo apt-get update Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 20070407-11:55] etch Release.gpg Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 20070407-11:55] etch Release Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 20070407-11:55] etch/contrib Packages/DiffIndex Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 20070407-11:55] etch/main Packages/DiffIndex Get:1 http://ftp.au.debian.org etch Release.gpg [378B] Hit http://ftp.au.debian.org etch Release Ign http://ftp.au.debian.org etch/main Packages/DiffIndex Ign http://ftp.au.debian.org etch/main Sources/DiffIndex Hit http://ftp.au.debian.org etch/main Packages Hit http://ftp.au.debian.org etch/main Sources Get:2 ftp://ftp3.de.postgresql.org etch Release.gpg [189B] Get:3 ftp://ftp3.de.postgresql.org etch Release [2417B] Get:4 ftp://ftp3.de.postgresql.org etch/pgadmin Packages [1745B] Get:5 http://security.debian.org etch/updates Release.gpg [189B] Hit http://security.debian.org etch/updates Release Ign http://security.debian.org etch/updates/main Packages/DiffIndex Ign http://security.debian.org etch/updates/contrib Packages/DiffIndex Ign http://security.debian.org etch/updates/main Sources/DiffIndex Ign http://security.debian.org etch/updates/contrib Sources/DiffIndex Hit http://security.debian.org etch/updates/main Packages Hit http://security.debian.org etch/updates/contrib Packages Hit http://security.debian.org etch/updates/main Sources Hit http://security.debian.org etch/updates/contrib Sources Fetched 4353B in 23s (184B/s) Reading package lists... Done ron@zoe:~/Ron$ sudo apt-get install pgadmin3 Reading package lists... Done Building dependency tree... Done The following extra packages will be installed: pgadmin3-data The following packages will be upgraded: pgadmin3 pgadmin3-data 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 1070kB/5967kB of archives. After unpacking 414kB disk space will be freed. Do you want to continue [Y/n]? Get:1 ftp://ftp3.de.postgresql.org etch/pgadmin pgadmin3-data 1.8.0-1~pgaoetch1 [1070kB] Fetched 1070kB in 8s (124kB/s) Failed to fetch ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org//pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1~pgaoetch1_all.deb Size mismatch E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing? ron@zoe:~/Ron$ sudo apt-get update Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 20070407-11:55] etch Release.gpg Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 20070407-11:55] etch Release Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 20070407-11:55] etch/contrib Packages/DiffIndex Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 20070407-11:55] etch/main Packages/DiffIndex Get:1 http://ftp.au.debian.org etch Release.gpg [378B] Hit http://ftp.au.debian.org etch Release Ign http://ftp.au.debian.org etch/main Packages/DiffIndex Ign http://ftp.au.debian.org etch/main Sources/DiffIndex Hit http://ftp.au.debian.org etch/main Packages Hit http://ftp.au.debian.org etch/main Sources Get:2 ftp://ftp.de.postgresql.org etch Release.gpg [189B] Get:3 ftp://ftp.de.postgresql.org etch Release [2417B] Get:4 ftp://ftp.de.postgresql.org etch/pgadmin Packages [1745B] Get:5 http://security.debian.org etch/updates Release.gpg [189B] Hit http://security.debian.org etch/updates Release Ign http://security.debian.org etch/updates/main Packages/DiffIndex Ign http://security.debian.org etch/updates/contrib Packages/DiffIndex Ign http://security.debian.org etch/updates/main Sources/DiffIndex Ign http://security.debian.org etch/updates/contrib Sources/DiffIndex Hit http://security.debian.org etch/updates/main Packages Hit http://security.debian.org etch/updates/contrib Packages Hit http://security.debian.org etch/updates/main Sources Hit http://security.debian.org etch/updates/contrib Sources Fetched 4353B in 23s (186B/s) Reading package lists... Done ron@zoe:~/Ron$ sudo apt-get install pgadmin3 Reading package lists... Done Building dependency tree... Done The following extra packages will be installed: pgadmin3-data The following packages will be upgraded: pgadmin3 pgadmin3-data 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 1070kB/5967kB of archives. After unpacking 414kB disk space will be freed. Do you want to continue [Y/n]? Failed to fetch ftp://ftp.de.postgresql.org/mirror/postgresql/pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1~pgaoetch1_all.deb Size mismatch E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing? ron@zoe:~/Ron$ > > can you try to follow these steps please: > > a) > wget -q -O - http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg | > sudo apt-key add - > > (if you don't have sudo, run the following as root: > wget -q -O - http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg | > apt-key add - ) > > b) > retry your installation with the german mirror, it should be ok. > > The first two errors need investigation (size mismatch). > > Regards, > Raphaël > > > Ron Savage a écrit : > > Hi FOlks > > > > This is for Debian etch. > > > > I followed these instructions: > > > > <----><8----> > > * From: Raphaël Enrici <blacknoz ( at ) club-internet ( dot ) fr> > > * To: Vince Ieraci <vince ( at ) rocktown ( dot ) com ( dot ) au> > > * Subject: Re: Debian etch download doesn't work > > * Date: Sun, 28 Oct 2007 14:21:16 +0100 > > > > Vince Ieraci wrote: > > > >> Oh, forgot to mention the sources.list line: > >> > >> deb > >> > >> > > http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/dists/ > > > >> etch pgadmin > >> > > > > Hi Vince, > > > > you should remove the "dists" from the URL. This should give the > > following line in your sources.list: > > <on one line :> > > deb > > http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/ > > etch pgadmin > > </on one line> > > <----><8----> > > > > but for this: > > > > sudo aptitude install pgadmin3 > > > > I get (for Australia): > > > > Selecting previously deselected package pgagent. > > (Reading database ... 78137 files and directories currently installed.) > > Unpacking pgagent (from .../pgagent_1.8.0-1~pgaoetch1_i386.deb) ... > > Setting up pgagent (1.8.0-1~pgaoetch1) ... > > E: Failed to fetch > > http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1~pgaoetch1_all.deb: Sizemismatch > > > > and (for Argentina): > > > > Get:1 http://ftp2.au.postgresql.org etch/pgadmin pgadmin3-data > > 1.8.0-1~pgaoetch1 [1070kB] > > Fetched 1B in 0s (2B/s) > > E: Failed to fetch > > http://ftp2.au.postgresql.org/pub/postgresql/pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1~pgaoetch1_all.deb: Sizemismatch > > > > and for this (for Germany): > > > > aptitude update > > > > I get: > > > > Get:5 ftp://ftp.de.postgresql.org etch/pgadmin Packages [1745B] > > Fetched 4353B in 22s (197B/s) > > Reading package lists... Done > > W: GPG error: ftp://ftp.de.postgresql.org etch Release: The following > > signatures couldn't be verified because the public key is not available: > > NO_PUBKEY AE9545D6FC0564BE > > W: You may want to run apt-get update to correct these problems > > > > Very frustrating... > > > > Any ideas? > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate > -- Ron Savage ron@savage.net.au http://savage.net.au/index.html
Hi Ron, the repository is definitely broken... My best bet is that I broke it when I uploaded the amd64 packages as only the arch=all seems to be affected. I must recheck this tonight. If that's what happened I'll fix it rapidly if something else happened, I'll disable the repository for a while. I come back to you rapidly. Regards, Raph Ron Savage a écrit : > On Mon, 2007-12-03 at 09:34 +0100, Raphaël Enrici wrote: > > Hi Raphael > > Many thanx for your reply, but it still fails. > > In /etc/apt/sources.list I tried these, one at a time: > deb > ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org//pgadmin3/release/debian etch pgadmin > > deb > ftp://ftp.de.postgresql.org/mirror/postgresql/pgadmin3/release/debian > etch pgadmin > > ron@zoe:~/Ron$ wget -q -O - > http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg | sudo apt-key > add - > Password: > OK > ron@zoe:~/Ron$ > ron@zoe:~/Ron$ sudo apt-get update > Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 > 20070407-11:55] etch Release.gpg > Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 > 20070407-11:55] etch Release > Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 > 20070407-11:55] etch/contrib Packages/DiffIndex > Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 > 20070407-11:55] etch/main Packages/DiffIndex > Get:1 http://ftp.au.debian.org etch Release.gpg [378B] > Hit http://ftp.au.debian.org etch Release > Ign http://ftp.au.debian.org etch/main Packages/DiffIndex > Ign http://ftp.au.debian.org etch/main Sources/DiffIndex > Hit http://ftp.au.debian.org etch/main Packages > Hit http://ftp.au.debian.org etch/main Sources > Get:2 ftp://ftp3.de.postgresql.org etch Release.gpg [189B] > Get:3 ftp://ftp3.de.postgresql.org etch Release [2417B] > Get:4 ftp://ftp3.de.postgresql.org etch/pgadmin Packages [1745B] > Get:5 http://security.debian.org etch/updates Release.gpg [189B] > Hit http://security.debian.org etch/updates Release > Ign http://security.debian.org etch/updates/main Packages/DiffIndex > Ign http://security.debian.org etch/updates/contrib Packages/DiffIndex > Ign http://security.debian.org etch/updates/main Sources/DiffIndex > Ign http://security.debian.org etch/updates/contrib Sources/DiffIndex > Hit http://security.debian.org etch/updates/main Packages > Hit http://security.debian.org etch/updates/contrib Packages > Hit http://security.debian.org etch/updates/main Sources > Hit http://security.debian.org etch/updates/contrib Sources > Fetched 4353B in 23s (184B/s) > Reading package lists... Done > ron@zoe:~/Ron$ sudo apt-get install pgadmin3 > Reading package lists... Done > Building dependency tree... Done > The following extra packages will be installed: > pgadmin3-data > The following packages will be upgraded: > pgadmin3 pgadmin3-data > 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. > Need to get 1070kB/5967kB of archives. > After unpacking 414kB disk space will be freed. > Do you want to continue [Y/n]? > Get:1 ftp://ftp3.de.postgresql.org etch/pgadmin pgadmin3-data > 1.8.0-1~pgaoetch1 [1070kB] > Fetched 1070kB in 8s (124kB/s) > Failed to fetch > ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org//pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1~pgaoetch1_all.deb Size mismatch > E: Unable to fetch some archives, maybe run apt-get update or try with > --fix-missing? > > ron@zoe:~/Ron$ sudo apt-get update > Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 > 20070407-11:55] etch Release.gpg > Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 > 20070407-11:55] etch Release > Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 > 20070407-11:55] etch/contrib Packages/DiffIndex > Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD Binary-1 > 20070407-11:55] etch/main Packages/DiffIndex > Get:1 http://ftp.au.debian.org etch Release.gpg [378B] > Hit http://ftp.au.debian.org etch Release > Ign http://ftp.au.debian.org etch/main Packages/DiffIndex > Ign http://ftp.au.debian.org etch/main Sources/DiffIndex > Hit http://ftp.au.debian.org etch/main Packages > Hit http://ftp.au.debian.org etch/main Sources > Get:2 ftp://ftp.de.postgresql.org etch Release.gpg [189B] > Get:3 ftp://ftp.de.postgresql.org etch Release [2417B] > Get:4 ftp://ftp.de.postgresql.org etch/pgadmin Packages [1745B] > Get:5 http://security.debian.org etch/updates Release.gpg [189B] > Hit http://security.debian.org etch/updates Release > Ign http://security.debian.org etch/updates/main Packages/DiffIndex > Ign http://security.debian.org etch/updates/contrib Packages/DiffIndex > Ign http://security.debian.org etch/updates/main Sources/DiffIndex > Ign http://security.debian.org etch/updates/contrib Sources/DiffIndex > Hit http://security.debian.org etch/updates/main Packages > Hit http://security.debian.org etch/updates/contrib Packages > Hit http://security.debian.org etch/updates/main Sources > Hit http://security.debian.org etch/updates/contrib Sources > Fetched 4353B in 23s (186B/s) > Reading package lists... Done > ron@zoe:~/Ron$ sudo apt-get install pgadmin3 > Reading package lists... Done > Building dependency tree... Done > The following extra packages will be installed: > pgadmin3-data > The following packages will be upgraded: > pgadmin3 pgadmin3-data > 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. > Need to get 1070kB/5967kB of archives. > After unpacking 414kB disk space will be freed. > Do you want to continue [Y/n]? > Failed to fetch > ftp://ftp.de.postgresql.org/mirror/postgresql/pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1~pgaoetch1_all.deb Size mismatch > E: Unable to fetch some archives, maybe run apt-get update or try with > --fix-missing? > ron@zoe:~/Ron$ > > >> can you try to follow these steps please: >> >> a) >> wget -q -O - http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg | >> sudo apt-key add - >> >> (if you don't have sudo, run the following as root: >> wget -q -O - http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg | >> apt-key add - ) >> >> b) >> retry your installation with the german mirror, it should be ok. >> >> The first two errors need investigation (size mismatch). >> >> Regards, >> Raphaël >> >>
Hi Ron, sorry for the delay... So, that was my fault. The -data present in the -all section was the one from AMD64 upload but the description files were not up to date. I've reuploaded the right files. It should be ok after the sync updates the mirrors. So, please retry in some hours or days it _should_ be ok if I did not miss something else ;) Thanks for the feedback, Raph Le 4 déc. 07 à 10:09, Raphaël Enrici a écrit : > Hi Ron, > > the repository is definitely broken... My best bet is that I broke > it when I uploaded the amd64 packages as only the arch=all seems to > be affected. I must recheck this tonight. If that's what happened > I'll fix it rapidly if something else happened, I'll disable the > repository for a while. > > I come back to you rapidly. > Regards, > Raph > > Ron Savage a écrit : >> On Mon, 2007-12-03 at 09:34 +0100, Raphaël Enrici wrote: >> >> Hi Raphael >> >> Many thanx for your reply, but it still fails. >> >> In /etc/apt/sources.list I tried these, one at a time: >> deb >> ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org//pgadmin3/release/debian >> etch pgadmin >> >> deb >> ftp://ftp.de.postgresql.org/mirror/postgresql/pgadmin3/release/debian >> etch pgadmin >> >> ron@zoe:~/Ron$ wget -q -O - >> http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg | sudo apt- >> key >> add - >> Password: >> OK >> ron@zoe:~/Ron$ ron@zoe:~/Ron$ sudo apt-get update >> Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD >> Binary-1 >> 20070407-11:55] etch Release.gpg >> Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD >> Binary-1 >> 20070407-11:55] etch Release >> Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD >> Binary-1 >> 20070407-11:55] etch/contrib Packages/DiffIndex >> Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD >> Binary-1 >> 20070407-11:55] etch/main Packages/DiffIndex >> Get:1 http://ftp.au.debian.org etch Release.gpg [378B] >> Hit http://ftp.au.debian.org etch Release >> Ign http://ftp.au.debian.org etch/main Packages/DiffIndex >> Ign http://ftp.au.debian.org etch/main Sources/DiffIndex >> Hit http://ftp.au.debian.org etch/main Packages >> Hit http://ftp.au.debian.org etch/main Sources >> Get:2 ftp://ftp3.de.postgresql.org etch Release.gpg [189B] >> Get:3 ftp://ftp3.de.postgresql.org etch Release [2417B] >> Get:4 ftp://ftp3.de.postgresql.org etch/pgadmin Packages [1745B] >> Get:5 http://security.debian.org etch/updates Release.gpg [189B] >> Hit http://security.debian.org etch/updates Release >> Ign http://security.debian.org etch/updates/main Packages/DiffIndex >> Ign http://security.debian.org etch/updates/contrib Packages/ >> DiffIndex >> Ign http://security.debian.org etch/updates/main Sources/DiffIndex >> Ign http://security.debian.org etch/updates/contrib Sources/DiffIndex >> Hit http://security.debian.org etch/updates/main Packages >> Hit http://security.debian.org etch/updates/contrib Packages >> Hit http://security.debian.org etch/updates/main Sources >> Hit http://security.debian.org etch/updates/contrib Sources >> Fetched 4353B in 23s (184B/s) >> Reading package lists... Done >> ron@zoe:~/Ron$ sudo apt-get install pgadmin3 >> Reading package lists... Done >> Building dependency tree... Done >> The following extra packages will be installed: >> pgadmin3-data >> The following packages will be upgraded: >> pgadmin3 pgadmin3-data >> 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. >> Need to get 1070kB/5967kB of archives. >> After unpacking 414kB disk space will be freed. >> Do you want to continue [Y/n]? >> Get:1 ftp://ftp3.de.postgresql.org etch/pgadmin pgadmin3-data >> 1.8.0-1~pgaoetch1 [1070kB] >> Fetched 1070kB in 8s (124kB/s) >> Failed to fetch >> ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org//pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1 >> ~pgaoetch1_all.deb Size mismatch >> E: Unable to fetch some archives, maybe run apt-get update or try >> with >> --fix-missing? >> >> ron@zoe:~/Ron$ sudo apt-get update >> Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD >> Binary-1 >> 20070407-11:55] etch Release.gpg >> Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD >> Binary-1 >> 20070407-11:55] etch Release >> Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD >> Binary-1 >> 20070407-11:55] etch/contrib Packages/DiffIndex >> Ign cdrom://[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 CD >> Binary-1 >> 20070407-11:55] etch/main Packages/DiffIndex >> Get:1 http://ftp.au.debian.org etch Release.gpg [378B] >> Hit http://ftp.au.debian.org etch Release >> Ign http://ftp.au.debian.org etch/main Packages/DiffIndex >> Ign http://ftp.au.debian.org etch/main Sources/DiffIndex >> Hit http://ftp.au.debian.org etch/main Packages >> Hit http://ftp.au.debian.org etch/main Sources >> Get:2 ftp://ftp.de.postgresql.org etch Release.gpg [189B] >> Get:3 ftp://ftp.de.postgresql.org etch Release [2417B] >> Get:4 ftp://ftp.de.postgresql.org etch/pgadmin Packages [1745B] >> Get:5 http://security.debian.org etch/updates Release.gpg [189B] >> Hit http://security.debian.org etch/updates Release >> Ign http://security.debian.org etch/updates/main Packages/DiffIndex >> Ign http://security.debian.org etch/updates/contrib Packages/ >> DiffIndex >> Ign http://security.debian.org etch/updates/main Sources/DiffIndex >> Ign http://security.debian.org etch/updates/contrib Sources/DiffIndex >> Hit http://security.debian.org etch/updates/main Packages >> Hit http://security.debian.org etch/updates/contrib Packages >> Hit http://security.debian.org etch/updates/main Sources >> Hit http://security.debian.org etch/updates/contrib Sources >> Fetched 4353B in 23s (186B/s) >> Reading package lists... Done >> ron@zoe:~/Ron$ sudo apt-get install pgadmin3 >> Reading package lists... Done >> Building dependency tree... Done >> The following extra packages will be installed: >> pgadmin3-data >> The following packages will be upgraded: >> pgadmin3 pgadmin3-data >> 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. >> Need to get 1070kB/5967kB of archives. >> After unpacking 414kB disk space will be freed. >> Do you want to continue [Y/n]? >> Failed to fetch >> ftp://ftp.de.postgresql.org/mirror/postgresql/pgadmin3/release/debian/dists/etch/pgadmin/binary-all/misc/pgadmin3-data_1.8.0-1 >> ~pgaoetch1_all.deb Size mismatch >> E: Unable to fetch some archives, maybe run apt-get update or try >> with >> --fix-missing? >> ron@zoe:~/Ron$ >> >> >>> can you try to follow these steps please: >>> >>> a) >>> wget -q -O - http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg >>> | sudo apt-key add - >>> >>> (if you don't have sudo, run the following as root: >>> wget -q -O - http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg >>> | apt-key add - ) >>> >>> b) >>> retry your installation with the german mirror, it should be ok. >>> >>> The first two errors need investigation (size mismatch). >>> >>> Regards, >>> Raphaël >>> >>> > > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend > >
On Fri, 2007-12-07 at 23:38 +0100, Raphaël Enrici wrote: Hi Ralph > sorry for the delay... So, that was my fault. The -data present in the Yes, this time I can upgrade to 1.8.0. Many thanx. -- Ron Savage ron@savage.net.au http://savage.net.au/index.html
Built in display of contents of temporary tables when select has no destination
От
"Robert M. Bernabe"
Дата:
Hi, Not sure if this is the proper forum but I'd like to post a request of sorts. The PG Admin III SQL Editor and Debugger are great but I've noticed that when a select statement has no destination, the software issues an error. I've tried MSSQL, MySQL and even Valentina...the debuggers there automaticaly display the contents of select statements with no destination for the query recordset on a window or tab somewhere. (e.g. select * from mytable limit 5) This provides an easy built in display of temporary tables (or even parameter passed ones) without having to resort to a loop with raise commands. Am hoping the nice people here would consider plugging this feature into future releases...:) Good day to all. :) I'm protected by SpamBrave http://www.spambrave.com/
Robert M. Bernabe wrote: > Hi, > Not sure if this is the proper forum but I'd like to post a request > of sorts. The PG Admin III SQL Editor and Debugger are great but I've > noticed that when a select statement has no destination, the software > issues an error. What do you mean 'has no destination'? Can you provide an example? Regards, Dave
Re: Built in display of contents of temporary tables when select has no destination
От
"Robert M. Bernabe"
Дата:
Hi Dave, Within a function just type select * from table; ...call the function and the SQL editor will give an error saying that the select statement has no destination...which is true...:) but often very complex stored functions have temporary tables within and the only way to display the contents while debugging is to use a loop with raise info calls. It would be great if the debugger automatically streams all select statements to a output and formatted already for viewing. ----- Original Message ----- From: "Dave Page" <dpage@postgresql.org> To: "Robert M. Bernabe" <rbernabe@sandmansystems.com> Cc: "Postgres" <pgadmin-support@postgresql.org> Sent: Monday, December 10, 2007 5:25 PM Subject: Re: [pgadmin-support] Built in display of contents of temporary tables when select has no destination > Robert M. Bernabe wrote: >> Hi, >> Not sure if this is the proper forum but I'd like to post a request >> of sorts. The PG Admin III SQL Editor and Debugger are great but I've >> noticed that when a select statement has no destination, the software >> issues an error. > > What do you mean 'has no destination'? Can you provide an example? > > Regards, Dave > I'm protected by SpamBrave http://www.spambrave.com/
Robert M. Bernabe wrote: > Hi Dave, > Within a function just type select * from table; ...call the function > and the SQL editor will give an error saying that the select statement > has no destination...which is true...:) but often very complex stored > functions have temporary tables within and the only way to display the > contents while debugging is to use a loop with raise info calls. It > would be great if the debugger automatically streams all select > statements to a output and formatted already for viewing. Oh, I see what you mean. Unfortunately thats not possible with the way the server is currently designed - you would need to use RAISE as you mention I'm afraid. Regards, Dave