Bump
Op 27 feb. 2017 12:41 p.m. schreef "Willy-Bas Loos" :
> Hi,
>
> My colleages and I am looking for a GUI postgres client that supports
> editable views.
> I found this conversation about it
> http://www.postgresql-archive.org/Editing-Views-with-
> EditGrid-td2
On Mon, Feb 27, 2017 at 12:41 PM, Willy-Bas Loos wrote:
> I think that It goes without saying that you need to refresh to see
> changes outside of the record that was editted.
>
> I mean the user has to refresh the data manually, no one can expect a
client to do this by itself.
-
It goes without saying that you need to refresh to see changes
outside of the record that was editted.
Maybe there is a chance that the pgAdmin team would reconsider?
Cheers,
--
Willy-Bas Loos
ng dependencies from the regular repositories, on Ubuntu?
Cheers,
Willy Loos
On Thu, Jan 12, 2017 at 10:43 AM, Dave Page wrote:
> Hi
>
> On Wed, Jan 11, 2017 at 8:33 PM, Willy-Bas Loos
> wrote:
> > Hi, i've just installed pgAdmin4 on ubuntu 14.04 using git (and QT4).
d in my home dir and without a password.
And i have access to the root filesystem.
I hear that on windows, this runs as a desktop application. Is there a
possibility to do this for ubuntu?
Cheers,
--
Willy-Bas Loos
possibly that is this wxWidgets bug:
http://trac.wxwidgets.org/ticket/15345
On Mon, Dec 9, 2013 at 8:12 PM, Vinícius Fontes
wrote:
>
>
>
> 2013/12/9 Vinícius Fontes
>
>> I reported the same bug a few days ago, not sure if the devs acknowledged
>> this.
>>
>> -- Forwarded message ---
On Fri, Sep 23, 2011 at 10:07 PM, Guillaume Lelarge
wrote:
> The adminpack should only work if you use the logging_collector and the
> default values for log_directory and log_filename. One of these is
> probably wrongly configured.
the logging collector is off by default, yet the log is being co
Hi,
It's a late reply, sry about that.
pgAdmin stalls on me when i open the server status window, since i
installed the adminpack.
(pgAdmin version 1.12.2 on ubuntu 11.04)
It shows an error, which doesn't react to click events.
from the pgadmin log:
2011-09-21 11:14:16 ERROR : ERROR: could not r
Hi,
I've encountered this before, psql gives me a syntax error for no clear
reason. It's allways on the first character of a sql file.
I think that there must be some strange character code at the first
position, maybe it is because i share a ntfs partition with the windows
installation on my lapt
Hi,
Whenever i export a query to CSV that contains booleans, writing the
data is exceptionally slow.
I'm using pgAdmin 1.8.4 on ubuntu, it also occurs in several (all?)
versions on windows.
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all
others because you wer
could it be that there is a lot of data (including whitespaces) in the column?
A text record can contain up to 1GB of text AFAIK (the manual says "no
specific upper limit").
WBL
--
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George
On Mon, Jul 6, 2009 at 10:19 AM, Dave Page wrote:
> Or shall I just remove
> it and leave it to the downstream project to produce binaries? (which
> I think they do these days anyway).
>
The thing is, it takes a while for the latest pgAdmin to turn up in the
ubuntu repositories.
probably about
m i doing something wrong, or is the sig actually invalid?
Thx,
WBL
On Mon, Jun 22, 2009 at 11:36 AM, Willy-Bas Loos wrote:
> Hi,
>
> I'm trying to download the 1.10 RC1 on ubuntu jaunty.
> Now there is no special version voor jaunty, so i'm trying the feisty
> version.
>No.
>--
>Dave Page
So what would it take to implement that?
(anyone else on this list that would like such a feature?)
--
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw
Hi,
Is there any way to move a column in the edit grid?
I mean, without actually changing the table in the database.
It's doesn't have to be persistent.
Cheers,
Willy-Bas Loos
--
"Patriotism is the conviction that your country is superior to all others
because you
Hi,
I'm trying to download the 1.10 RC1 on ubuntu jaunty.
Now there is no special version voor jaunty, so i'm trying the feisty
version.
I'm using these instructions:
http://www.pgadmin.org/download/ubuntu.php
I installed the key mentioned,
m...@my-laptop:~$ sudo wget -q -O -
http://www.pgadmin.o
There are tcp_keepalives on the server side of postgresql
The problem was that debian waits 2 hours before starting the keepalives
(7200 s).
Also, the connection would only be kept alive for 9*75 s, which is 11 min.
So i changed the tcp_keepalives_idle to 120 (keepalives start after 2 min)
and th
ou would
have if you mucked with your system's default TCP keepalive settings), and
it works like a charm."
Maybe this would be a useful addition to pgAdmin?
Cheers,
WBL
On Thu, Apr 10, 2008 at 11:49 AM, Willy-Bas Loos wrote:
> the point i was trying to make is that pgAdmin seems to
>If I understand well you say that I could isolate data by using separate
group roles for each firms and defining updatable views to work on.
yes. it's one way to do it.
As simple as this example is, you might as well make a seperate table for
each firm. Then you wouldn't need to bother with views
> *thinks* - I wonder if we can use RETURNING for that now...
> How? If there is no RETURNING present in the command...
I'm not sure if this is all possible, but you might:
o make all editable views editable in pgAdmin as an option (costs
performance i guess, maybe some unexpected results if the
oh, and :
revoke all on table1 from public;
revoke all on view_firm1 from public;
revoke all on view_firm2 from public;
duh
--
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw
Only, it's too bad that you can't update the records from the "view data"
dialog.
It works in access2000, it doesn't know the difference between views and
tables (the difference is actually very small).
You probably get some annoying error when you try to edit a normal select
view from access, thou
e1 set val = NEW.val where id=old.id;
create or replace rule _update as on update
to view_firm2 do instead
update table1 set val = NEW.val where id=old.id;
On Thu, Nov 27, 2008 at 3:06 PM, Csaba Együd <[EMAIL PROTECTED]> wrote:
> ""Willy-Bas Loos"" <[EMAIL PROT
>The problem is that my triggers refuse modifying a record if a given Temp
table is not created before, because one or more fields have their default
values from that temp table
So why don't you either use a normal table, or if you need simultaneous use
of the trigger with different values, use an
Hi,
One thing that i'm missing in pgAdmin is a way to change the case of my
code.
When i type code that others are supposed to read, i use uppercase for the
keywords (such as SELECT, FROM, CREATE, etc). Sometimes i'm sloppy and
forget to do the case thing, or i had the caps-lock on and didn't noti
pr 7, 2008 at 6:18 PM, Willy-Bas Loos <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> We also have issues with connections ending abrubtly. Not only with
> pgAdmin by the way.
> We're at the end of a DSL line, and the connection usually has a lot of
> hiccups.
> After one
Hi,
We also have issues with connections ending abrubtly. Not only with pgAdmin
by the way.
We're at the end of a DSL line, and the connection usually has a lot of
hiccups.
After one of those hiccups, you have to wait for at least 30 seconds to find
out what happened, after which you get a correct
> Willy-Bas; are you able to look at this? I'm not sure if any of the
> regular developers would be interested or have time (I fall firmly into
> the latter category right now).
I'm not a C programmer myself, but I'll see what resources i can win
for this case. It won't be very easy, so if you do h
upgrade possibilities.
Cheers,
WBL
On Nov 15, 2007 5:57 PM, Dave Page <[EMAIL PROTECTED]> wrote:
>
> Willy-Bas Loos wrote:
> > I mean, would it be technically possible.
> > It might be possible for us to provide funding if it is.
> >
> > On Nov 13, 2007 2:49
I mean, would it be technically possible.
It might be possible for us to provide funding if it is.
On Nov 13, 2007 2:49 PM, Willy-Bas Loos <[EMAIL PROTECTED]> wrote:
> Hi,
>
> One function that we would love to see in pgAdmin would be a wrapper
> for pgsql2shp, so that you can e
Hi,
One function that we would love to see in pgAdmin would be a wrapper
for pgsql2shp, so that you can export queries to a shapefile directly.
Would that be possible?
WBL
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will igno
Hi,
I've noticed that the character number "Ch" in the status bar of the
query window has been changed to col -1 since version 1.6.2
Why is that? I liked the feature of the character position, and i
don't see the point in substracting 1 from a number i can see next to
it instead.
In some situations
version on a debian machine)
Whatever, i guess i´ll just go w/ the flow and accept that a fedora versions
come with package versions.
I guess i should brag about this on fedora forums..
Willy-Bas
On 1/23/07, Willy-Bas Loos <[EMAIL PROTECTED]> wrote:
>On Windows I think it is nece
On Windows I think it is necessary, as PgAdmin has it's own libpq.dll -
my version from 1.6.2 on Windows XP is "8.2.0.6338", so is obviously
from the 8.2.0 series of PostgreSQL, which would equate to libpq.so.5 on
Linux/Unix. The server doesn't have to be upgraded, but the client
library PgAdmin
ade the backend for a new pgAdmin, or is it?
I know that on Windows it isnt't, why should it be necessary on Linux?
thx,
Willy-Bas Loos
On 1/22/07, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
Hi,
On Mon, 2007-01-22 at 13:34 +0100, Willy-Bas Loos wrote:
> Am i missing a repository wh
deps from source?
Am i missing a repository where these can be found? I've been reading about
all kinds of trouble with installing wxWidgets 2.8 on FC6, but why offer
ready-built pgAdmin3 1.6.2 if there can be no wxWidgets 2.8??
thx,
Willy-Bas Loos
-- yum errors--
Error: Missing Dependency: libwx
36 matches
Mail list logo
