Re: [ADMIN] Dying PostgreSQL backend

"otisg" <[EMAIL PROTECTED]> writes: > Unfortunately, I cannot get PostgreSQL to dump core despite setting > ulimit -c to: > [root@linux2 otis]# ulimit -a > core file size (blocks) unlimited > And starting PostgreSQL this way: > su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p > /usr/bi

Re: [ADMIN] Delete function

Thanks Mendola , that was a nice idea for functions regds mallah. On Tuesday 07 May 2002 06:41 pm, Gaetano Mendola wrote: > "Rajesh Kumar Mallah." <[EMAIL PROTECTED]> wrote: > > eg > > regression=> \o command.sql > > regression=> select 'DROP function ' || proname from pg_proc WHERE > > p

Re: [ADMIN] Delete function

"Rajesh Kumar Mallah." <[EMAIL PROTECTED]> wrote: > eg > regression=> \o command.sql > regression=> select 'DROP function ' || proname from pg_proc WHERE proname > ~ '^sp_'; > > then psql -f command.sql This work fine with the views, unfortunately when you drop a function you should specify t

Re: [ADMIN] [DOCS] Migrating Oracle to PostgreSQL

> Hi there, > > Has anyone migrated Oracle database to Postgres? If yes, could you please > help me - what > are the steps involved, complications you faced, any other info you think is > appropriate. Sorry to answer so lately! I made some of this migrations. From Oracle 7 to 8i databases. Ba

[ADMIN] Connection to multiple databases

hi, how can I solve following problem: On a standalone Linux-PC I wish to locate several databases in the directory ../pgsql/data, viz: 1. readers_DATABASE with about 20 tables the readers_TABLE has follwing fields: readers_id readers_name ... ... 2. pub

[ADMIN] pg_dump failed

Hi all, performing a pg_dump I obtain this error $ pg_dump empdb > dacan.sql getTables(): SELECT (for VIEW DEFINITION) failed. Explanation from backend: ERROR: cache lookup for proc 117968 failed Anyone have an idea ? Ciao Gaetano -- #exclude #include printf("\t\t\b\b\b\b\b\b");. printf("

Re: [ADMIN] Delete function

On Tuesday 07 May 2002 03:47 pm, Gaetano Mendola wrote: > I did this but I don't know if is the correct way: > > DELETE FROM pg_proc WHERE proname ~ '^sp_'; > DELETE FROM pg_class WHERE relname ~ '^v_'; hmm.. i dont think its safe to fiddle with the system catalogs like that. There exists SQL c

Re: [ADMIN] Delete function

I did this but I don't know if is the correct way: DELETE FROM pg_proc WHERE proname ~ '^sp_'; DELETE FROM pg_class WHERE relname ~ '^v_'; Ciao Gaetano. - Original Message - From: "Gaetano Mendola" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 9:28 AM Subje

Re: [ADMIN] Add a month

From: "Rajesh Kumar Mallah." <[EMAIL PROTECTED]> > Hi the answer is: > > select now() + cast ( '1 day' as interval ) ; I guess that for me should be enough cast ('1 month' as interval) or may be after RTFM should be also good select now() + interval '1 month'; > are you reading manuals

Re: [ADMIN] Add a month

Hi the answer is: select now() + cast ( '1 day' as interval ) ; are you reading manuals ?? regds mallah. On Tuesday 07 May 2002 12:59 pm, Gaetano Mendola wrote: > Hi all, > > giving a date how can I add a month ? > Till now I was working adding x days like this > > now() + x > > but is not

[ADMIN] Add a month

Hi all, giving a date how can I add a month ? Till now I was working adding x days like this now() + x but is not anymore enough Ciao Gaetano -- #exclude #include printf("\t\t\b\b\b\b\b\b");. printf("\t\t\b\b\b\b\b\b"); ---(end of broadcast)--

[ADMIN] Delete function

Hi all, How can I delete all function that match some name rules? Ex: I want delete all functions that matches sp_* and all views that matches v_* Ciao Gaetano -- #exclude #include printf("\t\t\b\b\b\b\b\b");. printf("\t\t\b\b\b\b\b\b"); ---(end of broadcast)-