[pgadmin-support] problem downloading/installing pgadmin3 on Debian testing

2003-08-14 Thread Giuseppe Sacco
[please CC in reply, since I am not subscribed to the list] Hi, I jst read the announcement about pgAdminIII and I am very happy. I tried to install it in my debian box, but I found that the binary version is available only for i386. I then decided to recompile everything from source and send it b

Re: [pgadmin-support] [Fwd: problem downloading/installing pgadmin3 on Debian

2003-08-14 Thread Giuseppe Sacco
Il sab, 2003-08-09 alle 11:37, Raphaël Enrici ha scritto: [...] > More simply, try this : > You can find the source packages or our wxWindows 2.5 by adding this > line to your sources.list > deb-src http://www.pgadmin.org/snapshots/linux/debian > experimental/testing wxwindows-pgadmin3 > > And t

[pgadmin-support] problem in restoring database when connected via named socket

2010-01-12 Thread Giuseppe Sacco
Hi all, I am connected to a local postgresql server via named pipe instead of tcp/ip socket, i.e., I did not specify the hostname while creating the connection. No, when I try to restore a database, the command fail since the "hostname" argument is missing. This is the error message I get: /usr/b

[pgadmin-support] problem in restoring database when connected via named socket

2010-01-12 Thread Giuseppe Sacco
Hi all, I am connected to a local postgresql server via named pipe instead of tcp/ip socket, i.e., I did not specify the hostname while creating the connection. No, when I try to restore a database, the command fail since the "hostname" argument is missing. This is the error message I get: /usr/b

Re: [pgadmin-support] problem in restoring database when connected via named socket

2010-01-12 Thread Giuseppe Sacco
Hi Guillaume, Il giorno mar, 12/01/2010 alle 10.47 +0100, Guillaume Lelarge ha scritto: > Hi Giuseppe, [...] > You shouldn't have this issue because we check if the server name is > empty or not before adding the -h command line option. AFAICT, this is > fixed since "Wed Mar 19 11:28:37 2008". So

Re: [pgadmin-support] problem in restoring database when connected via named socket

2010-01-12 Thread Giuseppe Sacco
Il giorno mar, 12/01/2010 alle 11.21 +0100, Guillaume Lelarge ha scritto: > Did you re-run ./bootstrap? if not, try to do so. I didn't. That fixed the problem. Thanks again, Giuseppe -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription

[pgadmin-support] Remove automatically generated content

2010-05-05 Thread Giuseppe Sacco
Hi all, is there any way to get an empty window for querying data? Currently, when I press the SQL button, I always get a window with a CREATE statement for the currently selected object / databases, view, schema, table, ...) Thank you very much, Giuseppe -- Sent via pgadmin-support mailing lis

[pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-15 Thread Giuseppe Sacco
Hi, in order to check an updated Italian translation, I would like to compile pgadmin3 on my Debian box. This is what happens: giuseppe@scarafaggio:~/src/cvs/pgadmin3$ ./configure --prefix=/usr/local/pgadmin3-1.14 checking build system type... i686-pc-linux-gnu checking host system type... i686-

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-16 Thread Giuseppe Sacco
Il giorno mar, 16/08/2011 alle 09.00 +0300, Devrim GÜNDÜZ ha scritto: > Hi, > > On Tue, 2011-08-16 at 07:31 +0200, Giuseppe Sacco wrote: > > configure: error: you must specify a valid PostgreSQL 8.4+ > > installation with --with-pgsql=DIR > > > > I really do n

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-16 Thread Giuseppe Sacco
Il giorno mar, 16/08/2011 alle 09.00 +0200, Guillaume Lelarge ha scritto: [...] > /usr/lib/postgresql//bin (so, for 8.4, it would > be /usr/lib/postgresql/8.4/bin). > > I also noticed the OP doesn't have the -devel package. Not sure it's > required, but I wouldn't be surprised if it is. I do get

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-16 Thread Giuseppe Sacco
Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha scritto: > On Tue, 2011-08-16 at 09:05 +0200, Giuseppe Sacco wrote: [...] > Did you install the -devel package? there is no such package: $ apt-cache search postgresql | grep -- -devel $ Thanks again, Giuseppe -- Se

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-16 Thread Giuseppe Sacco
Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha scritto: [...] > > How do I recognize that directory? I think it should > > be /usr/lib/postgresql/8.4 but this does not work. > > > > It is. If it does not work, what error message do you have? $ ./configure --prefix=/usr/local/pg

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-16 Thread Giuseppe Sacco
Il giorno mar, 16/08/2011 alle 09.32 +0200, Guillaume Lelarge ha scritto: > On Tue, 2011-08-16 at 09:14 +0200, Giuseppe Sacco wrote: > > Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha > > scritto: > > > On Tue, 2011-08-16 at 09:05 +0200, Giuseppe Sacco wr

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Hi Guillaume, thanks for spending your time on this topic. I was really missing both packages postgresql-server-dev-{8.4,9.0}, but even after installing them, I still get the same error: $ ./configure --prefix=/usr/local/pgadmin3-1.14 checking build system type... i686-pc-linux-gnu checking host s

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 09.26 +0100, Dave Page ha scritto: [...] > > I did not have much time for finding a solution. I will try to work it > > out today or tomorrow. > > There are almost certainly some clues in config.log... Config log show something about ssl: it seems libpq is detected

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 10.04 +0100, Dave Page ha scritto: > On Wed, Aug 24, 2011 at 9:54 AM, Giuseppe Sacco [...] > > Config log show something about ssl: it seems libpq is detected but not > > usable since configure cannot compile with it. libpq require ssl, and I > >

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 11.00 +0100, Dave Page ha scritto: > On Wed, Aug 24, 2011 at 10:40 AM, Giuseppe Sacco [...] > > configure:5403: checking for SSL_library_init in -lssl > > configure:5428: gcc -o conftest -g -O2 conftest.c -lssl >&5 > > /usr/lib/libss

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 12.15 +0200, Guillaume Lelarge ha scritto: [...] > And ldd on libssl gives me this: > root@debian:~# ldd /usr/lib/libssl.so.1.0.0 > linux-vdso.so.1 => (0x7fffcf3ff000) > libcrypto.so.1.0.0 => /usr/lib/libcrypto.so.1.0.0 (0x7ffccd12a000) > li

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 11.24 +0100, Dave Page ha scritto: > On Wed, Aug 24, 2011 at 11:18 AM, Giuseppe Sacco [...] > >liblber-2.4.so.2 => /usr/lib/i386-linux-gnu/liblber-2.4.so.2 > > (0xb729) > >libsasl2.so.2 => /usr/lib/i386-linux-gn

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 16.00 +0530, Ashesh Vashi ha scritto: > Giuseppe, > What is the output of 'ldd /usr/lib/i686/cmov/libcrypto.so.1.0.0'? $ ldd /usr/lib/i686/cmov/libcrypto.so.1.0.0 linux-gate.so.1 => (0xb772) libdl.so.2 => /lib/i386-linux-gnu/i686/cmov/libdl.so.2

[pgadmin-support] error "permission denied for relation" on postgresql 9.0.6 during CREATE TABLE

2012-01-27 Thread Giuseppe Sacco
Hi, I get this error while executing a CREATE TABLE statement. This is my CREATE statement: CREATE TABLE agenzia.BarcodeByDocumentInfo ( docId VARCHAR(17) NOT NULL, defaultOp VARCHAR(10) NOT NULL DEFAULT 'Append', CONSTRAINT BcByDocInfo_pk PRIMARY KEY (docId), CONST