Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: out of shared memory - Mailing list pgsql-sql

From Michael Moore
Subject Re: ERROR: out of shared memory
Date
Msg-id CACpWLjMDSzCNE6ArgvTj972E7WC009J8ZQyiSjzjcj-xLm9uFA@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: out of shared memory  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view
create temporary table if not exists  temp_rslt of ypxportal2__fgetquestions  on commit drop;
got it, thanks

On Wed, Nov 2, 2016 at 3:29 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Nov 2, 2016 at 3:28 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Nov 2, 2016 at 3:03 PM, Michael Moore <michaeljmoore@gmail.com> wrote:
That appears to not be valid syntax. 
create temporary table temp_rslt of ypxportal2__fgetquestions if not exists on commit drop;
ERROR:  syntax error at or near "if"
LINE 146: ...rary table temp_rslt of ypxportal2__fgetquestions if not exi..


Am I doing something wrong?

​I always get the placement of IF NOT EXISTS confused - but you found the doc page with the syntax definition, do you have a question regarding what the correct order of parts should be?


​Actually, you didn't find the correct page...

This is a "CREATE TABLE" not "CREATE TABLE AS" command...

David J.
​
 


pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: ERROR: out of shared memory
Next
From: "David G. Johnston"
Date:
Subject: Re: ERROR: out of shared memory