Re: [ADMIN] any tricks to get foreign key constraint builds faster

2011-06-06 Thread Kevin Grittner
Mike Broers wrote: > Should this be posted in performance instead? The readers of that list, while there is some overlap, would overall be a better group for getting your answer. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:

Re: [ADMIN] any tricks to get foreign key constraint builds faster

2011-06-06 Thread Mike Broers
Should this be posted in performance instead? On Fri, Jun 3, 2011 at 9:46 AM, Mike Broers wrote: > I am in the process of implementing cascade on delete constraints > retroactively on rather large tables so I can cleanly remove deprecated > data. The problem is recreating some foreign key const

Re: [ADMIN] How I do from PostgreSQL to Oracle Db Link

2011-06-06 Thread Tom Lane
Ray Stell writes: > On Sat, Jun 04, 2011 at 10:05:46AM +0900, ?? wrote: >> ERROR: odbclink: unsuccessful SQLConnect call: [S1000] [12514] >> >> [[unixODBC][Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently >> know of service requested in connect descripto > sounds like you got t

Re: [ADMIN] How I do from PostgreSQL to Oracle Db Link

2011-06-06 Thread Ray Stell
On Sat, Jun 04, 2011 at 10:05:46AM +0900, ?? wrote: > > ERROR: odbclink: unsuccessful SQLConnect call: [S1000] [12514] > > [[unixODBC][Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently > know of service requested in connect descripto > $ oerr ora 12514 12514, 0, "TNS:liste

[ADMIN] ERROR: type "pg_catalog.int4" does not exist

2011-06-06 Thread Lukasz Brodziak
Hello, I have a problem with conncting to db. Whe I try to connect I get either: ERROR: type "pg_catalog.int4" does not exist or Cache lookup failed for type 23. Is there a way of recreating the type because I heve to get to the data from this particular db as the dump is 2 days old (which is too