Re: [pgadmin-support] Segmentation fault

2009-07-08 Thread Michael Shapiro
I don't think this is really a PgAdmin problem. PgAdmin is running the postgres function pg_logdir_ls() which is defined (on my server) as: CREATE OR REPLACE FUNCTION pg_logdir_ls() RETURNS SETOF record AS '$libdir/admin81', 'pg_logdir_ls' LANGUAGE 'c' VOLATILE STRICT; So there is some intera

Re: [pgadmin-support] Segmentation fault

2009-07-08 Thread Michael Shapiro
PostgreSQL 8.1.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-58) I am not the admin that installs or runs the server. This server (and the others below) are at another institution. NOTE: I have access other servers which do not cause this particular problem

Re: [pgadmin-support] Segmentation fault

2009-07-08 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yes I do. BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Guillaume Lelarge wrote: > Le mercredi 8 juillet 2009 à 11:06:43, Pedro Doria Meunier a écrit > : >> [...] As for me running the below select returns "1". >> > > Can you che

Re: [pgadmin-support] Segmentation fault

2009-07-08 Thread Guillaume Lelarge
Le mercredi 8 juillet 2009 à 11:06:43, Pedro Doria Meunier a écrit : > [...] > As for me running the below select returns "1". > Can you check if you still have the error without the adminpack? -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgadmin-support mailing l

Re: [pgadmin-support] Segmentation fault

2009-07-08 Thread Guillaume Lelarge
Le mercredi 8 juillet 2009 à 16:09:15, Michael Shapiro a écrit : > The query > select count(*) from pg_proc where proname='pg_file_write'; > returns 1 > Which release of PostgreSQL are you using? Did you change it? (I'm thinking about a 8.1 to something upgrade). Because the error message says yo

Re: [pgadmin-support] Segmentation fault

2009-07-08 Thread Michael Shapiro
The query select count(*) from pg_proc where proname='pg_file_write'; returns 1 On Wed, Jul 8, 2009 at 1:42 AM, Guillaume Lelarge wrote: > Le mardi 7 juillet 2009 à 23:47:18, Michael Shapiro a écrit : > > I have no idea. Would this be part of the postgres server or part of > > PgAdmin? > > > > Th

Re: [pgadmin-support] Segmentation fault

2009-07-08 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael, you install the admin pack like this: psql yourdatabase < /usr/share/pgsql/contrib/ adminpack.sql As for me running the below select returns "1". As per David suggestion, i.e. building pgadmin3 with debug support, I'm afraid that my wxWidg

Re: [pgadmin-hackers] [pgadmin-support] PGP problem ubuntu jaunty (9.04)

2009-07-08 Thread Dave Page
On Wed, Jul 8, 2009 at 9:52 AM, Guillaume Lelarge wrote: > Le mercredi 8 juillet 2009 à 10:13:05, Dave Page a écrit : >> On Tue, Jul 7, 2009 at 10:33 PM, Guillaume >> >> Lelarge wrote: >> > Raphaël is not supposed to work on this? or does he "only" do the Debian >> > package? I CC-ed him, just in c

Re: [pgadmin-hackers] [pgadmin-support] PGP problem ubuntu jaunty (9.04)

2009-07-08 Thread Guillaume Lelarge
Le mercredi 8 juillet 2009 à 10:13:05, Dave Page a écrit : > On Tue, Jul 7, 2009 at 10:33 PM, Guillaume > > Lelarge wrote: > > Raphaël is not supposed to work on this? or does he "only" do the Debian > > package? I CC-ed him, just in case. > > Well Raph unfortunately doesn't have time to maintain t

Re: [pgadmin-hackers] [pgadmin-support] PGP problem ubuntu jaunty (9.04)

2009-07-08 Thread Dave Page
On Tue, Jul 7, 2009 at 10:33 PM, Guillaume Lelarge wrote: > Raphaël is not supposed to work on this? or does he "only" do the Debian > package? I CC-ed him, just in case. Well Raph unfortunately doesn't have time to maintain the APT repos these days I don't think. I think what we need to do is re

[pgadmin-support] Locking table

2009-07-08 Thread AshikAli.m
Hi , I want to lock the table from select query . After locking , Other process can do update or insert but it should not do select query . what is the mode of lock I have to use . I have used ACCESS EXCLUSIVE . But it lock update statement too .. what I have to do implement this scenario ? w