Re: [GENERAL] How Big is Too Big for Tables?

There are Postgres Enterprise solutions available although I think they are commercial. You may want to take a look and see if they can be helpful to you. On Wed, Jul 28, 2010 at 8:44 PM, Vincenzo Romano vincenzo.rom...@notorand.it wrote: 2010/7/28 P Kishor punk.k...@gmail.com: ... Two.

Re: [GENERAL] xpath

Allan, Postgres is very strict on variable types and char conversion. I have a feeling you are trying to access data from a varchar feild using an integer... Can you paste here your schema for that table? P. On Wed, Feb 10, 2010 at 11:06 AM, Allan Kamau kamaual...@gmail.com wrote: Hi, I am

[GENERAL] Granting rights

Hi, Is it possible to give a user rights(update,select,insert) rights on a database and not necessary doing that for one relation at a time? I have many tables in the database but I don't want this user to be able to delete a relation. Granting the user rights per table is gonna take a lot of

Re: [GENERAL] very large tables

Try partitioning. It should sort you out. -Peter- On 5/25/09, Ramiro Diaz Trepat ram...@diaztrepat.name wrote: Hello list,I will try to make this as brief as possible. I have a brother who is a scientist studding atmospheric problems. He was trying to handle all of his data with flat files

Re: [GENERAL] text_soundex function

, 2008 at 10:26 AM, Chris dmag...@gmail.com wrote: Otandeka Simon Peter wrote: Does this function(text_soundex) exist in the latest Postgresql versions or it was replaced? It's called soundex: http://www.postgresql.org/docs/8.3/interactive/fuzzystrmatch.html -- Postgresql php tutorials

[GENERAL] text_soundex function

Does this function(text_soundex) exist in the latest Postgresql versions or it was replaced? Any example on how to use it?

[GENERAL] Recover data for one table from database dump

Hi, I need to know how I can easily get data for just one table from postgres dump database backup. Kind regards, P.

[GENERAL] Import db from 8.1.3 to 8.3.1

Hi All, I am trying to import db from 8.1.3 to 8.3.1 database however I get some characters \x09\x09\x09\x09. I know this is an error in 8.3.1 that was fixed in later updates however is there a way of getting around it without going all over again and remain with 8.3.1 database where I have

Re: [GENERAL] Import db from 8.1.3 to 8.3.1

Upgraded to 8.3.4 but am still getting the same error Anything I can do about it? On Thu, Oct 23, 2008 at 4:35 PM, Andrew Sullivan [EMAIL PROTECTED] wrote: On Thu, Oct 23, 2008 at 12:58:39PM +0300, Otandeka Simon Peter wrote: Hi All, I am trying to import db from 8.1.3 to 8.3.1 database