Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

2010-03-17 Thread Ashesh Vashi
What is the output of the following commands: *file /usr/local/pgadmin3/bin/pgadmin3* *file /usr/local/lib/libpq.so.5* -- Ashesh On Wed, Mar 17, 2010 at 6:39 PM, Vinicius Borges wrote: > Hello, > > I installed pgadmin3-1.10.2 and I got an error that might strange... > > bash-3.1# /usr/local/pgad

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

2010-03-17 Thread Devrim GÜNDÜZ
On Wed, 2010-03-17 at 13:33 -0300, Vinicius Borges wrote: > Right. How can I do that? Just compile PostgreSQL sources (don't run make install). When make is finished, manually copy libpq,libecpg and libpgtypes to related directories, and see what happens. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/

[pgadmin-support] Select multiple rows for delete does too good of a job

2010-03-17 Thread Scott Dunbar
Hi all, I'm using pgAdmin III version 1.10.0 from the Ubuntu 9.10 64 bit package. I bring the contents of a table by right clicking on the table name and selecting "View Data" and either "View Top 100 Rows" or "View All Rows". I have a very small table with about 10 rows in it. I then selec

Re: [pgadmin-support] pgAdmin III v1.10.2 released

2010-03-17 Thread Dale J Thompson
I apologize for assuming this was a well known problem. If it's not feasible to adjust the build to work around this issue, I'd suggest the documentation for pgAdmin be updated to clarify that it requires 8.3(?) or greater version of postgresql to build. It's certainly not reasonable to assume

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

2010-03-17 Thread Vinicius Borges
Hello Devrim, Right. How can I do that? thanks 2010/3/17 Devrim GÜNDÜZ > On Wed, 2010-03-17 at 12:37 -0300, Vinicius Borges wrote: > > /usr/local/pgadmin3/bin/pgadmin3: error while loading shared > > libraries: > > /usr/lib64/libpq.so.5: ELF file OS ABI invalid > > You may need to compile your

Re: [pgadmin-support] pgAdmin III v1.10.2 released

2010-03-17 Thread Dave Page
2010/3/17 Guillaume Lelarge : > Le 17/03/2010 17:01, Devrim GÜNDÜZ a écrit : >> On Wed, 2010-03-17 at 16:52 +0100, Guillaume Lelarge wrote: >>> You should because I don't have any idea what you are talking about. >> >> I sent build log yesterday: >> >> http://archives.postgresql.org/message-id/1268

Re: [pgadmin-support] pgAdmin III v1.10.2 released

2010-03-17 Thread Guillaume Lelarge
Le 17/03/2010 17:01, Devrim GÜNDÜZ a écrit : > On Wed, 2010-03-17 at 16:52 +0100, Guillaume Lelarge wrote: >> You should because I don't have any idea what you are talking about. > > I sent build log yesterday: > > http://archives.postgresql.org/message-id/1268719771.2229.1.ca...@hp-laptop2.gundu

Re: [pgadmin-support] pgAdmin III v1.10.2 released

2010-03-17 Thread Devrim GÜNDÜZ
On Wed, 2010-03-17 at 16:52 +0100, Guillaume Lelarge wrote: > You should because I don't have any idea what you are talking about. I sent build log yesterday: http://archives.postgresql.org/message-id/1268719771.2229.1.ca...@hp-laptop2.gunduz.org -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

2010-03-17 Thread Devrim GÜNDÜZ
On Wed, 2010-03-17 at 12:37 -0300, Vinicius Borges wrote: > /usr/local/pgadmin3/bin/pgadmin3: error while loading shared > libraries: > /usr/lib64/libpq.so.5: ELF file OS ABI invalid You may need to compile your own libpq from using PostgreSQL 8.2... -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consult

Re: [pgadmin-support] pgAdmin III v1.10.2 released

2010-03-17 Thread Guillaume Lelarge
Le 17/03/2010 15:45, Dale J Thompson a écrit : > I don't suppose there's any chance this build fixes the build issue > pgAdmin has with 8.1.x versions of postgresql? Version 1.10.0 builds > fine under Redhat Enterprise 5, but 1.10.1 will not build due to needing > some function from the postgresql

Re: [pgadmin-support] pgAdmin III v1.10.2 released

2010-03-17 Thread Dale J Thompson
I don't suppose there's any chance this build fixes the build issue pgAdmin has with 8.1.x versions of postgresql? Version 1.10.0 builds fine under Redhat Enterprise 5, but 1.10.1 will not build due to needing some function from the postgresql headers that was not added until a later 8.x release

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

2010-03-17 Thread Vinicius Borges
Hello, I saw that libpq.so.5 wasn't in /usr/lib64/. Then I installed libpq.so.5 for 64-bit. from http://rpm.pbone.net/index.php3/stat/4/idpl/13529891/dir/fedora_other/com/postgresql-libs-8.4.2-6.fc13.x86_64.rpm.html But now appears other error. #$ /usr/local/pgadmin3/bin/pgadmin3 /usr/local/pgad

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

2010-03-17 Thread Guillaume Lelarge
Please keep the list on CC. Le 17/03/2010 15:22, Vinicius Borges a écrit : > #$ ldd /usr/local/pgadmin3/bin/pgadmin3 >[...] > libpq.so.5 => not found ldd doesn't find it too. Kind of strange. How did you install libpq? did you install the 32-bits library? (which would explain where it is loca

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

2010-03-17 Thread Guillaume Lelarge
Le 17/03/2010 14:09, Vinicius Borges a écrit : > Hello, > > I installed pgadmin3-1.10.2 and I got an error that might strange... > > bash-3.1# /usr/local/pgadmin3/bin/pgadmin3 > /usr/local/pgadmin3/bin/pgadmin3: error while loading shared libraries: > libpq.so.5: cannot open shared object file: N

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Guillaume Lelarge
Le 17/03/2010 13:49, Thom Brown a écrit : > On 17 March 2010 11:40, Guillaume Lelarge wrote: > >> Le 17/03/2010 12:37, Thom Brown a écrit : >>> On 17 March 2010 11:29, javib wrote: >>> Thanks for replying so fast Thom. I tried the following line and it >> didn't work: CR

Re: [pgadmin-support] pgAdmin III v1.10.2 released

2010-03-17 Thread John Gage
An incremental approach is undoubtedly best. Identifying the PK's and FK's (not connecting them, just identifying them) in the Query Builder might be an easy first step. On Mar 17, 2010, at 12:29 PM, Guillaume Lelarge wrote: Le 15/03/2010 09:29, John Gage a écrit : This is my opportunity

[pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

2010-03-17 Thread Vinicius Borges
Hello, I installed pgadmin3-1.10.2 and I got an error that might strange... bash-3.1# /usr/local/pgadmin3/bin/pgadmin3 /usr/local/pgadmin3/bin/pgadmin3: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory I have the libpq.so.5 in /usr/lib a

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Thom Brown
On 17 March 2010 11:40, Guillaume Lelarge wrote: > Le 17/03/2010 12:37, Thom Brown a écrit : > > On 17 March 2010 11:29, javib wrote: > > > >> > >> Thanks for replying so fast Thom. I tried the following line and it > didn't > >> work: > >> > >> CREATE TABLESPACE otraParti LOCATION '/media/Iomeg

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread javib
Thanks!! It works now. My OS is windows. I've created the new tablespace with the pgadmin following the instructions and works fine!! Thanks againn Guillaume Lelarge-3 wrote: > > Le 17/03/2010 12:51, javib a écrit : >> >> How can I assign permissions to postgress to access the drive? > > Depe

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Guillaume Lelarge
Le 17/03/2010 12:51, javib a écrit : > > How can I assign permissions to postgress to access the drive? Depends on you operating system, which you still haven't told us. I suppose this is on Windows. Right click on your directory, choose Properties, click on the Security tab, check if the postgre

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread javib
How can I assign permissions to postgress to access the drive? Thanks! Guillaume Lelarge-3 wrote: > > Le 17/03/2010 12:37, Thom Brown a écrit : >> On 17 March 2010 11:29, javib wrote: >> >>> >>> Thanks for replying so fast Thom. I tried the following line and it >>> didn't >>> work: >>> >>> CR

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Guillaume Lelarge
Le 17/03/2010 12:37, Thom Brown a écrit : > On 17 March 2010 11:29, javib wrote: > >> >> Thanks for replying so fast Thom. I tried the following line and it didn't >> work: >> >> CREATE TABLESPACE otraParti LOCATION '/media/Iomega HDD(F:)' >> >> and I'm getting the following error: >> ERROR: coul

Re: [pgadmin-support] report generation

2010-03-17 Thread Guillaume Lelarge
Le 16/03/2010 17:40, Cedric Boudinet a écrit : > > Hello, > I am using the report generation options of PgAdmin. > I'm trying to generate in a few steps the data dictionary for all the tables > of a given schema. > With version 1.10.1 under Windows, the only global operation available gives > a

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Guillaume Lelarge
Le 17/03/2010 12:29, javib a écrit : > > Thanks for replying so fast Thom. I tried the following line and it didn't > work: > > CREATE TABLESPACE otraParti LOCATION '/media/Iomega HDD(F:)' > > and I'm getting the following error: > ERROR: couldn't define permissions for directory «/media/Iomega

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Thom Brown
On 17 March 2010 11:29, javib wrote: > > Thanks for replying so fast Thom. I tried the following line and it didn't > work: > > CREATE TABLESPACE otraParti LOCATION '/media/Iomega HDD(F:)' > > and I'm getting the following error: > ERROR: couldn't define permissions for directory «/media/Iomega H

Re: [pgadmin-support] Can't access entire window in Graphical Query Builder (Windows platform)

2010-03-17 Thread Guillaume Lelarge
Le 16/03/2010 17:29, Michael Haltrecht a écrit : > Even when I rotate my monitor (so it's taller than wider), I can't scroll to > access past the 55th field. > The window scroll bars don't seem to take into account the actual size of > the table. > > This is still an issue in 1.10.2 > I added th

Re: [pgadmin-support] Graphical Query Builder - usage stats?

2010-03-17 Thread Guillaume Lelarge
Le 15/03/2010 09:54, Julius Tuskenis a écrit : > [...] > I don't usually use the builder, but sometimes it is convenient for long > table/column names having queries. I'd like to propose some improvements > to it: > 1. Why not join the selected tables if they are related over foreign > key? Usually

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread javib
Thanks for replying so fast Thom. I tried the following line and it didn't work: CREATE TABLESPACE otraParti LOCATION '/media/Iomega HDD(F:)' and I'm getting the following error: ERROR: couldn't define permissions for directory «/media/Iomega HDD(F:)»: No such file or directory Any ideas? Tho

Re: [pgadmin-support] pgAdmin III v1.10.2 released

2010-03-17 Thread Guillaume Lelarge
Le 15/03/2010 09:29, John Gage a écrit : > This is my opportunity to say that I do use the graphical query builder. > > It would be great if it could be brought into line with (subsume the > code for) DBUML, the ArgoUML class diagramming software for databases > (http://sourceforge.net/projects/db

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Thom Brown
On 17 March 2010 11:10, javib wrote: > > Hello, > I would like to create a database in a different hard drive than the one in > which pgadmin is installed. I've been looking through the options of > pgadmin > and I haven't seen anything. The reason I'm doing this is because this new > database I'

[pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread javib
Hello, I would like to create a database in a different hard drive than the one in which pgadmin is installed. I've been looking through the options of pgadmin and I haven't seen anything. The reason I'm doing this is because this new database I'm going to create will be huge and I need lots of sp

[pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread javib
Hello, I would like to create a database in a different hard drive than the one in which pgadmin is installed. I've been looking through the options of pgadmin and I haven't seen anything. The reason I'm doing this is because this new database I'm going to create will be huge and I need lots of sp