From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Strict mode in postgresql?? |
Date: | 2013-06-24 15:33:39 |
Message-ID: | 51C866D3.6000909@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 06/23/2013 10:33 PM, Andreas Kretschmer wrote:
>
> Arun P.L <arunpl(at)hotmail(dot)com> wrote:
>
>> Hi,
>>
>> Is there any settings in postgresql version 9.2 similar to mysql strict mode? I
>> need to get rid of some type casting errors in the upgrading process from
>> version 7.4 to 9.2, if this mode is not available I have to modify queries in
>> the system to make it work...
>
> No, there isn't such an option.
>
> If you now on 9.2 and there are problems with missings casts, you can
> recreate that, read
> http://petereisentraut.blogspot.de/2008/03/readding-implicit-casts-in-postgresql.html
Or fix the casting which is the real problem.
JD
>
>
> Andreas
>
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms
a rose in the deeps of my heart. - W.B. Yeats
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2013-06-24 16:18:07 | Re: pg_largeobject.sql script not run after upgrade |
Previous Message | boraldomaster | 2013-06-24 15:26:58 | Re: Index scan and bitmap index scan - hard to understand how planner chooses |