RE: [PEAR] Problem with PEAR::MDB
| From: | Xavier Sosnowska | Date: | Fri, 20 Jun 2003 14:58:25 +0000 |
| Subject: | RE: [PEAR] Problem with PEAR::MDB | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-6157@lists.php.net to get a copy of this message | ||
> I assume that you have a problem with your pgsql setup, which means that
> the connect to the database doesnt work. Please ensure that you don't
> get an error returned when you do Manager->connect();
You're absolutely right. All my apologies on that one. It's now working. A
minor question though: is there any reason why the timestamp in the xml
schema is converted into character in postgres. Should it not rather be
timestamp? Is there anything wrong in the way I defined it?
<field>
<name>ses_expire</name>
<type>timestamp</type>
<default>0000-00-00 00:00:00</default>
<notnull>1</notnull>
<description>Time where the session will expire.</description>
</field>
kobzar_webpim=# \d glo_session
Table "public.glo_session"
Column | Type | Modifiers
------------+-----------------------+----------------------------------------
ses_id | character varying(32) | not null default 'x'
ses_expire | character(19) | not null default '0000-00-00 00:00:00'
ses_value | text |
Indexes: ses_ses_exp_idx unique btree (ses_expire),
ses_ses_id_idx unique btree (ses_id)