Version: 1.4.0 Beta 2 (Oct 12 2005)
running on Windows XP SP2
installed from PGInstaller 8.1 beta 3, 12. Oct. 2005
when doing "longer running operations" like "VACUUM ANALYZE", the
interface freezes totally. I cannot press "CANCEL" or resize windows or
do anything else.
With older PG_Admin this
I use libpq from 8.1-beta3 from the actual beta installer.
I get the freeze on connecting to 8.1-beta3 server and 8.0.3 servers.
And: it freezes when I use "right mouse, maintainance" ... not from the sql query menu
(rechte Maus + Wartung)
Harald
-- GHUM Harald Massapersuasion python postgresql
In my case even "intense and active waiting" helped. VACUUM seemed to stop for some thinking, then it moved it moved it...
I had this "clicking OK multiple times" on 1.2 pgAdmin. But
my impression was that that "ok" really started VACUUM again.
Yes,
it does - it seems to just pause every now
Dave,
I had this "clicking OK multiple times" on 1.2 pgAdmin. But my impression was that that "ok" really started VACUUM again.
Harald-- GHUM Harald Massapersuasion python postgresqlHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607
Hello,today I installed pgAdmin III rc1It still looks PHANTASTIC :)When I go "Hilfe, pgAdmin III FAQ" the appearing Window freezes as well as pgAdmin IIIThis is within a corporate network, all HTTP- and HTTPS-Access is only possible via a Proxy. (even ping is disabled)
The proxy settings are e
Hello,I tried to install pgAgent on Windows XP Prof. SP2. Documentation and help suggest:options:-u -p -d -t
-r =10, default 30)>-l using -uusernameor
-ppasswordleads to ERROR: Invalid command line argumentonly without a space I can move on to "illegal account name"May
Dave,C:\Programme\pgAdmin III\1.4>pgagent.exe INSTALL pgAgent -unasenbaerERROR: Der Kontenname ist unzulõssig oder nicht vorhanden, oder das Kennwort ist f³r den angegebenen Kontennamen ung³ltig.
C:\Programme\pgAdmin III\1.4>pgagent.exe INSTALL pgAgent -u nasenbaerERROR: Invalid command line argume
pppsss...never thought that there are separate ones, sorry to bother.I guess "proxy authorization" is beyond scope?Harald-- GHUM Harald Massapersuasion python postgresql
Harald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607
Wow, thank you very very much, Dave!
think you can put that DOMAIN\user syntax into the documentation?
Everytime I stumble upon I get mixed up if it is
[EMAIL PROTECTED]
or
domain/user
or
domain\user
or
\\domain\user
or even
\\domain/user
... so, to have it in that documentation could really
aktuell: PostgreSQL's Offfizieller Beburtstab ist der 8. Juli. Das PostgreSQL-Projekt wurde in 1996 geboren.should be: PostgreSQLs offfizieller Geburtstag ist der 8. Juli. Das PostgreSQL-Projekt wurde 1996 geboren.
-- GHUM Harald Massapersuasion python postgresqlHarald Armin MassaReinsburgstraße 20
hello,after playing with inheritance of tables to find some use for the new constraint_checks table partitioning, I found myself in need of dropping one column.Within the tree it is possible to drop cascade for many objects, but not yet for colums.
So I ask for the orthogonality enhancement of allo
I discovered a subtle bug within the dialog for foreign key creation:Be there a database "testdb" structured like:CREATE SCHEMA nb1;CREATE TABLE nb1.hauptbaer ( id_baer serial NOT NULL,
fischfeld text);ALTER TABLE nb1.hauptbaer ADD CONSTRAINT hauptbaer_pkey PRIMARY KEY(id_baer);CREATE TABLE
pgAdmin in its youngest incarnation supports a "connection" dropdown above the query window.But I am not able to select more then 1 connection by any means.1st try: being connected to more then one server in the main tree. Opening Query Window while standing on one database. only 1 connection
2nd t
> pgAdmin in its youngest incarnation supports a "connection" dropdown> above the query window.>Which version/platform?Version 1.4.1 on Win32Harald-- GHUM Harald Massa
persuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-PostgreSQL - supported by a community th
Version 1.4.2 on Windows XP, freshly installed from the "official" .msisituation:database schema ibox containts table filestore - id_fs inet- content bytea- morecol text
and fs2objekt- id_fs inet- whatever textI try to create a foreign key on f2objekt, referencing filestoreThe dialogue does show al
Dear Henrique,to be able to help you better, you should direct your question to the appropriate mailing list, which is postgresql performance; you can find all mailing-list-subscription within
www.postgresql.orgYou also should in that mail give some more details: which PostgreSQL Verison, on which
Anika,thanks for the complete error description, I bet the culprit is in here:
I recently updated my norton anti-virus and norton goback - and up until then - everything for my sambc was working fine now when I try and open sambc and I received the error message:
X 2006-07-09 22:09:19 [CORE] Conne
the Owner (administrator) account and a postgre account - the postgre acccount requires a password - unfortunatly when I get the password from sambc/core.xml file - the password does not work HELP
Thank you
Anika Evans
On 7/10/06, Harald Armin Massa <[EMAIL PROTECTED]
> wrote:
Anik
I am sooo impressed with this new release! And that scratch pad is a really helpfull addition, I fell in love with it.BUT... that is a dangerous love, I learned. What happened?I constructed a fine query:
select md5(array_to_string(array( select md5(id_pkl||id_label || id_lg || name_l||letztespeiche
Hello,when exporting a query result with 1000 rows , 2 colums (int4 and text), and some NULL values within the text column, pgadmin crashes. (phone home crash)This crash does not appear on exporting a smaller subste of the same result also with nulls and only 5, 100 or 200 rows (added a limit claus
I am totally fascinated with 1.6 ... and do more and more queries in that joyfull Query window!The "underlining of the errornous character" is really a big help for small typing misstakes, GREAT!On the Data Output grid, something could be better: those grey column headers get refreshed in slow moti
Same "slow motion" is happening on resizing
the output pane panel.
What's
happening is that when the grid control redraws itself, it asks the dataset what
the header labels should be. The dataset then queries the
database to get the correct
typename (because libpq's PGresult only stores th
Hello,I am using a kindly-by-Dave-provided PgAdmin 1.6 Beta from SVN Head as of 2006-09-19 9:07.Within the Query Window I am developping a query:select md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf), * from repofeld
select md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf||anothe
I am developing this sort of query since last friday. And only since yesterday (= update Beta 1.6) I am plagued with those crashes within the query window. (it is no complete prove that it worked - but on monday I developed this query for around 5 tables, without plague of crashes; and yesterday /
The dataset is some 1000 rows; usually while developing I limit to 10. I did it again: developed a query, and just as I was finishing - crash. (this time without "as checksum")Wil do it again, with "as checksum" ... and it works.
I keep on trying to make it reproducible, with a limit amount of data
Ezequias,you can vastly speedup of day-to-day knowledge retrieval by simply using Firefox. You can just highlighted the text, rightclick and search ...
http://www.google.de/search?q=The%20answer%20to%20the%20question%20of%20Life%2C&ie=UTF-8&oe=UTF-8&hl=de&btnG=Google-Suche&meta=
the first hit is:
h
Ezequias ,
I would like to overwrite a table with problem with his original. But there are some points.
I can't just delete and restore it becouse it has a foreign key and when I try to delete it ask for drop cascade.
As I know the drop cascade delete in both tables the rows related. Is it correc
I created a time-constraint table ... that is, rows have a valid-timespan (validvon - validbis, as in "valid from" - "valid until", with German intermixed)CREATE TABLE otlabel( id_label serial NOT NULL,
id_lg integer, name_l text, letztespeicherung timestamp without time zone DEFAULT now(), i
On the "Licence" Page of the above mentioned installer, english language version, the letter "N" is used as accellerator for "_N_o, I Do not accept" and for "_N_ext"That renders it useless :(
Harald-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart017
I downloaded the pgadmin3.mo fileI created a directory named de_DE within i18nI copied the pgadmin3.mo into that directoryno, within File / options / general / user_language I can select de_DE (Deutsch)
but after closing the dialog it falls back to Default ... or whatever else was selected before.W
Hello Dave,I was using that .exe from yesterday intensly.There was only one "stuck" situation, and that was a long running query, and in the middle of the process a virus scanner started to scan. So far from my side: good bugfixing!
One very frustrating habbit was the resizing of the columns of th
Dave,
I downloaded the pgadmin3.mo file
I created a directory named de_DE within i18n
I copied the pgadmin3.mo into that directory
no, within File / options / general / user_language I can select de_DE (Deutsch)
but after closing the dialog it falls back to Default ... or whatever else was selec
Hello,on using pgAdmin b4 query window with German menues, the letter "n" is no longer typeable...select * from wunfails at typing the "n", and opens a new query window.
I know, I have done the German translation ... but aren't .mo files not forbidden to add NON-Alted keys and non Ctrl-ed keys to h
Dave,
select * from wunfails
at typing the "n", and opens a new query window.
Sounds
like you're leaning on the control key.Yeah. That was my first suspicion. So I tried it again, put my left hand away and single-fingerly typed that nand still, a new query window opens. That's absolutely repro
will be enabled.
Best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
---(end of broadcast)---
TI
ible placement would be within the "Export" Dialog,
make a radio select
( ) Filename [filenameselector]
( ) to Clipboard
as wx has a wx.Clipboard-class -> that may be doable, or?
Best wishes
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße
also add the right quotes.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Python: the only language with more web frameworks than keywords.
ald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Python: the only language with more web frameworks than keywords.
if I do
select pg_get_constraintdef(36100)
instead of
select pg_get_constraintdef(36099)
I get the needed result
Please find that "-1" and add it again :)
Best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stutt
st to make sure there is no other bug
hidden)
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Python: the only language with more web frameworks than keywords.
inting to the "o" of spclocation
After accepting the error I cann proceed and work with that database.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!
lt blank in the wizards.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!
sure that I am using the default win32 build.
>
> I guess I'll have to on the CREATE version of the dialogs. Thankfully,
> it shouldn't matter for the ALTER versions as they only script the
> tabespace if you try to change it.
Sounds fine.
Harald
--
GHUM Harald Massa
persua
positioning definition to "pop
up in middle of application window area" instead of
"pop up in middle of main screen" ?
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 200
My 2€cent: dropping suport for 7.x in pgAdmin would give a healthy
incentiv to update.
Harald
> Should we consider dropping official support for PostgreSQL 7.x in the
> next major version of pgAdmin?
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
bout the reason why you cannot start your service.
Also have a look at $PGDATA/pg_log (default below
PostgreSQL/8.3/data), if anything is written there.
best wishes
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 0
a name/timestamp indicating it was created
"just at last system start" ? what is in that logfile?
Best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take pl
partly invalidate all
existing external documetation but being more explicit
I recommend to go with d), especially as in a modern hardware there may be
more then one PostgreSQL cluster (with or without virtual machine around it)
listeing to different IP-Interfaces.
opinions?
Harald
--
GHU
48 matches
Mail list logo
