Re: [GENERAL] Must be table owner to truncate?

Unfortunately, I found the command via google...I later checked the documentation... http://www.postgresql.org/docs/8.1/static/sql-truncate.html Thanks...Michelle Tom Lane-2 wrote: > > smiley2211 <[EMAIL PROTECTED]> writes: >> GRANT TRUNCATE ON stage01 TO jaime44; >&

[GENERAL] Must be table owner to truncate?

Hello all, I am trying to GRANT truncate permissions to a non-owner of table and it's not allowing me to: GRANT TRUNCATE ON stage01 TO jaime44; ERROR: unrecognized privilege type "truncate" How do I grant said permission? Thanks...Michelle. -- View this message in context: http://www.nabb

[GENERAL] Can a pg_dump file loaded via pg_Admin tool??

Hello all, I have created a backup via 'pg_dump -c -f mydump.backup' - however when I try to load it via pg_Admin tool, it does not allow me to - the 'OK' button is grayed out even though I have selected the file to be restored...is this doable? Thanks...Michelle -- View this message in contex

[GENERAL] Extracting \ Generate DDL for existing object permissions

Hello all, How do I capture the EXISTING permissions for a database? I know you can see them via \z or \dp however I need ALL permissions to be captured so I can reapply after performing a database restore. ex: 1) dump database A - 2) Extract permissions from database B - (HOW) 3) load d

Re: [GENERAL] Trigger - will not perform INSERT

Thanks all...ended up being a missing field in my table definition...sorry to bother you all ... :wistle: -- View this message in context: http://www.nabble.com/Trigger---will-not-perform-INSERT-tp14282848p14297220.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. --

Re: [GENERAL] Trigger - will not perform INSERT

Ok, thanks...I will do some more testing and see what I get... -- View this message in context: http://www.nabble.com/Trigger---will-not-perform-INSERT-tp14282848p14296002.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---(end of broadcast)

[GENERAL] Trigger - will not perform INSERT

ex: CREATE TRIGGER mytrig AFTER INSERT OR UPDATE ON foo1 FOR EACH ROW EXECUTE PROCEDURE updatefoo1('datarow'); The command itself is able to be executed without error. However, what then happens, is that whenever the application attempts to insert a record into foo1, it simply doesn't insert. On

Re: [GENERAL] pg_ctl & show all

I was able to figure this out... Thanks all...Michelle smiley2211 wrote: > > Hello all, > > I changed my postgresql.conf settings and restarted postmaster show > changes would take affect however when I type 'show all' I don't see the > changes reflect

[GENERAL] pg_ctl & show all

Hello all, I changed my postgresql.conf settings and restarted postmaster show changes would take affect however when I type 'show all' I don't see the changes reflected...how do I get this file to be reloaded?? effective_cache (requires restart) shared_buffers (requires restart) version 8.2.5

Re: [GENERAL] Automating Backup & Restore

THANKS ALL... -- View this message in context: http://www.nabble.com/Automating-Backup---Restore-tf4684052.html#a13392360 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the p

[GENERAL] Automating Backup & Restore

Hello all, Does someone have a script that backups a database from one server and restores it to another server??? I am NEW to Postgresql so I am starting from scratch... so, in essence - what I want to do is (I CURRENTLY DO THIS MANUALLY): Server1 (IS IT POSSIBLE TO DUMP DIRECTLY TO SERVER2?

Re: [GENERAL] Generating sql to capture fully qualified table names??? - THANKS

THANK YOU BOTH ON YOUR REPLIES...THIS IS WHAT I WAS LOOKING FOR... -- View this message in context: http://www.nabble.com/Generating-sql-to-capture-fully-qualified-table-namestf4654460.html#a13299646 Sent from the PostgreSQL - general mailing list archive at Nabble.com. --

[GENERAL] Generating sql to capture fully qualified table names???

Hello all, I am using the query below to generate SQL code to grant access to objects - how do I get this statement to PULL the fully qualified name (schema.tablename)??? * SELECT 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' || relname || ' TO newuser;' FROM pg_c