El día 2 de marzo de 2009 18:14, Angelo Astorga
angeloasto...@gmail.com escribió:
Trabajo con postgresql 7.3.4 y el log se guarda en el dir
.../data/serverlog, ahora que utilizo postgresql 8.1.11 no encuentro donde
guarda el log, alguna ayuda de como generar archivo log de postgresql...
Thank you very much for your advice, I guess I'm wasting my time in
this 'problem'. I'm going to check that class, it seems pretty useful.
And by the way...yes, this is a born-dead app (at least on the client
side) and it's likely to be ported to .NET in the future, but like I
said before, it's
Hi, check this out:
http://archives.postgresql.org/pgsql-general/2008-05/msg00938.php
I would say that execute is the only way to achieve some things
related to schemas and temp tables.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi all, I'm using visual foxpro 9 -not my decision- for a client
application. Statements are writen as the typical sql string and sent
through ODBC.
For numbers, I have to convert them first to string and then remove
the spaces, the code looks like this: sql_string = some sql +
alltrim( str(
What error are you getting?
I tried your query and I had to add an explicit cast to smallint[] to
make it work. Like this:
... a.attnum = any ((select conkey FROM pg_catalog.pg_constraint WHERE
oid = 3708025)::smallint[]);
It seems strange to me, I didn't expect the ANY clause to need that
Hola, no olvides que esta es la lista de correo para usuarios de habla inglesa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Check out the log_statement option in the postgresql.conf file
(there's an entire section (18.7) in the docs about logging).
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi, I'm working on a little backup utility for a desktop application. It's
going to execute pg_dumpall (-r) and pg_dump, but first I have to deal with
the permissions needed to do that:
1. Users (pgsql roles) enabled to backup would be superusers all the time.
This sounds insecure.
2. Users will
Hello Scott, thanks for your answer. I've just noticed that my first message
lacked some important info.
First, this is an accounting software, and there's only one database. Almost
all of the options (buttons, generally ) are stored in a set of tables,
beside the database privileges needed to
2008/10/22 Ma. Cristina Peña C. [EMAIL PROTECTED]
I want to use a function in to a trigger
This is my
CREATE FUNCTION subradio(integer) RETURNS integer AS 'select cast(count
(claveubica) as integer ) from asradios where ubicacion =0;' LANGUAGE 'sql';
And my ttrigger is
CREATE
2008/10/20 Glyn Astill [EMAIL PROTECTED]
Hi people,
Hopefully this is a quickie, I want to pass in a table name to a plpgsql
function and then use that table name in my queries.
Is EXECUTE the only way to do this?
As far as I know, yes. That's the only way to create queries using dynamic
2008/10/7 Alvaro Herrera [EMAIL PROTECTED]
Bruce Momjian escribió:
Well, I posted about this in August with no one replying:
http://archives.postgresql.org/pgsql-admin/2008-08/msg00068.php
Basically, there is a mismatch between what libpq and the backend think
is the username,
Hi there, I'm going to use the db_user_namespace parameter to get a strong
relationship between roles and databases, multiple databases -users
included- residing in the same server without conflicts is my objective too.
Right now I'm working on the backup process, which ideally would let me
Hi, first of all, a new role doesn't have any privilege on any table (every
type of database object has different default privileges), so you only have
to grant select on the tables you want, and yes, one by one.
You can also grant or revoke privileges this way: grant select on
BTW, should you have an else clause in there? - What happens when the
comparison fails?
As Tom said, a null value would be returned.
2008/9/3 brian [EMAIL PROTECTED]
Fernando Moreno wrote:
Hello, I'm new to this mailing list, and I have a couple of questions:
Is it really necessary to add the [GENERAL] prefix?
The prefix is added by the mailing list software. It's there so that people
subscribed to multiple pgsql
Hello, I'm new to this mailing list, and I have a couple of questions:
Is it really necessary to add the [GENERAL] prefix?
Are messages without this prefix likely to be ignored by automatic filters
or something like that?
Thanks in advance.
2008/8/29 Bill Todd [EMAIL PROTECTED]
If I have a series of RAISE NOTICE 'xxx' statements in a plpgsql function
and I call the function from pgAdmin the notice messages are concatenated on
a single line on the Messages tab. Is there any way to get each message to
appear on a separate line?
Hi, I've changed the setting log_statement to mod, in order to log data
modifications, and it's working fine with sentences sent by the client
application (psql included), but insert/update/delete sentences executed
inside functions are not logged. Functions are called in a select query.
I've
I haven't use the RETURNING clause before, but the INTO option, at least
in SELECT sentences, must be outside of the string expression. This way:
EXECUTE 'some query' INTO variable;
Cheers.
2008/5/30 A B [EMAIL PROTECTED]:
I have a query like this in a plpgsql function:
EXECUTE 'INSERT INTO
20 matches
Mail list logo
