well i've tried the search_path for postgres.. more like their answer for oracle's synonyms. but anyway its now currently working. the next problem is postgres' double quotations. :D
On Apr 1, 9:38 am, "jmgtan" <[EMAIL PROTECTED]> wrote: > tried it, doesn't seem to work. I tried changing my table definitions > in schema.xml to <table name='core."USERS"' phpName="CoreUsers">...</ > table>, but propel can't seem to get the final query right > > On Mar 31, 10:23 pm, Joby Walker <[EMAIL PROTECTED]> wrote: > > > [Also not having tried it, but....] > > > Have you tried just using the fully qualified names for the table names? > > > So: > > > Schema 'foo', Table 'bar' -> 'foo.bar', > > Schema 'public', Table 'bob' -> 'public.bob' > > > jbw > > > [EMAIL PROTECTED] wrote: > > > Hi, > > > > i use postgres and symfony and i think i remember some infos i'd like > > > to share with you. > > > > As far as i know posgres schemas are postgres specific. I read > > > somewhere a recommendation > > > in the docs there, that if you want to keep your database portable, > > > you schouldn't use schemas at all. > > > > Also, you should look in the propel docs to find an answer. But i bet, > > > because propel must be > > > database independent, that postgres schemas are not implemented. > > > > I hope this helps you. > > > Michael > > > > On 31 Mrz., 06:49, "jmgtan" <[EMAIL PROTECTED]> wrote: > > >> Hi guys, i've been using symfony for the past four months already and > > >> still haven't found a way to let propel or doctrine understand > > >> postgres schemas, currently I put all the tables in the public schema, > > >> but right now i need to access legacy data in different schemas.. how > > >> do you do this? > > > >> Thanks, > > >> jmgtan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
