Re: [pgadmin-support] Error Messages

2013-08-01 Thread Dinesh Kumar
Hi, The ERROR message what have got is from PG database and it's not from the pgAdmin. It's an expected result. I believe, EXPLAIN ANALYZE only supports DML/Select queries. Dinesh -- *Dinesh Kumar* Software Engineer Ph: +918087463317 Skype ID: dinesh.kumar432 www.enterprisedb.co

[pgadmin-support] v 1.16.1 incorrectly displays the properties of a FDW table

2013-08-01 Thread Bill MacArthur
Hello, I am guessing that somebody has already reported this, but in case not, here goes. I am using version 1.16.1 on windows XP against a Postgres version 9.2.4 server. The wrapper options for a foreign data wrappers table get really goobered up inside of pgadmin. I have a foreign table that

[pgadmin-support] Error Messages

2013-08-01 Thread Hall, Samuel L (Sam)
When I run commands other than SELECT, I get error messages like this from Explain ALTER TABLE sites ALTER COLUMN meters_wgs84 SET NOT NULL; Query result with 0 rows will be returned. ERROR: syntax error at or near "ALTER" LINE 1: ... (ANALYZE off, VERBOSE off, COSTS on, BUFFERS off)ALTER TABL.

Re: [pgadmin-support] How to enter daterange into a raw? - SOLVED

2013-08-01 Thread David Johnston
Csanyi Pal wrote > Now, I don't understand, why changes pgAdminIII the entered value, > namely from > [2013-09-01,2013-11-12] > > to > > [2013-09-01,2013-11-12) > > automatically?? > > I want to enter [2013-09-01,2013-11-12] because I want to to set this > range with inclusive bounds. Are you

Re: [pgadmin-support] PgAdmin V 1.16.1 Error - Comment on database

2013-08-01 Thread Jan-Peter Seifert
Am 01.08.2013 08:40, schrieb Oli Noname: > PgAdmin V 1.16.1 (on Win7) with Postgres 9.1 Server doesn´t show the > Comments on a Database. Neither in SQL Field then in Preferences. > > I can overwrite the comments but i still doesn´t show any comment on > database but the new set comment can be see

Re: [pgadmin-support] How to enter daterange into a raw? - SOLVED

2013-08-01 Thread Csanyi Pal
On Wed, Jul 31,Hi David, 2013 at 02:36:23PM -0700, David Johnston wrote: > Csanyi Pal wrote > > Hi, > > > > I have installed PostgreSQL 9.2 on my desktop machine, and > > pgAdmin III version: 1.16.1. > > > > I'm being creating a new database with daterange type. > > > > When I'm trying to ente

Re: [pgadmin-support] How to enter daterange into a raw?

2013-08-01 Thread David Johnston
Csanyi Pal wrote > Hi, > > I have installed PostgreSQL 9.2 on my desktop machine, and > pgAdmin III version: 1.16.1. > > I'm being creating a new database with daterange type. > > When I'm trying to enter in the 'Edit Data - PostgreSQL' window in the > first raw a range of data: > > '2013-09-01

Re: [pgadmin-support] PgAdmin V 1.16.1 Error - Comment on database

2013-08-01 Thread Oli Noname
PgAdmin V 1.16.1 (on Win7) with Postgres 9.1 Server doesn´t show the Comments on a Database. Neither in SQL Field then in Preferences. I can overwrite the comments but i still doesn´t show any comment on database but the new set comment can be seen using an older Version of PgAdmin. Comments on S