Follow Me on Twitter
Client Support Community Server Status Contact Us Client Login
Email Hosting Website Hosting Reseller Hosting VPS Hosting Dedicated Servers
    Join our Community      Check your private messages       Profile       Search       FAQ       Memberlist       Log in

[Postgresql] public schema owned by postgresql

  
Post new topic   Reply to topic    NetHosted Community Index -> FTP/SQL Support
miemacom Reply with quote
 NetHosted Customer

 

 Joined: 10 Mar 2010
 Posts: 7
 
PostPosted: Wed Mar 10, 2010 10:01 pm    Post subject: [Postgresql] public schema owned by postgresql
 
Dears,

Is it normal that the public schema on my database is owned by postgresql?

I cannot delete it then of course.

What could I do?

Thanks!

Best regards,

Raphaël
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 7017
 
PostPosted: Wed Mar 10, 2010 10:27 pm    Post subject:
 
Hi,

This is expected. You are free to create other schema's.

Thanks,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Follow us on Twitter: http://twitter.com/nethosted 
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
miemacom Reply with quote
 NetHosted Customer

 

 Joined: 10 Mar 2010
 Posts: 7
 
PostPosted: Wed Mar 10, 2010 10:36 pm    Post subject:
 
Mmmhh, in fact, my tables are not schema aware, it's why I use the public one.

How could I still not choose the schema in my code? Using the set schema_path? Do you know if I have to execute this statement each time I do a request or could I execute it once for everytime?

Thank you for your quick reply
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 7017
 
PostPosted: Wed Mar 10, 2010 10:43 pm    Post subject:
 
miemacom wrote:

How could I still not choose the schema in my code? Using the set schema_path? Do you know if I have to execute this statement each time I do a request or could I execute it once for everytime?

Thank you for your quick reply


Hi,

I'm afraid these are more PgSQL specific coding questions and are out of the scope of our support.

Sorry,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Follow us on Twitter: http://twitter.com/nethosted 
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
miemacom Reply with quote
 NetHosted Customer

 

 Joined: 10 Mar 2010
 Posts: 7
 
PostPosted: Wed Mar 10, 2010 10:50 pm    Post subject:
 
Ok, I will search on the Internet

Thank you

Good evening
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 7017
 
PostPosted: Wed Mar 10, 2010 10:51 pm    Post subject:
 
Sorry I couldn't be of more help!

Have a good evening too

Thanks,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Follow us on Twitter: http://twitter.com/nethosted 
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Post new topic   Reply to topic    NetHosted Community Index -> FTP/SQL Support
Page 1 of 1

User Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

 
Jump to: