Have a table that shows no records in Postgres

[Kevin]

Here it is.

CREATE TABLE "public"."tblfiles" ( 
	"id" INTEGER DEFAULT nextval('tblfiles_id_seq'::regclass) NOT NULL UNIQUE, 
	"filehandlingid" INTEGER DEFAULT '0', 
	"filereceiveddt" TIMESTAMP WITH TIME ZONE, 
	"filename" TEXT COLLATE "pg_catalog"."default", 
	"filedatahash" TEXT COLLATE "pg_catalog"."default", 
	"filedt" TIMESTAMP WITH TIME ZONE, 
	"siteidext" TEXT COLLATE "pg_catalog"."default", 
	"uploaduserid" INTEGER DEFAULT '0', 
	"jobdefidext" TEXT COLLATE "pg_catalog"."default", 
	"doctypeidext" TEXT COLLATE "pg_catalog"."default", 
	"xdpstartdt" TIMESTAMP WITH TIME ZONE, 
	"xdpfinishdt" TIMESTAMP WITH TIME ZONE, 
	"doccreationstartdt" TIMESTAMP WITH TIME ZONE, 
	"doccreationfinishdt" TIMESTAMP WITH TIME ZONE, 
	"doctotal" INTEGER DEFAULT '0', 
	"docsvisible" BOOLEAN DEFAULT 'false', 
	"releaseduserid" INTEGER DEFAULT '0', 
	"releaseddt" TIMESTAMP WITH TIME ZONE, 
	"notes" TEXT COLLATE "pg_catalog"."default", 
	"deliveriescreateddt" TIMESTAMP WITH TIME ZONE, 
	"deliveriesprocesseddt" TIMESTAMP WITH TIME ZONE,
 PRIMARY KEY ( "id" )
 );
CREATE INDEX "indx_tblfiles_releaseddt" ON "public"."tblfiles" USING btree( "releaseddt" ASC NULLS LAST );


CREATE INDEX "indx_tblfiles_deliveriescreateddt" ON "public"."tblfiles" USING btree( "deliveriescreateddt" ASC NULLS LAST );


CREATE INDEX "indx_tblfiles_deliveriesprocesseddt" ON "public"."tblfiles" USING btree( "deliveriesprocesseddt" ASC NULLS LAST );

On Nov 27, 2013, at 2:51 PM, Sergey Pashkov <sergey_pashkov at valentina-db.com> wrote:

> Hello, Kevin
> Can you show the structure of this table, please?
> 
> Select table in Schema Editor, open a contextual menu and select Generate SQL...->Create...
> 
> Thank you.
> 
> Best regards,
> Sergey Pashkov
> 
> 
> On Wed, Nov 27, 2013 at 10:42 PM, Kevin <kevo at gatorgraphics.com> wrote:
> 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.
> 
> Is there anyway to troubleshoot this? We can see the records from other tools.
> 
> - Kevin
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio
> 
> 
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina-studio/attachments/20131127/60b59b03/attachment.html>