Re: [GENERAL] diagram tools?
Hey all, I recommend also look at dbWrench - http://www.dbwrench.com/ 2010/11/25 Joshua Tolley eggyk...@gmail.com 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 helpful pg_docbot that lives on Freenode in #postgresql. For whatever it's worth, I don't know that I've used any of these except the first link; it has proven itself fairly helpful. http://www.rbt.ca/autodoc/ http://druid.sf.net/ http://www.sqlmanager.net/ http://www.casestudio.com/ http://www.hardgeus.com/projects/pgdesigner/ http://www.thekompany.com/products/dataarchitect/ http://uml.sourceforge.net/index.php http://schemaspy.sourceforge.net/ http://pgfoundry.org/projects/autograph/ http://archives.postgresql.org/pgsql-general/2008-05/msg00918.php http://mogwai.sourceforge.net/?Welcome:ERDesigner_NG http://www.dbvis.com/products/dbvis/ http://www.modelsphere.org/ http://www.sqlpower.ca/page/architect -- Joshua Tolley / eggyknap End Point Corporation http://www.endpoint.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkzt+KIACgkQRiRfCGf1UMNXiwCgmbEC8NgyBdcEF/IMbqTfJZAZ UnIAnjnmmskQHMjNGSytbe1jNu+XrKD3 =oXEI -END PGP SIGNATURE- -- // Dmitriy.
[GENERAL] PgAdmin3 for PostgreSQL 9 Linux version
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 - Share your knowledge. It's a way to achieve immortality - Dalai Lama -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PgAdmin3 for PostgreSQL 9 Linux version
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.12.1, and you get it here: http://www.pgadmin.org/download Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [ADMIN] PgAdmin3 for PostgreSQL 9 Linux version
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 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. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [ADMIN] PgAdmin3 for PostgreSQL 9 Linux version
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 installed the yum.repos file appropriate for your version and architecture, simply run... # yum install pgadmin3_90 and get the latest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [ADMIN] PgAdmin3 for PostgreSQL 9 Linux version
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 guilla...@lelarge.info 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 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 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. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Gera Mel E. Handumon Chief Information Officer NexGen Systems - Paglaum MPC RnD Division email : geram...@paglaumcoop.org.ph gerame...@gmail.com gtalk : geramel.h YM : geram...@yahoo.com Skype : geramelh - Share your knowledge. It's a way to achieve immortality - Dalai Lama -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [ADMIN] PgAdmin3 for PostgreSQL 9 Linux version
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/mailpref/pgsql-general
Re: [GENERAL] Postgres 9.01 and WAL files issue
On Wed, Nov 24, 2010 at 12:52 PM, DM dm.a...@gmail.com 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-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgres 9.01 and WAL files issue
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, Nov 25, 2010 at 2:43 PM, Vick Khera vi...@khera.org wrote: On Wed, Nov 24, 2010 at 12:52 PM, DM dm.a...@gmail.com 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-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- View my Linkedin profile http://uk.linkedin.com/in/matthewdwalden
Re: [GENERAL] Use of search path in plpgsql functions, PG 8.3.12
Troy Rasiah tr...@vicnet.net.au 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 only really reliable way around that is to use EXECUTE instead of an in-line statement. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] PGError: ERROR: missing FROM-clause entry for table
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_shipments INNER JOIN ca_customs_entries ON ca_customs_entries.ca_customs_shipment_id = ca_customs_shipments.id WHERE (ca_customs_entries.is_cadex_transmitted = 'f') ORDER BY ca_customs_entry.is_across_transmitted, ca_customs_entry.is_across_rejected, ca_customs_entry.is_across_accepted, ca_customs_entry.is_cadex_released LIMIT 5 OFFSET 0 From what I have been able to piece together for myself I suspect that the cause may be the absence of an 'AS alias' immediately following the 'FROM ca_customs_shipments' segment. PG evidently treats this as required element whereas standard SQL does not. If someone could confirm that my suspicions are well founded then I will raise an issue to handle the matter with the software maintainers. On the other hand, if there is another cause of this then I would like to have that information as well. Sincerely, -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PGError: ERROR: missing FROM-clause entry for table
On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne byrn...@harte-lyne.cawrote: 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_shipments INNER JOIN ca_customs_entries ON ca_customs_entries.ca_customs_shipment_id = ca_customs_shipments.id WHERE (ca_customs_entries.is_cadex_transmitted = 'f') ORDER BY ca_customs_entry.is_across_transmitted, ca_customs_entry.is_across_rejected, ca_customs_entry.is_across_accepted, ca_customs_entry.is_cadex_released LIMIT 5 OFFSET 0 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). You need to either set a matching alias, or fix the table name qualifier in those order by columns. Robert Treat play: xzilla.net work: l42.org/lg
Re: [GENERAL] PGError: ERROR: missing FROM-clause entry for table
On Thu, November 25, 2010 21:58, Robert Treat wrote: On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne byrn...@harte-lyne.cawrote: 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). You need to either set a matching alias, or fix the table name qualifier in those order by columns. That was exactly the problem. Thank you very much. I am afraid that the mental gymnastics that Rails requires--table names are plural, corresponding model classes are singular--often trips me up. I would never have seen that error on my own. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general