Re: Strict mode in postgresql??

On 06/23/2013 10:33 PM, Andreas Kretschmer wrote:
>
> Arun P.L <arunpl@hotmail.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