[GENERAL] Order of Update

Hello List: I'm having an interesting problem. I know what is happening, but I do not know why; therefore, I am hoping that some of those very familiar with the internals can/will explain it to me. I have a function A written in plpgsql which is designed to undo changes to several records.

Re: [GENERAL] Order of Update

Heck, I forgot version information: rnd=# select version(); version -- PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc

[GENERAL] OpenSuse10.0 and postgresql

Hi All,Can somebody please tell me where i can find rpms for postgesql on OpenSuse 10.0?Sincerely,Hrishi

Re: [GENERAL] OpenSuse10.0 and postgresql

On Saturday 18 March 2006 09:15 am, Hrishikesh Deshmukh wrote: Hi All, Can somebody please tell me where i can find rpms for postgesql on OpenSuse 10.0? Sincerely, Hrishi Try this site and enter postgresql. I found rpm's for OpenSuSE . http://rpm.pbone.net/index.php3 -- Adrian Klaver

Re: [GENERAL] Transactions

Kevin Brown wrote: I've been creating a databased application with PostgreSQL for a while now and have loved it, though we just recently stumbled on an interesting bug. I have a particular dialog which can do all kinds of incredibly complicated things to the database. Of course I didn't want

Re: [GENERAL] Transactions

On Saturday 18 March 2006 12:31, Florian G. Pflug wrote: Kevin Brown wrote: I've been creating a databased application with PostgreSQL for a while now and have loved it, though we just recently stumbled on an interesting bug. I have a particular dialog which can do all kinds of

Re: [GENERAL] Transactions

Kevin Brown wrote: On Saturday 18 March 2006 12:31, Florian G. Pflug wrote: I've been creating a databased application with PostgreSQL for a while now and have loved it, though we just recently stumbled on an interesting bug. I have a particular dialog which can do all kinds of incredibly

Re: [GENERAL] Transactions

On Saturday 18 March 2006 12:58, Florian G. Pflug wrote: Kevin Brown wrote: So what you're saying is that my commits and rollbacks should be async, correct? No, you should always use _async(), and never, ever use query() or exec() in a multi-threaded app. I don't quite understand how a

Re: [GENERAL] OpenSuse10.0 and postgresql

Hi All, In downloaded the rpms and installed rpms. Could someone help me what to do next?! The 8.0 documentation talks about installation from source code! Thanks, Hrishi

Re: [GENERAL] OpenSuse10.0 and postgresql

On Saturday 18 March 2006 11:44 am, Hrishikesh Deshmukh wrote: Hi All, In downloaded the rpms and installed rpms. Could someone help me what to do next?! The 8.0 documentation talks about installation from source code! Thanks, Hrishi SuSE puts their documentation for packages under

Re: [GENERAL] OpenSuse10.0 and postgresql

The README doesn't talk about what next to do after installation from rpms, there is no file which talks about in the /usr/share/doc/packages/postgresql . It only says look at INSTALL file but there is no install with the rpms!! Thanks, HrishiOn 3/18/06, Adrian Klaver [EMAIL PROTECTED] wrote: On

[GENERAL] ' and \ characters in passwords

I found that \ characters needs not to be quoted in password strings create role test1 password '\' is OK. I havent found any mention of this behaviour in docs. Where this is documented ? I created role create role test2 password Trying to login using password ' causes error from my

Re: [GENERAL] Clustered PostgreSQL

Jojo Paderes wrote: We're currently using Ubuntu Breezy Hedgehog for our existing PostgreSQL database server (8.0.x). A Java-based applications uses the database server via JDBC. I'm not sure if this question is within the context but I would like to know if clustering can provide a

Re: [GENERAL] ' and \ characters in passwords

Andrus Moor wrote: I found that \ characters needs not to be quoted in password strings create role test1 password '\' is OK. Not sure what client you are using but in psql this fails to find the ending quote, as it should.

Re: [GENERAL] OpenSuse10.0 and postgresql

On Saturday 18 March 2006 01:38 pm, Hrishikesh Deshmukh wrote: The README doesn't talk about what next to do after installation from rpms, there is no file which talks about in the /usr/share/doc/packages/postgresql . It only says look at INSTALL file but there is no install with the rpms!!

Re: [GENERAL] \copy combine with SELECT

Thanks Martijn. \d test Table public.test Column | Type | Modifiers id | integer | score| integer | I tried \copy test (score) to test.txt. It works well. But, suppose I want to select rows with score 20 (just an example). Then,\copy table [ ( column_list ) ] { from |

[GENERAL] Postgresql over ppc4 °

Title: Postgresql over ppc4 ° Hi. Where can i download the postgresql-7.4-3 release for ppc64 ?. What postgresql release is compatible for this kind of arquitecture ?. My server is a pseries p520/power 5/64 bits. Thank's in advance ! Ivan Azuara

[GENERAL] db sever seems to be dropping connections

I'm facing an issue with PostgreSQL .. The server seems to drop the connection to my script after a couple of hours (sometimes, not always). DBD::Pg::db selectrow_array failed: could not receive data from server: :server closed the connection unexpectedly. And in another scenario it

[GENERAL] RE: Postgresql over ppc4 °

Title: RE: Postgresql over ppc4 ° _ De: Ivan Israel Azuara Hernandez Enviado el: Viernes, 17 de Marzo de 2006 09:26 p.m. Para: 'pgsql-general@postgresql.org' CC: Ivan Israel Azuara Hernandez Asunto: Postgresql over ppc4 ° Importancia:

[GENERAL] pg_dump cross-version support

Title: Message Hello! I need to load a pgsql 8.1 database dump (SQL format)into a pgsql 7.3 server (through phpPgAdmin). This does not work, since many v8 instructions are not recognised by v7.3 (e.g. SET default_table_space, function pg_get_serial_sequence,...) which is not unexpected.