Terse little DB, isn't it?<br><br>'preciate it.<br>-- <br>dz<br><br><div><span class="gmail_quote">On 3/9/06, <b class="gmail_sendername">Keegan Quinn</b> <<a href="mailto:keegan@thebasement.org">keegan@thebasement.org</a>
> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">On Thu, Mar 09, 2006 at 05:37:06AM -0500, Dan Ziemecki wrote:<br>> Can I get one of you postgre aficionados to translate this SQL statement
<br>> into whatever works on postgre for me?<br><br>Yeah.<br><br>> DROP TABLE IF EXISTS subscriptions_holding;<br><br>Not sure about that "if exists" clause.<br><br>DROP TABLE subscriptions_holding; works though.
<br><br>> CREATE TABLE subscriptions_holding (<br>> rid int(11) NOT NULL auto_increment COMMENT 'Unique row ID',<br>> content blob NOT NULL COMMENT 'The node array',<br>> type tinytext NOT NULL COMMENT 'New node or comment',
<br>> op tinytext NOT NULL COMMENT 'The operation on the node',<br>> uid int(11) NOT NULL default '0' COMMENT 'The person performing the<br>> operation',<br>> PRIMARY KEY ('rid')<br>> );<br><br>CREATE TABLE subscriptions_holding (
<br> rid SERIAL,<br> content OID NOT NULL,<br> type TEXT NOT NULL,<br> op TEXT NOT NULL,<br> uid INTEGER NOT NULL DEFAULT 0<br>);<br>COMMENT ON COLUMN subscriptions_holding.rid IS 'Unique row ID';<br>COMMENT ON COLUMN subscriptions_holding.content IS 'The node array';
<br>COMMENT ON COLUMN subscriptions_holding.type IS 'New node or comment';<br>COMMENT ON COLUMN subscriptions_holding.op IS 'The operation on the node';<br>COMMENT ON COLUMN subscriptions_holding.uid IS 'The person performing the operation';
<br><br>Tested on PostgreSQL 7.4.<br><br>HTH,<br><br>--<br>Keegan Quinn <<a href="mailto:keegan@thebasement.org">keegan@thebasement.org</a>><br>CEO, Producer<br>the basement productions<br><a href="http://www.thebasement.org">
http://www.thebasement.org</a><br><br><br>-----BEGIN PGP SIGNATURE-----<br>Version: GnuPG v1.4.1 (GNU/Linux)<br><br>iD8DBQFEEAd1RMUr35HwZXoRAvnhAJ9GplHEFxZllWJxzkklWMdA9kEFegCdHUy+<br>9MqSltxpHgT7J5RvSM3c3CE=<br>=mfL1<br>
-----END PGP SIGNATURE-----<br><br><br></blockquote></div><br>