hi all
i try to find a new postgre rpm package for suse 9.2 but i didnt find some.
plz help a newbee
thx
martin
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Announcing dataKiosk version 0.7
**
-- What can this version of dataKiosk do? --
dataKiosk 0.7 can provide a fully featured data entry application tailored to
any SQL database in a matter of minutes.
-- What does fully
hi.
i just compiled a few versions of postgresql rpms for redhat 8.0 based on the
official srpms for redhat 9.
i started off with the official 7.4.1 release for redhat 8, then added the
lowest possible next version of the version i compiled. i ended up at 7.4.8.
it seems to work fine.
i am no
--- Peter Fein <[EMAIL PROTECTED]> wrote:
> Hi-
>
> I wanted to use a partially unique index (dependent on a flag) on a
> TEXT
> column, but the index row size was too big for btrees. See the
> thread
> "index row size 2728 exceeds btree maximum, 2713" from the beginning
> of
> this month for so
David Siebert <[EMAIL PROTECTED]> writes:
> Okay I have version 8.0.2 installed on CentOS 4.0 with all updates.
> I SSH into the server and try and run pg_dump all and get a stream of
> errors on the server screen but not on my ssh.
What do you get from
ls -Z /usr/bin/pg_dumpall
ls -Z /usr/bin/p
Dan Black <[EMAIL PROTECTED]> writes:
> 1)
> select * from my_table where active and deleted
> --
> Seq Scan on my_table (cost=1.00..10180.00 rows=2500 width=56)
> Filter: (active AND deleted)
> 2)
> select * from my_table where active = true and deleted = true
> --
Eric,
You might check out this thread:
http://archives.postgresql.org/pgsql-general/2005-06/msg00527.php
Someone can almost certainly point to a better thread, but it is a
start
Sean
On Jun 13, 2005, at 12:41 PM, Eric E wrote:
Hi David,
I ended up doing what you suggest, and it seems
On Jun 13, 2005, at 6:48 PM, Jonah H. Harris wrote:
I wouldn't say it's enterprise-grade, but one could probably make it
work.
I totally agree--I use it relatively often. This single piece of
software opened my eyes as to the extent to which the procedure
languages can be leveraged.
Se
Hi-
I wanted to use a partially unique index (dependent on a flag) on a TEXT
column, but the index row size was too big for btrees. See the thread
"index row size 2728 exceeds btree maximum, 2713" from the beginning of
this month for someone with a similar problem. In it, someone suggests
indexi
I wouldn't say it's enterprise-grade, but one could probably make it work.
Sean Davis wrote:
There is DBI-link, but this probably isn't an "enterprise" solution
http://www.pervasive-postgres.com/postgresql/tidbits.asp
Sean
On Jun 13, 2005, at 2:31 PM, Jonah H. Harris wrote:
The contrib/d
Hi David,
I ended up doing what you suggest, and it seems to work OK right now. I'll definitely look for return_next in 8.1.
On a related subject, is there any interest in eliminating the requirement that types be specified at runtime,
either by the function returning the type, or in the sele
Thanks.
- Original Message -
From: "Volkan YAZICI" <[EMAIL PROTECTED]>
To: "Zlatko Matić" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>
Sent: Monday, June 13, 2005 8:47 AM
Subject: Re: [GENERAL] [INTERFACES] retrieving information about password
from MS Access front-end
Hi,
On 6/13
There is DBI-link, but this probably isn't an "enterprise" solution
http://www.pervasive-postgres.com/postgresql/tidbits.asp
Sean
On Jun 13, 2005, at 2:31 PM, Jonah H. Harris wrote:
The contrib/dblink module only works for creating a database link to
another PostgreSQL database. I'm work
Hi.
I'm forwarding you what I answered to Rolland about it. This "#deleted"
phenomena is something often, but can be easily solved.
It seems to be common problem with Access connectiong to ODBC data source.
Access has some problems to determine primary key...
You should not use textual fields as
On Tue, Jun 14, 2005 at 08:37:38 +1200,
David Mitchell <[EMAIL PROTECTED]> wrote:
> I'm totally baffled as to why postgres won't use this index. I have a
> table "point" with an index on it as so:
>
> CREATE INDEX unit_point
> ON point
> USING btree
> (unit_id, time);
>
> When I try the
On Mon, Jun 13, 2005 at 22:27:31 +0200,
Együd Csaba <[EMAIL PROTECTED]> wrote:
>
> The critical tables are vacuum analyzed in every hour. (Not vacuum full
> because of the several minutes long exclusive lock)
>
> Earlier the system had been running for 3 months without problems, but a few
> we
=?iso-8859-2?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes:
> The critical tables are vacuum analyzed in every hour.
Evidently that's not often enough. Or it could be that your
FSM settings aren't large enough?
regards, tom lane
---(end of broadcas
I'm totally baffled as to why postgres won't use this index. I have a
table "point" with an index on it as so:
CREATE INDEX unit_point
ON point
USING btree
(unit_id, time);
When I try the following query, it insists on using a seqscan:
SELECT time FROM point
WHERE unit_id = 95501 and fla
Hi,
there is a very intensively used database. The "usage" means that there are
many-many changes in it. It is 24/7 application.
One table is used to insert 200+ rows per minute from a datacolletor driver
application. 200+ deletions are also performed on the same table. It is very
very important
Dan Black <[EMAIL PROTECTED]> writes:
> 1)
> select * from my_table where active and deleted
> --
> Seq Scan on my_table (cost=1.00..10180.00 rows=2500 width=56)
> Filter: (active AND deleted)
>
> 2)
> select * from my_table where active = true and deleted = true
> -
Richard Huxton wrote:
David Siebert wrote:
Okay I have version 8.0.2 installed on CentOS 4.0 with all updates.
I SSH into the server and try and run pg_dump all and get a stream of
errors on the server screen but not on my ssh.
Any suggestions?
Um - post some of the errors?
There are some
1)
select * from my_table where active and deleted
--
Seq Scan on my_table (cost=1.00..10180.00 rows=2500 width=56)
Filter: (active AND deleted)
2)
select * from my_table where active = true and deleted = true
-
Index Scan using my_table_index on my_table (c
I'm using postgres 7.4.6 and I've created a table as follows:
create table t(dh int, fh int, fn int, x bytea, ...)
create index idx_dh_fh on t(dh, fh);
I have this query:
select *
from t
where dh = 1
and fn > 1000
and x = 'abc'
order by fn;
The optimizer use
David Siebert wrote:
Okay I have version 8.0.2 installed on CentOS 4.0 with all updates.
I SSH into the server and try and run pg_dump all and get a stream of
errors on the server screen but not on my ssh.
Any suggestions?
Um - post some of the errors?
There are some very clever people on th
Um - post some of the errors?
There are some very clever people on these lists, but none of them
psychic afaik ;-)
Speak for yourself. I know you are wearing a blue shirt today! ;P)
Sincerely,
Joshua D. Drake
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
Dan Black <[EMAIL PROTECTED]> writes:
> First query does not use index in contrast to two query.
>
> Why?
You don't give enough information. Post EXPLAIN ANALYZE output for
both queries and perhaps someone can help.
-Doug
---(end of broadcast)---
Okay I have version 8.0.2 installed on CentOS 4.0 with all updates.
I SSH into the server and try and run pg_dump all and get a stream of
errors on the server screen but not on my ssh.
Any suggestions?
---(end of broadcast)---
TIP 9: the planner w
The contrib/dblink module only works for creating a database link to
another PostgreSQL database. I'm working on a dblink_ora which allows
you to connect to an 8i, 9i, or 10g system the same way. dblink_ora is
based on dblink, not dblink_tds (for SQL Server) so it has more
features. Also, I'
I created a table
CREATE TABLE my_table
(
id int4 NOT NULL,
name varchar(64) NOT NULL,
deleted bool NOT NULL,
active bool NOT NULL,
CONSTRAINT my_table_pkey PRIMARY KEY (id)
)
and index
CREATE INDEX my_table_index
ON my_table
USING btree
(deleted, active);
there is two identi
Hi, can you give me hints to port this ASA stored procesure
ALTER procedure dba.sp_billetes(in p_importe numeric(15))
result(cien_mil numeric(3),cincuenta_mil numeric(3),diez_mil
numeric(3),cinco_mil numeric(3),mil numeric(3),quinientos
numeric(3),cien numeric(3),cincuenta numeric(3),diez numeric(
I successfully installed Postgre 8.0 and was able to develop tables,
columns and insert data.. However, after an uninstall Postgre would not let
me proceeded reinstalling it.
Even after manually removing any vestige of Postgre the install still
sees an existing account and refuses to proce
[EMAIL PROTECTED] (Tatsuo Ishii) writes:
>> For the contents too. I dont think the source code installation
>> should be so much in the focus of the certification.
>
> Since PostgreSQL is an open source database, I think it is important
> to understand how to install PostgreSQL from the source code
Folks
I am a little confused, I am trying to implement md5
autentication protocol,
as the field is used salt?
is hash of md5 algorithm?
how build the key?
the server log say:
'Password authentication failed for user'
is algun example of as it is the protocol?
best regards
mdc
__
Csaba Nagy wrote:
That would work indeed. Bit I guess the savepoint solution will be the
simplest and fastest if the OP has or can install 8.0 version.
I'd say so. Otherwise you'll just sit on the lock, and then still have
to deal with an error later anyway when the lock times out.
--
Rich
That would work indeed. Bit I guess the savepoint solution will be the
simplest and fastest if the OP has or can install 8.0 version.
Cheers,
Csaba.
On Mon, 2005-06-13 at 17:49, Richard Huxton wrote:
> Csaba Nagy wrote:
> > [snip]
> >
> >>If you have more than one client, this can always happen.
Csaba Nagy wrote:
[snip]
If you have more than one client, this can always happen. You have two
choices:
1. Use a lock to stop two clients interacting like this
This won't work unless you make all the clients serialized, or you have
all the ip's already inserted in the data base... you can
[snip]
> If you have more than one client, this can always happen. You have two
> choices:
> 1. Use a lock to stop two clients interacting like this
This won't work unless you make all the clients serialized, or you have
all the ip's already inserted in the data base... you can't lock on an
unk
On Mon, 2005-06-06 at 14:52, Edward Peschko wrote:
> hey all,
>
>
> I'm trying to convince some people here to adopt either mysql or postgresql
> as a relational database here.. However, we can't start from a clean slate;
> we have a very mature oracle database that applications point to right n
folks
the server log message is
LOG: invalid message length
any clue?
best regards
mdc
pd: where can i find header format messages for
bki protocol?
___
A tu celular ¿no le falta algo?
Usá Yahoo! Messenger y Correo Yahoo! en
ON.KG wrote:
before inserting or updating this table there're some checkings,
logs, etc., so I'm using PL/PgSQL for that
after all checkings and logs I have:
UPDATE table1
SET hits = hits + 1
WHERE ip = some_ip;
IF NOT FOUND THEN
INSERT INTO table1
Your problem is that the trigger's "found" check will not see the row
inserted by a concurrent transaction. In other words, your insert
actually fails, the record what you see was inserted by another
concurrent transaction, and the "found" check didn't work because the
other transaction started aft
folks
the server log message is
LOG: invalid message length
any clue?
best regards
mdc
pd: where to found the foot print header messages for
bki protocol?
___
A tu celular ¿no le falta algo?
Usá Yahoo! Messenger y Correo Yahoo! en tu telé
Hi All!
I have table:
CREATE TABLE table1 (
ip char(15) NOT NULL,
hits integer NOT NULL default '1',
PRIMARY KEY (ip)
);
So it's counting hits per each IP for current day and every day
trancated by cron:
TRUNCATE TABLE table1;
before inserting or updating this table there're some check
Tom, Magnus.
Thanks for the great support.
Howard Cole
www.selestial.com
Magnus Hagander wrote:
Are there any plans for fixing the UNICODE encoding on Windows?
Yes. There is a patch floating around to use ICU, which will fix this
(amongst the other things it does). The hope is that it'
> I looked into the problem further - and could not repeat the
> problem on my windows XP machine. The problem was isolated to
> a server which uses the 64bit edition of W2K3 server.
> Otherwise the W2K3 64bit edition seems to run PG ok.
>
> Are there any plans for fixing the UNICODE encoding o
I looked into the problem further - and could not repeat the problem on
my windows XP machine. The problem was isolated to a server which uses
the 64bit edition of W2K3 server. Otherwise the W2K3 64bit edition seems
to run PG ok.
Are there any plans for fixing the UNICODE encoding on Windows?
Dan Miller wrote:
I have a server under very light load -- just me doing some work in php.
I am getting this error often and don't know why:
postgresql max connections Unable to connect to PostgreSQL server:
FATAL: Sorry, too many clients already
my orignal postgresql.conf had:
max_
47 matches
Mail list logo