Re: Re: Re: Re: Ignore Relation already exists error from DBI

There is a timestamp entry for each record, it is just that I have to call the table something :-))

Can you help with my regular expression. I was having difficulty so have tried both suggestions and this is what I'm getting back:

DBD::Pg::st execute failed: ERROR: Relation '20030219' already exists at ./dbasetest.pl line 21.
Database handle destroyed without explicit disconnect.
Database handle destroyed without explicit disconnect.

I have tried various bits and pieces, including: return if $error =~ /Relation\s.0-9*.\salready\sexists/;

Thanks again.

Comment on Re: Re: Re: Re: Ignore Relation already exists error from DBI

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: Ignore Relation already exists error from DBI by Tomte (Priest) on Feb 19, 2003 at 13:37 UTC
Well I guess `cisco_netflow_log` would be more accurate a name then... :-) You sounded as if you would create a new table each day, and that would be a thing to think over. `#!/usr/bin/perl my $test = "Relation '20030219' already exists"; print "Result: ", $test =~ /Relation\s'[0-9]*'\salready\sexists/, "\n" +; __END__ Result: 1` [download] HTH, regards, tomte	[reply] [d/l]