[ADMIN] pg_user pg_shadow out of sync

Hi All, Can any one tell me what I need to do to get this back on if I do a select on pg_user for a particular user and then do a select on users for the same user the expiry and valuntil columns are different? How do I get these to match? Cheers, Sandy ---(end of broa

Re: [ADMIN] Trigger trouble

stwyth Ceredigion Wales - UK SY23 3DB Tel: (01970)-622433 Fax: (01970)-628536 -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: 03 January 2007 15:40 To: Sandy Spence Cc: 'Rajesh Kumar Mallah'; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Trigger trouble

Re: [ADMIN] Trigger trouble

To: Sandy Spence Cc: 'Rajesh Kumar Mallah'; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Trigger trouble "Sandy Spence" <[EMAIL PROTECTED]> writes: > select typowner from pg_type where typname='trigger'; typowner > -- > (0 rows) Um .

Re: [ADMIN] Trigger trouble

sts there is a problem. regds On 12/21/06, Sandy Spence <[EMAIL PROTECTED]> wrote: > Hi All, > > I get the following error when performing a pg_dump > > dumping database "ltt"... > pg_dump: WARNING: owner of data type trigger appears to be invalid >

[ADMIN] Trigger trouble

Hi All, I get the following error when performing a pg_dump dumping database "ltt"... pg_dump: WARNING: owner of data type trigger appears to be invalid the owner and database exists, I have run the following select statement, select pg_class.oid, pg_trigger.tgrelid from pg_trigger left join p

Re: [ADMIN] invalid types and tables

Aberystwyth Ceredigion Wales - UK SY23 3DB Tel: (01970)-622433 Fax: (01970)-628536 -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: 15 December 2006 15:50 To: Shoaib Mir Cc: Sandy Spence; pgsql-admin@postgresql.org Subject: Re: [ADMIN] invalid types and tables "Shoai

Re: [ADMIN] invalid types and tables

- UWA Llandinam Building Penglais Campus Aberystwyth Ceredigion Wales - UK SY23 3DB Tel: (01970)-622433 Fax: (01970)-628536 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: 15 December 2006 15:50 To: Shoaib Mir Cc: Sandy Spence; pgsql-admin

Re: [ADMIN] invalid types and tables

] [mailto:[EMAIL PROTECTED] On Behalf Of Shoaib Mir Sent: 15 December 2006 12:59 To: Sandy Spence Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] invalid types and tables For table ownership you can use the following: select tablename, tableowner from pg_tables; For types: select pg_type.typname

Re: [ADMIN] invalid types and tables

_ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shoaib Mir Sent: 15 December 2006 12:35 To: Sandy Spence Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] invalid types and tables It appears to me you dropped the user that was owner of the database objects been warned during

[ADMIN] invalid types and tables

2.3 (upgrading in the new year) Thanks in advance for any assistance, Regards, Sandy Spence Computer Officer, RA Certification Manager Department of Computer Science - UWA Llandinam Building Penglais Campus Aberystwyth Ceredigion Wales - UK SY23 3DB Tel: (01970)-622433 Fax: (01970)-628536