<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">False alarm. The other tools we used were showing cached records. The table does actually appear empty in psql on the server so I don’t think this has anything to do with VS.<div><br></div><div>- Kevin<br><div><br><div><div>On Nov 27, 2013, at 2:57 PM, Kevin <<a href="mailto:kevo@gatorgraphics.com">kevo@gatorgraphics.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Here it is.<div><br></div><div><div>CREATE TABLE "public"."tblfiles" ( </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"id" INTEGER DEFAULT nextval('tblfiles_id_seq'::regclass) NOT NULL UNIQUE, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"filehandlingid" INTEGER DEFAULT '0', </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"filereceiveddt" TIMESTAMP WITH TIME ZONE, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"filename" TEXT COLLATE "pg_catalog"."default", </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"filedatahash" TEXT COLLATE "pg_catalog"."default", </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"filedt" TIMESTAMP WITH TIME ZONE, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"siteidext" TEXT COLLATE "pg_catalog"."default", </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"uploaduserid" INTEGER DEFAULT '0', </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"jobdefidext" TEXT COLLATE "pg_catalog"."default", </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"doctypeidext" TEXT COLLATE "pg_catalog"."default", </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"xdpstartdt" TIMESTAMP WITH TIME ZONE, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"xdpfinishdt" TIMESTAMP WITH TIME ZONE, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"doccreationstartdt" TIMESTAMP WITH TIME ZONE, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"doccreationfinishdt" TIMESTAMP WITH TIME ZONE, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"doctotal" INTEGER DEFAULT '0', </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"docsvisible" BOOLEAN DEFAULT 'false', </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"releaseduserid" INTEGER DEFAULT '0', </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"releaseddt" TIMESTAMP WITH TIME ZONE, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"notes" TEXT COLLATE "pg_catalog"."default", </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"deliveriescreateddt" TIMESTAMP WITH TIME ZONE, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>"deliveriesprocesseddt" TIMESTAMP WITH TIME ZONE,</div><div> PRIMARY KEY ( "id" )</div><div> );</div><div>CREATE INDEX "indx_tblfiles_releaseddt" ON "public"."tblfiles" USING btree( "releaseddt" ASC NULLS LAST );</div><div><br></div><div><br></div><div>CREATE INDEX "indx_tblfiles_deliveriescreateddt" ON "public"."tblfiles" USING btree( "deliveriescreateddt" ASC NULLS LAST );</div><div><br></div><div><br></div><div>CREATE INDEX "indx_tblfiles_deliveriesprocesseddt" ON "public"."tblfiles" USING btree( "deliveriesprocesseddt" ASC NULLS LAST );</div><div><br></div><div><div>On Nov 27, 2013, at 2:51 PM, Sergey Pashkov <<a href="mailto:sergey_pashkov@valentina-db.com">sergey_pashkov@valentina-db.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr"><div>Hello, Kevin<br></div><div>Can you show the structure of this table, please?</div><div><br></div><div>Select table in Schema Editor, open a contextual menu and select Generate SQL...->Create...</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">Thank you.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Best regards,</div><div class="gmail_extra">Sergey Pashkov</div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Wed, Nov 27, 2013 at 10:42 PM, Kevin <span dir="ltr"><<a href="mailto:kevo@gatorgraphics.com" target="_blank">kevo@gatorgraphics.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I have a problem with a particular table in our db not showing any records in VS. This table seems to be the only one that has this issue.<br>
<br>
Is there anyway to troubleshoot this? We can see the records from other tools.<br>
<span class="HOEnZb"><font color="#888888"><br>
- Kevin<br>
_______________________________________________<br>
Valentina-studio mailing list<br>
<a href="mailto:Valentina-studio@lists.macserve.net">Valentina-studio@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina-studio" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina-studio</a><br>
<br>
</font></span></blockquote></div><br></div></div>
_______________________________________________<br>Valentina-studio mailing list<br><a href="mailto:Valentina-studio@lists.macserve.net">Valentina-studio@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina-studio">http://lists.macserve.net/mailman/listinfo/valentina-studio</a><br></blockquote></div><br></div></div>_______________________________________________<br>Valentina-studio mailing list<br><a href="mailto:Valentina-studio@lists.macserve.net">Valentina-studio@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina-studio<br></blockquote></div><br></div></div></body></html>