cfdbinfo and PostgreSQL schemas

27 views
Skip to first unread message

Seb Duggan

unread,
Oct 15, 2016, 4:28:55 AM10/15/16
to Lucee
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

Igal @ Lucee.org

unread,
Oct 15, 2016, 1:24:36 PM10/15/16
to lu...@googlegroups.com

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


Igal Sapir
Lucee Core Developer
Lucee.org

--
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 https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp
---
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+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/74bec069-27ec-4266-9a4f-558b6af2a60f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Seb Duggan

unread,
Oct 15, 2016, 2:12:43 PM10/15/16
to lu...@googlegroups.com
Currently the 8.3 one from the extension. Might try and see what happens with the new driver...
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+un...@googlegroups.com.

To post to this group, send email to lu...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages