Hi,
Today a client ask me for help to create a read only user for a postgresql 8.2
database, i ended up reading, copying and pasting and finally creating a
function i'm sharing with the list:
CREATE OR REPLACE FUNCTION db_grant(usuario text, privilegio text)
RETURNS INTEGER AS $$
DECLARE
db R
Eric,
The posts in this forum must be done in english.
Entiendo que los posts a este foro deben ser en inglés.
May be you already did some of the next:
- Test if it works connecting with same credentials from the server itself and
other machine.
- Raise log/debug level on server and examine the
Hi,
Sorry for the recent post, mistakenly i wrote the subject in spanish... glup.
Hi,
Sometimes i end up with some duplicated constraints definitions in my database,
i've noticed this when i reverse engineer databases, and see many links between
two tables.
I prepared a perl script that read
Hi,
Sometimes i end up with some duplicated constraints definitions in my database,
i've noticed this when i reverse engineer databases, and see many links between
two tables.
I prepared a perl script that read an schema on standard input, and prints on
standard output some drop constraints f