Thread: Odd error...
morannon:~>pg_dump -t bboard openacs | less getTables(): SELECT (for VIEW ec_subsubcategories_augmented) returned NULL oid SELECT was: SELECT definition as viewdef, (select oid from pg_rewrite where rulename='_RET' || viewname) as view_oid from pg_views where viewname = 'ec_subsubcategories_augmented'; Any ideas what would cause this? -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli ------------------------------------------------------------------------------- http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/
At 22:12 16/07/01 -0500, Dominic J. Eidson wrote: >morannon:~>pg_dump -t bboard openacs | less >getTables(): SELECT (for VIEW ec_subsubcategories_augmented) returned NULL oid >SELECT was: SELECT definition as viewdef, (select oid from pg_rewrite >where rulename='_RET' || viewname) as view_oid from pg_views where >viewname = 'ec_subsubcategories_augmented'; > >Any ideas what would cause this? Probably the length of the view name; which version are you running? I haven't look at PG for a while, but I thought this was fixed in 7.1.2 ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.B.N. 75 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 0500 83 82 82 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/
On Tue, 17 Jul 2001, Philip Warner wrote:
> At 22:12 16/07/01 -0500, Dominic J. Eidson wrote:
> >morannon:~>pg_dump -t bboard openacs | less
> >getTables(): SELECT (for VIEW ec_subsubcategories_augmented) returned NULL
> oid
> >SELECT was: SELECT definition as viewdef, (select oid from pg_rewrite
> >where rulename='_RET' || viewname) as view_oid from pg_views where
> >viewname = 'ec_subsubcategories_augmented';
> >
> >Any ideas what would cause this?
>
> Probably the length of the view name; which version are you running? I
> haven't look at PG for a while, but I thought this was fixed in 7.1.2
openacs=# select version(); version
-------------------------------------------------------------PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC
2.95.2
(1 row)
(pretty sure that's 7.1.0, btw)
openacs=# SELECT definition as viewdef, (select oid from pg_rewrite where rulename='_RET' || viewname) as view_oid from
pg_viewswhere viewname = 'ec_subsubcategories_augmented';
viewdef
| view_oid
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------SELECT
subsubs.subsubcategory_id,subsubs.subcategory_id, subsubs.subsubcategory_name, subsubs.sort_key, subsubs.last_modified,
subsubs.last_modifying_user,subsubs.modified_ip_address, subs.subcategory_name, cats.category_id, cats.category_name
FROMec_subsubcategories subsubs, ec_subcategories subs, ec_categories cats WHERE ((subsubs.subcategory_id =
subs.subcategory_id)AND (subs.category_id = cats.category_id)); |
As you can see, it gets the "viewdef" part fine, but not the "select oid
from pg_rewrite where ... " part.
--
Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/
"Dominic J. Eidson" <sauron@the-infinite.org> writes:
> On Tue, 17 Jul 2001, Philip Warner wrote:
> Any ideas what would cause this?
>>
>> Probably the length of the view name; which version are you running? I
>> haven't look at PG for a while, but I thought this was fixed in 7.1.2
> PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC 2.95.2
IIRC, that was a post-7.1 bug fix. Update to 7.1.2, or shorten your
view name by a few characters.
regards, tom lane