<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
Bruce Momjian wrote:<br>
<blockquote type="cite" cite="mid:200201082333(dot)g08NXuo16483(at)candle(dot)pha(dot)pa(dot)us">
<pre wrap="">Thomas Swan wrote:<br></pre>
<blockquote type="cite">
<pre wrap="">This could be useful for cleaning out a database (sequences, triggers, <br>rules) without deleting it and without having to create it, thus <br>preserving permissions/owner information.<br></pre>
</blockquote>
<pre wrap=""><!----><br>Why delete just those? I don't see a compelling usefulness.<br><br></pre>
</blockquote>
You have to explicitly name all of them. Also, some of those are unnamed
if they were auto created. <br>
<br>
Also, the SERIAL datatype creates an auto_named sequence that's not always
easy to figure out. And, dropping a table leaves that sequence still intact.
<br>
<br>
On the owner permissions front. If someone is developing and wants to
wipe their database and start fresh, the easiest way is to do a drop database,
and create database. But, that would require the createdatabase right.
But, in a situation where multiple developers are working on different
databases, this is awkward. The proposed request always a normal user
to clean that database and start fresh, so to speak.<br>
<br>
</body>
</html>