Thread: PostgreSQL + PHP + SQL warning messages
Hi!
Is there any way to get the equivalent sqlca.sqlcode value of informix in PostgreSQL from php ?
I would like to use the sqlcode to print the messages in Spanish.
Thanks in advance
-- Evelio Martínez Testanet. Dept. desarrollo software. Av. Reino de Valencia, 15 - 5 46005 Valencia (Spain) Tel: +34 96 395 90 00 Fax: +34 96 316 23 19
El Jue 25 Ene 2001 16:36, Evelio Martinez escribió: > Hi! > > Is there any way to get the equivalent sqlca.sqlcode value of informix > in PostgreSQL from php ? > > I would like to use the sqlcode to print the messages in Spanish. The problem is that informix puts in an array (sort of) all the info about the last query. What sort of information would you like? Last insert? You have an pg_getlastoid() function. Hope it helps. Saludos...:-) -- System Administration: It's a dirty job, but someone told I had to do it. ----------------------------------------------------------------- Martín Marqués email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------
Does anyone know how many tables I can have in One database. I am using postgreSQL for a massive listserver database that has 16,000+ list and will have over 160,000 tables. Mark
I think there is something seriously wrong with your database design. Are you creating 10 tables for each list? Why? \Flemming At 01:44 PM 1/25/2001 -0700, you wrote: >Does anyone know how many tables I can have in One database. I am using >postgreSQL for a massive listserver database that has 16,000+ list and will >have over 160,000 tables. > >Mark