[ubuntu-mono] [Bug 1031149] [NEW] fsgateway cannot list postgreSQL tables

[zasran]

Public bug reported:

When trying to list postgreSQL tables (ls /mountpoint/tables) I get the
following error:

Exception reading of the tables list : ERROR: 42703: column "oid" does not exist
Postgresql Version: 9.0.4
List tables: SQL=SELECT (SELECT oid FROM pg_class WHERE relname = 'pg_class') AS tableoid      , oid      , relname      , relacl      , CASE WHEN relhasrules and relkind = 'r' and EXISTS(SELECT rulename FROM pg_rewrite r WHERE r.ev_class = c.oid AND r.ev_type = '1')                  THEN '%c'::"char"                  ELSE relkind END AS relkind      , 0::oid as relnamespace      , (relowner) as rolname      , relchecks      , reltriggers      , relhasindex      , relhasrules      , 't'::bool as relhasoids      , NULL::oid as owning_tab      , NULL::int4 as owning_col      , NULL as reltablespace      , n.nspname as namespace      , NULL as reloptions from pg_class c left join pg_namespace n on n.oid = c.relnamespace where relkind = 'r'   and n.nspname not in ('pg_catalog', 'information_schema') order by oid

Listing of other entities works (no errors from indexes, views,
sequencies, even though I only have data for indexes, no sequencies or
views).

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: fsgateway 0.1.1-2build2
ProcVersionSignature: Ubuntu 3.2.0-27.43-generic 3.2.21
Uname: Linux 3.2.0-27-generic x86_64
ApportVersion: 2.0.1-0ubuntu11
Architecture: amd64
Date: Mon Jul 30 17:32:55 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
ProcEnviron:
 TERM=xterm
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: fsgateway
UpgradeStatus: No upgrade log present (probably fresh install)

** Affects: fsgateway (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug precise running-unity

-- 
You received this bug notification because you are a member of Ubuntu
CLI/Mono Uploaders, which is subscribed to fsgateway in Ubuntu.
https://bugs.launchpad.net/bugs/1031149

Title:
  fsgateway cannot list postgreSQL tables

Status in “fsgateway” package in Ubuntu:
  New

Bug description:
  When trying to list postgreSQL tables (ls /mountpoint/tables) I get
  the following error:

  Exception reading of the tables list : ERROR: 42703: column "oid" does not exist
  Postgresql Version: 9.0.4
  List tables: SQL=SELECT (SELECT oid FROM pg_class WHERE relname = 'pg_class') AS tableoid      , oid      , relname      , relacl      , CASE WHEN relhasrules and relkind = 'r' and EXISTS(SELECT rulename FROM pg_rewrite r WHERE r.ev_class = c.oid AND r.ev_type = '1')                  THEN '%c'::"char"                  ELSE relkind END AS relkind      , 0::oid as relnamespace      , (relowner) as rolname      , relchecks      , reltriggers      , relhasindex      , relhasrules      , 't'::bool as relhasoids      , NULL::oid as owning_tab      , NULL::int4 as owning_col      , NULL as reltablespace      , n.nspname as namespace      , NULL as reloptions from pg_class c left join pg_namespace n on n.oid = c.relnamespace where relkind = 'r'   and n.nspname not in ('pg_catalog', 'information_schema') order by oid

  Listing of other entities works (no errors from indexes, views,
  sequencies, even though I only have data for indexes, no sequencies or
  views).

  ProblemType: Bug
  DistroRelease: Ubuntu 12.04
  Package: fsgateway 0.1.1-2build2
  ProcVersionSignature: Ubuntu 3.2.0-27.43-generic 3.2.21
  Uname: Linux 3.2.0-27-generic x86_64
  ApportVersion: 2.0.1-0ubuntu11
  Architecture: amd64
  Date: Mon Jul 30 17:32:55 2012
  EcryptfsInUse: Yes
  InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: fsgateway
  UpgradeStatus: No upgrade log present (probably fresh install)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/fsgateway/+bug/1031149/+subscriptions