Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.5
    • Component/s: Platforms
    • Security Level: All
    • Labels:

      Description

      Since version 9.2 PostgreSQL has a new data type for JSON fields: http://www.postgresql.org/docs/9.2/static/datatype-json.html

      The current json_array datatype works on this field if it was not created by Doctrine but manually but it would be nice to support the field type also for schema generation.

      I can offer a Pull Request for this change but I have not found a method for determining the database version.

        Issue Links

          Activity

          Martin Prebio created issue -
          Hide
          Daniel Londero added a comment -

          It would be great to have JSON datatype! In the mean time the solution is creating a "Custom Mapping Type", right?

          Show
          Daniel Londero added a comment - It would be great to have JSON datatype! In the mean time the solution is creating a "Custom Mapping Type", right?
          Hide
          Steve Müller added a comment -

          Benjamin Eberlei We could adopt the GuidType implementation here with checking on the platform if it supports native json type and use that instead. What do you think?

          Show
          Steve Müller added a comment - Benjamin Eberlei We could adopt the GuidType implementation here with checking on the platform if it supports native json type and use that instead. What do you think?
          Steve Müller made changes -
          Field Original Value New Value
          Assignee Benjamin Eberlei [ beberlei ] Steve Müller [ deeky666 ]
          Steve Müller made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Hide
          Steve Müller added a comment -
          Show
          Steve Müller added a comment - Patch supplied in PR: https://github.com/doctrine/dbal/pull/469
          Hide
          Doctrine Bot added a comment -

          A related Github Pull-Request [GH-469] was closed:
          https://github.com/doctrine/dbal/pull/469

          Show
          Doctrine Bot added a comment - A related Github Pull-Request [GH-469] was closed: https://github.com/doctrine/dbal/pull/469
          Benjamin Eberlei made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Fix Version/s 2.5 [ 10523 ]
          Resolution Fixed [ 1 ]
          Hide
          Benedikt Allendorf added a comment -

          It seems that this feature is already in the documentation (http://doctrine-dbal.readthedocs.org/en/latest/reference/types.html#mapping-matrix) although it is only included in the next version of DBAL (2.5).

          Show
          Benedikt Allendorf added a comment - It seems that this feature is already in the documentation ( http://doctrine-dbal.readthedocs.org/en/latest/reference/types.html#mapping-matrix ) although it is only included in the next version of DBAL (2.5).
          Steve Müller made changes -
          Link This issue is duplicated by DBAL-815 [ DBAL-815 ]

          This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

          • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DBAL-553, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

            People

            • Assignee:
              Steve Müller
              Reporter:
              Martin Prebio
            • Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: