Re: Graphics in postgress using GTK

Hi
We are trying to implement a progress estiamator for long queries. We
are trying to make the display graphical using GTK but we get an error
saying
Xlib : Connection to ":0.0" refused by server
xlib : no protocol specified

GTK-warning ** : Cannot open display

Can someone suggest a method to integrate this GTK code into postgres
and solve this problem.

Thanks and Regards
Anuj Tripathi

On Fri, Dec 02, 2005 at 04:15:55PM +0530, Anuj Tripathi wrote:
> Hi
> We are trying to implement a progress estiamator for long queries. We
> are trying to make the display graphical using GTK but we get an error
> saying
> Xlib : Connection to ":0.0" refused by server
> xlib : no protocol specified

Err, why on earth would the *backend* need to talk to the X server.
Shouldn't it be sending messages to the client and then the client
making the pics? How do you plan to deal with 10 queries running
simultaneously on a server at the other side of the world. I'm not even
running an X-server on my database server...

Anyway, the database server doesn't have permissions to access the X
server, that's the error.

> Can someone suggest a method to integrate this GTK code into postgres
> and solve this problem.

Umm, don't?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Anuj Tripathi wrote:
> Hi
> We are trying to implement a progress estiamator for long queries. We
> are trying to make the display graphical using GTK but we get an error
> saying
> Xlib : Connection to ":0.0" refused by server
> xlib : no protocol specified
>
> GTK-warning ** : Cannot open display
>
> Can someone suggest a method to integrate this GTK code into postgres
> and solve this problem.

Um - don't you want to be doing this in the client, not in the backend?

--
Richard Huxton
Archonet Ltd

What are you doing? Trying to run the GTK application in the same server as
the database?

Or are you trying to do a graphical interface in a server without an X
server?. I guess there is something very bad with your approach, I guess
your graphical interface should be running in the client side NOT in the
server side.

-----Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Anuj Tripathi
Sent: Viernes, 02 de Diciembre de 2005 04:46 a.m.
To: pgsql-hackers(at)postgresql(dot)org
Subject: [HACKERS] Graphics in postgress using GTK

Hi
We are trying to implement a progress estiamator for long queries. We
are trying to make the display graphical using GTK but we get an error
saying
Xlib : Connection to ":0.0" refused by server
xlib : no protocol specified

GTK-warning ** : Cannot open display

Can someone suggest a method to integrate this GTK code into postgres
and solve this problem.

Thanks and Regards
Anuj Tripathi

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

On 12/2/05, Anuj Tripathi <anujt(at)it(dot)iitb(dot)ac(dot)in> wrote:
> Hi
> We are trying to implement a progress estiamator for long queries. We
> are trying to make the display graphical using GTK but we get an error
> saying
> Xlib : Connection to ":0.0" refused by server
> xlib : no protocol specified
>
> GTK-warning ** : Cannot open display
>
> Can someone suggest a method to integrate this GTK code into postgres
> and solve this problem.
>
> Thanks and Regards
> Anuj Tripathi
>
>

What about to return to your application a cursor or a set of rows and
while looping let your progress bar advance?

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)