[PHP-DB] Postgres Trigger

Hi! Does any one know the way to execute a Postgres trigger every day? I mean, the event for the trigger execution must be a moment in time. Thank's Norma Ramirez -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Grant Privileges on Postgres

a password parameter to it bastien From: Norma Ramirez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Grant Privileges on Postgres Date: Tue, 21 Sep 2004 16:32:41 -0500 Hi all, I run this instruction on Postgres psql tool: grant all privileges on database test to newuser; The goal

[PHP-DB] Grant Privileges on Postgres

Hi all, I run this instruction on Postgres psql tool: grant all privileges on database test to newuser; The goal is to give all privileges to newuser(user that is not a superuser) on test, the owner is postgres but I need to give this other user privileges. The problem is, after run this

[PHP-DB] Postgresql Performance

Hi all, I have a problem with a small software in Postresql, through the time the database become slower and slower so, quick solution: pg_dump, dropdb, createdb and pg_dump again but this software is becoming important and such procedure is not a very reliable way to improve the performance, I

[PHP-DB] Lock Record on Postgresql

I need to lock a record in a postgresql table, how can I send the lock query in a script and after in other script send the unlock instruction? Is this possible? Thanks Norma R -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Lock Record on Postgresql

, currently I'm doing this by code but like to do by Postgres directly. Thanks in advance. - Original Message - From: Robby Russell [EMAIL PROTECTED] To: Norma Ramirez [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, August 13, 2004 10:07 AM Subject: Re: [PHP-DB] Lock Record

Re: [PHP-DB] Lock Record on Postgresql

Torsten: Thank's a lot, I think I get it! Hi Norma, you can achieve this in a much more comfortable and elegant way: Create an integer column named oca (stands for Optimistic Concurrency Control Attribute). When you load the data to show them in the editing form store the value in a hidden

[PHP-DB] Excel Formulas

Hi all, I need to integrate an aplication runing under Linux and postgresql with Excel formulas, I mean while I insert records in a table, for some of that records I need to calculate values using a Formula from excel, does any one know if that's posible, call any kind of function in excel for

Re: [PHP-DB] export queries to plain/text

What I need exactly is to send the outputs from queries made in the command line of postgresql to an plain text file, cvs or something like that, so the function suggested frwrite don't work for that case because it's from the command line. Than'ks Norma R -- PHP Database Mailing List

[PHP-DB] export queries to plain/text

Hi all, does any one know how to export queries to plain/text files in postgresql? Thank's Norma R

[PHP-DB] Remove log files in Postgres

Hi all, does any one know a configuration parameter or command line that automatically remove in a period of time the log files in postresql database? Thanks a lot. Norma Ramirez

[PHP-DB] Free PHP Editor

version.Thanks for answer my question, it helps me a lot. =) Norma Ramirez

[PHP-DB] Store images in postgres database

varchar(50), filetype varchar(50)), description varchar(50); how can I store images from my php form on postgres? Regards, Norma Ramirez

[PHP-DB] Free php editor!!

Hi, does any one know if exist a free php editor like DreamWeaver? =) I know DreamW it´s too much than an editor with all of the duties... but I need something free... Thank´s Norma Ramirez

Re: [PHP-DB] Bar codes in PHP

Later on librarians are using the bar code scanner, which will pick up the unique id and look up in the database for further processing. Hardik this part it´s exactly what I want to know, how by using a php form, read or pick up as you say, the bar code and make an input to the database or

[PHP-DB] Bar codes in PHP

Hi all, does someone know how to capture or read bar codes from php? It will be great if I could do inputs to my database directly from bar codes in the products. Ideas??? Thank´s Norma Ramirez Area de Desarrollo Web [EMAIL PROTECTED]

Re: [PHP-DB] Bar codes in PHP

Thank´s Brad, that sounds simple, I gonna try and later I´ll tell the results. =) Norma Ramirez Area de Desarrollo Web -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] change datatype in postgres

Thank´s Xaos, help´s a lot. = Regards, Norma R -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] change datatype in postgres

Thank´s Xaos, but I have a inocent question ¿why on earth can`t do with a simple alter table like other databases??? and, o.k drop the old column buy copy the data into a new one? how? with an update query? Thank´s again and sorry if bother =) -- PHP Database Mailing List

[PHP-DB] export mysql table to .dbf

Hi all, does any one how export data from mysql to fox 2.0? I have to capture data from a php form and store in mysql database, and then export those data or generate a .dbf table. Thank´s a lot. Norma Ramirez

Re: [PHP-DB] export mysql table to .dbf

Thank´s Stephen, I gonna try it looks very useful... Norma Ramirez -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PDF Implementation

Check out this page:http://www.ros.co.nz/pdf/, is a useful class and you can implement with any kind of database. Norma Ramirez Area de Desarrollo Web [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 9:01 AM Subject: [PHP

Re: [PHP-DB] Delete constraint

Thank´s a lot Pascal, it works just fine and all those links have very useful information. =) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Delete constraint

Hi all, coul I delete a constraint made over a postgresql table? (In the parent table). The child doesn`t have records. By the way, does any one know a good postgresql administrator like mysqladmin?? Thank´s Norma Ramirez

[PHP-DB] ODBC conection with DB2

. I´get this error: odbcinst: iniOpen failed on /unixodbcregistration. Could someone help??? Thank´s. Norma Ramirez

[PHP-DB] Get last id in postgresql

into test(name) values('myname'); $test = pg_exec($insert); echo $id = pg_last_oid($test); Norma Ramirez [EMAIL PROTECTED]