in reply to Re: Re: Ignore Relation already exists error from DBI
in thread Ignore Relation already exists error from DBI

Does this still sound like a bad design?

To my ears, it does :-)
The date of the day makes for a perfect column, if you think about it.

regards,
tomte

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

Replies are listed 'Best First'.
Re: Re: Re: Re: Ignore Relation already exists error from DBI
by global (Novice) on Feb 19, 2003 at 13:03 UTC
    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.

[reply]

      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]

In Section Seekers of Perl Wisdom