�
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid;
MARGIN-RIGHT: 0px">
<FONT
face=Tahoma size=2>-----Original Message-----From: Mark A. Taff
[mailto:[EMAIL PROTECTED]] Sent: 14 February 2002
21:03To: Dave Page; pgadmin-hackersSubject: RE:
[pgadmin-hackers] Introduction<FONT
face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">�<FONT
color=black> <SPAN
class=EmailStyle16><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: blue 1.5pt solid; PADDING-TOP:
0in; BORDER-BOTTOM: medium none">
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN-LEFT: 75.75pt; BORDER-LEFT: medium
none; TEXT-INDENT: -0.25in; PADDING-TOP: 0in; BORDER-BOTTOM: medium none;
mso-border-left-alt: solid blue 1.5pt; mso-padding-alt: 0in 0in 0in 4.0pt; mso-list:
l0 level1 lfo1; tab-stops: list 1.0in"><FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size:
12.0pt">2.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">���
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">I
would like to see the treeview root item be `servers`, which would have sub
nodes for different servers.� I
work in a multi-server environment, and it would be nice to be able to work
with objects on multiple servers at the same time.<SPAN
style="mso-spacerun: yes">� This would open up the possibility of
easily `copying` objects from one server to another.<FONT
color=black>�<FONT face=Arial
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">�Agreed.
This will require significant reworking of�the higher levels of pgSchema.
I did look at it a month or so back and left it when I realised how much work
was involved.<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size:
12.0pt">
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: blue 1.5pt solid; PADDING-TOP:
0in; BORDER-BOTTOM: medium none">
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">�
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">MT:
That occurred to me as well.� That
is one of the major reasons I wanted to be sure about the future direction
before I even considered trying to write the code.<SPAN
class=710482523-14022002>�
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><FONT
color=#0000ff><SPAN
class=710482523-14022002>�
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><FONT
color=#0000ff>DP: Thinking
about it, you would end up touching all the Plugins and just about
every�form in pgAdmin as
well.
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">�
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: blue 1.5pt solid; PADDING-TOP:
0in; BORDER-BOTTOM: medium none">
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN-LEFT: 75.75pt; BORDER-LEFT: medium
none; TEXT-INDENT: -0.25in; PADDING-TOP: 0in; BORDER-BOTTOM: medium none;
mso-border-left-alt: solid blue 1.5pt; mso-padding-alt: 0in 0in 0in 4.0pt; mso-list:
l0 level1 lfo1; tab-stops: list 1.0in"><FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size:
12.0pt">3.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">���
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">The
re-engineered SQL code is nice, but it has limited usefulness.<SPAN
style="mso-spacerun: yes">� I do most of my work using the execute
sql window because in good coding tradition, I like to leave lots of comments
about just what the heck is going on.�
This is most important for functions (and function-like objects).<SPAN
style="mso-spacerun: yes">� I also like to save the SQL for each
object as both an individual .sql file and as part of a global class and
object-type class files.� This
modular approach allows me to pick and choose objects to quickly build a new
database.� To implement such a
creature, I would suggest an SQL IDE so to speak, much like the VBA editor
used in Office applications.� Part
of this is also the desired ability to right-click an object in the tree and
to be able to edit _my_ sql
code (with comments) rather than re-engineered SQL code.<SPAN
style="mso-spacerun: yes">� I am keenly interested in making this
a reality.<SPAN
style="COLOR: black">�<FONT face=Arial color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">�The
re-engineered SQL is essential to the Revision Control features. The downside
with the approach you suggest�is that it requires centralised storage of
all the SQL�- one of the things people often complained about with
pgAdmin I was the tables it created in each database. The other side of this,
is that�most people probably use pgAdmin so they don't have to worry
about authoring the SQL themselves, so such a feature would probably be of
limited interest.<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size:
12.0pt">
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: blue 1.5pt solid; PADDING-TOP:
0in; BORDER-BOTTOM: medium none">
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">�
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">MT: It
hadn't even occurred to me store the SQL in the database.<SPAN
style="mso-spacerun: yes">� I was planning on storing it in local
.sql files.� I consider it a
benefit to have the data stored outside of the database.<SPAN
style="mso-spacerun: yes">� That way if the database dies a
horrible and sudden death, I still have my code. <SPAN
style="mso-spacerun: yes">�I guess all I really need such a
creature for is writing complex stored procedures. <SPAN
style="mso-spacerun: yes">�I was thinking of adding this
capability as opposed to replacing the re-engineered code with this. <SPAN
style="mso-spacerun: yes">�I'll have to mull this over a bit
more.
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">�<SPAN
class=710482523-14022002>DP: The database is the *only*
place such data can be stored as it is the only place that all developers of a
single database can be assumed to have access
to.
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN
class=710482523-14022002>�
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN
class=710482523-14022002>Anyhoo, if you're using it primarily for stored
procedures, then there shouldn't be a problem anyway as the code of a PL
function *never* gets altered by pgAdmin or PostgreSQL - it can't, because
neither have any builtin knowledge of the language. This means you can comment
your code as much as you like and not lose those comments. With PostgreSQL 7.2
you can edit those functions using pgAdmin as well, and in a future version of
pgAdmin, I intend to make the highlight box (the textbox that you write
functions in) be detachable from the parent window, into a resizable edit
window of it's own.
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN
class=710482523-14022002>Gotta go now, I'm falling asleep on my laptop
:-)
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN
class=710482523-14022002>�
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none;
PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in;
BORDER-BOTTOM: medium none; mso-border-left-alt: solid blue 1.5pt; mso-padding-alt:
0in 0in 0in 4.0pt"><SPAN
class=EmailStyle17><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN
class=710482523-14022002><FONT
color=#0000ff>Dave.
