Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL

2003-12-02 Thread scott.marlowe
On Tue, 2 Dec 2003, Jan Wieck wrote: scott.marlowe wrote: On Mon, 1 Dec 2003, Jan Wieck wrote: Jason Tesser wrote: Quoted as gospel by various people: MySQL cannot even handle sub-queries yet. BTW, is that really still true? I thought they had at least some support

Re: [GENERAL] Feature Request for 7.5

2003-12-02 Thread Scott Ribe
I have been looking into how to ensure that synchronous replication, etc. could best be implimented. To date, I see only two options: incorporate the replication code into the database backend or have a separate proxy which handles the replication. There are many problems with a proxy

Re: [GENERAL] perl(Pg) (S)RPM

2003-12-02 Thread Roderick A. Anderson
On Tue, 2 Dec 2003, Lamar Owen wrote: Because Pg is no longer distributed as a part of the main tarball, but a contrib is being distributed that requires it. This is an issue with the main tarball, not with the RPM packaging, IMO. Someone needs to step up to the plate and build a Pg RPM

Re: [GENERAL] Error in select

2003-12-02 Thread Tom Lane
Carmen Gloria Sepulveda Dedes [EMAIL PROTECTED] writes: I get: ERROR: variable not found in subplan target list Could we have enough context to reproduce the problem? I don't have time to guess at your table definitions ... regards, tom lane

Re: [GENERAL] bytea - text

2003-12-02 Thread Tom Lane
Baldur Norddahl [EMAIL PROTECTED] writes: Seems like like knows how to convert bytea to text, No, it doesn't. The reason that works is there's a LIKE operator for bytea (try \do ~~ in psql). regards, tom lane ---(end of

Re: [GENERAL] embedded postgresql + C++ IDE

2003-12-02 Thread jini us
Thanks for all the answers. It seems if I wish to make my idea into reality I will have to invest in the Profesional Microsoft Visual C++ studio. Having said that if anyone can help me with a cheap copy of the developer studio which you do not want and want to sell it to me very very cheap. I

Re: [GENERAL] embedded postgresql + C++ IDE

2003-12-02 Thread jini us
Thanks for all the answers. It seems if I wish to make my idea into reality I will have to invest in the Profesional Microsoft Visual C++ studio. Having said that if anyone can help me with a cheap copy of the developer studio which you do not want and want to sell it to me very very cheap. I

[GENERAL] DBD::Pg problem

2003-12-02 Thread Ausrack Webmaster
Hi I am trying to insert a simple email address into a text field, and I get the below error: DBD::Pg::st execute failed: ERROR: pg_atoi: error in [EMAIL PROTECTED]: can't parse [EMAIL PROTECTED] I figure it is because of the and @ in the value, but why does it take these as operators even

Re: [GENERAL] DBD::Pg problem

2003-12-02 Thread Martijn van Oosterhout
pg_atoi is the string to int converter. You're trying to insert it into an integer field. On Wed, Dec 03, 2003 at 03:45:53PM +0900, Ausrack Webmaster wrote: Hi I am trying to insert a simple email address into a text field, and I get the below error: DBD::Pg::st execute failed: ERROR: