Re: [GENERAL] [SQL] syntax error in createdb

2007-05-07 Thread Phillip Smith
Where are you trying to execute these commands? They should be run at the command line as they are 'standalone' programs, not SQL commands to be run in an SQL session. On Mon, 2007-05-07 at 10:01 +0100, kannan kk wrote: hello when i try to execute createdb,psql,pg_dump,pg_restore and similar

Re: [GENERAL] [ADMIN] Backup

2008-01-24 Thread Phillip Smith
We have a center in Europe who has just started to use PostgreSQL and was asking me if there are any Symantec product or other products that backup this type of database. It doesn't appear to. I've just been through the whole rigmarole of BackupExec for some Windows Servers, and I couldn't

[GENERAL] Case Sensitivity

2011-01-13 Thread Phillip Smith
. This is a workaround for point (2) but does not remedy point (1) above. Many thanks Phillip Phillip Smith

Re: [GENERAL] Case Sensitivity

2011-01-13 Thread Phillip Smith
Thanks Pavel, Is this the only way?. I would prefer to use a collation setting if this is possible. Do you know whether there would be a performance hit using non standard character strings? Phillip

Re: [GENERAL] Case Sensitivity

2011-01-13 Thread Phillip Smith
Hi Karsten, modifying user inputted data is not an option for me. I need to maintain the original data. I had read about indexing on a lower function. This all seems a bit of a bodgy workaround to me. A clean Case Insensitive collation setting is cleaner. Is this supported in postgreSQL 9?

Re: [GENERAL]

2010-08-04 Thread Phillip Smith
On 5 August 2010 11:54, andi astowo andi.ast...@ymail.com wrote: At this oppurtinity we ask for your support to give us informations regarding the bellow questionaires. First, how can we have our data of the Postgre 7 under Red Hat Linux 7.2 to be used by the Postgre 8 under RHEL 5?.

Re: [GENERAL] MySQL versus Postgres

2010-08-06 Thread Phillip Smith
On 6 August 2010 16:08, Torsten ZĂĽhlsdorff f...@meisterderspiele.de wrote: I receive my oh wow when i do the same things in Postgres like in MySQL: Writting some procedures, triggers and use foreign key. The oh wow was that it just *works*. After some years of using MySQL this is a very