CREATE OR REPLACE TABLE ...

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема CREATE OR REPLACE TABLE ...
Дата
Msg-id 200302261807.37219.mallah@trade-india.com
обсуждение исходный текст
Ответы Re: CREATE OR REPLACE TABLE ...  (Robert Treat <xzilla@users.sourceforge.net>)
Список pgsql-admin
Has create or replace table been implemented in 7.3 ?
or am i doing somthing silly?


regds
mallah.


[rmallah@system11 rmallah]$ psql
Welcome to psql 7.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

Border style is 2.
Timing is on.
tradein_clients=# SELECT version();
+-----------------------------------------------------------+
|                          version                          |
+-----------------------------------------------------------+
| PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 |
+-----------------------------------------------------------+
(1 row)

Time: 0.92 ms
tradein_clients=# CREATE table t_test (a int );
CREATE TABLE
Time: 17.50 ms
tradein_clients=# CREATE or REPLACE table t_test (a int );
ERROR:  parser: parse error at or near "table" at character 19
tradein_clients=#




Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

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

Предыдущее
От: Daniel Rubio
Дата:
Сообщение: Limiting database size ...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ExclusiveLock and Python