Say you have a tab: Query-1 open
You go to history, and say you have some failed queries you want to retry
The full query is truncated in the 'Query' column and there's no options
to re-open this query and try again (or edit)
--
Sent via pgadmin-support mailing list (pgadmin-support@postgre
1)
While doing Table -> View Data, and inserting a new row:
If you get an error such as a primary key violation on a table that uses
a serial... you may have violation where id=1... and you may want to
retry because you know that id=2 is available... so the counter will
increase and your inser
the startup. It's pretty easy to auto detect where
the virtualenv tools are located on major distros, and worst-case, it
can always fall back to spit out a note saying 'here's how you do it
manually'.
On 12/13/2016 04:05 AM, Dave Page wrote:
On Mon, Dec 12, 2016 at 9
64 Nov 1 13:11 flask_sqlalchemy
drwxr-xr-x 1 markm markm 154 Nov 1 13:11 flask_wtf
I'm using the same path as last time, but it cannot find what it needs...
On 12/12/16 04:41, Dave Page wrote:
Hi
On Mon, Dec 12, 2016 at 1:04 AM, Mark Murawski
wrote:
(pgadmin4)markm {~/download/p
(pgadmin4)markm {~/download/pgadmin4/runtime} kobaz$ git pull
Already up-to-date.
(pgadmin4)markm {~/download/pgadmin4/runtime} kobaz$ git log | head -n 1
commit 4a280b251755091af9bf56bcdee964601df104ae
(pgadmin4)markm {~/download/pgadmin4/runtime} kobaz$ qmake
Project MESSAGE: Building for QT5+.
More to Add:
Core features missing from pgadmin4
-There's no search functionality in the sql-query/function editor
-You cannot dynamically change the font size bigger/smaller with
ctrl-mouse-scroll
-You cannot open a query in a new window
-Functions all open up in a tab named 'Query-untitled' w
pgadmin4 1.1
Problem:
Add columns to table in "create table" dialog
Navigate to 'primary key'
Enter primary key name
Cannot select column to primary key on
This also is a problem for foreign keys and unique keys
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.or
On 11/2/16 8:01 AM, Dave Page wrote:
Hi
On Tuesday, November 1, 2016, Mark Murawski
mailto:markm-li...@intellasoft.net>> wrote:
On 11/01/16 12:58, Mark Murawski wrote:
The above exception was the direct cause of the following exc
Make sense. Probably should throw a warning about this and/or refuse to
connect.
On 11/2/16 10:50 AM, Ben Trewern wrote:
Hi,
pgAdmin 4 supports PostgreSql 9.2 and above. I guess that’s the problem.
Regards,
Ben
On 2 Nov 2016, at 14:43, Mark Murawski <mailto:markm-li...@intellasoft.
Working with pgAdmin 4 1.1 on Mac 10.11.5
I connected to a postgres 9.1 database and I'm just clicking around
looking at individual columns in the tree within:
db
schema
table
col1
col2
..etc..
If I click on 'col1', I get this:
ERROR: syntax error at or near "WH
On 11/01/16 12:58, Mark Murawski wrote:
Now I'm stuck here:
(pgadmin4)markm {~/download/pgadmin4} markm$ pip install -r
requirements_py3.txt
Downloading/unpacking Babel==1.3 (from -r requirements_py3.txt (line 1))
Downloading Babel-1.3.tar.gz (3.4MB):
On 10/30/16 13:13, Dave Page wrote:
That email is really quite old - we ignore PYTHONPATH these days
(otherwise, if the user has it set for other purposes, it can break
pgAdmin).
I made some significant updates to the README last week, which you
should review - particularly the part about config
Hi,
So I followed all the instructions so far with pgadmin4 1.1
Debian Jessie
Qt5 5.3.2-2
Python 3.4 3.4.2-1
All the requirements are met:
markm {/home/markm/download/pgadmin4-1.1} root# pip3 install -r
requirements_py3.txt
Requirement already satisfied (use --upgrade to upgrade): Babel==1.3
Hi,
It seems to run on my Win7 … I started it, connected to a DB, did a few things
and I left it alone for an hour (I went out to lunch).
It crashed while I was away …
Regards,
Csaba
From: pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of
… But if the name of the database contains uppercase characters, the same
problem arises :
psql: FATAL: database ""Dj"" does not exist
- Mark
De : Melvin Davidson [mailto:melvin6...@yahoo.com]
Envoyé : Thursday, October 20, 2016 10:09 AM
À : Mark Watson; pgadmin-su
De : Melvin Davidson [mailto:melvin6...@yahoo.com]
Envoyé : Thursday, October 20, 2016 10:09 AM
À : Mark Watson; pgadmin-support@postgresql.org
Objet : Re: [pgadmin-support] pgAdmin4 Maintenance gives Database does not exist
I am not pgadmin4 support, but this looks to me like the problem is
ror : psql: FATAL: database ""815""
does not exist
Note the datebase name has two double quotes. Could this be a configuration
issue?
Executine analyze in an sql window works fine.
Thanks,
Mark Watson
the preference for a consistent look and feel, but the
native Windows Open File dialog (as used in pgAdmin 3) seems quicker and
more fully featured e.g. I can rename and move files and directories
within it. Perhaps it doesn't work with the new web based paradigm though.
I appreciate the wo
Hello,
Just a note:
Press Alt+Space, then select „Move” from the menu and you will be able to move
that window from behind the splash screen with the cursor buttons.
It will not solve the problem but you will be able read it.
Regards,
Csaba
From: pgadmin-support-ow...@postgresql.org
[
Hello,
I'm not an expert on this, but I would start with this line:
"undefined reference to symbol 'pthread_sigmask@@GLIBC_2.2.5'"
Csaba
-Original Message-
From: pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Luca Ferrari
Sent: Tuesday,
Hello Luca,
Try using apt-file:
sudo apt-get install apt-file
sudo apt-file update
sudo apt-file search python-config
And you will get a list with the package and filenames ... from which probably
you'll need "python-dev"
Cheers,
Csaba
-Original Message-
From: pgadmin-support-ow...@p
disconnecting and reconnecting the external displays fixes the issue until
reboot.
unsure if this is an OSX quirk or something related to pgAdmin3.
thanks,
-Mark
t. Suggestions as to how
to access postgresql?
Thank-you
Mark Gleicher
edit pg_hba.conf
make sure you have the following line:
local all postgres ident sameuser
su to the postgres user
run psql
you should now have full access to the database to add your superuser
back again
On 02/01/2010 08:55 AM, pedro.prat.du...@everis.com
Hello,
I do not want to run Poker Tracker on my Mac Book.
How do I remove the trial set-up set up from my Mac.
Thanks Mark Drabot
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
retrying the connection, but I waited more than 30 minutes for it
to time out and reconnect. It has done this to me a number of times. It
seems the connection management needs more intelligence.
Very minor stuff, but I though you should be aware of it. Again, nice work
and thanks for all you do
When you double click on a column, it cycles from collapsed, to the size
that fits the longest value.
It would be very very useful if it also cycled to a third option, which is:
expand to the longest value that also shows the full column name and
column type.
--
Sent via pgadmin-support ma
lhost' problem has gone.
--MZ
____
From: Dave Page
To: Mark Zhitomirski
Cc: pgadmin-support@postgresql.org
Sent: Thu, October 22, 2009 12:28:11 PM
Subject: Re: [pgadmin-support] pgAdmin does not respect pgpass.conf when
opening .sql files?
On Wed, Oct 21, 2009
ut. Password prompt happens again. Question 2 - is it possible to
avoid this prompt?
Thanks
-- Mark
If you
- have a query window open
- and you're editing a function definition, or trigger
- execute the query, and update/replace the function or trigger, or
type. or table, or any other object
- and then later right click on the object and do 'create script'
you'll get the old data that was cac
When I'm doing heavy development I'm always removing and recreating
tables and views.
If you
- drop a view
- create a view with the same name
- and have the data window for the view open from before it was dropped
- and do a refresh
You lose the column names, since the oid for the view/table is
Also, along the lines of pasting...
You can't copy text from a query editor using the "select a region"
method that's standard in X (where you select a bit of text, and then
middle click in another window to paste).. This kills the ability to
paste into xterms from the query window. But, if y
I think you're on the wrong list
On 07/13/09 15:46, Benjamin Krajmalnik wrote:
There is a bug on the php pg libraries for windows.
Apparently they are having an issue loading the libraries (started about
a year ago with an apparent change in the way the p libraries are
compiled)..
On my wi
It would be really really great if when you added a new server, or
changed local settings, that it wrote out the config file. When pgadmin
crashes, you lose any settings changes.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
htt
Tabs would be cool!
On 07/11/09 16:13, Erik Rijkers wrote:
Hi,
With several servers (e.g. 8.3, 8.4, 8.4devel) open in pgadmin's (1.10)
main-screen
(object-browser panel), it often becomes difficult to see where you are,
because there is no
feedback other than in the 'root' object (where the
Well, All of my editable views have a unique identifier. Navicat does
warn you, that it will use an all old = new type of update when you
edit.
On 07/11/09 15:53, Dave Page wrote:
On 7/11/09, Mark Murawski wrote:
Feature request: Editing of editable views
When you view the
Feature request: Editing of editable views
When you view the data on a view, nothing is editable. Navicat in
windows supports editing editable views by using an 'update where all
columns = old data, set new data' type of query.
My projects heavily use editable views, and I'm constantly swit
I am a newbe with PostgreSQL and with pgAdmin so bare with me please. Below you
list the steps to fix this issue but I need the steps before the "Now, click on
created aggregate..." I can not locate this.
Also I am very impressed with the response time for this help request
No rush Magnus, Dave's alt-printscreen suggestion works just fine. Thanks
Dave
____
Mark Steben│Database Administrator│ @utoRevenueT
480 Pleasant Street, Suite B200, Lee, MA 01238
413-243-4800 x1512 (Phone) │ 413-243-4809 (Fax)
A Division of Dominion Enterp
appreciated.
Thank you,
Mark Steben│Database Administrator│ @utoRevenueT
480 Pleasant Street, Suite B200, Lee, MA 01238
413-243-4800 x1512 (Phone) │ 413-243-4809 (Fax)
A Division of Dominion Enterprises
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To
Thanks for the confirmation Vince, at least I know I'm not loony.
The windows version is the binary downloaded from pgadmin site. wxWidgets
on my linux box is 2.8
On Nov 29, 2007 5:39 AM, Dave Page <[EMAIL PROTECTED]> wrote:
> Vince Ieraci wrote:
> >> Mark Williamson
to post a patch, but my C/C++ is not worth
beans these days.
Mark
-
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.
all
> (and I don't know PostGIS so can't really make an informed comment).
>
> Mark; can you comment on what would be needed in pgAdmin to claim we
> support PostGIS?
Hi Dave,
In terms of operation, PostGIS is 95% server-side code, with the only
client-side code being the
Im missing the table backup/restore on PGadmin 1.6.2 in Linux
Sorry if this is a faq but a cursory look at the bug list didnt reveal anything.
Mark
---(end of broadcast)---
TIP 6: explain analyze is your friend
t of functions for the DB.
> This seems so stupidly simple, and it probably is, so what am I doing
> wrong?
>
> Thanks,
> Steve
>
>
>
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster
Been a _
I would like to second this suggestion. It would even be nice to be
able to define an sql template to be run when the table is double
clicked. Either way, it would be a great addition to a tool that I use
on a daily basis.
Thank you for your consideration.
-Original Message-
From: [EMAI
Hi,
I think the default rmp installation ( rpm -ihv
postgresql-server-.rpm) will install postgresql into
/var/lib/pgsql/
How can I install postgresql's rpm's (v7.4.6/FC2) into specific
directory?
Thanks,
Mark
__
Do you Yahoo!?
Meet t
Justin,
Just dowload and use YaST to install the rpms for _Mandrake_ from the
pgadmin3 mirrors. They work perfectly on SuSE 9.0. I think this is just a
small bug in the way the pgAdmin3 rpm for SuSE was rolled.
This worked for me, YMMV.
Mark
On Tuesday 27 January 2004 00:44, Justin
ousands of "undefined
reference" errors from what seems like every line of code in the app. Make
then exits with an error.
Any ideas? Thanks.
Regards,
Mark
---(end of broadcast)---
TIP 9: the planner will ignore your desire to cho
Can someone help me? I have a large database that I have been working on in MS Access
and then placed it on a Red Hat Server. It works awesome with PGAdmin and PostgreSQL.
I then needed to take the code and database both an Access based import and a pgdump.
When I installed the beta version, I r
atch. The migrations do work and the data is
there, but that is all I seem to be getting.
Thank you
Mark
Perez
October 08, 2003 1:07 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Keep-alive?
>
>
>
>
> > -Original Message-
> > From: Mark Rappoport [mailto:[EMAIL PROTECTED]
> > Sent: 08 October 2003 12:01
> > To: [EMAIL PROTECTE
sage boxes telling me that the
server is offline.
Are there any plans to change this functionality?
Thanks.
--
+------
+ Mark A. Rappoport
+ Software Engineer
+ NSA Internet & Security Ltd.
+ +972-68-523-103
+--
e configure command is case sensitive, and spaces are
important. It should be:
./configure --with-gtk --enable-gtk2 --enable-unicode --disable-shared
--enable-debug
Regards,
Mark
On Monday 29 September 2003 12:55, b-vol wrote:
> Greetings,
>
> I am new to this list. I need so
files? I've been at this for a month of my spare
time (granted, my spare time is rather limited), and I haven't come across
any other workable solutions.
Thanks.
Regards,
Mark
> *NO*.
> This destroys dialog design, remaining is merely a control collection.
> Sizings
which I will submit to pgadmin-hackers to get feedback on whether the
developers want to pursue this with the remaining forms and add them to the
distribution.
Thanks for all of your help, and congrats to the developers and testers on
reaching v1.0!
Regards,
Mark
On Friday 19 September 2003
displaying the documentation in traditionall Postgres blue, etc.
However the builtin help browser does not seem to apply the CSS. IMHO this is
the cause for the gigantic fonts in the help browser.
Could a CSS/XML issue be the root of my problem? Any ideas?
Thanks,
Mark
> Mark A. Taff
d, rendering the controls/forms difficult (in some cases,
nearly impossible) to use. Any other suggestions? Thanks.
Regards,
Mark
>
>
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
--
nitor.
System Info:
AMD Athalon XP 2400
1 GB RAM
SuSE Linux 8.2
KDE 3.1.1
PG 7.3.2
Installed from: pgadmin3-0.9-20030806.1386.rpm
Regards,
Mark
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postg
On Friday 08 August 2003 12:01, you wrote:
> Hi Mark,
Hi Andreas,
>
> Mark A. Taff wrote:
> >Font name and size settings in help: bug reporting: options dialog are not
> >saved between uses
>
> Can't reproduce this, works for me. Is ~/.pgadmin3 write prot
On Friday 08 August 2003 12:01, you wrote:
> It's rumoured that Mark A. Taff once said:
> > First off, thank you Dave, et. al. for continuing your work and
>
> You're welcome.
>
> > Font name and size settings in help: bug reporting: options dialog are
> >
PostreSQL is not compatible with Microsoft
Server.
Is there an update or anyway I can do this without changing my entire
database?
Please help?
Mark A. Perez
IT Specialist
Woods Hole Group
---(end of broadcast)---
TIP 2: you can get off all lists
have been made in pgadmin, ie, add a column, field, etc.?
If anyone has this answer, or knows someone who does, please let me know.
Best regards,
Mark A. Perez
IT Specialist
Woods Hole Group
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "John Bercik
date DEFAULT
'2299-12-31'::date,
---snip---
Now, I could go and check each table, however it
would be great if they came across.
Thanks for a wonderful product (which I will
continue to say until hell freezes over!)
Thanks,
Mark ...
(50),
"ShipState" character varying(50),
"ShipStateOrProvince" character varying(50),
"ShipPostalCode" character varying(20),
"ShipCountryID" integer,
"ShipPhoneNumber" character varying(30),
"ShipDate&
Hi,
I have installed cygwin 1.3.12-2, latest release version.
Using the instructions given at:
http://www.ejip.net/faq/postgresql_win_setup_faq.jsp#cygwin
I have installed postgresql. Created a db on a drive other than the default
drive. Can connect using psql. Default user Administrator
unsubscribe
Hello [EMAIL PROTECTED]
This is a test Email
Did it work?
Mark
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
the record for updating the database"
I have checked my ODBC Configuration to ensure it is not set to the
default "READ ONLY" Settings. Can anyone tell me why I get this error
and whether there are any workarounds to this problem, short of writing
my on SQL statements
69 matches
Mail list logo
