Re: ltree and PHP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Open _ <opensheart(at)yahoo(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: ltree and PHP
Date: 2021-02-05 05:33:03
Message-ID: 79711.1612503183@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Open _ <opensheart(at)yahoo(dot)com> writes:
> I've created the ltree extensioncreated a table with an ltree column called ltree_path
> In php I can access the table, insert, update, delete.but ltree operators don't work.

It sounds like the ltree extension is in a schema that's not in the
search_path setting you're using from PHP.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Atul Kumar 2021-02-05 08:15:39 Re: vacuumdb not letting me connect to db
Previous Message Jagmohan Kaintura 2021-02-05 05:27:37 updating(column) Porting from Oracle Trigger to PostgreSQL trigger