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   |/

Tue, 17 Jul 2001 16:23:51 +1000
Philip Warner <pjw@rhyme.com.au>
Re: Odd error...
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_views where 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 FROM ec_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/


Tue, 17 Jul 2001 08:15:57 -0500 (CDT)
"Dominic J. Eidson" <sauron@the-infinite.org>
Re: Odd error...
"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

Tue, 17 Jul 2001 11:42:56 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Odd error... 