| From: | Thomas Swan <tswan(at)idigx(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SET LOCAL again |
| Date: | 2002-07-30 21:48:40 |
| Message-ID: | 3D4709B8.2090505@idigx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body>
Bruce Momjian wrote:<br>
<blockquote type="cite"
cite="mid200207301647(dot)g6UGlkL16351(at)candle(dot)pha(dot)pa(dot)us">
<pre wrap="">Tom Lane wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Peter Eisentraut <a class="moz-txt-link-rfc2396E" href="mailto:peter_e(at)gmx(dot)net"><peter_e(at)gmx(dot)net></a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">Tom Lane writes:
As an alternative syntax I can suggest
</pre>
<pre wrap="">SET name TO value [ ON COMMIT RESET ];
</pre>
<blockquote type="cite">
<pre wrap="">Ugh. Why can't we stick with SET LOCAL?
</pre>
</blockquote>
</blockquote>
<blockquote type="cite">
<pre wrap="">SET LOCAL is already used for something else in the SQL standard. Not
sure if we'll ever implement that, but it's something to be concerned
about.
</pre>
</blockquote>
<pre wrap="">Actually, it looks to me like the spec's SET LOCAL has a compatible
interpretation: it only affects the current transaction.
My main gripe with "ON COMMIT RESET" is that it's a misleading
description of what will happen --- RESETting a variable is quite
different from allowing it to revert to the pre-transaction state.
</pre>
</blockquote>
<pre wrap=""><!---->
I don't like stuff trailing off at the end, especially three words.
That SET command is getting so big, it may fall over. ;-)
</pre>
</blockquote>
Perhaps ON COMMIT REVERT would be more intuitive.<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2002-07-30 22:02:35 | Re: WAL file location |
| Previous Message | Peter Eisentraut | 2002-07-30 21:43:22 | Re: START TRANSACTION |