sqlobject-discuss

Re: [SQLObject] Postgres: DROP table CASCADE

[Justin A. <JA...@ua...>]

On Mon, 2004-11-29 at 11:55, Oleg Broytmann wrote:
>    AFAII Postgres does not support CASCADE. Exactly opposite - it is
> MySQL who supports it... to some extent. MySQL silently ignores CASCADE.
> But Postgres actively opposes it.

it doesn't ?
http://www.postgresql.org/docs/7.4/static/sql-droptable.html

Synopsis
DROP TABLE name [, ...] [ CASCADE | RESTRICT ]

-- 
-- Justin Azoff
-- Network Performance Analyst

Re: [SQLObject] Postgres: DROP table CASCADE

[Oleg B. <ph...@ma...>]

On Mon, Nov 29, 2004 at 12:04:26PM -0500, Justin Azoff wrote:
> On Mon, 2004-11-29 at 11:55, Oleg Broytmann wrote:
> >    AFAII Postgres does not support CASCADE. Exactly opposite - it is
> > MySQL who supports it... to some extent. MySQL silently ignores CASCADE.
> > But Postgres actively opposes it.
> 
> it doesn't ?
> http://www.postgresql.org/docs/7.4/static/sql-droptable.html
> 
> Synopsis
> DROP TABLE name [, ...] [ CASCADE | RESTRICT ]

   I use 7.2:

Synopsis

 DROP TABLE name [, ...]

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.