Thread: pgAdmin III locks up

---

From: Donald Fraser [mailto:demolish@cwgsy.net]
Sent: 24 May 2004 18:26
To: [pgADMIN]
Subject: [pgadmin-support] pgAdmin III locks up

pgAdmin III Version 1.1.0 Devel (Apr 14 2004)

OS: W2K SP4

 

Bug:

 

1) Open SQL editor pain with for example a large PL/PGSQL function.

 

2) Select cursor say 10 lines from top:

 

3) Edit->Find (Ctrl-F) type some text in the "Find what" text entry - for example "gobbledegook"

 

4) Press the "Find Next" button.

 

5) Change direction to up.

 

6) Press the "Find Next" button.

 

pgAdmin III locks up

 

regards

Donald Fraser

Donald Fraser wrote:
Hm,
can't reproduce this.

> pgAdmin III Version 1.1.0 Devel (Apr 14 2004)
> OS: W2K SP4
>  
> Bug:
>  
> 1) Open SQL editor pain with for example a large PL/PGSQL function.
>  
> 2) Select cursor say 10 lines from top:
>  
> 3) Edit->Find (Ctrl-F) type some text in the "Find what" text entry 
> - for example "gobbledegook"
>  
> 4) Press the "Find Next" button.
>  
> 5) Change direction to up.
>  
> 6) Press the "Find Next" button.
>  
> pgAdmin III locks up
>  


I'm only getting the "reached end of doc" message. Does by any chance 
this message hide somewhere? Try Alt-Tabbing to locate it.

Regards,
Andreas

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 26 May 2004 10:01
> To: Donald Fraser
> Cc: [pgADMIN]
> Subject: Re: [pgadmin-support] pgAdmin III locks up
>
> Donald Fraser wrote:
> Hm,
> can't reproduce this.
>
>
> I'm only getting the "reached end of doc" message. Does by
> any chance this message hide somewhere? Try Alt-Tabbing to locate it.

No, it doesn't get hidden - in fact the find button on the find dialogue
doesn't even become 'unpressed' if you know what I mean. Try it with a
fair bit of text in the dialogue - sometimes it'll crash searching
forward and sometimes back but it seems pretty broken here.

Mind you, what wx are you using? I still have our last 'offical' version
as found on developer.pgadmin.org.

Regards, Dave.

----- Original Message -----
From: "Andreas Pflug" <pgadmin@pse-consulting.de>
To: "Donald Fraser" <demolish@cwgsy.net>
Cc: "[pgADMIN]" <pgadmin-support@postgresql.org>
Sent: Wednesday, May 26, 2004 10:01 AM
Subject: Re: [pgadmin-support] pgAdmin III locks up


> Donald Fraser wrote:
> Hm,
> can't reproduce this.
>
> > pgAdmin III Version 1.1.0 Devel (Apr 14 2004)
> > OS: W2K SP4
> >
> > Bug:
> >
> > 1) Open SQL editor pain with for example a large PL/PGSQL function.
> >
> > 2) Select cursor say 10 lines from top:
> >
> > 3) Edit->Find (Ctrl-F) type some text in the "Find what" text entry
> > - for example "gobbledegook"
> >
> > 4) Press the "Find Next" button.
> >
> > 5) Change direction to up.
> >
> > 6) Press the "Find Next" button.
> >
> > pgAdmin III locks up
> >
>
>
> I'm only getting the "reached end of doc" message. Does by any chance
> this message hide somewhere? Try Alt-Tabbing to locate it.

I get "reached end of doc" message when direction is down.
After changing direction to up and pressing "Find Next" button pgAdmin locks
up. Alter-tab does nothing, task manger shows pgAdmin at 99% processor
utilisation!
Remember that I am on pgAdmin III Version 1.1.0 Devel (Apr 14 2004).
Dave - what version did you test against and find the same problem?

Regards
Donald Fraser

> -----Original Message-----
> From: Donald Fraser [mailto:demolish@cwgsy.net]
> Sent: 26 May 2004 10:22
> To: [pgADMIN]
> Subject: Re: [pgadmin-support] pgAdmin III locks up
>
> I get "reached end of doc" message when direction is down.
> After changing direction to up and pressing "Find Next"
> button pgAdmin locks up. Alter-tab does nothing, task manger
> shows pgAdmin at 99% processor utilisation!
> Remember that I am on pgAdmin III Version 1.1.0 Devel (Apr 14 2004).
> Dave - what version did you test against and find the same problem?

CVS tip.

Regards, Dave

Dave Page wrote:

> 
>
>  
>
>>-----Original Message-----
>>From: Andreas Pflug [mailto:pgadmin@pse-consulting.de] 
>>Sent: 26 May 2004 10:01
>>To: Donald Fraser
>>Cc: [pgADMIN]
>>Subject: Re: [pgadmin-support] pgAdmin III locks up
>>
>>Donald Fraser wrote:
>>Hm,
>>can't reproduce this.
>>
>>
>>I'm only getting the "reached end of doc" message. Does by 
>>any chance this message hide somewhere? Try Alt-Tabbing to locate it.
>>    
>>
>
>No, it doesn't get hidden - in fact the find button on the find dialogue
>doesn't even become 'unpressed' if you know what I mean. Try it with a
>fair bit of text in the dialogue - sometimes it'll crash searching
>forward and sometimes back but it seems pretty broken here.
>
>Mind you, what wx are you using? I still have our last 'offical' version
>as found on developer.pgadmin.org.
>  
>

I used the latest binary, as well as my local debug version (updated wx) 
on Server2003.


Regards,
Andreas

Is there a way to copy tables, functions, etc. between databases and servers
within pgAdmin?

For example, within pgAdmin we have:   Server1 has a database called DB1 with a table called Table1.   Server2 has a
databasecalled DB2 with a table called Table2.
 

I want to copy the data and metadata from Table1 to Table2.  Is this
possible?  If so, how?

Thanks,
Derrick

look at pg_dump.

If you want to do this in real-time please specify ?

Jim
----- Original Message ----- 
From: "derrick@grifflink.com" <Derrick@grifflink.com>
To: <pgadmin-support@postgresql.org>
Sent: Wednesday, May 26, 2004 11:58 AM
Subject: [pgadmin-support] Copy between Databases


> Is there a way to copy tables, functions, etc. between databases and
servers
> within pgAdmin?
>
> For example, within pgAdmin we have:
>     Server1 has a database called DB1 with a table called Table1.
>     Server2 has a database called DB2 with a table called Table2.
>
> I want to copy the data and metadata from Table1 to Table2.  Is this
> possible?  If so, how?
>
> Thanks,
> Derrick
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

Is there a way to implement the pg_dump from within pgAdminIII?  If so, how?

Thanks,
Derrick


> look at pg_dump.
>
> If you want to do this in real-time please specify ?
>
> Jim
>
> > Is there a way to copy tables, functions, etc. between databases and
> servers
> > within pgAdmin?
> >
> > For example, within pgAdmin we have:
> >     Server1 has a database called DB1 with a table called Table1.
> >     Server2 has a database called DB2 with a table called Table2.
> >
> > I want to copy the data and metadata from Table1 to Table2.  Is this
> > possible?  If so, how?
> >
> > Thanks,
> > Derrick
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
>
>

derrick@grifflink.com wrote:

>Is there a way to implement the pg_dump from within pgAdminIII?  If so, how?
>  
>
Of course, all you need is a C++ compiler and some spare time :-)

You could code a graphical frontend for pg_dump/pg_restore, which is on 
the pgadmin3 TODO list anyway.

Regards,
Andreas

>> Is there a way to implement the pg_dump from within pgAdminIII?  If 
>> so, how?
>>  
>>
> Of course, all you need is a C++ compiler and some spare time :-)
> 
> You could code a graphical frontend for pg_dump/pg_restore, which is on 
> the pgadmin3 TODO list anyway.

Just do what we do with phpPgAdmin - we just open a connection to the 
pg_dump process and execute it.  We then capture the output and stream 
it to the user's browser.

Chris