[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: [ADMIN] Cannot access proper data from pgadmin
From: <Mamatha_Kagathi_Chan () DELL ! com>
Date: 2011-10-24 10:24:13
Message-ID: 89A978D5BD307B41B174E9250A8D343905A7C4 () BLRX10HMBAN02 ! AMER ! DELL ! COM
[Download RAW message or body]
Hi ,
I am using Pgadmin in a server A and Server B. In both the places postgreSQ=
L is installed. I added the postgres server present in SERVER A to the pgad=
min in Server B. Now, I would expect both the pgadmins to show same number =
of objects. But the Pgadmin in Server A (where the server is) shows 29 proc=
s and the pgadmin(where only the client is) shows 12 procs. How is this pos=
sible? Am I missing something.
My second query is, After I edit one of the procedures and execute pgscript=
it seems to disappear from the list of procedures. Is it a known bug or ag=
ain am I missing something.
Pls let me know.
Thanks,
Mamatha
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@SimSun";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi ,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am using Pgadmin in a server A and Server B. In both the \
places postgreSQL is installed. I added the postgres server present in SERVER A to \
the pgadmin in Server B. Now, I would expect both the pgadmins to show same number of \
objects. But the Pgadmin in Server A (where the server is) shows 29 procs and the \
pgadmin(where only the client is) shows 12 procs. How is this possible? Am I missing \
something.<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">My second query is, After I edit one of the procedures and \
execute pgscript it seems to disappear from the list of procedures. Is it a known bug \
or again am I missing something. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Pls let me know.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Mamatha<o:p></o:p></p>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic