Doctrine DBAL

PostgreSQL Session init

Details

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

Description

During PostgreSQL Session init it may be interesting to set the search path to a different value than the default.

Activity

Hide
Permalink
Benjamin Eberlei added a comment -

Implemented a generic SQLSessionInit listener that executes a single sql command after connection initializtion.

Example usage:

$evm->addEventListener(new SQLSessionInit("SET SEARCH_PATH TO foo, public, TIMEZONE TO 'Europe/Berlin'"));
$conn = DriverManager::getConnection($params, $config $evm);
Show
Benjamin Eberlei added a comment - Implemented a generic SQLSessionInit listener that executes a single sql command after connection initializtion. Example usage: $evm->addEventListener( new SQLSessionInit( "SET SEARCH_PATH TO foo, public , TIMEZONE TO 'Europe/Berlin'" )); $conn = DriverManager::getConnection($params, $config $evm);

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Benjamin Eberlei
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: