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

[smiley2211]

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.


---(end of broadcast)---
TIP 6: explain analyze is your friend

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

[smiley2211]

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_class 
 where relname !~ 'pg_*' AND relkind in ('r','v','S') ORDER BY relname;

*

Thanks...Michelle :confused:


-- 
View this message in context: 
http://www.nabble.com/Generating-sql-to-capture-fully-qualified-table-namestf4654460.html#a13298439
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[GENERAL] Automating Backup & Restore

[smiley2211]

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??)
pg_dump > filename.dmp
scp filename.dmp to SERVER2

Server2 
psql -d mydb -f filename.dmp
vacuum
reindex

Any hints or tips are welcomed...

Thanks...Michelle.
-- 
View this message in context: 
http://www.nabble.com/Automating-Backup---Restore-tf4684052.html#a13384762
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Automating Backup & Restore

[smiley2211]

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 postmaster

[GENERAL] pg_ctl & show all

[smiley2211]

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

Thanks...Michelle
-- 
View this message in context: 
http://www.nabble.com/pg_ctl---show-all-tf4774691.html#a13658884
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] pg_ctl & show all

[smiley2211]

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 reflected...how do I get this file to be reloaded??
> 
> effective_cache (requires restart)
> shared_buffers (requires restart)
> 
> version 8.2.5
> 
> Thanks...Michelle
> 

-- 
View this message in context: 
http://www.nabble.com/pg_ctl---show-all-tf4774691.html#a13659995
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

[GENERAL] Trigger - will not perform INSERT

[smiley2211]

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. Once I take the trigger off, it beings
inserting again.

I have checked permissions but INSERT only FAILS while trigger is enabled..

Thanks...Michelle
-- 
View this message in context: 
http://www.nabble.com/Trigger---will-not-perform-INSERT-tp14282848p14282848.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Trigger - will not perform INSERT

[smiley2211]

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)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Trigger - will not perform INSERT

[smiley2211]

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.


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

[GENERAL] Extracting \ Generate DDL for existing object permissions

[smiley2211]

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 database B from A - 
4) execute sql to put permissions back to database B from step 2

Thanks...Michelle
-- 
View this message in context: 
http://www.nabble.com/Extracting-%5C-Generate-DDL-for-existing-object-permissions-tp17413948p17413948.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[smiley2211]

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 context: 
http://www.nabble.com/Can-a-pg_dump-file-loaded-via-pg_Admin-tool---tp17541378p17541378.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Must be table owner to truncate?

[smiley2211]

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.nabble.com/Must-be-table-owner-to-truncate--tp18697753p18697753.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[smiley2211]

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;
>> ERROR:  unrecognized privilege type "truncate"
> 
> There is no such permission; where did you get the idea there was?
> 
>   regards, tom lane
> 
> -- 
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
> 
> 
>-(
-- 
View this message in context: 
http://www.nabble.com/Must-be-table-owner-to-truncate--tp18697753p18698506.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general