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 |/
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html