Cfdbinfo and PostgreSQL schemas

dev google-group-archive
1

If I do cfdbinfo against a PostgreSQL database - for instance, to get a
list of tables, or detect if a table exists - it will return results for
all schemas within that database (even if the db user doesn’t have
permissions on the other schemas).

Is there a way to restrict this to simply look in the current (or
explicitly defined) schema?

I have an issue where a second instance of an app will not initialise the
tables it needs, because cfdbinfo is telling it that the tables already
exist - but they are in a different schema.

Thanks,

Seb

2

I would think that this is under the responsibility of the driver.
Which driver are you using?

Igal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/On 10/15/2016 1:28 AM, Seb Duggan wrote:

If I do cfdbinfo against a PostgreSQL database - for instance, to
get a list of tables, or detect if a table exists - it will return
results for all schemas within that database (even if the db user
doesn’t have permissions on the other schemas).

Is there a way to restrict this to simply look in the current (or
explicitly defined) schema?

I have an issue where a second instance of an app will not initialise
the tables it needs, because cfdbinfo is telling it that the tables
already exist - but they are in a different schema.

Thanks,

Seb

Get 10% off of the regular price for this years CFCamp in Munich,
Germany (Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp.
189€ instead of 210€. Visit
CFCamp 2016

You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+unsubscribe@googlegroups.com
mailto:lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com
mailto:lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/74bec069-27ec-4266-9a4f-558b6af2a60f%40googlegroups.com
https://groups.google.com/d/msgid/lucee/74bec069-27ec-4266-9a4f-558b6af2a60f%40googlegroups.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.

3

Currently the 8.3 one from the extension. Might try and see what happens
with the new driver…On 15 October 2016 at 18:24:37, Igal @ Lucee.org (@Igal) wrote:

I would think that this is under the responsibility of the driver. Which
driver are you using?

Igal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/
On 10/15/2016 1:28 AM, Seb Duggan wrote:

If I do cfdbinfo against a PostgreSQL database - for instance, to get a
list of tables, or detect if a table exists - it will return results for
all schemas within that database (even if the db user doesn’t have
permissions on the other schemas).

Is there a way to restrict this to simply look in the current (or
explicitly defined) schema?

I have an issue where a second instance of an app will not initialise the
tables it needs, because cfdbinfo is telling it that the tables already
exist - but they are in a different schema.

Thanks,

Seb

Get 10% off of the regular price for this years CFCamp in Munich, Germany
(Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€ instead
of 210€. Visit CFCamp 2016

You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/74bec069-27ec-4266-9a4f-558b6af2a60f%40googlegroups.com
https://groups.google.com/d/msgid/lucee/74bec069-27ec-4266-9a4f-558b6af2a60f%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
Get 10% off of the regular price for this years CFCamp in Munich, Germany
(Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€ instead
of 210€. Visit CFCamp 2016

You received this message because you are subscribed to a topic in the
Google Groups “Lucee” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/lucee/8Zn_ndysEE0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/7de1bb4c-0971-28cb-a55a-45d39eff5f7a%40lucee.org
https://groups.google.com/d/msgid/lucee/7de1bb4c-0971-28cb-a55a-45d39eff5f7a%40lucee.org?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.