Search Postgresql Archives

Porting Schema from MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Porting Schema from MySQL
From: "Farhan Khan" <farhankhan@xxxxxxxxxx>
Date: Mon, 1 Oct 2007 12:54:29 -0700

Hi ... I am porting a db schema from MySQL to postgresql and having problem in defining a column level constraint...

mtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

gives me problem at ^ON UPDATE ...

Any pointer for implementing this functionality in postgresql ??

Tx .. Farhan

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Porting Schema from MySQL
  - From: Michael Glaesemann

Prev by Date: Re: Find clusters containing a schema?
Next by Date: Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username
Previous by thread: PostgreSQL Conference Fall 2007, final schedule
Next by thread: Re: Porting Schema from MySQL
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux