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

[Torello Querci]

Bug already fixed in latest code version.

New package need to be released.

** Changed in: fsgateway (Ubuntu)
       Status: New => Confirmed

** Changed in: fsgateway (Ubuntu)
     Assignee: (unassigned) => Torello Querci (tquerci)

-- 
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:
  Confirmed

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