BD_DataObject PogreSQL Sequence
| From: | Muhyiddin A.M Hayat | Date: | Wed, 29 Dec 2004 04:05:56 +0000 |
| Subject: | BD_DataObject PogreSQL Sequence | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-16492@lists.php.net to get a copy of this message | ||
Dear all
I have problem with Sequence on PostgreSQL.
I have created below table:
CREATE TABLE "public"."news" (
"id" SERIAL,
"title" VARCHAR(64) NOT NULL,
"intro_text" TEXT,
"full_text" TEXT,
"picture" BYTEA,
"created" TIMESTAMP(0) WITH TIME ZONE DEFAULT ('now'::text)::timestamp(6) with
time zone,
"created_by" INTEGER,
"publish_up" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT
('now'::text)::timestamp(6) with time zone,
"publish_down" TIMESTAMP(0) WITHOUT TIME ZONE,
CONSTRAINT "news_pkey" PRIMARY KEY("id")
) WITH OIDS;
Table "public.news"
Column | Type | Modifiers
--------------+--------------------------------+------------------------------------------------------
id | integer | not null default
nextval('public.news_id_seq'::text)
title | character varying(64) | not null
intro_text | text |
full_text | text |
picture | bytea |
created | timestamp(0) with time zone | default ('now'::text)::timestam
p(6) with time zone
created_by | integer |
publish_up | timestamp(0) without time zone | default ('now'::text)::timestamp(6) with
time zone
publish_down | timestamp(0) without time zone |
Indexes: news_pkey primary key btree (id)
the Sequence created is news_id_seq. when i using DB_DataObject, DB_DataObject doen't use
news_id_seq, but DB_DataObject created news_seq and using them.
How to swich to default Sequence (news_id_seq)