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 : > ... > > Two. Partitioning is n

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 wrote: > Hi, > I am running postgreSQL

[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 tim

Re: [GENERAL] very large tables

Try partitioning. It should sort you out. -Peter- On 5/25/09, Ramiro Diaz Trepat 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 and MatLab, when I

Re: [GENERAL] text_soundex function

hu, Dec 18, 2008 at 10:26 AM, Chris 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/fuz

[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.

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 im

[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 alre