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
_
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
]
[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
- 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
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
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
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
>
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 .
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
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
10 matches
Mail list logo
