Mailing List Archive

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
> Dbmail-dev@dbmail.org
> 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