On Wed, Feb 09, 2005 at 03:40:49PM -0500, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > The 7.3 and 7.2 documentation for CREATE TABLE both mention ON COMMIT:
>
> > http://www.postgresql.org/docs/7.3/static/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITY
> > http://www.postgres
Michael Fuhr <[EMAIL PROTECTED]> writes:
> The 7.3 and 7.2 documentation for CREATE TABLE both mention ON COMMIT:
> http://www.postgresql.org/docs/7.3/static/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITY
> http://www.postgresql.org/docs/7.2/static/sql-createtable.html#SQL-CREATETABLE-COMPATIB
I learned that there is an on commit clause by looking at the
Compaitiblity section of the 7.3.3 docs and I was confused whether it
is supporting this or not
rgds
Antony Paul
On Wed, 9 Feb 2005 00:19:41 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Wed, Feb 09, 2005 at 06:00:52PM +1100, N
On Wed, Feb 09, 2005 at 06:00:52PM +1100, Neil Conway wrote:
> On Wed, 2005-02-09 at 10:48 +0530, Antony Paul wrote:
> > Hi all,
> > This is giving error in 7.3.3.
> >
> > CREATE TEMP TABLE temptest3(col int PRIMARY KEY) ON COMMIT DELETE ROWS;
> > ERROR: parser: parse error at or near "ON" a
On Wed, 2005-02-09 at 10:48 +0530, Antony Paul wrote:
> Hi all,
> This is giving error in 7.3.3.
>
> CREATE TEMP TABLE temptest3(col int PRIMARY KEY) ON COMMIT DELETE ROWS;
> ERROR: parser: parse error at or near "ON" at character 51
>
> Is this supported.
No. Looking at the manual would h
Hi all,
This is giving error in 7.3.3.
CREATE TEMP TABLE temptest3(col int PRIMARY KEY) ON COMMIT DELETE ROWS;
ERROR: parser: parse error at or near "ON" at character 51
Is this supported.
rgds
Antony Paul
---(end of broadcast)---
TIP 8: ex
