Re: odbc can't edit postgresql database ?? -- Small example

"Geoff Russell" <geoffrey.russell@xxxxxxxxx> · Mon, 12 Mar 2007 15:44:12 +1030

I have a clue to this problem, see below.

On 3/11/07, Geoff Russell <geoffrey.russell@xxxxxxxxx> wrote:
Hi all,

I have postgresql 8.1, unixodbc and openoffice on a Ubuntu 6.06.1
machine and can connect to my postgresql
databases fine --- but can't edit data, only view. pgadmin3 also only
allows viewing
but not editing.

I can insert records with psql.

If I load a dump of my real database, I can edit it. But I can't edit my little
testing database. So I dumped that, reloaded it and bingo I can't edit it.

Here is the dump (minus comments) of the database I can't edit in
open office with odbc/jdbc. To load and
test you will need to change the user name from "geoff" below.

Cheers,
Geoff Russell

---------- start dump
SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

COMMENT ON SCHEMA public IS 'Standard public schema';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
CREATE TABLE sample (
   "key" text,
   data text,
   number integer
);
ALTER TABLE public.sample OWNER TO geoff;
COPY sample ("key", data, number) FROM stdin;
mykey   mydata  2345
my2key  mydata  2345
my2key  mydata  2347
\.
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;

------------ end dump.