Postgres not finding new table in Relational Model Data

Posts   
 
    
joenathan
User
Posts: 27
Joined: 28-Jun-2011
# Posted on: 03-Oct-2011 21:35:41   

I have a model first approach project that I have been working on getting LLBLGEN to work with Postgres. However I am implementing ELMAH for error logging and it comes with it's own table definition. I have added the table to my Postgres DB and then I refresh the relational model from a database. I don't get any errors, it shows me the schema to pull in (no tables though, so I dunno if that's weird), then finishes with no errors. However the new elmah_error table doesn't appear under the relational model data. I have the definition for the new table...

CREATE TABLE ELMAH_Error ( ErrorId CHAR(36) NOT NULL, Application VARCHAR(60) NOT NULL, Host VARCHAR(50) NOT NULL, Type VARCHAR(100) NOT NULL, Source VARCHAR(60) NOT NULL, Message VARCHAR(500) NOT NULL, "User" VARCHAR(50) NOT NULL, StatusCode INT NOT NULL, TimeUtc TIMESTAMP NOT NULL, Sequence INT NOT NULL DEFAULT NEXTVAL('ELMAH_Error_SEQUENCE'), AllXml TEXT NOT NULL );

is there something in that table that is out of the ordinary or would cause LLBLGEN to not pull in the table?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 04-Oct-2011 05:55:54   

I can't reproduce it. I had to tweak a little bit the SQL but I can retrieve the entity in the designer. Please see if the user used to log into the DB has administration permissions.

David Elizondo | LLBLGen Support Team
joenathan
User
Posts: 27
Joined: 28-Jun-2011
# Posted on: 04-Oct-2011 15:24:51   

you're correct, this is my postgres ignorance biting me in the ass, thank you for taking the time.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 04-Oct-2011 22:17:59   

Good simple_smile

David Elizondo | LLBLGen Support Team