From: | "Patrick Hatcher" <PHatcher(at)macys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Prefix operator error to type OID? |
Date: | 2004-03-12 01:02:39 |
Message-ID: | OF285C91DD.FBBEC383-ON88256E55.0003A1D8-88256E55.0006666B@fds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm not sure this is a PgAdminIII error or a Pg 7.3.5 error
I've created the following table:
CREATE TABLE public.prod_manager
(
mgmid varchar(6) NOT NULL,
mgmname varchar(35),
email varchar(50) NOT NULL,
CONSTRAINT prdmg_pk PRIMARY KEY (mgmid)
) WITHOUT OIDS;
with the following data
insert into prod_manager values ('000001', 'Tiny Tim', 's(at)s(dot)com');
insert into prod_manager values ('000002', 'Med Tim', 'o(at)s(dot)com');
insert into prod_manager values ('000003', 'Large Tim', 'p(at)s(dot)com');
If I try to view the data directly from PgAdminII using the grid, I get an
error message:
Unable to identify a prefix operator '-' for type 'oid' You may need to
add parentheses or an explicit cast.
The data will then show. However, if I try to update any data within the
grid, I get the same error as the above. Everything works fine if I try to
SELECT, UPDATE, or DELETE.
Any ideas?
Patrick Hatcher
Macys.Com
From | Date | Subject | |
---|---|---|---|
Next Message | dewins murillo | 2004-03-12 01:56:04 | Postgresql Oculto en Aplicacion Bajo Windows. Hide under a Windows App |
Previous Message | Jerry LeVan | 2004-03-11 20:38:44 | ANN: BiggerSQL-.12.2 a Mac Postgresql Browser/Editor |