[pgadmin-support] How to access table from one database to another database

2006-07-03 Thread VivekanandaSwamy R.
  hi, I have 2 databases namee PAO and CAS. PAO contains 3 schemas named Public,pao,sts CAS contains 4 schemas named Public,cao,sts,reports   Now  i am in PAO database..now i want access table 'activity' in schema 'cas' in CAS database. How it is posible.   2nd thing is...   i have 2 serv

Re: [pgadmin-support] How to provide db access to other systems

2006-07-03 Thread Keith C. Perry
Quoting "VivekanandaSwamy R." <[EMAIL PROTECTED]>: > > > Hi, > We are using J2EE with PostgresSQL 8.1.0. OS : Wind > In my system,i am having Postgre database.Now i want to provide database > access to the front-end programmers. > How can i do that? > Please give me and explain the path...becau

Re: [pgadmin-support] [ADMIN] How to cal function in in another function

2006-07-03 Thread Chandra Sekhar Surapaneni
You should try it as follows:   create or replace function subfun1(int8) returns record as'declare   rec record;begin    select ename as ename,mgr as mgr into rec from emp where empno=$1 ;    return rec;end;'language'plpgsql'; -   selec

Re: [pgadmin-support] pgadmin3 segmentation fault

2006-07-03 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brian Guan > Sent: 03 July 2006 19:14 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] pgadmin3 segmentation fault > > I tried to configure for debug and/or static linking using: >

[pgadmin-support] pgadmin3 segmentation fault

2006-07-03 Thread Brian Guan
Hi, I have been using pgadmin3 for over a year on my amd64 gentoo dev box. Lately after updating to latest version of everything pgadmin refuses to run. So I downloaded the latest source code (trunk 1.4.3?) from your svn repository and compiled it manually, but the result is the same.

[pgadmin-support] i have troble entering data

2006-07-03 Thread furher
hi i am a newbie into DBMS and hev troble entering new data (ie first time after creating the tables) is it gotta do someting with privalages... -- View this message in context: http://www.nabble.com/i-have-troble-entering-data-tf1885446.html#a5154480 Sent from the PostgreSQL - pgadmin support f

[pgadmin-support] How to provide db access to other systems

2006-07-03 Thread VivekanandaSwamy R.
  Hi, We are using J2EE with PostgresSQL 8.1.0. OS : Wind In my system,i am having Postgre database.Now i want to provide database access to the front-end programmers. How can i do that? Please give me and explain the path...because we dont have any DBA.. Im the new one for PostgreSQL Th