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

2006-08-30 Thread VivekanandaSwamy R.
Hai all,  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

Re: [pgadmin-support] update using OID instead of PKEY?

2006-08-30 Thread Dave Page
> -Original Message- > From: Vivek Khera [mailto:[EMAIL PROTECTED] > Sent: 30 August 2006 15:36 > To: Dave Page > Cc: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] update using OID instead of PKEY? > > > On Aug 30, 2006, at 8:55 AM, Dave Page wrote: > > >> We're obs

Re: [pgadmin-support] update using OID instead of PKEY?

2006-08-30 Thread Vivek Khera
On Aug 30, 2006, at 8:55 AM, Dave Page wrote: We're observing that updates issued by the tabular view of a table use OID instead of the PKEY when the table has OIDs. Using pgAdmin3 version 1.4.2. Thanks - I've reversed it to favour a PKEY over oids when present. This change will appear in

Re: [pgadmin-support] Maintenance PK bug

2006-08-30 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Alexander Kirpa > Sent: 25 August 2006 13:26 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Maintenance PK bug > > In pgAdmin V 1.4.3(Jul 19 2006) > > 1. Select DB Server > 2.

Re: [pgadmin-support] update using OID instead of PKEY?

2006-08-30 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Vivek Khera > Sent: 29 August 2006 15:47 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] update using OID instead of PKEY? > > We're observing that updates issued by the tabular vi