Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

CREATE GLOBAL TABLE really supported?

CREATE GLOBAL TABLE really supported?

CREATE GLOBAL TABLE really supported?

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?


RE: CREATE GLOBAL TABLE really supported?

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

RE: CREATE GLOBAL TABLE really supported?

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.


RE: CREATE GLOBAL TABLE really supported?

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

RE: CREATE GLOBAL TABLE really supported?

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


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close