After reading the original post, the copydb -help looked good, but I don't
think its quite wahat
Norhaza was looking for.
I tried various options, whilst trying to copy out a table called mm
That particular table had three rules on it, triggering two different
procedures
What ever flags I tried, I could not get copydb to copy out just the mm
table, and the three rules and two procedures.
The with_rules|procs only seemed to have an effect on the copy.in if there
was no table specified, then
I could get all the rules and/or all the procedures
I even tried procedures like mm@[EMAIL PROTECTED]
etc, but to no avail.
Perhaps I was reading too much into the copydb -help.
Thoughts??
Cheers
Richard
/**********************************\
| New Zealander, leading the world |
\**********************************/
-----Original Message-----
From: info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of Andrew
Sent: Monday, 12 May 2008 1:52 a.m.
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] copydb with rules/procedures?
Hi All,
I think it would be a good idea to see if any Views are dependent on
this/these table(s) as well, if the copydb is for one/some table(s).
Regards,
Andrew.
Denise Vancil wrote:
> As of Ingres 2.6, copydb -help shows you can copy out rules and
> procedures with extra parameters to copydb such as -with_proc
> -with_rules. I would think this is what you need to get your
> procedures and rules copied out.
>
> $ copydb -help
>
> E_UG0011 Correct syntax:
> copydb [-param_file=filename] | [ dbname [-c] [-row_labels]
> [-uusername]
> [-Ggroupid ] [-parallel] [-journal] [-P] [-source=dirname]
> [-dest=dirname] [-ddirname] [-with_tables] [-with_modify]
> [-with_data]
> [-all] [-order_ccm] [-with_index] [-with_constr] [-with_views]
> [-with_synonyms] [-with_events] [-with_proc] [-with_reg]
> [-with_rules]
> [-with_alarms] [-with_comments] [-with_roles] [-add_drop]
> [-infile=filename] [-outfile=filename] [-with_permits] [-relpath]
> [-no_loc] [-no_perm] [-noint] [-no_persist] [-no_repmod]
> {tablename|viewname}]
>
> - Denise
>
> Denise Vancil
>
> Senior Quality Assurance Engineer
>
> Ingres Cor****ation
>
> denise.vancil@[EMAIL PROTECTED]
> www.ingres.com
>
>
>
>
>
> -----Original Message-----
> From: info-ingres-bounces@[EMAIL PROTECTED]
> [mailto:info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of
> Norhaza Yusoff
> Sent: Thursday, May 08, 2008 11:19 AM
> To: Ingres and related product discussion forum
> Subject: [Info-Ingres] copydb with rules/procedures?
>
> Hello everyone,
> Is there a way to copy a table and get all the related rules and
> procedures be included in the copy.in script?
> We have been having a problem of forgetting to include the rules and
> procedures into the new table whenever we do the copydb to a table,
> which results in missing rules and procedures for that table.
>
> Anyone who has experienced with this issue or who knows the answer,
> please give us some insights.
>
> Thanks.
>
_______________________________________________
Info-Ingres mailing list
Info-Ingres@[EMAIL PROTECTED]
|
