Thread: 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

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

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