230 reputation
413
bio website
location
age
visits member for 2 years, 11 months
seen Aug 17 at 10:08

Free-Thinker, Individualist, INTP


Nov
11
awarded  Notable Question
Oct
11
awarded  Notable Question
Sep
24
awarded  Autobiographer
Jul
2
awarded  Curious
Mar
17
awarded  Notable Question
Nov
25
awarded  Popular Question
Sep
16
awarded  Popular Question
Apr
9
awarded  Popular Question
Apr
7
awarded  Popular Question
Nov
28
awarded  Yearling
Sep
21
awarded  Custodian
Sep
3
comment PostgreSQL 9.1 vs MySQL 5.6 with InnoDB ? Which is better for scaling?
Thanks for the insight. +1.
Aug
27
comment WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
BTW, used ALTER ROLE user SET search_path TO "$user",public; to set the search path. Although, $user is useless as I do not have any schema named after the current users.
Aug
27
accepted WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
Aug
27
comment WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
@JackDouglas It was a search path problem for the user I was trying to login as. I am guessing I had created the user when I had done a session-wise set search_path to some other schema and instead of the default '"$user",public' it was set to the other schema. The user did not have any access to public schema at all. Thanks to Daniel Vérité for pointing me in the right direction.
Aug
27
comment WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
It was a search path problem for the user I was trying to login as. I am guessing I had created the user when I had done a session-wise set search_path to some other schema and instead of the default '"$user",public' it was set to the other schema. The user did not have any access to public schema at all. Thanks for pointing me in the right direction.
Aug
27
comment WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
@JackDouglas Yes, I have.. it works as excepted. CITEXT does gets recognized as a valid datatype. And the result is a single row.
Aug
27
comment WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
@JackDouglas both the installations have the same user and same grant permissions
Aug
27
asked WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
Aug
15
revised Starting PostgreSQL server after a HDD crash results in FAILED STATE
added 60 characters in body