From a0255d22d0ec28d0542821bcb7f64945cdf44ef8 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Thu, 31 Aug 2006 23:58:34 +0000 Subject: since casing is figured out quasi-automatically when creating table/column/etc, removed casing checks within pg reflection --- lib/sqlalchemy/databases/postgres.py | 12 +++--------- 1 file changed, 3 insertions(+), 9 deletions(-) (limited to 'lib/sqlalchemy/databases/postgres.py') diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py index ff123ff00..8234d96f0 100644 --- a/lib/sqlalchemy/databases/postgres.py +++ b/lib/sqlalchemy/databases/postgres.py @@ -339,7 +339,6 @@ class PGDialect(ansisql.ANSIDialect): break found_table = True name = row['attname'] - natural_case = preparer._is_natural_case(name) ## strip (30) from character varying(30) attype = re.search('([^\(]+)', row['format_type']).group(1) @@ -372,7 +371,7 @@ class PGDialect(ansisql.ANSIDialect): colargs= [] if default is not None: colargs.append(PassiveDefault(sql.text(default))) - table.append_item(schema.Column(name, coltype, nullable=nullable, case_sensitive=not natural_case, *colargs)) + table.append_item(schema.Column(name, coltype, nullable=nullable, *colargs)) if not found_table: @@ -434,17 +433,14 @@ class PGDialect(ansisql.ANSIDialect): referred_table = preparer._unquote_identifier(referred_table) referred_columns = [preparer._unquote_identifier(x) for x in f.search(referred_columns).groups() if x] - natural_case = preparer._is_natural_case(referred_table) - refspec = [] if referred_schema is not None: - natural_case_schema = preparer._is_natural_case(referred_schema) schema.Table(referred_table, table.metadata, autoload=True, schema=referred_schema, - autoload_with=connection, case_sensitive= not natural_case, case_sensitive_schema = not natural_case_schema) + autoload_with=connection) for column in referred_columns: refspec.append(".".join([referred_schema, referred_table, column])) else: - schema.Table(referred_table, table.metadata, autoload=True, autoload_with=connection, case_sensitive=not natural_case) + schema.Table(referred_table, table.metadata, autoload=True, autoload_with=connection) for column in referred_columns: refspec.append(".".join([referred_table, column])) @@ -553,7 +549,5 @@ class PGIdentifierPreparer(ansisql.ANSIIdentifierPreparer): if value[0] == self.initial_quote: value = value[1:-1].replace('""','"') return value - def _is_natural_case(self, value): - return self._fold_identifier_case(value) == value dialect = PGDialect -- cgit v1.2.1