[pgadmin-support] Strange character in Table Properties

2012-03-13 Thread Colin Beckingham
1.15 Dev, latest from git. This is not an error, no crash, no backtrace, just an unexplained character in property definition. 1. open pgadmin 2. drill down and right click a table name, click on properties 3. click the 'columns' tab 4. columns are listed. Window shows: ['Column name','Definit

Re: [pgadmin-support] Operator script error

2012-03-13 Thread Bartosz Dmytrak
Hi my script: CREATE OR REPLACE FUNCTION "Calc"."getDataRepository"(a text[]) RETURNS numeric AS $BODY$ DECLARE /* ARRAY STRUCTURE Metric_Name, Date, Value_Type Value_Type: 1. N - Numerator 2. D - Denominator */ vRetValue "DataRepository"."tblDataRepository"."NumeratorValue"%TYPE; vMetricN

Re: [pgadmin-support] Operator script error

2012-03-13 Thread Guillaume Lelarge
On Tue, 2012-03-13 at 14:21 +0100, Bartosz Dmytrak wrote: > Hi my script: Thanks. I fixed the issue. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://ww

Re: [pgadmin-support] Operator script error

2012-03-13 Thread Bartosz Dmytrak
Thank You for your time. Regards, Bartek 2012/3/13 Guillaume Lelarge > On Tue, 2012-03-13 at 14:21 +0100, Bartosz Dmytrak wrote: > > Hi my script: > > Thanks. I fixed the issue. > > > -- > Guillaume > http://blog.guillaume.lelarge.info > http://www.dalibo.com > > > -- > Sent via pgadmin-suppor

Re: [pgadmin-support] QB - record count incorrect

2012-03-13 Thread Guillaume Lelarge
On Sat, 2012-03-10 at 11:41 -0500, Colin Beckingham wrote: > On open QB, drill down to table, right click table name, seek menu item > View Data, sub menu items top and last contain odd number of records > 398316718 which should be 100, table opens correctly, but count of > records in status bar

Re: [pgadmin-support] Strange character in Table Properties

2012-03-13 Thread Guillaume Lelarge
On Tue, 2012-03-13 at 08:30 -0400, Colin Beckingham wrote: > 1.15 Dev, latest from git. > > This is not an error, no crash, no backtrace, just an unexplained > character in property definition. > > 1. open pgadmin > 2. drill down and right click a table name, click on properties > 3. click the '

[pgadmin-support] code completion feature question

2012-03-13 Thread Bartosz Dmytrak
Hi all, there is code completion feature in pgAdmin, where can I found some doc to read about this? It is great thing, but looks like need more development - on first sight e.g. I can't discover how to get column names, how to accept schema selection (without using space). thanks in advance Regar

Re: [pgadmin-support] code completion feature question

2012-03-13 Thread Guillaume Lelarge
On Tue, 2012-03-13 at 22:30 +0100, Bartosz Dmytrak wrote: > Hi all, > there is code completion feature in pgAdmin, where can I found some doc to > read about this? IIRC, the code completion feature comes from psql. > It is great thing, but looks like need more development - on first sight > e.g.

Re: [pgadmin-support] code completion feature question

2012-03-13 Thread Bartosz Dmytrak
Hi, lets say I would like do write something like this: SELECT a."Col1", b."Col2" FROM "FirstSchema"."FirstTable" a INNER JOIN "SecondSchema"."SecondTable" b ON (a."RowId" = b."RefRowId") WHERE a."Col3" = NULL; so: what works for me (pseudo code): SELECT FROM list of schemas in context menu the

Re: [pgadmin-support] Strange character in Table Properties

2012-03-13 Thread Colin Beckingham
On 03/13/2012 05:18 PM, Guillaume Lelarge wrote: On Tue, 2012-03-13 at 08:30 -0400, Colin Beckingham wrote: 1.15 Dev, latest from git. This is not an error, no crash, no backtrace, just an unexplained character in property definition. 1. open pgadmin 2. drill down and right click a table nam