Have a table that shows no records in Postgres

[Kevin]

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.

- Kevin

On Nov 27, 2013, at 2:57 PM, Kevin <kevo at gatorgraphics.com> wrote:

> 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
> 
> _______________________________________________
> 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/1540b2b8/attachment-0001.html>