Re: [pgadmin-hackers] Server Status window work

2009-02-13 Thread Guillaume Lelarge
Dave Page a écrit : > On Thu, Feb 12, 2009 at 11:09 PM, Guillaume Lelarge > wrote: > >> The patch attached takes care of this. It's not really finished but it >> gives an idea of what could be done. There's also the combo stuff. I >> would love to get comments on this, to see if I go further. >

Re: [pgadmin-hackers] Patch: when select bit varying type, column length can be inputted

2009-02-13 Thread Dave Page
On Fri, Feb 13, 2009 at 9:55 AM, Quan Zongliang wrote: > Review it: >when select bit varying type, column length can be inputted Thanks, patch applied. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)

Re: [pgadmin-hackers] [pgadmin-support] about bit varying

2009-02-13 Thread Dave Page
On Fri, Feb 13, 2009 at 9:06 AM, Quan Zongliang wrote: >> Dear pgadmin-support >> >> Hi, I'm using pgadmin3 1.8.4 windows version. >> I found that the length of bit varying in sql view window >> is different from the one shown from psql command (\dt). >> Its shown as 16 in sql view window, but 20

[pgadmin-hackers] SVN Commit by dpage: r7588 - in branches/REL-1_8_0_EDB/pgadmin3/pgadmin: dlg include/utils schema

2009-02-13 Thread svn
Author: dpage Date: 2009-02-13 11:38:04 + (Fri, 13 Feb 2009) New Revision: 7588 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7588&view=rev Log: Fix support for 'bit varying' columns [Quan Zongliang]. Modified: branches/REL-1_8_0_EDB/pgadmin3/pgadmin/dlg/dlgProperty

[pgadmin-hackers] SVN Commit by dpage: r7587 - in trunk/pgadmin3: . pgadmin/dlg pgadmin/include/utils pgadmin/schema

2009-02-13 Thread svn
Author: dpage Date: 2009-02-13 11:33:15 + (Fri, 13 Feb 2009) New Revision: 7587 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7587&view=rev Log: Fix support for 'bit varying' columns [Quan Zongliang]. Modified: trunk/pgadmin3/CHANGELOG trunk/pgadmin3/pgadmin/dlg/

Re: [pgadmin-hackers] Server Status window work

2009-02-13 Thread Dave Page
On Thu, Feb 12, 2009 at 11:09 PM, Guillaume Lelarge wrote: > The patch attached takes care of this. It's not really finished but it > gives an idea of what could be done. There's also the combo stuff. I > would love to get comments on this, to see if I go further. I immediately got an assertion

[pgadmin-hackers] SVN Commit by dpage: r7586 - trunk/pgadmin3/pgadmin/frm

2009-02-13 Thread svn
Author: dpage Date: 2009-02-13 10:04:34 + (Fri, 13 Feb 2009) New Revision: 7586 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7586&view=rev Log: Fix help paths Modified: trunk/pgadmin3/pgadmin/frm/frmHbaConfig.cpp trunk/pgadmin3/pgadmin/frm/frmMainConfig.cpp t

[pgadmin-hackers] SVN Commit by dpage: r7585 - branches/REL-1_8_0_EDB/pgadmin3/pgadmin/frm

2009-02-13 Thread svn
Author: dpage Date: 2009-02-13 10:03:56 + (Fri, 13 Feb 2009) New Revision: 7585 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7585&view=rev Log: Fix help paths Modified: branches/REL-1_8_0_EDB/pgadmin3/pgadmin/frm/frmHbaConfig.cpp branches/REL-1_8_0_EDB/pgadmin3/

[pgadmin-hackers] Patch: when select bit varying type, column length can be inputted

2009-02-13 Thread Quan Zongliang
Review it: when select bit varying type, column length can be inputted --- Quan Zongliang quanzongli...@gmail.com CIT Japan: http://www.cit.co.jp CIT China: http://www.citbj.com.cn pgDefsh.patch Description: Binary data dlgPropertycpp.patc

Re: [pgadmin-hackers] Import: I need help

2009-02-13 Thread Dave Page
On Fri, Feb 13, 2009 at 9:21 AM, Quan Zongliang wrote: > And more one question: > I think the import work should get a new PGconn instance before it starts. > in document: http://www.postgresql.org/docs/8.3/static/libpq-copy.html said: > It is not possible to execute other SQL commands using the

Re: [pgadmin-hackers] Import: I need help

2009-02-13 Thread Quan Zongliang
> Those values may, in theory, change between versions of the server, > and also won't exist for user defined types. In fact, another type constants had been defined in utils\pgDefs.h and used in the dlgTypeProperty class. When I validated the bug report about bit varying from Mr. Hiromichi Nakaji

Re: [pgadmin-hackers] Import: I need help

2009-02-13 Thread Quan Zongliang
> The second way is to use SAVEPOINT. > You can use savepoints: > http://www.postgresql.org/docs/8.3/interactive/sql-savepoint.html This a good idea. I forgot it. > I think you should take a look at pgloader: > http://pgfoundry.org/projects/pgloader/ Ok, before the work go on, I study from the

Re: [pgadmin-hackers] [pgadmin-support] about bit varying

2009-02-13 Thread Quan Zongliang
> Dear pgadmin-support > > Hi, I'm using pgadmin3 1.8.4 windows version. > I found that the length of bit varying in sql view window > is different from the one shown from psql command (\dt). > Its shown as 16 in sql view window, but 20 is correct. > I hope this problem will fix soon! > Thank you.

Re: [pgadmin-hackers] Import: I need help

2009-02-13 Thread Guillaume Lelarge
Hi, Quan Zongliang a écrit : > [...] > I haven't any experience with libpq. So there are a lot of questions. > > When import to db using INSERT statement. Like this: >res = PQexec(m_conn->connection(), "BEGIN"); >LOOP: res = PQexec(m_conn->connection(), "INSERT INTO ..."); >res = PQex

Re: [pgadmin-hackers] Import: I need help

2009-02-13 Thread Dave Page
Hi, On Fri, Feb 13, 2009 at 3:08 AM, Quan Zongliang wrote: > Hi, all > > I haven't any experience with libpq. So there are a lot of questions. > > When import to db using INSERT statement. Like this: > res = PQexec(m_conn->connection(), "BEGIN"); > LOOP: res = PQexec(m_conn->connection(), "IN