Re: [GENERAL] Tool to create database diagrams in postgreSQL

2012-12-28 Thread Ognjen Blagojevic
Neville, On 28.12.2012 7:52, nevillekb wrote: Can anyone tell me which free GUI based tools are available for creating database diagrams for my database in postgresql. This was asked many times before, search the archives. E.g: http://archives.postgresql.org/pgsql-general/2011-08/msg01023.php

Re: [GENERAL] Postgres 8.0 upgrade to 9.0

2011-08-02 Thread Ognjen Blagojevic
Hi Atul, On 1.8.2011 16:12, Atul Goel wrote: We are planning to upgrade a postgres 8.0 database to postgres 9.0 (Actually already done in Dev). The application is J2EE application with Hibernate. My question are 1)Is there a list of things that needs to be taken care while upgrading(known issue

Re: [GENERAL] Need suggestion

2011-06-02 Thread Ognjen Blagojevic
, with small project fees, and I'm employee, not a contractor at my company :-) Thanks you in advance, Regards, Carl 2011/6/2 Ognjen Blagojevic mailto:ognjen.d.blagoje...@gmail.com>> Carl, I don't have experience with that big databases, but I did both solutions, and h

Re: [GENERAL] Need suggestion

2011-06-02 Thread Ognjen Blagojevic
Carl, I don't have experience with that big databases, but I did both solutions, and here are pros of both of them: 1. Files stored on the filesystem: - Small database footprint - Faster backup, export and import 2. Files stored in the database - RDBMS takes care of transactions and ref. int.

Re: [GENERAL] Some insight on the proper SQL would be appreciated

2010-06-09 Thread Ognjen Blagojevic
Plenty of solutions here: http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/ -Ognjen On 8.6.2010 18:29, Aaron Burnett wrote: Greetings, I hope this is the proper list for this, but I am a loss on how to achieve one particular set of results. I have a

Re: [GENERAL] Java Memory Issue while Loading Postgres library

2010-04-30 Thread Ognjen Blagojevic
a.bhattacha...@sungard.com wrote: We have a java exe making a call to a postgres function. This postgres function internally makes a call to a dll (which is written using Postgres extended C). Now the issue is that, when we make a call to this dll, it consumes a lot of memory and this memory

[GENERAL] Is SSL enabled in CentOS packages

2010-04-28 Thread Ognjen Blagojevic
Hi, How can I check if SSL is enabled in Postgres releases hosted at YUM repository [1]? -Ognjen [1] http://yum.pgsqlrpms.org/reporpms/repoview/pgdg-centos.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.

Re: [GENERAL] Embedded Postgres

2010-04-22 Thread Ognjen Blagojevic
John R Pierce wrote: Ognjen Blagojevic wrote: Is there a way to run Postgres in embedded mode? More precisely, to run it without using TCP/IP port, and without installing as a service? I am aware of Unix-domain sockets, but is there something similar for Windows? on unix, as you imply, it

Re: [GENERAL] Embedded Postgres

2010-04-22 Thread Ognjen Blagojevic
John R Pierce wrote: Ognjen Blagojevic wrote: Is there a way to run Postgres in embedded mode? More precisely, to run it without using TCP/IP port, and without installing as a service? I am aware of Unix-domain sockets, but is there something similar for Windows? on unix, as you imply, it

[GENERAL] Embedded Postgres

2010-04-21 Thread Ognjen Blagojevic
Hi, Is there a way to run Postgres in embedded mode? More precisely, to run it without using TCP/IP port, and without installing as a service? I am aware of Unix-domain sockets, but is there something similar for Windows? -Ognjen -- Sent via pgsql-general mailing list (pgsql-general@postgr

[GENERAL] [offtopic] How do you name a table...

2010-04-08 Thread Ognjen Blagojevic
Hi, How do you name a table which sole purpose is to store a list of values? E.g. Table: sex id name --- 1 male 2 female Table: day id name --- 1 Sunday 2 Monday 3 Tuesday 4 Wednesday 5 Thursday 6 Friday 7 Saturday Is this: a. Lookup table b. Classifier c. Cypher(er)? I'm looking fo

Re: [GENERAL] need a query

2010-03-29 Thread Ognjen Blagojevic
If you are sure that your words are space delimited, you may use this: select regexp_replace('Ispahani Public School'||' ', '([^ ])([^ ]* )', '\\1', 'g'); Regards, Ognjen Timo Klecker wrote: Try this: SELECT regexp_matches('foobar beque bazil barf bonk', '(\\m.)', 'g') Now you have the fi