SERIAL type in PHP

Поиск
Список
Период
Сортировка
От Dmitry A Brutckevich
Тема SERIAL type in PHP
Дата
Msg-id 37DE12B5.D7B3A714@mail.ru
обсуждение исходный текст
Список pgsql-interfaces
Hi All !


I am get a some problem :

When i write in  php
<?php
$dbase=pg_connect("host=somehost.domain.ru user=$login  password=$pass
port=5432 dbname=maindb");
$result=pg_Exec($dbase, "  CREATE table users (userid serial) ");
?>
my brower ( and log on server ) write to me :

Warning: PostgresSQL query failed: pqReadData() -- backend closed the
channel unexpectedly. This probably means the backend terminated
abnormally before or while processing the request. in
/usr/local/rubin/system/generating.phtml on line 134

I am rewrite:

$dbase=pg_connect("host=somehost.domain.ru user=$login  password=$pass
port=5432 dbname=maindb");
$result=pg_Exec($dbase, "  CREATE SEQUENCE users_userid_seq ");
$result=pg_Exec($dbase, " CREATE TABLE users ( userid INT4 DEFAULT
nextval('users_userid_seq')) ");
$result=pg_Exec($dbase, " CREATE UNIQUE INDEX users_userid_key on users
(userid) " );

And all work properly. No warnings.

Where is problem ?

Dmitry




В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Andreas Theofilu
Дата:
Сообщение: Found error with apostrophes in ecpg
Следующее
От: Nuchanach Klinjun
Дата:
Сообщение: ODBC