Re: Strict mode in postgresql?? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Strict mode in postgresql??
Date
Msg-id 51C866D3.6000909@commandprompt.com
Whole thread Raw
In response to Re: Strict mode in postgresql??  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
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


pgsql-general by date:

Previous
From: boraldomaster
Date:
Subject: Re: Index scan and bitmap index scan - hard to understand how planner chooses
Next
From: Jashaswee
Date:
Subject: Re: postgresql query