>Are computer professionals still using MS Windows?
Yes, we use MS Windows with PgAdmin to connect to PostgreSQL on LINUX systems.
Melvin Davidson 🎸
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.
he current version of the product, so I simply
continue to use PgAdmin III until I see sufficient improvements. However,
yourrecent rants does nothing to encourage Dave Page and his team. So kindly
rephrase your disappointment into positive suggestions.
Melvin Davidson 🎸
Cell 720-320-0155
I r
Regardless of the upcoming problem resolution regarding slow start times, or
any of the multitude of Reddit reports, I think PgAdmin developers should
consider this a lesson learned and test on ALL platforms (IE:Mac, Windows,
Linux) before releasing a new version.
Melvin Davidson 🎸
s not existSQL state: 42P01Character: 15
So I would suggest you also provide information as the the O/S you are using
and how you installed PgAdmin 4. Also, what version of PostgreSQL you areusing.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fanta
mode.
3. It's a workaround that says it's ok to ignore a major problem.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.fol
tatic/app-pgdump.html
If you want to "dump" a single column, you must use the COPY TO command.
https://www.postgresql.org/docs/9.6/static/sql-copy.html
Melvin Davidson 🎸
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is
>Unless you omit the E prefix on the string literal, which the OP did.
Nope! That results in 'a//b' but the op wants 'a/b';
Hence the need to Escape.
Melvin Davidson 🎸
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantas
get to enclose your strings in quotes!
IE:
SELECT 'a' || E'\\' || 'b'
UNION ALL
SELECT 'c' || E'\\' || 'd';
https://www.postgresql.org/docs/9.4/static/functions-matching.html#POSIX-ESCAPE-SEQUENCES
Melvin Davidson 🎸
I reserve the rig
coming to
another email address other than pgadmin-support, because I have not seen them.
I do appreciate what you and your team are doing, but as I have said before, I
believePgAdmin4 was a hurried release and more testing should have been done
before it went GA.
Melvin Davidson 🎸
I reserv
data_type,
character_maximum_length as length,
column_default as default
FROM INFORMATION_SCHEMA.COLUMNS where table_name = ''
ORDER BY 1;
--ordinal_position;
Melvin Davidson 🎸
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantas
I have just one wish. Fix ALL the bugs that have been reported BEFORE even
thinking about adding "features". Melvin Davidson 🎸
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/v
el Seq Scan on
> > tblpuorderstatushistory osh (cost=0.00..2957011.17 rows=220702
> > width=4)
> >
> >
> >
> >Filter: ((cancelled_date IS
> > NULL) AND (cc_accept_date IS NOT NULL) AND (vip_order_type = 17))
> >
> >
> >
> >-> Index Scan using tblcnpatientordermap_pkey on
> > tblcnpatientordermap po (cost=0.09..0.41 rows=1 width=8)
> >
> >
> >
> > Index Cond: (vip_order_id = os.vip_order_id)
> >
> >
> >
> > -> Nested Loop Semi Join (cost=0.17..1.02 rows=1 width=4)
> >
> >-> Index Scan using tblcndoctorpatientmap_pkey on
> > tblcndoctorpatientmap d (cost=0.09..0.39 rows=1 width=8)
> >
> > Index Cond: (vip_patient_id = po.vip_patient_id)
> >
> >-> Index Scan using tblcnaccounts_pkey on
> > tblcnaccounts a (cost=0.08..0.36 rows=1 width=4)
> >
> > Index Cond: (master_user_id = d.master_user_id)
> >
> > Filter: ((user_name)::text = 'dd'::text)
> >
> > (19 rows)
> >
> >
> >
> >
> >
> > Regards,
> >
> > ravi
> >
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>I am not sure whether they are doing the vacuum after the upgrade or not
So just run an ANALYZE on the database!
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
t; Nested Loop Semi Join (cost=0.17..1.02 rows=1 width=4)
>
>-> Index Scan using tblcndoctorpatientmap_pkey on
> tblcndoctorpatientmap d (cost=0.09..0.39 rows=1 width=8)
>
> Index Cond: (vip_patient_id = po.vip_patient_id)
>
>-> Index Scan using tblcnaccounts_pkey on tblcnaccounts a
> (cost=0.08..0.36 rows=1 width=4)
>
> Index Cond: (master_user_id = d.master_user_id)
>
> Filter: ((user_name)::text = 'dd'::text)
>
> (19 rows)
>
>
>
>
>
> Regards,
>
> ravi
>
1. Have you run ANALYZE on the database after upgrading?
2. Have you insured that the proper changed were done to the
postgresql.conf in 9.6?
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
version (9.5 or 9.6).
In the meantime, it looks like you need to increase your shared_buffers
parameter in yourpostgresql.conf and restart the postgres server.
https://www.postgresql.org/message-id/4057e37d0fad0814281017dc6c211c00.squir...@sq.gransy.com
Melvin Davidson
I reserve the right to
said, I have replied back to
Marcin that I believe the reason his pg_restore is not working is because his
dbname is CamelCase. I suggested he use the command line version of pg_restore
and look in postgres log for any errors. Since then I have not heard back from
him.
Melvin Davidson
I
local, then can use PgAdmin to restore to either a local or
remote database.
Melvin Davidson
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
you the cause right away, or would you understand if he asks you what led
up to the pain?
Yes, I am a volunteer. In fact, I am a retired PostgreSQL DBA. Hopefully you
will now understand thedifference between a transaction and a stand alone
query. Good luck. Melvin Davidson
Cell 720-320
to reproduce the problem.
As for "ERROR: current transaction is aborted, commands ignored until end of
transaction block"It means all commands from BEGIN; until the error occurs are
rolled back. No further commandsafter the error occurs are executed.
Melvin Davidson
I reserve th
always a good idea to include the PostgreSQL version.
Melvin Davidson
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
>deleting ~/ .pgadmin3 did not change anything.
Did you restart pgadmin3 after deleting?Did you look at pgadmin3.log to see if
there are any obvious related errors?
Just as a wild thought, if you su as root and run pgadmin3 as root, does the
problem still occur?
Melvin Davidson
C
Walter,
Thanks for additional details.
I believe Ashesh Vashi has already given you the best advice of renaming the
~/.pgadmin3 file.Please do not reply directly to me, as I am just another user
like you. All repliesshould go to pgadmin-support@postgresql.org.
Melvin Davidson
Cell 720
Marie-claude,
Have you tried restarting windows? It has always been a problem with Windows
O/Sthat new programs are not fully recognized until windows is restarted.
Probably has
something to do with Windows Registration.
Melvin Davidson
Cell 720-320-0155
I reserve the right to
fwiw, I had the same problem as reported by Marie-Claude QUIDOZ.However, that
was only after initial installation. After closing and restarting the
program, all was working as expected. I view this as an oddity with Windows 10
O/S.
Thank you for continuing to improve the product.
Melvin
programming, but do not
translate well to databases.
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: Mark Watson
To
), is a no no.
Try renaming the database to db815, and see if the problem still exists.
Melvin Davidson
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours
>..what is the server/cluster?It is the instance of PostgreSQL that you have
>installed.You can have multiple instances/copies of PostgreSQL on your PC,
each on a separate port #. If you only have one, it is usually on port 5432.
Melvin Davidson
I reserve the right to fantasize. Whet
uld be helpful if you provided exact PgAdmin version and O/S,
otherwise, we cannot tell you how to remove anything.
FYI, PostgreSQL 9.6 is still Beta. You are better off using a supported
release, ie: 9.5
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my f
I'm pretty sure it would be more helpful if you provided:A. The structure of
the table(s) involved.B. The actual query you used to retrieve the data.C. Did
you run the query in PgAdmin Query Tool or psql ? Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to sha
aving trouble configuring it with Poker Tracker 4". What O/S are you
installing on?
What is the actual problem you are having?
What are the specific errors you are encountering?
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to y
/latest/tutorial-en.html
3. For High availablity, you should look into Replication
https://www.postgresql.org/docs/9.1/static/high-availability.html
or alternatively Slony http://lists.slony.info/
or Bucardo Bucardo - Bucardo
|
|
|
| ||
|
|
|
| |
Bucardo - Bucardo
| |
dback. Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: Regina Obe
To: pgadmin-support@postgresql.org
Sent: Saturday, Janua
tatements will then be
captured to the log.
The other way is to make the changes to the table in properties.A. right click
on the tableB. left click on Properties...C. Add column, constraints, etc as
needed.D. Click on the SQL tab _BEFORE_ clicking the OK button,
Melvin Davidson
Cell 720-32
Options Query Tool Favourites Favourites file path ?
Melvin Davidson
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
g_filename in
postgresql.conf.
Melvin Davidson
Cell 720-320-0155
Folk Alley - All Folk - 24 Hours a day www.folkalley.com
From: "Soule, Cathi (HQP)"
To: Melvin Davidson ; "pgadmin-support@postgresql.org"
Sent: Monday, June 15, 2015 3:29 PM
Subject: R
g_min_error_statement in postgresql.conf?
Try restoring by specifying just the user table.
IOW:
pg_restore -t user -d yourdb your_dump_file
Then see if any errors are returned.
Melvin Davidson
Cell 720-320-0155
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: &
Got it working. It seems the debugger functions need to be generated in each
database, not just postgres.
Melvin Davidson
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero
Folk Alley
FWIW, I am confirming the same problem on Windows 7 Home Premium Service Pack
1PostgreSQL 9.2.10, compiled by Visual C++ build 1600, 32-bit Melvin Davidson
Cell 720-320-0155
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: M. Matt Dugan
To: pgadmin-support
ake that long to open or close. Melvin Davidson
Cell 720-320-0155
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: "hushthatb...@hushmail.com"
To: "pgadmin-support@postgresql.org"
Sent: Wednesday, February 11, 2015 4:03 PM
Subject: [pgadmin-
Have you tried using the "Explain analyze" function (Shift-F7)?
That's what it's for.
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
alks through the basics of creating your first
database using pgAdmin, the comprehensive database design and management
console for Postgres databases. |
| |
| View on www.enterprisedb.com | Preview by Yahoo |
| |
| |
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wis
Thanks. I know support for Windows XP has been officially dropped, and I do
have v1.18. Still, it's a bummer that I can't use the latest/greatest version
of PgAdmin. Hopefully, the Ubuntu version will be released soon.
Melvin Davidson
I reserve the right to fantasize. Whether
n .zip and click on pgadmin3msi
3. Follow prompts to install
4. Click on link to PgAdmin III 1.20
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
>Works for me here. What are your exact steps?
Steps to duplicate:
1. Right Click on a database
2. Click on Backup
3. In popup screen, specify filename.
4. Click the Objects Tab
5. Uncheck the database (1st box)
6. Specifically check two or more individu
O/S - Windows XP Service Pack 3
Language - English
Distribution - binary (.zip)
Version you tested 1.12.2
Bug:
Attempting to backup a CamelCase named database (eg: MyDataBase)
fails with
C:\Program Files\pgAdmin III\1.12\pg_dump.exe --ho
PgAdmin v1.12
I noticed that while viewing the Server Status in PgAdmin, the colors change
for the various processes.
Where is it documented what the significance / meaning of each color is?
Melvin Davidson
and Color
4. Set Red=255
Green=170
Blue=85
5. Click on "Add To Custom Colors" button
6. Click OK
7. Click OK
8. Click OK to messages about server settings
9. Close & then re-open PgAdmin
10, Repeat steps 1, 2 & 3.
11. Note the previous defined custom color has
#x27;postgresql-%d.log' or
'postgresql-%a.log', which causes pgAdmin to not be able to locate the
file.
How hard would it be to add an option, in the General tab,
which specifies the format for the log_filename, thus making it more
flexible?
Melvin
Davidson
Folk Alley
a new name ?
thanks
Rgrds,
Abhi
Melvin Davidson-3 wrote:
>
> Hello Abhi,
>
> It seems to me that a datatype of real[] would be appropriate.
> Alternative syntax is real ARRAY[3]
>
> http://www.postgresql.org/docs/8.2/interactive/arrays.html#AEN5738
>
>
> -Origin
Hello Abhi,
It seems to me that a datatype of real[] would be appropriate.
Alternative syntax is real ARRAY[3]
http://www.postgresql.org/docs/8.2/interactive/arrays.html#AEN5738
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of leoabhi
Sent: Monday, April
you don't want
(pg_catalog & information_schema) and just leave one database and related
schemas.
good luck,
Melvin Davidson
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Monday, March 31, 2008 8:45 AM
To: pgadmin-sup
that?
Also, is there an documented (or undocumented) function I can run to manually
update the counts.
Thanks in advance,
Melvin Davidson
the VACUUM have done that?
Also, is there an documented (or undocumented) function I can run to manually
update the counts.
Thanks in advance,
Melvin Davidson
Can anyone tell me when pgAdmin III v1.8.0 will be available for Fedora Core 8 ?
TIA,
Melvin Davidson
Home 720-870-9595
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
Folk Alley - All Folk - 24 Hours a
That is an old version of PostgreSQL.
"intended for testing puposes only" means just that. It is a Beta release. It
is not intended/advised for a production environment.
If you want the latest release, you should use 8.2.5.
From: [EMAIL PROTECTED] [mailto:[EM
uting.
SELECT n.nspname || ' .' || c.relname AS tablename
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace
WHERE c.relkind = 'r'::"char"
AND reltuples < 3000
ORDER BY
Here's another, quicker way to do it.
SELECT column1,
column2,
COALESCE(maybe_null_column, 'NULL')
FROM your_table;
Note: If maybe_null_column is not a character data type,
then you need to coerce it. ie: maybe_null_column::text
---(end of broadcast
You can do that now with a little code as follows:
SELECT column1,
column2,
CASE WHEN maybe_null_column IS NULL THEN 'NULL' ELSE
maybe_null_column END
FROM your_table;
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ketema Harris
Sent: Thu
@postgresql.org
Subject: Re: [pgadmin-support] Server order
Melvin Davidson wrote:
> Unfortunately, it is currently not that easy because that information
> is stored in the Windows registry.
>
> I think it would be a nice enhancement if it were stored in a small
> local PostgreSQL
Unfortunately, it is currently not that easy because that information is
stored in the Windows registry.
I think it would be a nice enhancement if it were stored in a small
local PostgreSQL database table,
(suggestion - PgAdminDB), but I guess that is something that may be
considered for a future
Behalf Of Matt Busby
Sent: Monday, January 22, 2007 12:10 PM
To: Melvin Davidson
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Cannot connect to one specific postgres
database on a server
I can telnet to the database and query the database The site that is
using the
al Message-
From: Andy Shellam (Mailing Lists)
[mailto:[EMAIL PROTECTED]
Sent: Monday, January 22, 2007 2:35 PM
To: Melvin Davidson
Cc: Matt Busby; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Cannot connect to one specific postgres
database on a server
Melvin,
Your understanding
postmaster(s) are running, then perhaps someone or
something(gremlins) :) has modified the
pg_hba.conf file in the $PGDATA directory?
From: Matt Busby [mailto:[EMAIL PROTECTED]
Sent: Monday, January 22, 2007 12:10 PM
To: Melvin Davidson
Cc: pgadmin-support@post
I cannot tell you what is specificially wrong, but try the following:
Can you telnet to that database and query?
Is the postmaster running for that database?
Do you get any errors returned when you try to connect via telnet? What
are they?
Is it possible your database is corrupted and you n
Look at your script.
Your syntax is backward.
> GRANT administradores TO ezequias;
Also, you must create the administradores role _BEPORE_ you grant to it/
It should be:
CREATE ROLE administradores
NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;
GRANT ezequias TO administradores ;
That shou
Right clicking on a table show the "count" option, which updates the
Rows(counted) value in the properties window for the table.
Is there an equivalent SQL command? ANALYZE table_name does not work as
the equivalent.
In Postgresql
it's
RAISE NOTICE 'Your Message Goes Here %', value_to
_replace%_must_be_text_or_varchar;
Please note, this is not
a question for PgAdmin. It should go to
pgsql-general@postgresql.org
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael
SuSent: Tuesday,
With a custom query. :)
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of MCDONNELL,
JAMES PSent: Thursday, October 19, 2006 9:24 AMTo:
pgadmin-support@postgresql.orgSubject: [pgadmin-support]
question
Hi how
would I create custom report using Postgre Sql?
James McDonnell
Information/documentation about slony is found at the
url below.
http://gborg.postgresql.org/project/slony1/genpage.php?howto_idx
Slony clusters are what you create when you install
slony. It is not part of postgresql.
Complete information is in the
documenatation.
From: [EMAIL PROTEC
Vivekananda,
1. These question is not one for pgadmin. They are best
addressed in postgres general forum.
2. Postgres does not facilitate inter-database connectivity.
However, you can use the dblink
utility that you will find in
postgresql-8.0.3/contrib/dblink.
3. Please send any fu
Gibson,
Check that the schema is in the default path.
eg: SHOW SEARCH_PATH;
If not, either set the path to include it,
or specify the schema with the table.
eg: Select * from .user;
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gibson
Sent: Monday, A
OK everybody. So far we've determined this happens for some people and
not for others.
So how about being a little more specific on the conditions regarding
the hardware in use?
Run the System Information function and save the output to a file. The
attach it to the report.
"C:\Program Files\Common
I cannot duplicate your problem either.
Is it possible you are using/have a keyboard mapping utility program
which
has redefined the function of the delete key?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, August 02,
You just need to use position the cursor after the character and press
'Backspace' to delete it.
You should not be using the "Delete" key to delete characters.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, August 02, 20
>Now i am in PAO database..now i want
access table 'activity' in schema 'cas' in CAS
database.
>How it is
posible.
>i have 2 servers access i.e local and
mainserver.
>How access table from one server to another
server?
Please note, these are not question that are specific
to Pgadmi
=
'slonyversion'
ORDER BY
nspname;
From: Dave Page
[mailto:[EMAIL PROTECTED] Sent: Friday, July 07, 2006 10:14
PMTo: Melvin Davidson;
pgadmin-support@postgresql.orgSubject: RE: [pgadmin-support] Detemine
name of replication schema
From: [EMAIL PROTECTED]
[mailto:[EMAIL
to get the names of all replication schemas in a cluster.
Thank you in advance,
Melvin Davidson
to get the names of all replication schemas in a cluster.
Thank you in advance,
Melvin Davidson
77 matches
Mail list logo
