diff options
author | Tomasz Kubacki <tomasz.kubacki@gmail.com> | 2011-04-08 08:07:06 +0400 |
---|---|---|
committer | Lluis Sanchez <slluis.devel@gmail.com> | 2011-04-08 11:45:28 +0400 |
commit | f9d55b2456a855c80c59eaff6c60a9f3123dac2d (patch) | |
tree | 755505d4a9594ea81d0baef4e9871988e0264b1a /extras/MonoDevelop.Database | |
parent | b32e6a438d16431821fc051dffb91febf117d3cf (diff) |
fixed fetching postgresql columns
Diffstat (limited to 'extras/MonoDevelop.Database')
-rw-r--r-- | extras/MonoDevelop.Database/MonoDevelop.Database.Sql.Npgsql/NpgsqlSchemaProvider.cs | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/extras/MonoDevelop.Database/MonoDevelop.Database.Sql.Npgsql/NpgsqlSchemaProvider.cs b/extras/MonoDevelop.Database/MonoDevelop.Database.Sql.Npgsql/NpgsqlSchemaProvider.cs index 20f341a322..71b7fec0f1 100644 --- a/extras/MonoDevelop.Database/MonoDevelop.Database.Sql.Npgsql/NpgsqlSchemaProvider.cs +++ b/extras/MonoDevelop.Database/MonoDevelop.Database.Sql.Npgsql/NpgsqlSchemaProvider.cs @@ -113,11 +113,10 @@ using Npgsql; a.attname,
a.attnotnull,
a.attlen,
- typ.typname,
+ t.typname,
adef.adsrc
FROM
- pg_catalog.pg_attribute a,
- pg_catalog.pg_type typ
+ pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_attrdef adef ON
a.attrelid=adef.adrelid
AND a.attnum=adef.adnum
@@ -130,7 +129,7 @@ using Npgsql; WHERE relname='{0}')
AND a.attnum > 0
AND NOT a.attisdropped
- AND a.atttypid = typ.oid
+ AND a.atttypid = t.oid
ORDER BY a.attnum;", table.Name))) {
try {
using (IDataReader r = command.ExecuteReader()) {
|