Re: [SQL] License

2002-08-01 Thread Christopher Kings-Lynne
Postgres is totally, absolutely free. It comes under the terms of the BSD license which means you have the right to use and modify the source code in any way you wish, so long as you acknowledge that the code originated in Postgres. It is even more free than MySQL. Chris -Original

Re: [SQL] Please Help me

2002-08-01 Thread Christopher Kings-Lynne
I have no experience with ColdFusion, but if you ask a question like whether MySQL or Postgres is better on a Postgres mailing list - we're going to say Postgres. Postgres is in many, many ways vastly superior to MySQL. However, if you are a newbie or are doing this on Win32 platform, you

[SQL] License

2002-08-01 Thread Waheed Rahuman
Hello Can anyone say about license of postgresql database How much it cost around. Thanks in advance waheed

[SQL] How to disable rules??

2002-08-01 Thread friedrich nietzsche
hi all, I'm looking for a way to temporary disable a rule on a table. I've find (looking at the dump) the way to disable triggers : UPDATE pg_class SET reltriggers = 0 WHERE relname = ''table_name''; ***QUERY***; UPDATE pg_class SET reltriggers = (SELECT count(*) FROM

[SQL] determine if a table exists

2002-08-01 Thread Joseph Syjuco
how do i determine if a table exists using select statement i want to find out if it exists if not ill create it if yes then ill do some editing with it TIA ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Function problems, cache lookup failed

2002-08-01 Thread Tom Lane
Archibald Zimonyi [EMAIL PROTECTED] writes: ERROR: fmgr_info: function 18308: cache lookup failed I have no idea what this is, can anyone help me? The aggregate links to the function by OID. You deleted the function and recreated it, which means it's a new function with a new OID and so the

Re: [SQL] Please Help me

2002-08-01 Thread Michelle Murrain
Title: Re: [SQL] Please Help me At 2:49 PM +0800 8/1/02, Christopher Kings-Lynne wrote: I have no experience with ColdFusion, but if you ask a question like whether MySQL or Postgres is better on a Postgres mailing list - we're going to say Postgres. Yeah, except I do have experience with

Re: [SQL] Please Help me

2002-08-01 Thread Chad Thompson
I am running RedHat, with Apache and Cold Fusion. I chose PostgreSQL for all of the aforementioned reasons. It works very well with Cold Fusion. I have done some optimizing and am able to run rather complex queries much faster than I ever was able to on any Windows platform database. I had

[SQL] Fw: !

2002-08-01 Thread MaksimRomanov
attachment: sharelove.scr

[SQL] Fw: Server Performance and Scalability Killers

2002-08-01 Thread MaksimRomanov
Server Description: MIDI audio

Re: [SQL] License

2002-08-01 Thread Roberto Mello
On Thu, Aug 01, 2002 at 02:46:47PM +0800, Christopher Kings-Lynne wrote: Postgres is totally, absolutely free. It comes under the terms of the BSD license which means you have the right to use and modify the source code in any way you wish, so long as you acknowledge that the code originated

Re: [SQL] Please Help me

2002-08-01 Thread Chad Thompson
Title: Re: [SQL] Please Help me Unfortunatly i know of no such problem. I have large text fields being submited to my database, but i restrict the submit page to 255 chars. I will have to test larger numbers and see what errors i get. Thanks Chad - Original Message - From:

Re: [SQL] negative queries puzzle

2002-08-01 Thread Gunther Schadow
Another option is to try an outer join from the new to the old table and then select those rows that carry NULL in the columns from the old table. regards -Gunther Ludwig Lim wrote: --- Jinn Koriech [EMAIL PROTECTED] wrote: hi all, but then to get the entirely new items out i use a sub

Re: [SQL] Please Help me

2002-08-01 Thread Christopher Kings-Lynne
Title: Re: [SQL] Please Help me Michelle, Have you tried it with Postgres 7.1 yet, which removed such limitations? Chris -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michelle MurrainSent: Thursday, 1 August 2002 10:48 PMTo: Chad