i have a solution using RULES and PLGPSQL functions (instead of
triggers) for insert-unless-found, using perl lingo:
# perlish pseudoCode
unless (select(tbl.fld == val)) { insert tbl.fld = val };
i'd love to hear the skinny on why the following is a bad idea,
which i presume it i
The RPM support locale ?
If not I cant use them :(
- Original Message -
From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]>
To: "Ben-Nes Michael" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 7:12 AM
Subject: Re: [GENERAL] readline and rh7.1
"Ben-Nes Michael" <[
Justin Clift <[EMAIL PROTECTED]> forwards:
> The problem was that when we run the benchmark with the --fast option,
> which basicly does a vacuum() between after each batch of updates,
> postmaster started to fill up disk with log files during one of the
> vacuum() runs and didn't stop until the d
"Ben-Nes Michael" <[EMAIL PROTECTED]> writes:
> Yes I did with locale + debug
It's known to work in the official RPMs. I suggest you take a look at
those, and at the output from configure on your own system.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)--
Hi there,
> Having done a fair bit of VB programming (in VB 6), it seems to me that
> recordcount is simply unreliable, no matter which database or which ODBC driver
> you use...
In fact the ODBC specs states that it may not be accurate for client/server databases
because they may not know ho
Wayne Johnson <[EMAIL PROTECTED]> writes:
> According to the Postgresql manual, a user can alter their own
> password. When I try:
> alter user "test" with password "";
> Where test is the user id signed in with, I get the error:
> ERROR: pg_shadow: Permission denied.
Works for me. What ve
According to the Postgresql manual, a user can alter their own
password. When I try:
alter user "test" with password "";
Where test is the user id signed in with, I get the error:
ERROR: pg_shadow: Permission denied.
What am I overlooking?
Tia,
---(end of broadcast
Svenne Krap <[EMAIL PROTECTED]> writes:
> I thought of the possibility to do something like
> select rownum as artistplacement, s.* from (select rownum as
> techplacement, * from ranking order by technical_points) order by
> s.artiste_points
This is an interesting example, but I do not believe
[EMAIL PROTECTED] (Lee Harr) writes:
> Ok, I got some more information out of the debugger, but not much more.
Ah, I didn't see this message before --- apologies for my previous
waste-of-bandwidth.
> Program terminated with signal 4, Illegal instruction.
> #0 0x812023a in convert_numeric_to_sca
matthew wong <[EMAIL PROTECTED]> writes:
> i found sometimes when i setup the pg_hba.conf
> to restrict to only allow a client from certain
> ip to access a database with password auth, but
> i found even i give an invalid password, the
> client still can connect to t
[EMAIL PROTECTED] (Lee Harr) writes:
> I am running PostgreSQL 7.1.2 on FreeBSD 4.3
> This is an old 486 with only 12MB memory.
> I am able to create databases and insert and retrieve data,
> but when I try to query on the structure of the database
> I am getting this error:
> signin=# \d pe
Yes I did with locale + debug
- Original Message -
From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]>
To: "Ben-Nes Michael" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 29, 2001 6:36 PM
Subject: Re: [GENERAL] readline and rh7.1
"Ben-Nes Michael" <[EMAIL PROTECTED]> wri
"Ben-Nes Michael" <[EMAIL PROTECTED]> writes:
> The readline support don't work under Red Hat 7.1.
Yes, it does. I'm guessing you compiled postgresql yourself?
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 4: Don't 'kill -9
Hi All
The readline support don't work under Red Hat 7.1.
I have both rpm files
$ rpm -qa|grep readline
readline-devel-4.1-9
readline-4.1-9
and I searched the archive + read the following threads with no success
http://fts.postgresql.org/db/mw/msg.html?mid=1026906
any one solved the problem ?
Hi all,
The "MySQL Benchmark" page on the mysql.com website has benchmarks for
various databases :
http://www.mysql.com/information/benchmarks.html
In the PostgreSQL entry they aren't able to report an "accurate" result
for all things, as they haven't been able to get vacuum to work 100%
correc
15 matches
Mail list logo
