Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP

Loading…

Consider different schemas in the Table Data functions #158

Closed
bitbucket-import opened this Issue · 5 comments

5 participants

@bitbucket-import

In my test environment I have a postgres database where the tables aren't under the "public" schema. The Table Data functions aren't able to find my tables. Ex:
My schema is named foo and I have a table named bar. The following code will show false.

$this->load->database();
var_dump($this->db->table_exists('bar'));

I've attached a patch that solves this issue by allowing me to indicate at the database configuration which schemas I want to use. Maybe it's not the correct approach to the project but I like CodeIgniter and wanted to help somehow. Nice work guys!

@jflow

Any news on this? I use postgresql and need the ability to use schemas other than public. Will the mentioned patch work with the current-stable/development builds of CI? If it will can I get access to it as it doesn't appear to be available at the moment?

@mckaygerhard

heloo, any news over patch!?

@alexbilbie

I've not been able to find the old patch that was submitted when CI was hosted on Bitbucket so someone else is going to have to recreate and submit this patch

@mckaygerhard

its possible that the codeigniter oracle patch could works? remenber that oracle always use shemas...

@narfbg
Owner

Oracle's schemas represent the username that accesses data in them, so that's a non-issue there.

@narfbg narfbg closed this in 485a348
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.