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

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..

https://www.postgresql.org/docs/9.2/static/sql-createtableas.html

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...