the type is not recognized but the reflection operation should
succeed. thats why you're only getting a warning on those.
On Nov 29, 2008, at 8:00 AM, [EMAIL PROTECTED] wrote:
>
> Or maybe this is my problem
>
> /home/jchesney/workspace/sqlalchemy/lib/sqlalchemy/engine/base.py:
> 1237: SAWarning: Did not recognize type 'name' of column 'USERNAME'
> self.dialect.reflecttable(conn, table, include_columns)
> /home/jchesney/workspace/sqlalchemy/lib/sqlalchemy/engine/base.py:
> 1237: SAWarning: Did not recognize type 'name' of column 'SCHEMA_NAME'
> self.dialect.reflecttable(conn, table, include_columns)
> /home/jchesney/workspace/sqlalchemy/lib/sqlalchemy/engine/base.py:
> 1237: SAWarning: Did not recognize type 'name' of column 'TABLE_NAME'
> self.dialect.reflecttable(conn, table, include_columns)
> /home/jchesney/workspace/sqlalchemy/lib/sqlalchemy/engine/base.py:
> 1237: SAWarning: Did not recognize type 'name' of column 'FIELD_NAME'
> self.dialect.reflecttable(conn, table, include_columns)
>
> I use the 'name' column data type for my columns.
> Its a postgresql database.
>
> engine = create_engine('postgres://.........')
>
> engine
> metadata = MetaData()
> metadata.reflect(engine,'xxxx')
>
> for t in metadata.tables.values():
> print t.fullname
> for c in t.columns:
> print "\t" + c.name
>
> I get a partial listing which as two different schemas in it. Is the
> reflect bombing out when it hits the above errors?
> If so, I will need to try and get sqlalchemy to accept this field
> type.
>
> Regards, Jar
>
> On Nov 29, 10:34 pm, "[EMAIL PROTECTED]"
> <[EMAIL PROTECTED]> wrote:
>> Hi
>> I was wondering if there was a way to reflect all schemas in the
>> metadata, or get a list of schemas in the database with out querying
>> the catalog for postgresql.
>>
>> Regards, Jar
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
