Re: [pgadmin-support] Trigger Script Error

2012-02-21 Thread Guillaume Lelarge
On Tue, 21 Feb 2012 21:53:49 +0100, Bartosz Dmytrak wrote: > Hi,I found incorrect script generated for trigger with column list > specified. > SQL window shows:CREATE TRIGGER "trgTest"   AFTER INSERT OR UPDATE OF > RowId, Value1 OR DELETE -- missing quotation marks for column names   > ON "tblTest

Re: [pgadmin-support] \Copy and "Copy With Headers" -- every day these bug me.

2012-02-21 Thread Guillaume Lelarge
On Mon, 20 Feb 2012 21:11:17 +0100, Guillaume Lelarge wrote: > On Mon, 20 Feb 2012 09:15:07 +, Dave Page wrote: >> On Mon, Feb 20, 2012 at 7:31 AM, Guillaume Lelarge >> wrote: >>> Hi Ashesh, >>> >>> On Mon, 2012-02-20 at 10:20 +0530, Ashesh Vashi wrote: [...] I think - we should ha

[pgadmin-support] Trigger Script Error

2012-02-21 Thread Bartosz Dmytrak
Hi, I found incorrect script generated for trigger with column list specified. SQL window shows: CREATE TRIGGER "trgTest" AFTER INSERT OR UPDATE OF RowId, Value1 OR DELETE -- missing quotation marks for column names ON "tblTest" FOR EACH ROW EXECUTE PROCEDURE "trgTest"(); But should be:

Re: [pgadmin-support] Extension script error

2012-02-21 Thread Guillaume Lelarge
On Tue, 21 Feb 2012 13:13:02 +0100, Bartosz Dmytrak wrote: > Hi,I think there is a bug in extensions SQL window eg. for intarray > extension, generated script looks like this: -- Extension: intarray > -- DROP EXTENSION intarray; >  CREATE EXTENSION intarray  SCHEMA public   VERSION 1.0;ALTER > E

Re: [pgadmin-support] Server Instrumentation Help

2012-02-21 Thread Carlos Mennens
On Tue, Feb 21, 2012 at 12:14 PM, Dave Page wrote: > Make sure the postgresql-contrib-9.1 package is installed (I'm > assuming you installed the Debian packages), then hit the "Fix it!" > button. I worked like magic... Thank you! -- Sent via pgadmin-support mailing list (pgadmin-support@postgr

Re: [pgadmin-support] Server Instrumentation Help

2012-02-21 Thread Dave Page
On Tue, Feb 21, 2012 at 5:11 PM, Carlos Mennens wrote: > So when I connect to my PostgreSQL 9.1.2 enterprise database, I'm > greeted with a window from pgAdmin3 that says: > > The server lacks instrumentation functions. > pgAdmin III uses some support functions that are not available by > default

[pgadmin-support] Server Instrumentation Help

2012-02-21 Thread Carlos Mennens
So when I connect to my PostgreSQL 9.1.2 enterprise database, I'm greeted with a window from pgAdmin3 that says: The server lacks instrumentation functions. pgAdmin III uses some support functions that are not available by default in all PostgreSQL versions. These enable some tasks that make life

Re: [pgadmin-support] pgadmin 1.14.1 bug

2012-02-21 Thread Dave Page
Hi 2012/2/21 Pavel V. : > Hi, > i have following bugs. Platform, Distribution and Version are on pic1.PNG. > > 1. Bug with underscore symbol > > watch pic1.PNG That's not really a bug. Some versions of PostgreSQL used _xyz as notation for an array variant of type xyz. pgAdmin recognises that and

[pgadmin-support] Extension script error

2012-02-21 Thread Bartosz Dmytrak
Hi, I think there is a bug in extensions SQL window eg. for intarray extension, generated script looks like this: -- Extension: intarray -- DROP EXTENSION intarray; CREATE EXTENSION intarray SCHEMA public VERSION 1.0; ALTER EXTENSION intarray OWNER TO postgres; But should be: -- Extension