[GENERAL] suse 9.2

2005-06-13 Thread martin
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]

[GENERAL] Announcing dataKiosk version 0.7

2005-06-13 Thread Adam Treat
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

[GENERAL] postgresql rpms (7.4.2, 7.4.5, 7.4.8) for redhat 8.0

2005-06-13 Thread stig erikson
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

Re: [GENERAL] Hash Function: MD5 or other?

2005-06-13 Thread Shelby Cain
--- 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

Re: [GENERAL] pg_dumpall not working?

2005-06-13 Thread Tom Lane
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

Re: [GENERAL] Index does not working.

2005-06-13 Thread Tom Lane
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 > --

Re: [GENERAL] return next and pl/perl

2005-06-13 Thread Sean Davis
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

Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

2005-06-13 Thread Sean Davis
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

[GENERAL] Hash Function: MD5 or other?

2005-06-13 Thread Peter Fein
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

Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

2005-06-13 Thread Jonah H. Harris
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

Re: [GENERAL] return next and pl/perl

2005-06-13 Thread Eric E
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

Re: [GENERAL] [INTERFACES] retrieving information about password from MS Access front-end

2005-06-13 Thread Zlatko Matić
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

Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

2005-06-13 Thread Sean Davis
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

Re: [GENERAL] Pb with linked tables on PG8

2005-06-13 Thread Zlatko Matić
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

Re: [GENERAL] Index problem

2005-06-13 Thread Bruno Wolff III
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

Re: [GENERAL] PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps

2005-06-13 Thread Bruno Wolff III
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

Re: [GENERAL] PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps

2005-06-13 Thread Tom Lane
=?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

[GENERAL] Index problem

2005-06-13 Thread David Mitchell
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

[GENERAL] PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps

2005-06-13 Thread Együd Csaba
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

Re: [GENERAL] Index does not working.

2005-06-13 Thread Douglas McNaught
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 > -

Re: [GENERAL] pg_dumpall not working?

2005-06-13 Thread David Siebert
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

Re: [GENERAL] Index does not working.

2005-06-13 Thread Dan Black
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

[GENERAL] Will the optimizer eliminate an unnecessary sort?

2005-06-13 Thread jao
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

Re: [GENERAL] pg_dumpall not working?

2005-06-13 Thread Richard Huxton
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

Re: [GENERAL] pg_dumpall not working?

2005-06-13 Thread Joshua D. Drake
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

Re: [GENERAL] Index does not working.

2005-06-13 Thread Douglas McNaught
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)---

[GENERAL] pg_dumpall not working?

2005-06-13 Thread David Siebert
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

Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

2005-06-13 Thread Jonah H. Harris
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'

[GENERAL] Index does not working.

2005-06-13 Thread Dan Black
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

[GENERAL] psql newby question, help to port Sybase ASA StoredProcedure

2005-06-13 Thread Hugo
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(

[GENERAL] New to Postgre

2005-06-13 Thread Bob Pawley
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

Re: [GENERAL] PostgreSQL Certification

2005-06-13 Thread Chris Browne
[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

[GENERAL] md5 autentication error

2005-06-13 Thread marcelo Cortez
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 __

Re: [GENERAL] duplicate key violates unique constraint

2005-06-13 Thread Richard Huxton
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

Re: [GENERAL] duplicate key violates unique constraint

2005-06-13 Thread Csaba Nagy
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.

Re: [GENERAL] duplicate key violates unique constraint

2005-06-13 Thread Richard Huxton
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

Re: [GENERAL] duplicate key violates unique constraint

2005-06-13 Thread Csaba Nagy
[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

Re: [GENERAL] mirroring oracle database in pgsql

2005-06-13 Thread Scott Marlowe
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

[GENERAL] invalid message length

2005-06-13 Thread marcelo Cortez
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

Re: [GENERAL] duplicate key violates unique constraint

2005-06-13 Thread Richard Huxton
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

Re: [GENERAL] duplicate key violates unique constraint

2005-06-13 Thread Csaba Nagy
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

[GENERAL] LOG: invalid message length

2005-06-13 Thread marcelo Cortez
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é

[GENERAL] duplicate key violates unique constraint

2005-06-13 Thread ON.KG
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

Re: [GENERAL] Case sensitivity

2005-06-13 Thread Howard Cole
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'

Re: [GENERAL] Case sensitivity

2005-06-13 Thread Magnus Hagander
> 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

Re: [GENERAL] Case sensitivity

2005-06-13 Thread Howard Cole
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?

Re: [GENERAL] FATAL: Sorry, too many clients already????

2005-06-13 Thread Richard Huxton
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_