Hi,

The tmp_ tables were needed in mysql because mysql does not support subselects - using the more advanced SQL of postgresql it was no longer necessary to use these tmp tables so they were ommitted.

regards roel


Aaron Stone heeft op zaterdag, 19 apr 2003 om 22:43 (Europe/Amsterdam) het volgende geschreven:

Uh oh, hit a snag already! The PostgreSQL layer doesn't have
tmpmessage/blk tables. What might be another way of stashing a message for
a short period? Perhaps a session limited temporary table...

CREATE LOCAL TEMPORARY TABLE tmpmessages ()
       INHERITS ( messages ) ON COMMIT PRESERVE ROWS;

Aaron

_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev


_________________________
R.A. Rozendaal
ICT Manager
IC&S
T: +31 30 2322878
F: +31 30 2322305
www.ic-s.nl

Reply via email to