On Mon, Jan 13, 2003 at 14:59:58 -0800,
Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> On Mon, 13 Jan 2003, Andrzej Kwiatkowski wrote:
>
> > I've read that in postgres v 7.3 and above is possible to set
> > permissions for creating tables in given database...
> >
> > I've tried in many various wa
Nick,
Thank you very much for your response. Actually, here is the details:- I have a Students table with only three columns: firstname, lastname, email. I issued the following select statements:1) select * from students; 2). select firstname, last name from students;
query 1) worked fine, but qu
Hi All,
May I know how can I replace 'Enter Character' to 'balnk space' character,
while retreiving data from my database.
While storing data in a field of type text, i am storing with 'Enter'
characters, but I have to give to my applciation data with our 'Enter Keys',
so I have to skip 'Enter' K
On Mon, 13 Jan 2003, Christian Brink wrote:
> I am looking for any discussions on when to use BLOB's as opposed to storing
> files on a filesystem. If someone knows of a published discussion or has
> some pearls of wisdom on this I would greatly appreciate it.
Furthermore, I would appreciate know
I am looking for any discussions on when to use BLOB's as opposed to storing
files on a filesystem. If someone knows of a published discussion or has
some pearls of wisdom on this I would greatly appreciate it.
Christian Brink
[EMAIL PROTECTED]
---(end of broadcast)--
On Mon, 13 Jan 2003, Andrew Biagioni wrote:
> It appears to me that the Deadlock Checker doesn't see (and thus
> release) foreign-key-based locks (see below for details). Am I missing
> something? Is there a configuration item I am unaware of?
We're going to need a runnable example, I'm not 100
It appears to me that the Deadlock Checker doesn't see (and thus
release) foreign-key-based locks (see below for details). Am I missing
something? Is there a configuration item I am unaware of?
As far as I can tell (yes, I tested thoroughly) if I create a normal
deadlock situation as follows, th
> The problem
> is that Tomcat computes the digest without a salt and, therefore,
> authentication is failing because the two digested versions of the same
> password are different.
If there is not a feature within Tomcat to allow adding the username as
a salt to the MD5 hash, then Tomcat is broke
On Mon, 13 Jan 2003, Andrzej Kwiatkowski wrote:
> I've read that in postgres v 7.3 and above is possible to set
> permissions for creating tables in given database...
>
> I've tried in many various ways, byt always given user can create
> tables in database.
If you remove the create permission f
Patrick Meylemans <[EMAIL PROTECTED]> writes:
> From time to time we receive some DEBUG information in the /var/log/messages
> logger: DEBUG: SendSharedInvalidMessage: SI buffer overflow
This is harmless. Ignore it.
regards, tom lane
---(end of
I've read that in postgres v 7.3 and above is possible to set
permissions for creating tables in given database...
I've tried in many various ways, byt always given user can create
tables in database.
Have you got any idea ?
Maybe some example ??
Thanks in advance
Andrzej Kwiatkowski
-
Helen-
There is a separate JDBC list for related questions that I suggest you use
in the future.
A code sample is needed for a really good answer, but I'll make a guess.
This message is probably telling you that you are either trying to set a
value in a where clause that has a higher index than t
Dear,
From time to time we receive some DEBUG information in the
/var/log/messages
logger: DEBUG: SendSharedInvalidMessage: SI buffer
overflow
I assume this is a parameter witch is too low, can anybody tell
me what parameter this is
Our settings:
THE OS
Red Hat Linux release 7.0 (Guinness)
Kern
Ah, yes, of course. This was not included on the 8.0 distribution CDs I
have...but I found it on Suse ftp site. All is well now.
Thanks for the help!
L.
On Sun, 12 Jan 2003, Peter Eisentraut wrote:
> Laurette Cisneros writes:
>
> > On Suse 8.0, I'm trying to compile postgresql 7.3.1.
> >
> >
"codeWarrior" <[EMAIL PROTECTED]> writes:
> I noticed that the server generated logfile gets real big real fast -- (15
> queries and it's already at 1.5MB) -- Is there a switch / option to recycle
> the server logs periodically ???
The recommended procedure is not to use pg_ctl's -l switch, but to
I recently discovered that another programmers CGI's are occasionally
killing my postgreSQL server so I decided to modify the postgres.conf file
to do some extended logging and additionally redirect the server output into
an error log (using the -l pgdblog.log) switch...
postgreSQL was restarted l
Hello,
I am new in postgresql. sorry if I may ask simple question. I got error message when I pass sql statement into database through JDBC. the error msg is:
"connect and execute query: The column index is out of range."
I check the sql statement string passed into db, it looks fine. I have no ide
Christopher McNabb <[EMAIL PROTECTED]> writes:
> I am trying to set up PAM authentication with postgres 7.3.1.
I'm not a PAM user, but your pg_hba entry seems correct according to the
docs:
> hostall all 0.0.0.0 0.0.0.0 pam
> postgresql
assuming that that'
"Geoff Ellis" <[EMAIL PROTECTED]> writes:
> === ERROR: fmgr_info: function 696542: cache lookup failed =
This is on 7.3? My first guess would have been that you deleted and
recreated the function without recreating the trigger that references
it. But 7.3 should not let you do that.
> I've t
Well, actually I *do* want to. My goal is to be able to use my existing set
of database users to authenticate to web apps running in Tomcat. Tomcat
allows you to set up a JDBC Realm for authentication, which lets you connect
to a database and use usernames and passwords from that database. The p
"Rob Abernethy IV" <[EMAIL PROTECTED]> writes:
> Can you tell postgres *NOT* to use a salt when calculating the MD5
> digest?
No, and you wouldn't want to. The salt is an essential security
feature.
regards, tom lane
---(end of broadcast)-
On Mon, 2003-01-13 at 10:13, Ing. Gabriel Monsalvo wrote:
> You must set the PAM's authentication file, you should have a configuration
> file with the authentication settings for the postgresql server in pam.d
> directory, for example if you auth file is "postgresl" your pg_hba.conf
> file:
>
Ye
You must set the PAM's authentication file, you should have a configuration
file with the authentication settings for the postgresql server in pam.d
directory, for example if you auth file is "postgresl" your pg_hba.conf
file:
hostall all 0.0.0.0 0.0.0.0 pam
I've got a tiny problem with how I want this function to work.
On and insert/delete from a table, I want to check to see if a field
contains a certain valule. If it does, not to insert or delete the record.
If it doesn't I want to go ahead and insert/delete the record.
Here's my function.
-- Fun
I am trying to set up PAM authentication with postgres 7.3.1. This is
under Mandrake Linux 8.2 for i586. I've searched the archives and
haven't yet found a solution.
Here is the pg_hba.conf file:
# TYPE DATABASEUSERIP-ADDRESSIP-MASK
Can you tell postgres *NOT* to use a salt when calculating the MD5 digest? I
found that it prepends the username to the password before making the calculation.
--
Robert Abernethy IV
Dynamic Edge, Inc.
734.975.0460
> Perl also came up with the same digest as Java.
>
> --
> Robert Abernethy IV
>
Hi All,
May I know how can I replace 'Enter Character' to 'balnk space' character,
while retreiving data from my database.
Sreedhar
"Faith, faith, faith in ourselves, faith, faith in God, this is the secret
of greatness.
If you have faith in all the three hundred and thirty millions of your
myth
27 matches
Mail list logo
