[ADMIN] like vs =

issing something? Postgresql: 8.1.1 Fieldtype: text Database encoding: Latin9 Regards, Stefan -- ----- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5709 BayCEER EDV und Datenbanken Universitaet Bayreuth D-95440 Bayreuth -

Re: [ADMIN] like vs =

Tom Lane schrieb: > Stefan Holzheu <[EMAIL PROTECTED]> writes: >>Other queries with the equal operator do match rows. Am I missing something? > >>Postgresql: 8.1.1 >>Fieldtype: text >>Database encoding: Latin9 > > What LC_COLLATE locale are you using?

[ADMIN] plperl does not build on RH7.1

: too few arguments to function `perl_eval_pv' Thanks in advance Stefan -- - Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth - ---(end of b

[ADMIN] plperl does not build on RH7.1

warning: passing arg 2 of `perl_eval_pv' makes pointer from integer without a cast plperl.c:810: too few arguments to function `perl_eval_pv' Thanks in advance Stefan -- - Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/5

[ADMIN] Problems with pg_dump

10 GB. OS is Redhat Linux 7.1. Help appreciated! Stefan -- --------- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth - ---(end of broadcast)---

Re: [ADMIN] Problems with pg_dump

s somehow block the dump process? Normally it should not? The database size is about 10 GB. How big is the particular table? The table has 9 000 000 entries. Stefan -- --------- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Univ

Re: [ADMIN] Problems with pg_dump

to pin down the blame. Well, I never used a packet sniffer but if anyone tells me what to capture, I'd be glad to. PostgreSQL is really a great piece of software, keep on making it even better! Stefan -- - Dr. Stefan Holzheu Tel.:

Re: [ADMIN] Problems with pg_dump

rors. Before using local connection pg_dump failed to about 50%. Anyway, we can live with that solution. But still I'd be curious to know what is the problem with local connections. Is there a way to capture traffic of local socket connections? Stefan -- -

Re: [ADMIN] Problems with pg_dump

occurs on an other machine with different kernel but identical database and postgres version. Regards, Stefan -- - Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-9544

[ADMIN] varchar to text

ago. Unfortunately I couldn't find the thread in the archive. We are running postgres 7.4.1 Regards Stefan -- ----- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Uni

[ADMIN] Servercrash

Stefan -- - Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth - ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Servercrash

ea? Stefan -- - Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth - ---(end of broadcast)--- TIP 7: don't forget to increase

[ADMIN] Bug with plpgsql function after drop column ?

rn next DOES NOT works after recreate of function!! PostgreSQL 8.1.3 Workaround is to drop/recreate the table or (what was easier in our case) dump/restore database. Is it a known known? Regards Stefan Holzheu -- - Dr. Stefan Holzheu Tel

[ADMIN] Transaction-log

rom a nightly dump - a certain state of the database after a user might have done something imprudent. regards Stefan -- - Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bay

Re: [ADMIN] Database Diagrams.

ny. I tried org.sourceforge.jxdbcon.JXDBConDriver and org.postgresql.Driver - no difference. Stefan -- ----- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95