pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL Tool?
7+ messages / 6 participants
[nested] [flat]
* PostgreSQL Tool?
@ 2004-10-14 15:29 Sídar LC <slopez_pg@ceroriesgo.co.cr>
2004-10-14 15:42 ` Re: PostgreSQL Tool? Christian Fowler <spider@viovio.com>
0 siblings, 1 reply; 7+ messages in thread
From: Sídar LC @ 2004-10-14 15:29 UTC (permalink / raw)
To: pgsql-admin
Where can i find a tool for print graphical PostgreSQL schemas?
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PostgreSQL Tool?
2004-10-14 15:29 PostgreSQL Tool? Sídar LC <slopez_pg@ceroriesgo.co.cr>
@ 2004-10-14 15:42 ` Christian Fowler <spider@viovio.com>
0 siblings, 0 replies; 7+ messages in thread
From: Christian Fowler @ 2004-10-14 15:42 UTC (permalink / raw)
To: Sídar LC <slopez_pg@ceroriesgo.co.cr>; +Cc: pgsql-admin
http://www.thekompany.com/products/dataarchitect/
Is an awesome tool. The "Reverse Engineer" ability will build the model
from an existing database.
On Thu, 14 Oct 2004, [UTF-8] Sídar LC wrote:
> Where can i find a tool for print graphical PostgreSQL schemas?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
[ \ /
[ >X< Christian Fowler | spider@viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
From pgsql-admin-owner@postgresql.org Thu Oct 14 17:19:54 2004
X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 5191932B404
for <pgsql-admin-postgresql.org@localhost.postgresql.org>; Thu, 14 Oct 2004 17:19:53 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 61350-08
for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
Thu, 14 Oct 2004 16:19:49 +0000 (GMT)
Received: from web50006.mail.yahoo.com (web50006.mail.yahoo.com [206.190.38.21])
by svr1.postgresql.org (Postfix) with SMTP id 252F732B1D5
for <pgsql-admin@postgresql.org>; Thu, 14 Oct 2004 17:19:47 +0100 (BST)
Message-ID: <20041014161946.26948.qmail@web50006.mail.yahoo.com>
Received: from [200.93.192.137] by web50006.mail.yahoo.com via HTTP; Thu, 14 Oct 2004 11:19:46 CDT
Date: Thu, 14 Oct 2004 11:19:46 -0500 (CDT)
From: Jaime Casanova <systemguards@yahoo.com>
Subject: Re: Database schemas: search_path
To: pgsql-admin@postgresql.org
In-Reply-To: <20041014143432.GA25803@wolff.to>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level:
X-Archive-Number: 200410/183
X-Sequence-Number: 15176
--- Bruno Wolff III <bruno@wolff.to> escribió:
> On Thu, Oct 14, 2004 at 09:42:45 -0300,
> Igor Maciel Macaubas <igor@providerst.com.br>
> wrote:
> > Hi all,
> >
> > I've organized my database design in multiple
> schemas, and migrated my existing tables to
> different schemas by using a simple how-to I found
> in this list history.
> > But what I couldn't find was a way to make this
> schemata fully transparent to my application - which
> does selects directly to tables instead to
> schema.table. I know that I can always set the
> search_path environmnet variable, but I have to do
> it on each session. I'd like to know if there is a
> way to make my set search_path persistent on the
> database, no matter the session.
> > I believe that this is supported, but couldn't
> find out how to make it. Can someone help me?
>
> Use ALTER DATABASE to set per database defaults.
>
Hi,
set the parameter in the postgresql.conf
Regards,
Jaime Casanova
_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PostgreSQL Tool?
@ 2004-10-14 17:42 CHRIS HOOVER <CHRIS.HOOVER@companiongroup.com>
2004-10-14 18:11 ` Re: PostgreSQL Tool? Michael Long <mlong@datalong.com>
0 siblings, 1 reply; 7+ messages in thread
From: CHRIS HOOVER @ 2004-10-14 17:42 UTC (permalink / raw)
To: Christian Fowler <spider@viovio.com>; +Cc: pgsql-admin; = UTF-8 B U8OtZGFyIExD = <slopez_pg@ceroriesgo.co.cr>
Dataarchitect looked good to me, but it could not handle a large schema.
We are using EMS's PG Manager tool. Good for DBA'n and generating erds.
(http://ems-hitech.com/pgmanager/). Only downside is for erd's, you have to
use the windows version, not the linux version.
HTH,
Chris
------------------( Forwarded letter 1 follows )---------------------
Date: Thu, 14 Oct 2004 11:42:55 -0400 (EDT)
To: =.UTF-8.B.U8OtZGFyIExD.=[slopez_pg]@ceroriesgo.co.cr.comp
Cc: postgresql[pgsql-admin]@postgresql.org.comp
From: Christian.Fowler[spider]@viovio.com.comp
Sender: pgsql-admin-owner+m15175@postgresql.org.comp
Subject: Re: [ADMIN] PostgreSQL Tool?
http://www.thekompany.com/products/dataarchitect/
Is an awesome tool. The "Reverse Engineer" ability will build the model
from an existing database.
On Thu, 14 Oct 2004, [UTF-8] Sídar LC wrote:
> Where can i find a tool for print graphical PostgreSQL schemas?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
[ \ /
[ >X< Christian Fowler | spider@viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PostgreSQL Tool?
2004-10-14 17:42 Re: PostgreSQL Tool? CHRIS HOOVER <CHRIS.HOOVER@companiongroup.com>
@ 2004-10-14 18:11 ` Michael Long <mlong@datalong.com>
0 siblings, 0 replies; 7+ messages in thread
From: Michael Long @ 2004-10-14 18:11 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
CHRIS HOOVER wrote:
>Dataarchitect looked good to me, but it could not handle a large schema.
>
>
>
What do you consider a large schema?
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PostgreSQL Tool?
@ 2004-10-14 19:46 CHRIS HOOVER <CHRIS.HOOVER@companiongroup.com>
0 siblings, 0 replies; 7+ messages in thread
From: CHRIS HOOVER @ 2004-10-14 19:46 UTC (permalink / raw)
To: Michael Long <mlong@datalong.com>; +Cc: pgsql-admin
We have over 100 tables in our database (some with a large number of columns -
100+), and that triggered a problem in Dataarchitect to where it would not
display the erd. All we got was a black screen. I contacted them and sent
them information, but have never heard back.
It is quite a shame since I would love to use a native linux tool.
Chris
------------------( Forwarded letter 1 follows )---------------------
Date: Thu, 14 Oct 2004 14:11:59 -0400
Cc: postgresql[pgsql-admin]@postgresql.org.comp
From: Michael.Long[mlong]@datalong.com.comp
Sender: pgsql-admin-owner+m15178@postgresql.org.comp
Subject: Re: [ADMIN] PostgreSQL Tool?
CHRIS HOOVER wrote:
>Dataarchitect looked good to me, but it could not handle a large schema.
>
>
>
What do you consider a large schema?
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
^ permalink raw reply [nested|flat] 7+ messages in thread
* PostgreSQL Tool
@ 2014-10-02 17:46 Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
2014-10-03 18:10 ` Re: PostgreSQL Tool Stephen Frost <sfrost@snowman.net>
0 siblings, 1 reply; 7+ messages in thread
From: Ferrell, Denise CTR NSWCDD, Z11 @ 2014-10-02 17:46 UTC (permalink / raw)
To: pgsql-admin
All,
Using PostgreSQL 9.3.5 on Red-Hat Linux platform.
Is there a known tool or a way to retrieve dependencies and/or track changes that will impact other items? For example, if a column is removed from a table is there a way to determine easily that this change will impact functions that use the deleted column?
Thank you in advance for any assistance.
Denise Ferrell
Attachments:
smime.p7s (application/pkcs7-signature, 5.5K) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PostgreSQL Tool
2014-10-02 17:46 PostgreSQL Tool Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
@ 2014-10-03 18:10 ` Stephen Frost <sfrost@snowman.net>
0 siblings, 0 replies; 7+ messages in thread
From: Stephen Frost @ 2014-10-03 18:10 UTC (permalink / raw)
To: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: pgsql-admin
Denise,
* Ferrell, Denise CTR NSWCDD, Z11 (denise.ferrell.ctr@navy.mil) wrote:
> Is there a known tool or a way to retrieve dependencies and/or track changes that will impact other items? For example, if a column is removed from a table is there a way to determine easily that this change will impact functions that use the deleted column?
There is the pg_depend catalog table, but that won't help with columns
which are referenced inside of functions as those are not considered
permanent dependencies and, in general, core PostgreSQL does not know or
really understand the contents of a stored procedure- only the language
handler itself does. There is a 'check' function provided by language
handlers generally, but that only does syntax checking and won't verify
that columns referenced in queries exist.
Also, with all the languages that I'm aware of, including plpgsql,
queries are only planned when they're actually reached- you could have a
query under a conditional (eg: IF) which is very rarely reached and you
won't realize that the query references a removed column until that code
path is followed.
If you have a large collection of plpgsql to review, this can certainly
be difficult to prove. One approach is to have a large set of
regression tests which go through most, if not all, of the code paths in
the plpgsql code. If the column and/or table names are sufficiently
distinct then it might be possible to search for them in the function
bodies and manually review each hit.
Thanks!
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2014-10-03 18:10 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-14 15:29 PostgreSQL Tool? Sídar LC <slopez_pg@ceroriesgo.co.cr>
2004-10-14 15:42 ` Christian Fowler <spider@viovio.com>
2004-10-14 17:42 Re: PostgreSQL Tool? CHRIS HOOVER <CHRIS.HOOVER@companiongroup.com>
2004-10-14 18:11 ` Michael Long <mlong@datalong.com>
2004-10-14 19:46 Re: PostgreSQL Tool? CHRIS HOOVER <CHRIS.HOOVER@companiongroup.com>
2014-10-02 17:46 PostgreSQL Tool Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
2014-10-03 18:10 ` Re: PostgreSQL Tool Stephen Frost <sfrost@snowman.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox