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(*)
FR
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
>
> 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
>
do
SELECT relname FROM pg_class
WHERE relkind='r'
AND relname !~ '^pg_'
AND relname !~ '^pga_'
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 t
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 ColdFu
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 h
<>
Server
Description: MIDI audio
Title: Re: [SQL] Please Help me
At 8:32 AM -0600 8/1/02, Chad Thompson wrote:
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 m
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 originate
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:
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 u
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 Thomp
13 matches
Mail list logo
