QGIS » QGIS Application

This is changed in 44339a85 (SVN r5510) to take DEFAULT as default value for the postgres provider instead of NULL. Unfortunately, i don't have a database with default values to test. Could you test it with your database and close the bug if it works?

It works - great improvement. To be really perfect, default values should show up in the dable during digitizing, otherwise the user has no way of kwowing which values will be filled automatically.

after commit #5694 (fix for bugs 131 and 134), default fields are no longer shown

Further testing: the default values are actually committed (which is good), they're just not shown in the dialog window (which is not good, as the user cannot know which values should be filled).

Works for me. What is the definition of your table?

CREATE TABLE fix (
cat integer DEFAULT nextval('cat_fix'::regclass) NOT NULL,
id_radio smallint,
data date,
ora time without time zone,
meteo character varying(2),
vento smallint,
terreno character varying(1),
zona character varying(2),
attivita boolean,
ambiente character varying,
visto boolean,
note text,
verificato_db boolean,
cova boolean DEFAULT false,
morto boolean DEFAULT false,
schiusa boolean DEFAULT false,
operatore character varying,
anno smallint DEFAULT 2006,
the_geom public.geometry,
nido boolean DEFAULT false);
);

That table definition works for me - see attachment. What version of postgres are you using? I can't think of much else that could be causing the problem.

Replying to [comment:16 hdus]:

Replying to [comment:15 jef]:

fixed in

mmm....

For me it does not work.

mmmm..... For me it does. I tested with following table:

CREATE TABLE test (
    myid integer NOT NULL,
    wkb_geometry geometry,
    mytext character varying DEFAULT 'Foo!'::character varying,
    mynr integer,
    mydate date DEFAULT now()
);

and the attribute dialog looks like the attached image and works as expected. What's different in your case?

Replying to [comment:17 jef]:

Replying to [comment:16 hdus]:

Replying to [comment:15 jef]:

fixed in

mmm....

For me it does not work.

mmmm..... For me it does. I tested with following table:

> CREATE TABLE test (
>     myid integer NOT NULL,
>     wkb_geometry geometry,
>     mytext character varying DEFAULT 'Foo!'::character varying,
>     mynr integer,
>     mydate date DEFAULT now()
> );

and the attribute dialog looks like the attached image and works as expected. What's different in your case?

I create your table and than I try to capture a polygon. See the attached image as the result. I doesn't work for me.

I just installed QGIS 0.10.0 Windows and I don't get default values too.

Replying to [comment:20 mhugent]:

If it works or not seems to depend on the Qt version. The last try is 7af5433f (SVN r8436). It did not work for me with Qt-4.3.4 and after the commit it works also with this version. Reopen this patch if you still have problems after 7af5433f (SVN r8436).

Ok, looks like I tried with Qt 4.4 on Debian unstable only. 7af5433f (SVN r8436) doesn't work there. But given this hint, I found that <commit:7af5433f (SVN r8436) didn't work on Windows using Qt 4.3.4 (MSVC build).

e6b0e02e (SVN r8437) now works on both.

Milestone Version 0.9.2 deleted