Re: PostgreSQL view is not listed
Seb <[email protected]> Wed, 17 Feb 2010 08:27:12 -0600
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Organization | Church of Emacs |
| Message-ID | <[email protected]> |
On Sun, 14 Feb 2010 20:52:28 +0100, "Frank Schoenheit, Sun Microsystems Germany" <[email protected]> wrote: [...] > Except Tools / Table Filter (which sounds unlikely) ... no. > You could try to find out what's different about this view by writing > a small macro which examines the result of > ThisDatabaseDocument.CurrentController.ActiveConnection.MetaData.getTables(), > perhaps this gives an idea. OK, I eventually found what's going on. Before adding the view, I had used "Tools -> Table Filter" and had selected only the stuff on the public schema selected. I had assumed that by having the check mark on the public schema, everything added to it would also be checked. After expanding the public schema in the Table Filter I saw that this doesn't happen. So making sure it is checked worked, duh! Thanks! -- Seb