ive? - or do they
need to be in the PATH or something?
--Ray.
-----
Raymond O'Donnell http://www.galwaycathedral.org/recitals
[EMAIL PROTECTED] Galway Cath
m Files\Borland\Delphi6\Bin (version
7.3.3.0, 32,768 bytes).
Has anyone encountered this problem?
--Ray.
---------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
[EMAIL PROTECTED] Galwa
large tab indent causes lines to run off the right edge of
the window after just a couple of levels of indent.
Congrats to all working on pgAdmin - the new version looks great!
--Ray O'Donnell
-----
Raymond O'D
On 10 Nov 2005 at 13:37, Andreas Pflug wrote:
> Just implemented and committed to svn for 1.5/1.6.
Great stuff! Thanks!
--Ray.
-----
Raymond O'Donnell http://www.galwaycathedral.org/recitals
[EMAIL P
no
I have the same behaviour on WinXP - I can't click on an item in the
combobox, but I can scroll down (if the combobox has focus) using the
arrow keys or the middle mouse button.
--Ray O'Donnell
---------
Raymond O'Donnell
the same machine.
--Ray O'Donnell
---------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
[EMAIL PROTECTED] Galway Cathedral Recitals
-
---(end o
On 3 Aug 2006 at 15:47, Dave Page wrote:
> It'll probably only get fixed for 1.6.0 though (I very much doubt there
> will be a 1.4.4 anyway).
Is there going to be a 1.5? - just curious.
--Ray.
------
Raymond O'
n32)? - Any chance that registry
entries, etc., might get messed up?
--Ray.
------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
gAdmin 1.6,
though I had the same problem with the recent beta and a couple of
snapshots before that. The problem doesn't manifest itself with
1.4.3.
Any help or ideas would be greatly appreciated.
--Ray O'Donnell
-----
s" spelt
properly. :P
--Ray.
------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
[EMAIL PROTECTED]
--
s uses the standard names such as
"character varying", etc, but the dialog for altering columns uses
the abbreviated forms, such as "varchar".
Thanks for all the hard work and a great tool.
--Ray O'Donnell.
------
On 16 Oct 2006 at 14:43, Erwin Brandstetter wrote:
> But I will test the piece if you send it over.
I'd also be happy to try it out.
--Ray.
--
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, I
the parentheses.
Thanks for all the hard work!
--Ray.
------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Irel
of the line. If it's still there, then the
line is having no effect - remove the '#' and restart postmaster.
This list isn't the appropriate place for this question - better on
pgsql-general.
--Ray.
----------
Raymond
in the same window.
--Ray.
------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
[EMAIL PROTECTED]
--
---(
creating it in turn from template0 - it's detailed at
http://www.postgresql.org/docs/techdocs.22
--Ray.
------
Raymond O'Donnell
Director of Music, Galway Cathedral, Gal
ation, and there
are no functions whatever in the public schema of template1 on my
development machine.
--Ray.
------
Raymond O'Donnell
Director of Music, Galway Cathedral, Gal
, not pgAdmin.
--Ray.
----------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
[EMAIL PROTECTED]
--
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
step (viii) on your previous installation - the
"Cube" module is the one that you seem to have included.
--Ray.
------
Raymond O'Donnell
Director of Music, Galway
o run..what error message did
you get?
--Ray.
----------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
[EMAIL PROTECTED]
--
On 28 Nov 2006 at 22:06, Raymond O'Donnell wrote:
> Don't you need to declare pCentreGroupPolicyID first? -
Oops, my mistake - you don't of course, because it's an INOUT
parameter.
--Ray.
------
Raymon
Hi Dave et al,
Just spotted a small typo or two in the guru hint for "Editting
Views, Stored Procedures or Functions" - "editing" should have just
one "t". :)
--Ray.
----------
Raymond O'Donnell
On 30 Nov 2006 at 21:05, Frank Jessopp wrote:
> and speling has two LL's
That was supposed to be my small joke :)
--Ray.
--
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
[EM
red that tooyou can resize the form to make the
button visible, but it is a bit of a nuisance to have to do so each
time.
--Ray.
------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway,
backups.
--Ray.
------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
[EMAIL PROTECTED]
--
---(end of broadcast)---
TIP 5: don't for
in it.
--Ray.
------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
[EMAIL PROTECTED]
--
---(end of broadcast)-
nd it by creating a new shortcut to the help file in my
Start menu (on WinXP) - if you use it a lot, you could even add it to
your quick-launch bar.
--Ray.
------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galw
tes an integer column with a default which executes
nextval() on a sequence which it also creates.
http://www.postgresql.org/docs/8.2/static/datatype-
numeric.html#DATATYPE-SERIAL
--Ray.
----------
Raymond O'Donnell
Director
and set the permissions on the sequence separately as often as not,
I forget to do it altogether and am reminded only when the application
bombs on the first INSERT! :)
Ray.
---
Raymond O'Donnell, Director of Music, Galway
, and does that supremely well.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of
t; node in the Object Browser and
select "New Slony-I cluster", the status bar still tells me "Slony-I
creation scripts not available; only joining possible."
I'm running pgAdmin III 1.6.2 on WinXP SP2.
What am I missing?
Thanks,
Ray.
-------
Dave Page wrote:
So, the simple answer is to rename xxid.sql to xxid.v80.sql, and then to
copy it to xxid.v74.sql, and copy the slony1_funcs.v80.sql in the same way.
That did the trick - good on you!
Ray.
---
Raymond O'Do
e database, the "Admin node"
field says "None". Please help me make sense of all this!
Thanks...!
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
ture I have to allow for others -
mostly non-technical - looking after it also. I'm a relative newcomer to
Slony and have been using slonik, but I thought pgAdmin might offer an
easier route for others.
Thanks for all the help,
Ray.
--------
oup.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ther there or on -advocacy. Have a trawl
through the archives for both those lists and I'm sure you'll find
material of help.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral,
dded.
Regards,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 6: explain analyze is your friend
ror(s) are you getting? etc etc.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of
here.
If PostgreSQL is running on Windows, then it runs as a service, and
"service" is the name of that service. Look in "Administrative Tools" ->
"Services" to find out what yours is called.
HTH,
Ray.
-
On 15/04/2007 17:12, Raymond O'Donnell wrote:
"Port" is the TCP/IP port on which the server is listening - this is
5432 by default, unless you chaned it when installing PostgreSQL.
Typo: for "chaned"
re you sure the server *is* actually running? - Have you tried to
connect to it with something else, such as psql? - or do a "ps ax | grep
postgres" on the server machine and verified that it's there?
Ray.
-------
Raymon
ddress) -U (username) -d (databasename) etc.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(e
? Did you try using psql to connect to the DBMS?
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
--
postgresql.conf.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broa
ce", "PostgreSQL
Client Applications".
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
--
day off! :)
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 3: Have you chec
Yes, the documentation is on the website - look under the link entitled
"documentation"..
Ray.
-------
Raymond O'Donnell, Director of Mu
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 1: if posting/reading through Usen
of pg_dump available at the time of release - so this
would have been 8.2 with the current pgAdmin.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROT
e could be different installer: one with only the latest tools and
another one with all compatible tools versions to be able to work
correctly on different servers !
The installer guys are going to *love* that suggestion! :-)
Ray.
-------
Raymond
On 19/06/2007 14:36, Dave Page wrote:
Raymond O'Donnell wrote:
Agreed - an option in the preferences to specify the path to the desired
pg_dump would certainly be useful.
Already in the next release.
Great!
another one with all compatible tools versions to be able to work
correct
c/pg/sql-commands.html
whereas the correct URL is
http://www.postgresql.org/docs/current/static/sql-commands.html
- note the extra '.../pg/...' in the first one.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Ca
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 2: Don'
ing using psql from the command line on the Windows box.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
://www.pgadmin.org/docs/
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broa
,
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 9: In version
left
then right-click and select "New...", or use the "New" button at the top
of the screen. Are you inadvertently creating the tables in the
"postgres" database?
When you use pg_dump, you need to specify the database by means of the
-d switch.
Ray.
-
configuration issue but could not find anything.
Didn't happen for me - I'm on XP SP2 and 1.8.0 beta 1, and F5 executed
the query as expected without any side-effects.
Ray.
-------
Raymond O'Donnell, Director of Music, Galw
carefully as I could, I was
getting psychadelic keyboard input! :-) I eventually had to replace it
altogether.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROT
.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desi
omment-out
selected text automatically, and I'll be the proverbial pig in
doo-doo yes, I know about executing selected chucks of a query, but
the other would be nice too. :-)
Thanks for all the hard work,
Ray.
-------
Ra
ainly don't
mean to increase your workload! :-)
Ray.
-----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
--
s and indents the currently-selected text.
Maybe in pgAdmin 1.10...? :-)
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL
ht me once or twice. Good on you!
I've updated the .exe again - please let me know what you think.
I've zapped the email with the link - any chance you could post it
again? Ta.
Ray.
-------
Raymond O'Donnell,
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 6: explain analyze is your friend
On 03/09/2007 12:48, Dave Page wrote:
Not sure I recall why Magnus left that as a combo box there, but you
should be able to manually enter the server, username and database
details, eg:
Ah, ok - grand - thanks.
Ray.
---
Raymond
better chance of getting answers
to your questions on the Slony-I list where you'll find the Slony gurus
- this list is for pgAdmin.
Sorry I can't be more help than that.
Ray.
-------
Raymond O'Donnell, Director of Music, G
once called 7.5 was a development version that went on
to be released as 8.0 a number of years ago - hence the warning.
Don't use it - get the latest version (8.2.5) from www.postgresql.org
instead.
Ray.
---
Raymond O&#x
k the box by "Aggregates".
Ray.
-----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)-
On 16/11/2007 12:24, Dave Page wrote:
Should we consider dropping official support for PostgreSQL 7.x in the
next major version of pgAdmin?
I'd be against dropping support before 7.x is officially deprecated.
Ray.
---
Ra
:-)
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 4: Have you se
pment
one, and so quite small (160kb zipped).
Anyone else see this? I'm using pgAdmin 1.8 on Windows XP SP2, and PG
8.2.5 on the same machine. I seem to recall a bug along these lines in
an earlier version of pgAdmin
-------
R
f pgAdmin, but I thought it had been fixed. I
couldn't find the reference in the archives.
Thanks,
Ray.
-------
Raymond O'Donnell, Direct
e view whenever I drop/recreate it.
Have a good weekend,
You too, and thanks for the pointer.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
On 24/11/2007 14:25, Dave Page wrote:
--- Original Message ---
From: "Raymond O'Donnell" <[EMAIL PROTECTED]>
I can send a dump of the database if it's any use - it's a development
one, and so quite small (160kb zipped).
Please do.
Do you still wan
andwidth in the lists.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
uot; and accepting TCP/IP connections
on port 5432?") and giving all sorts of useful advice.
Do you not see something like this?
Ray.
-------
Raymond O'Donnell, Director of Music, Galway
achine from which you're
trying to connect?
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---
tgres 192.168.1.25/24 md5
The configuration is well documented in the file itself, and also in the
PostgreSQL docs under "Client Authentication" (if memory serves).
HTH
Ray.
-------
Raymond O'Donnell, Director of
d will be md5-encrypted before being
passed over the wire.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)--
nnect?
Can you describe *exactly* the steps you take, and the error messages
you get back?
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL
orks fine.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
T
docs) - works a treat! :-)
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
mentation at http://www.postgresql.org/docs/ to see
whether a dump/reload was required.though if you can connect with
PgAdmin after the upgrade, then all is probably well.
HTH,
Ray.
-------
Raymond O'Donnell, Direc
grade requires initdb to be
run, which prepares the data directly afresh from scratch.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL
t show up in PgAdmin under the table's "Triggers" node. They do,
however, appear in PHPPgAdmin and in psql.
I'm using PgAdmin 1.8.0. Am I missing something? Or should I just
upgrade to 1.8.1?
TIA,
Ray.
-------
Raym
t show up as foreign keys under
the "Constraints" node either).
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
software. Pick one close to you and take it from there!
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROT
he job - I had done a pg_dumpall/psql reload, which created
all the databases from template0.
Thanks!
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[
hat am I missing?
TIA,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 4: Ha
le).
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 3: Have you checke
.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscri
the file
was created from the query editor in the first place, and had never been
opened by anything else.
Ray.
----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http
On 09/04/2008 09:35, leoabhi wrote:
I wish to connect Visual Studio 2008(VB) to Pgadmin..
Do you mean connect to PostgreSQL, not PgAdmin?
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[
.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--
--
Sent via pgadmin-support ma
it?
Ray.
------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--
--
Sent via pgadmin-support mailing list (pgadmin-support@pos
xt menus.
It does for meright-click on "Login Roles" and you get a menu item
"New Login Role..." as expected. I'm using 1.8.2.
Ray.
--
Raymond O'Donnell, Director of Music,
On 28/05/2008 20:50, Sri Lakshmi wrote:
Do we have GUI interface for postgresql on Linux?
PgAdmin is available for a variety of platforms, Linux among them. Have
a look at the website - www.pgadmin.org.
Ray.
--
Raymond
3/static/app-psql.html
[2] http://www.postgresql.org/docs/8.3/static/app-createdb.html
[3] http://www.postgresql.org/docs/8.3/static/app-createuser.html
----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMA
es installation}/bin.
HTH,
Ray.
----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
-
1 - 100 of 294 matches
Mail list logo
