Re: [pgadmin-support] MATERIALIZED VIEW not showing MATERIALIZED in SQL pane

2013-08-15 Thread Neel Patel
Hi, I have checked with latest master branch code and i am not able to reproduce the issue. I have followed the below steps in Ubuntu 10.04 and windows 7 64 bit. 1. Create the Materialized View with below commands. CREATE MATERIALIZED VIEW m_test AS SELECT generate_series(1,10); 2.

[pgadmin-support] PGAdmin3 runs pg_dump etc

2013-08-15 Thread Stephen Cook
Hello list! I recently noticed that PGAdmin III (v 1.16.1) is kind of slow starting up (it didn't use to be), and in fact one time I wasn't even sure if I clicked on the icon properly to start it. I opened the Task Manager (I run Windows 7 Ultimate SP1) and saw pg_restore was running, then the

[pgadmin-support] Foreign key match is unknown when using with postgresql 9.3b2

2013-08-15 Thread Attila Soki
hi, when used with postgresql 9.3, pgadmin shows in table definition ... CONSTRAINT xy_fkey FOREIGN KEY (xy_id) REFERENCES tablename (xy_id) MATCH Unknown insead of MATCH SIMPLE before 9.3 for MATCH SIMPLE was confmatchtype=u since postgresql 9.3 is confmatchtype=s cheers, Attila Soki