X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1EA54528C6 for ; Thu, 23 Jun 2005 17:03:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28179-08 for ; Thu, 23 Jun 2005 20:03:40 +0000 (GMT) Received: from web11.manitu.net (web11.manitu.net [217.11.48.111]) by svr1.postgresql.org (Postfix) with ESMTP id CF2A752812 for ; Thu, 23 Jun 2005 17:03:36 -0300 (ADT) Received: from tschibtschibojtschitsch (dsl-084-059-066-190.arcor-ip.net [84.59.66.190]) (authenticated) by web11.manitu.net (8.10.2-SOL3/8.10.2) with ESMTP id j5NK3ZV23010 for ; Thu, 23 Jun 2005 22:03:35 +0200 Subject: empty view, replace view, column type change? From: Markus Bertheau To: PgSQL - SQL Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-+E/GAxT8VZjQQL4Vgg0W" Date: Thu, 23 Jun 2005 22:03:29 +0200 Message-Id: <1119557009.7430.16.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.155 tagged_above=0 required=5 tests=AWL, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200506/285 X-Sequence-Number: 21886 --=-+E/GAxT8VZjQQL4Vgg0W Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Hi, it seems to me that the following should work but it fails: CREATE VIEW co AS SELECT LOCALTIMESTAMP::TIMESTAMP AS ov WHERE FALSE; CREATE TABLE link (ov TIMESTAMP); CREATE OR REPLACE VIEW co AS SELECT ov FROM link; Markus --=20 Markus Bertheau --=-+E/GAxT8VZjQQL4Vgg0W Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQBCuxWR2RUnMPztcykRAherAJ4+IUr11VksdILIzjP/bchqVf0MGgCfebQ/ COy65VnjDHtLJE0CcqmBCfI= =PNnG -----END PGP SIGNATURE----- --=-+E/GAxT8VZjQQL4Vgg0W--