Hi Julius Tuskenis,
Many thanks for helping me. These are good solutions. But I have some
doubts
Look below
On Oct 10, 11:06 am, [EMAIL PROTECTED] (Julius Tuskenis) wrote:
> I would suggest you 2 solutions:
> 1. to use a function to edit these fields. That way you will be sure
> that you will
On Oct 9, 6:23 pm, [EMAIL PROTECTED] ("c k") wrote:
> Is it possible to log all sql statements submitted to database server in a
> table in that database it self? This will be different from database logs
> which are written by db server.
> Regards,
> CPK
I am not confident but it should be posibl
On Oct 10, 9:42 am, Jagadeesh <[EMAIL PROTECTED]> wrote:
> HI,
>
> how can I invoke editor like vim from postgres? This helps me in
> editing large and complex queries.
> Thanks
I just got to know emacs can be used for it. Is there any other
method?
I am using FreeBSD.
Thanks
--
Sent via pgsql-
thanks for your answer Tom,
I've installed that module contrib but there's nothing like ossp-uuid inside!
I've found it through software.opensuse for my opensuse 11 version and
ossp-uuid should be installed separately, or am I wrong?. I took it from
http://www.ossp.org/pkg/lib/uuid/
you know som
I don't know a way to edit 2 tables in 1 SQL statement. If you have 2
sql statements then the performance should be almost the same with the
function and maybe slightly worse with a trigger.
Jagadeesh rašė:
Hi Julius Tuskenis,
Many thanks for helping me. These are good solutions. But I have
[EMAIL PROTECTED] writes:
> I've installed that module contrib but there's nothing like ossp-uuid inside!
> I've found it through software.opensuse for my opensuse 11 version and
> ossp-uuid should be installed separately, or am I wrong?. I took it from
> http://www.ossp.org/pkg/lib/uuid/
Looks li
If you could declare a Foreign Key on two columns in "history" table
referencing "master" table, and declare this FK with "ON UPDATE CASCADE"
option, then postgres will update status in history table for you
whenever you update status in master table.
Igor
-Original Message-
From: [EMAIL
Jagadeesh escribió:
> HI,
>
> how can I invoke editor like vim from postgres? This helps me in
> editing large and complex queries.
Use \e, and make sure EDITOR is set to the editor of your preference.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL
[EMAIL PROTECTED] writes:
> I'm running on a openSuse 11 and postgresql 8.3 and I've installed ossp-uui.
> The
> problem is when I try to execute the uuid.sql, it doesn't work.
I'm not sure what uuid.sql is, but it is not the script that comes with
8.3's contrib/uuid-ossp module. Judging from th
Jagadeesh wrote:
Hello Gurus,
Is it possible to update two table using single sql statement? huh?
let me be clear
I have table master with state and date field. And in history table I
have same fields i.e., state and date. I'm writing an update statement
to set 'open' state records to 'closed'
Jagadeesh a écrit :
> On Oct 10, 9:42 am, Jagadeesh <[EMAIL PROTECTED]> wrote:
>>[...]
>> how can I invoke editor like vim from postgres? This helps me in
>> editing large and complex queries.
>> Thanks
>
> I just got to know emacs can be used for it. Is there any other
> method?
> I am using Free
Hi everybody, I'm a newcomer and I've started to work with postgresql this week
:)
I'm running on a openSuse 11 and postgresql 8.3 and I've installed ossp-uui. The
problem is when I try to execute the uuid.sql, it doesn't work.
[EMAIL PROTECTED]:/usr/lib64/postgresql> psql -U postgres -f
/usr/sha
Hello Gurus,
I'm new to Postgress world and before start creating my first database
for test.
I have some questions, beware I have experience with other RDBMS.
1- when issue create db , is there a option to specify the database
page size ? what's the default ? ( don't see any comments in do
>>> Isabella Ghiurea <[EMAIL PROTECTED]> wrote:
> 1- when issue create db , is there a option to specify the database
> page size ? what's the default ? ( don't see any comments in docs)
Page size is set at compile time. The default is 8kB. You probably
don't need to fuss with this, as lar
Please keep responses on the list; others may be able to help.
>>> Isabella Ghiurea <[EMAIL PROTECTED]> wrote:
> you mentioned about this PG cfg parameters , will the Postgress.org
Docs
> provide
> good example for setting this values in RH 5 -x86 -64 bits OS ?
I don't think many of these
Well, the list became very quiet on this question. Can anyone chime in with
suggestions to have some accounts authenticated by ldap and the remainder by MD5
Evan.
Evan Rempel wrote:
I would like to use password authentication for most users, but LDAP
authentication for the remaining ones users
It's surely possible.
Just enable this at postgresql.conf:
log_destination = 'stderr'
redirect_stderr = on
And then choose what to log:
log_statement = 'all'
Valid values are none, ddl, mod, and all. ddl logs all data definition
commands like CREATE, ALTER, and DROP commands. mod logs all ddl
17 matches
Mail list logo
