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 yuv

[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