From DBD::Pg: 
ATTRIBUTES COMMON TO ALL HANDLES
       InactiveDestroy (boolean)

       If set to true, then the "disconnect" method will not be
       automatically called when the database handle goes out of
       scope. This is required if you are forking, and even then
       you must tread carefully and ensure that either the parent
       or the child (but not both!) handles all database calls
       from that point forwards, so that messages from the
       Postgres backend are only handled by one of the processes.
       If you don't set things up properly, you will see messages
       such as "server closed the connection unexpectedly", and
       "message type 0x32 arrived from server while idle". The
       best solution is to either have the child process
       reconnect to the database with a fresh database handle, or
       to rewrite your application not to use use forking. See
       the section on "Asynchronous Queries" for a way to have
       your script continue to work while the database is
       processing a request.

[download]
so sharing the database handle between children will not work. You weren't exactly clear on what you meant by having access to the table, but since it is temporary, it will be destroyed at the end of the session and so re-opening the database handle for each forked child will not work either. Perhaps you should create a non-temporary table, re-open the database handle in each child and drop the table when your parent process exits. Alternatively you could use a different Net::Server personality, like Net::Server::Multiplex, which doesn't fork.

In reply to Re: Share a temp table in child process using Net::Server by james2vegas
in thread Share a temp table in child process using Net::Server by shammi000

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.