I downloaded postgresql and pgadmin and am setting up an experimental
database in our company.
I have a basic grasp on relational databases but now need a bullet proof
tutorial on setting up users and privileges as well as dealing with
autoincremental primary keys.
We have a Linux server wit
On Thu, Mar 5, 2009 at 7:59 AM, Gerhard Botha wrote:
> On my installation, the regular user is denied access to this table.
I think you've missed that you also need to grant USAGE privilege for
the schema. http://www.postgresql.org/docs/8.3/interactive/sql-grant.html
> I then log on as the super
On Thu, Mar 5, 2009 at 9:05 AM, Marcin Stępnicki wrote:
> Go to File/Options/Preferences and turn on "Show users for
> privileges". This should be default in my opinion.
No it shouldn't. In most cases if you're configuring permissions for
individual users then you're setting yourself up for futu
I've been trying to find a way to debug my PL/Pgsql functions. The one click
8.3 installer doesn't create a \contrib directory and although I found and
downloaded the appropriate files I don't know how to make them. I even
tried an alternate front end admin tool and it won't work either without
On Thu, Mar 5, 2009 at 11:21 AM, woodcock wrote:
>
> I've been trying to find a way to debug my PL/Pgsql functions. The one click
> 8.3 installer doesn't create a \contrib directory and although I found and
> downloaded the appropriate files I don't know how to make them. I even
> tried an alte
2009/3/5 Dave Page :
> On Thu, Mar 5, 2009 at 9:05 AM, Marcin Stępnicki wrote:
>
>> Go to File/Options/Preferences and turn on "Show users for
>> privileges". This should be default in my opinion.
>
> No it shouldn't. In most cases if you're configuring permissions for
> individual users then you'
On Thu, Mar 5, 2009 at 10:21 AM, woodcock wrote:
>
> I've been trying to find a way to debug my PL/Pgsql functions. The one click
> 8.3 installer doesn't create a \contrib directory and although I found and
> downloaded the appropriate files I don't know how to make them.
The contrib directory I
Thank you for the information guys. I did manage to figure it out
eventually. And yes, I would prefer using groups in the real world. I
missed the preferences thing completely though.
Regards, Gerhard
begin:vcard
fn:Gerhard Botha
n:Botha;Gerhard
org:Winder Controls (Pty) LTD
adr:PO Box 383;;56
> The one click installer includes the debugger plugin pre-compiled and
> ready to use. All you need to do is stick:
>
> shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'
>
> In postgresql.conf, and restart the server. Then, run the SQL script
> in the database you wish to debu
On Thu, Mar 5, 2009 at 1:07 PM, woodcock wrote:
>
> Thanks for the prompt response which worked. I can now debug in pgAdmin.
Glad to help.
> Hopefully other Windows users will find your easy solution (which I've not
> seen elsewhere.)
It's in the installation notes - see Start->Programs->Postg
10 matches
Mail list logo
