Re: [ADMIN] RAISE NOTICE

2007-10-03 Thread Greg Williamson
Ray Madigan wrote: I am trying to debug a trigger using raise notice. When I add this line raise notice 'A %', 5; I get a syntax erreo at or near "A" I am using version 8.1.2 Thanks ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaste

[ADMIN] RAISE NOTICE

2007-10-03 Thread Ray Madigan
I am trying to debug a trigger using raise notice. When I add this line raise notice 'A %', 5; I get a syntax erreo at or near "A" I am using version 8.1.2 Thanks ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] Database Migration

2007-10-03 Thread Devrim GÜNDÜZ
Hi, On Wed, 2007-10-03 at 09:01 -0600, Kevin Kempter wrote: > I'm not sure if their tool migrates from Oracle into generic > PostgreSQL as well After migrating to EDB, you can run PostgreSQL's pg_dump against EDB and dump the database. Of course, schema will probably need to be edited before th

Re: [ADMIN] Testing lo_unlink() in psql

2007-10-03 Thread Tom Lane
"Michael Goldner" <[EMAIL PROTECTED]> writes: > I've run "VACUUM ANALYZE" on the table after the delete and have the > same behavior. Do I need to run a "VACUUM FULL" to get the space back > after an lo_unlink()? Vacuuming the table isn't gonna help much, because all that reclaims is your table r

[ADMIN] Testing lo_unlink() in psql

2007-10-03 Thread Michael Goldner
I'm running postgres 8.1.8 on redhat. I have a very large table that contains an OID that refers to a large object. I have a rule defined that calls lo_unlink() on a delete. I seem to get a successful return status on the delete, but my total disk space used does not seem to shrink. I've run "V

Re: [ADMIN] Database Migration

2007-10-03 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Khan, Mahmood Ahram wrote: > Hi, > > > 1.What are necessary steps we should follow for migration of a > production database from Oracle 10g (10.2.0.1) to PostgreSQL 8.2.4? > 2.What are the most common issues we get and how to fix them in > mi

Re: [ADMIN] Postgres Array Traversing

2007-10-03 Thread Milen A. Radev
Yogesh Arora написа: > Hallo All Frnds, > >I have to add an array in my table. and to update the array in a > Procedure called by the trigger. > > In my case Like the Elements of the array are {1,2,5} now i have to > update it to {1,2,5,7} . I.e., Keeping the previous record

[ADMIN] Postgres Array Traversing

2007-10-03 Thread Yogesh Arora
Hallo All Frnds, I have to add an array in my table. and to update the array in a Procedure called by the trigger. In my case Like the Elements of the array are {1,2,5} now i have to update it to {1,2,5,7} . I.e., Keeping the previous record as such and appending the new eleme

Re: [ADMIN] Database Migration

2007-10-03 Thread Kevin Kempter
On Wednesday 03 October 2007 01:01:00 Khan, Mahmood Ahram wrote: > Hi, > > > > > > > 1.What are necessary steps we should follow for migration of a > production database from Oracle 10g (10.2.0.1) to PostgreSQL 8.2.4? > 2.What are the most common issues we get and how to fix them in > migra

[ADMIN] Database Migration

2007-10-03 Thread Khan, Mahmood Ahram
Hi, 1. What are necessary steps we should follow for migration of a production database from Oracle 10g (10.2.0.1) to PostgreSQL 8.2.4? 2. What are the most common issues we get and how to fix them in migration procedure? 3. Any tools available for doing this migration activ