Re: [GENERAL] Partitions and indexes

2011-02-26 Thread Amitabh Kant
On Sun, Feb 27, 2011 at 12:30 AM, John R Pierce wrote: > On 02/26/11 10:42 AM, Amitabh Kant wrote: > >> On Sat, Feb 26, 2011 at 11:52 PM, John R Pierce > pie...@hogranch.com>> wrote: >> >>On 02/26/11 10:01 AM, Alban Hertroys wrote: >> >>On 26 Feb 2011, at 18:04, Amitabh Kant wrote: >>

Re: [GENERAL] Partitions and indexes

2011-02-26 Thread John R Pierce
On 02/26/11 10:42 AM, Amitabh Kant wrote: On Sat, Feb 26, 2011 at 11:52 PM, John R Pierce > wrote: On 02/26/11 10:01 AM, Alban Hertroys wrote: On 26 Feb 2011, at 18:04, Amitabh Kant wrote: Now if I partition the table T2 based on field T1id,

Re: [GENERAL] Partitions and indexes

2011-02-26 Thread Amitabh Kant
On Sat, Feb 26, 2011 at 11:52 PM, John R Pierce wrote: > On 02/26/11 10:01 AM, Alban Hertroys wrote: > >> On 26 Feb 2011, at 18:04, Amitabh Kant wrote: >> >> Now if I partition the table T2 based on field T1id, making sure that >>> each distinct T1id is provided its own child table >>> >>> Table

Re: [GENERAL] Partitions and indexes

2011-02-26 Thread John R Pierce
On 02/26/11 10:01 AM, Alban Hertroys wrote: On 26 Feb 2011, at 18:04, Amitabh Kant wrote: Now if I partition the table T2 based on field T1id, making sure that each distinct T1id is provided its own child table Table T2C1 (inherited from T2, T1id field only contains 1 for all rows) Table T2C2

Re: [GENERAL] Partitions and indexes

2011-02-26 Thread Alban Hertroys
On 26 Feb 2011, at 18:04, Amitabh Kant wrote: > Now if I partition the table T2 based on field T1id, making sure that each > distinct T1id is provided its own child table > > Table T2C1 (inherited from T2, T1id field only contains 1 for all rows) > Table T2C2 (inherited from T2, T1id field only

Re: [GENERAL] Please help -- Postgres stopped responding ....

2011-02-26 Thread John R Pierce
On 02/26/11 7:04 AM, savio rodriges wrote: Hello Team, I am new to Postgresql. Postgresql suddenly stoped responding. Below is what I checked. [root@server]$/etc/init.d/postgres status dead but pid file exists that probably means the server aborted for some reason without cleaning up. thi

Re: [GENERAL] Partitions and indexes

2011-02-26 Thread Amitabh Kant
On Fri, Feb 25, 2011 at 1:17 PM, Chetan Suttraway < chetan.suttra...@enterprisedb.com> wrote: > > > On Wed, Feb 23, 2011 at 12:52 PM, Amitabh Kant wrote: > >> Hello >> >> If I have partitioned a table based on a foreign key in a manner where >> every child table will only have data for single valu

Re: [GENERAL] PostgreSQL database design for a large company

2011-02-26 Thread Kalai R
Thank You to all for your suggestions. Thank You Craig Ringer. Your suggestions are very useful to me. Now only, I am collecting the data so at present I can't say, How much data I expect. Now I got idea and confident to design my database. Thank you so much.

Re: [GENERAL] Please help -- Postgres stopped responding ....

2011-02-26 Thread Raymond O'Donnell
On 26/02/2011 16:00, savio rodriges wrote: Please let me know how to configure "ERROR REPORTING AND LOGGING" section of postgres.conf to get all necessary postgres information in logfile for debuging/administration purpose. I think you need to look at log_min_messages and log_error_verbosity

Re: [GENERAL] Please help -- Postgres stopped responding ....

2011-02-26 Thread savio rodriges
Hello Raymond, FYI, attach is "ERROR REPORTING AND LOGGING" section from postgres.conf. Following information is from /var/log -bash-3.2$ cd /var/log -bash-3.2$ ls -l mess* -rw--- 1 root root 242 Feb 25 23:14 messages -rw--- 1 root root 110 Feb 16 22:11 messages.1 -rw--- 1 root root

Re: [GENERAL] Website code Pl/pgsql

2011-02-26 Thread franco egizii
Thanks everybody , very useful F. 2011/2/26 Osvaldo Kussama > 2011/2/26, franco egizii : > > Hello, > > do you know some website about Pl/pgsql stored procedure , function and > > other resource (example, code ecc.) ? > > regards and thanks > > Frank > > > > > Like this? > http://www.postgres.cz

Re: [GENERAL] Please help -- Postgres stopped responding ....

2011-02-26 Thread Raymond O'Donnell
On 26/02/2011 15:04, savio rodriges wrote: Hello Team, I am new to Postgresql. Postgresql suddenly stoped responding. Below is what I checked. [root@server]$/etc/init.d/postgres status dead but pid file exists [root@server]$ uptime 20:33:26 up 63 days, 22:57, 4 users, load average: 1.73, 2.2

Re: [GENERAL] views and categorized tables

2011-02-26 Thread Raymond O'Donnell
On 26/02/2011 15:04, Zery wrote: Hi, I'm new in database world, but I know postgres for a long time ago. Now I'm trying to focusing on developing a database using postgresql and postgis extension. I have several question that needs help from all of you. 1. I understand about a view, the lack fo

Re: [GENERAL] views and categorized tables

2011-02-26 Thread David Johnston
1) You can attach RULES to a view in order to make it updatable. Consider as an alternative putting INSERT/UPDATE code into FUNCTIONs 2) You can introduce one level of hierarchy into the database by placing tables into SCHEMAs. Make sure to "SET search_path" so that all schemas are listed. You w

[GENERAL] Please help -- Postgres stopped responding ....

2011-02-26 Thread savio rodriges
Hello Team, I am new to Postgresql. Postgresql suddenly stoped responding. Below is what I checked. [root@server]$/etc/init.d/postgres status dead but pid file exists [root@server]$ uptime 20:33:26 up 63 days, 22:57, 4 users, load average: 1.73, 2.26, 2.43 My questions are, 1. Which postg

[GENERAL] views and categorized tables

2011-02-26 Thread Zery
Hi, I'm new in database world, but I know postgres for a long time ago. Now I'm trying to focusing on developing a database using postgresql and postgis extension. I have several question that needs help from all of you. 1. I understand about a view, the lack for me is I cannot edit a view

Re: [GENERAL] Website code Pl/pgsql

2011-02-26 Thread Osvaldo Kussama
2011/2/26, franco egizii : > Hello, > do you know some website about Pl/pgsql stored procedure , function and > other resource (example, code ecc.) ? > regards and thanks > Frank > Like this? http://www.postgres.cz/index.php/PL/pgSQL_%28en%29 http://wiki.postgresql.org/wiki/Category:Snippets Osv

Re: [GENERAL] Website code Pl/pgsql

2011-02-26 Thread Raymond O'Donnell
On 26/02/2011 12:05, franco egizii wrote: Hello, do you know some website about Pl/pgsql stored procedure , function and other resource (example, code ecc.) ? There's a certain amount on the PostgreSQL wiki: http://wiki.postgresql.org/wiki/Category:Snippets Ray. -- Raymond O'Donnell :: Ga

Re: [GENERAL] Website code Pl/pgsql

2011-02-26 Thread franco egizii
> > Thanks I know it, but I would like a website similar to > > http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=502&lngWId=5 > or http://psoug.org/reference/library.html. > regards > frank > 2011/2/26 Szymon Guz > > >> >> On 26 February 2011 13:05, franco egizii wrote: >> >>>

Re: [GENERAL] Website code Pl/pgsql

2011-02-26 Thread Szymon Guz
On 26 February 2011 13:05, franco egizii wrote: > Hello, > do you know some website about Pl/pgsql stored procedure , function and > other resource (example, code ecc.) ? > regards and thanks > Frank > This one is great: http://www.postgresql.org/docs/9.0/interactive/plpgsql.html regards Szymo

[GENERAL] Website code Pl/pgsql

2011-02-26 Thread franco egizii
Hello, do you know some website about Pl/pgsql stored procedure , function and other resource (example, code ecc.) ? regards and thanks Frank

Re: [GENERAL] finding strings with quotes

2011-02-26 Thread Alban Hertroys
On 25 Feb 2011, at 21:45, Christine Penner wrote: > I'm trying to do a select to find on a char field that has a single quote but > getting errors. This is what I'm doing: > > Select * from f_buildings where B_STRET_LNE_CON='BERLETT\'S ROAD' > > The text I'm trying to find is BERLETT'S ROAD >