CREATE GLOBAL TABLE really supported?

[gwinn7]

Does anyone have experience using this feature?

When I try to run the CREATE GLOBAL TABLE clause, the SQL parser rejects this as invalid syntax. But, the Postgres documentation has it in there as valid. I tried researching this, but I am not finding anything that seems to help.

Btw, when I remove the "GLOBAL" option, the table creates nicely.

Any suggestions or explanations?

Gary
gwinn7

 

[ceco]

well on my server it generates error too, but why do you want to use it anyway? there is no any difference if you create it without global in postgresql

 

[gwinn7]

Thank you for responding.

I was attempting to learn what the GLOBAL meant and if I could use it in a future project. But, I have disovered that you are right. It essentially does nothing in a PostgreSQL environment and causes an error if you attempt to included it in your script.

There is a small excerpt in the PostgreSQL documentation, pointed out by rycamor, that it was part of the SQL standard, but not really a supported item.

Gary
gwinn7

 

[rski]

I think u have to use global or local with temp or temporary options
ex.
create global temporary table ...

 

[gwinn7]

Nope. It appears that Postgres does not functionally support this clause.

Gary
gwinn7