Re: [GENERAL] diagram tools?

2010-11-25 Thread Dmitriy Igrishin
Hey all, I recommend also look at dbWrench - http://www.dbwrench.com/ 2010/11/25 Joshua Tolley > On Wed, Nov 24, 2010 at 10:23:15AM -0800, DM wrote: > > There are many of them, I use SchemaSpy java based - easy to generate. > > Here are several other possibilities, which I've taken from the hel

[GENERAL] PgAdmin3 for PostgreSQL 9 Linux version

2010-11-25 Thread Gera Mel Handumon
Hello, What version of pgadmin3 to be used for postgresql 9 running on CentOS 5? I encountered some errors when i used the pgadmin3 1.8.4. I've search for newer version of pgadmin3 for Linux but no luck at all. TIA for you valuable help. -- Geramel -

Re: [GENERAL] PgAdmin3 for PostgreSQL 9 Linux version

2010-11-25 Thread Raymond O'Donnell
On 25/11/2010 10:02, Gera Mel Handumon wrote: Hello, What version of pgadmin3 to be used for postgresql 9 running on CentOS 5? I encountered some errors when i used the pgadmin3 1.8.4. I've search for newer version of pgadmin3 for Linux but no luck at all. The current version of pgAdmin is 1.1

Re: [GENERAL] [ADMIN] PgAdmin3 for PostgreSQL 9 Linux version

2010-11-25 Thread Guillaume Lelarge
Le 25/11/2010 11:02, Gera Mel Handumon a écrit : > Hello, > > What version of pgadmin3 to be used for postgresql 9 running on CentOS > 5? I encountered some errors when i used the pgadmin3 1.8.4. I've > search for newer version of pgadmin3 for Linux but no luck at all. > You need the 1.12 releas

Re: [GENERAL] [ADMIN] PgAdmin3 for PostgreSQL 9 Linux version

2010-11-25 Thread John R Pierce
You need the 1.12 release to work with with PostgreSQL 9.0. Whether or not it is available on a CentOS package is another question, but I don't have an answer for this one. you mean, like this? http://yum.pgrpms.org/9.0/redhat/rhel-5-i386/pgadmin3_90-1.12.1-1.rhel5.i386.rpm if you install

Re: [GENERAL] [ADMIN] PgAdmin3 for PostgreSQL 9 Linux version

2010-11-25 Thread Gera Mel Handumon
Where can i find the 1.12 RPM release of PgAdmin3? It's 1.8 available for RPM. TIA. On Thu, Nov 25, 2010 at 2:08 AM, Guillaume Lelarge wrote: > Le 25/11/2010 11:02, Gera Mel Handumon a écrit : >> Hello, >> >> What version of pgadmin3 to be used for postgresql 9 running on CentOS >> 5? I encounte

Re: [GENERAL] [ADMIN] PgAdmin3 for PostgreSQL 9 Linux version

2010-11-25 Thread John R Pierce
On 11/25/10 2:16 AM, Gera Mel Handumon wrote: Where can i find the 1.12 RPM release of PgAdmin3? It's 1.8 available for RPM. http://yum.pgrpms.org/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpre

Re: [GENERAL] Postgres 9.01 and WAL files issue

2010-11-25 Thread Vick Khera
On Wed, Nov 24, 2010 at 12:52 PM, DM wrote: > Here is my Archive Command: > archive_command = 'cp -i %p /mnt/nfs/primary/%f < /dev/null' > Just curious... why would you turn on the interactive version of cp for an automated script? Is that why you feed it /dev/null as input? -- Sent via pgsql-

Re: [GENERAL] Postgres 9.01 and WAL files issue

2010-11-25 Thread Matthew Walden
I thought that when I first read about WAL archiving but the documentation explains quite well. Basically it is to stop a successful result being returned in the event that the file already exists in the archive destination (to cause an error in the event it tries to overwrite a file). On Thu, No

Re: [GENERAL] Use of search path in plpgsql functions, PG 8.3.12

2010-11-25 Thread Tom Lane
Troy Rasiah writes: > If i set the search path to schema1,public the function still returns > rows from the events table in the public schema. What's probably happening is that plpgsql caches the execution plan for the SELECT during the first execution of the function in any given session. The o

[GENERAL] PGError: ERROR: missing FROM-clause entry for table

2010-11-25 Thread James B. Byrne
I am getting this error: PGError: ERROR: missing FROM-clause entry for table "ca_customs_entry" LINE 1: ..._entries"."is_cadex_transmitted" = 'f') ORDER BY ca_customs... The code is generated by a Ruby-on-Rails-3.0.1 ActiveRecord model: SELECT "ca_customs_shipments".* FROM "ca_customs_shipment

Re: [GENERAL] PGError: ERROR: missing FROM-clause entry for table

2010-11-25 Thread Robert Treat
On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne wrote: > I am getting this error: > > PGError: ERROR: missing FROM-clause entry for table "ca_customs_entry" > LINE 1: ..._entries"."is_cadex_transmitted" = 'f') ORDER BY > ca_customs... > > The code is generated by a Ruby-on-Rails-3.0.1 ActiveRecor

Re: [GENERAL] PGError: ERROR: missing FROM-clause entry for table

2010-11-25 Thread James B. Byrne
On Thu, November 25, 2010 21:58, Robert Treat wrote: > On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne > wrote: >> > > Looks to me like the problem is you are trying to ORDER BY columns > in > "ca_customs_entry", but there is no such table for that (don't > confuse it > with "ca_customs_entries")