Re: [SQL] regexp_replace and search/replace values stored in table

2010-05-02 Thread Sofer, Yuval 
Hi 

Postgres crashes with -

PG "FATAL:  could not reattach to shared memory (key=5432001, addr=0210): 
Invalid argument.

The version is 8.2.4, the platform is win32

Does someone know the reason/workaround ? 

Thanks, 
Yuval Sofer
BMC Software
CTM&D Business Unit
DBA Team
972-52-4286-282
[email protected]



-Original Message-
From: [email protected] [mailto:[email protected]] On 
Behalf Of Leif Biberg Kristensen
Sent: Saturday, May 01, 2010 8:29 PM
To: [email protected]
Subject: Re: [SQL] regexp_replace and search/replace values stored in table

Followup II: I've written a blog post on the subject at 
.
 
regards,
-- 
Leif Biberg Kristensen
http://solumslekt.org/

-- 
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


-- 
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

[SQL] Prevent Domain Compare

2010-05-02 Thread Kaveh Mousavi Zamani 
Hi,

Is there a way that when I have to fields like
F1 Domain1_Type
F2 Domain2_Type

I prevent comparison between this two fields. I mean I make them somehow
in-compatible?!

They are eventually TEXT but I want to prevent it from SQL level.

Best Regards,
Kaveh

-- 
The GNU Operating System
Free as in Freedom
http://www.gnu.org