On 10/31/2014 04:14 PM, Mark Woodward wrote:
I have not kept up with PostgreSQL changes and have just been using it. A
co-worker recently told me that you need to word CONCURRENTLY in CREATE
INDEX to avoid table locking. I called BS on this because to my knowledge
PostgreSQL does not lock
(forwarding to pgadmin-hackers)
On 05/07/2014 06:44 PM, Stephen Frost wrote:
* d...@isam.kiwi (d...@isam.kiwi) wrote:
but when the credential contains the delimiter (colon) it fails to be
read back out and app responds with invalid credentials.
x.x.x.x:5432:*:username:password:with:colons
If you run something like:
copy (select * from pg_stat_activity) to stdout;
in the query editor, it will hang forever. The code in
pgQueryThread::execute() doesn't check for a PGRES_COPY_OUT result, and
calls PQgetResult() repeatedly. PQgetResult() will keep on returning
PGRES_COPY_OUT until
On 06.05.2012 19:05, Dave Page wrote:
On Thu, May 3, 2012 at 2:23 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
On 30.04.2012 15:14, Ashesh Vashi wrote:
With PostgreSQL 8.4.11, I still face the same issue, resolved as part of
the following checked-in:
http
On 07.05.2012 13:39, Dave Page wrote:
On Mon, May 7, 2012 at 11:33 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
for that matter. I'll fix this in git master. I consider the current tip of
the old CVS repository (or the corresponding checkout from the git repo
On 07.05.2012 13:54, Dave Page wrote:
On Mon, May 7, 2012 at 11:46 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
On 07.05.2012 13:39, Dave Page wrote:
Can you create a PRE-9_2 branch for the current architecture, and
apply Ashesh's patch to that if you think it's
that displays the red breakpoint symbol.
Attached is a patch to fix that.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
commit 22e7dee866214542f11e87cb61baf3e7f2e709e7
Author: Heikki Linnakangas heikki.linnakan...@iki.fi
Date: Mon May 7 14:50:27 2012 +0300
Don't set/clear
that, the
makefile will be much simpler, which means less trouble with OS-specific
things like this. Not only now, but also in the future if the pgxs
makefiles are changed - we make quite a few assumptions of the pgxs
build system at the moment.
--
Heikki Linnakangas
EnterpriseDB http
On 25.04.2012 14:22, Dave Page wrote:
On Wed, Apr 25, 2012 at 11:24 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
The hack that was removed skipped an initial newline when counting line
numbers. The PL/pgSQL debugger has a similar hack, but it didn't get the
memo
load the library in a
single session, you can set local breakpoints and debug in that session,
for example. But this patch doesn't change that.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
diff --git a/pgadmin/schema/pgDatabase.cpp b/pgadmin/schema/pgDatabase.cpp
index
. Attached is a patch
to fix that.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
diff --git a/pgadmin/debugger/ctlCodeWindow.cpp b/pgadmin/debugger/ctlCodeWindow.cpp
index 5db7178..0745bab 100644
--- a/pgadmin/debugger/ctlCodeWindow.cpp
+++ b/pgadmin/debugger/ctlCodeWindow.cpp
On 20.04.2012 11:52, Guillaume Lelarge wrote:
On Fri, 2012-04-20 at 10:47 +0200, Guillaume Lelarge wrote:
On Fri, 2012-04-20 at 09:21 +0100, Dave Page wrote:
On Thu, Apr 19, 2012 at 9:59 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
And now that I've updated my local
On 19.04.2012 15:25, Heikki Linnakangas wrote:
On 19.04.2012 15:20, Dharmendra Goyal wrote:
pldebugger build is failing on WIndows because targetinfo.c file is not
there where as vcproj file requires it to be there to build
targetinfo.dll.
I checked earlier this file was there and after moving
on Windows, so it's very possible there's other stuff
broken, too. Please let me know if so. Or even better, post a patch ;-).
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your
..)
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
diff --git a/pgadmin/schema/pgTablespace.cpp b/pgadmin/schema/pgTablespace.cpp
index 37ed1ed..9ad6ecf 100644
--- a/pgadmin/schema/pgTablespace.cpp
+++ b/pgadmin/schema/pgTablespace.cpp
@@ -266,7 +266,7 @@ pgObject *pgTablespaceFactory
the arguments
to the grid in the dialog. I'm not sure what the original problem was or
why this fixes it, but the attached patch fixes it for me.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
diff --git a/pgadmin/ui/dlgDirectDbg.xrc b/pgadmin/ui/dlgDirectDbg.xrc
index
Sorry, attached wrong patch in previous mail. Here's the correct one.
On 19.04.2012 23:42, Heikki Linnakangas wrote:
When I build pgAdmin from sources on my laptop running Debian, and try
to open the Direct Debug dialog by choosing Debug on a function,
pgAdmin hangs, consuming 100% of CPU
And now that I've updated my local repository, here's a third version
that actually applies. (just my working copy didn't fix the issue)
On 19.04.2012 23:43, Heikki Linnakangas wrote:
Sorry, attached wrong patch in previous mail. Here's the correct one.
On 19.04.2012 23:42, Heikki Linnakangas
of that API, so let's keep pldebugger related
discussions on this mailing list.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin
is to discuss their ideas on the usual project mailing lists,
like you would discuss any proposal regardless of GSoC.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http
(sorry for the late reply, this fell through the cracks..)
On 10.08.2011 11:48, Dave Page wrote:
On Thu, Aug 4, 2011 at 8:30 PM, Merlin Moncuremmonc...@gmail.com wrote:
On Thu, Aug 4, 2011 at 2:19 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
I created 100 identical
On 28.09.2011 20:24, Merlin Moncure wrote:
On Wed, Sep 28, 2011 at 2:16 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
(sorry for the late reply, this fell through the cracks..)
On 10.08.2011 11:48, Dave Page wrote:
On Thu, Aug 4, 2011 at 8:30 PM, Merlin Moncuremmonc
;hb=HEAD
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
into the max_connections limit, and pgagent didn't
handle that too well. JobThread::JobThread constructor does not check
for NULL result from DBConn::Get(), and passes a NULL connection to
Job::Job, which tries to reference it, leading to a segfault.
I propose the attached patch.
--
Heikki
'var' in the debugger GUI to something
with a single quote. Like '123.
4. Move focus from the cell, pgAdmin3 crashes
Looking at the code in ctlCodeWindow.cpp, it seems that the new value is
not quoted properly in the call to pldbg_deposit_value() server function.
--
Heikki Linnakangas
.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
is exactly what you're looking for.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
if no-one else volunteers.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
is to prefix the server names. Paris_server1,
Paris_dwserver and so forth. The list will be long, but servers will
be grouped together since the list is in alphabetical order.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgadmin-hackers mailing list (pgadmin
Dave Page wrote:
On Mon, Apr 6, 2009 at 9:20 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
It's reproducible with any other function too, by stepping to the end of the
function. Which suggests that the problem occurs when the dialog is
displayed for the 2nd time.
What
Dave Page wrote:
On Tue, Apr 7, 2009 at 8:45 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
When I choose Debug from the popup menu on the tree, on a functioon with
no args but with real content that the debugger can stop on, the function
execution is started and the debugger
discussion on pgsql-hackers.
Thanks! I was going to send a patch but you beat me to it.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Dave Page wrote:
Hi Heikki
On Fri, Apr 3, 2009 at 4:43 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
CREATE FUNCTION onelinefunc() RETURNS void AS $$ begin null; end; $$
LANGUAGE plpgsql;
Debugging that won't work terribly well anyway, as the plugin will
just skip
(working copy)
@@ -295,7 +295,7 @@
font.SetStyle( wxFONTSTYLE_ITALIC );
grdParams-SetCellFont( 0, COL_NAME, font );
-grdParams-AutoSizeColumns();
+//grdParams-AutoSizeColumns();
activateDebugger();
}
else
--
Heikki Linnakangas
has
heard of before. I don't know if the script issue makes it harder to do
that in Hindi, though.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http
of the whole CVS repository on my laptop, and work against
that. Much more convenient, you can do diffs, checkouts, view histories,
all offline and quickly.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
might set session-variables, create temp tables etc.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
address? I'll send you one to compensate.
:-)
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org
Mac :-(
I can try 7.3, but you'll have to tell me what to test.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose
Dave Page wrote:
Heikki Linnakangas wrote:
Thanks. Just tried 7.3 here but it won't build on my Mac :-(
I can try 7.3, but you'll have to tell me what to test.
Thanks Heikki.
- Create a postgres database (to avoid cluttering template1)
- Run pgagent.sql (should be in xtra/pgagent
A couple of typos fixed, and enhancements in wording.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Index: docs/fi_FI/hints/instrumentation.html
===
--- docs/fi_FI/hints/instrumentation.html (revision 6716
Heikki Linnakangas wrote:
Dave Page wrote:
Heikki Linnakangas wrote:
Dave Page wrote:
I'd be more interested in the patches so I can update my utilities and
those of developer.pgadmin.org where stringextract tends to be run (I
imagine Guillaume would like a copy too).
Ok. Here's two patches
it for your convenience.
I wonder if that's an appropriate place for it, though; does it get
copied to binary installations as well from there? Doesn't need to be...
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Alkuperäiset käännökset: Jori Luoto
Päivitykset, sekä vinkkien ja
Dave Page wrote:
Heikki Linnakangas wrote:
Dave Page wrote:
I'd be more interested in the patches so I can update my utilities and
those of developer.pgadmin.org where stringextract tends to be run (I
imagine Guillaume would like a copy too).
Ok. Here's two patches to enable that:
wx
Euler Taveira de Oliveira wrote:
Heikki Linnakangas wrote:
Attached is a patch to change a few string constructions to be more
localization-friendly. There's still a lot of troublesome constructs
where is the patch?
Oh crap. Here..
--
Heikki Linnakangas
EnterpriseDB http
(ERRCODE_FEATURE_NOT_SUPPORTED),
errmsg(prepared transaction belongs
to another database),
errhint(Connect to the database where
the transaction was prepared to finish it.)));
--
Heikki Linnakangas
EnterpriseDB http
Dave Page wrote:
[Guillaume; I've left some of Heikki's suggestions to your discretion,
please read on...]
Heikki Linnakangas wrote:
When creating a table or index, it would be nice if we checked that the
value given for fillfactor is valid, within 0-100, in pgAdmin. Would be
nicer than
will allow all reads to run
concurrently, though they might have to use sequential scans. Hmm, I
wonder if a CREATE+DROP+rename would be even better. Could use
CONCURRENT-mode in the create as well to allow concurrent writes...
I know I know, no new features at this point :).
--
Heikki Linnakangas
patch. I'm not sure how the xargs-magic works on windows...
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Index: stringextract
===
--- stringextract (revision 6673)
+++ stringextract (working copy)
@@ -40,4
Jyrki Wahlstedt wrote:
On 26.9.2007, at 14.26, Heikki Linnakangas wrote:
Finnish texts do tend to more longer than English. It's not a problem in
most places, but for example Rename in the favourites manager is
translated to Nimeä uudelleen, which is quite a bit longer. If we just
made
Dave Page wrote:
Heikki Linnakangas wrote:
There's some strings in calls to wxLogDebug, like OnTargetComplete()
called, that are wrapped in _() for translation. Aren't those just for
developers, and therefore a waste of time to translate?
Yep. Removed.
Here's a few more, though I must
Viewing data of a table with zero columns triggers this assertion:
./db/pgSet.cpp(222): assert col nCols col = 0 failed in
GetVal(). [in child thread]
To reproduce, create a table with no columns, and click View Data -
First 100 rows.
This is with an up-to-date SVN checkout.
--
Heikki
in _() for translation. Aren't those just for
developers, and therefore a waste of time to translate?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
53 matches
Mail list logo