[ADMIN] Bug with plpgsql function after drop column ?

!! 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.: 0921/55-5720 Fax.: 0921/55-5709 BayCEER EDV und Datenbanken

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? Your report looks a whole lot like the recently

[ADMIN] like vs =

: 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 - ---(end of broadcast

Re: [ADMIN] Servercrash

-- - 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 your free space

[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

[ADMIN] varchar to text

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 Universitaet Bayreuth D-95440 Bayreuth

Re: [ADMIN] Problems with pg_dump

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-95440 Bayreuth

Re: [ADMIN] Problems with pg_dump

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 -- - Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK

[ADMIN] Problems with pg_dump

appreciated! Stefan -- - Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth - ---(end of broadcast)--- TIP 3: if posting

Re: [ADMIN] Problems with pg_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 Universitaet Bayreuth D-95440 Bayreuth

Re: [ADMIN] Problems with pg_dump

be glad to. PostgreSQL is really a great piece of software, keep on making it even better! Stefan -- - Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth

[ADMIN] plperl does not build on RH7.1

Stefan -- - Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth - ---(end of broadcast)--- TIP 3: if posting/reading through

[ADMIN] plperl does not build on RH7.1

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/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth

Re: [ADMIN] Database Diagrams.

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-95440 Bayreuth

[ADMIN] Transaction-log

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 Bayreuth