id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
3858	Tutorial 1 needs to be updated to reflect changes in 0.96	kashif.razzaqui@…	Jacob	"1. In '''Database setup''', '''DATABASE_ENGINE''' should have the additional option - '''postgresql_psycopg2'''[[BR]]

2. PostgreSQL output when executing command -'''python manage.py sql polls''' is no longer precise, underneath is the output generated in PostgreSQL with psycopg2[[BR]]

{{{
BEGIN;
CREATE TABLE ""polls_poll"" (
    ""id"" serial NOT NULL PRIMARY KEY,
    ""question"" varchar(200) NOT NULL,
    ""pub_date"" timestamp with time zone NOT NULL
);
CREATE TABLE ""polls_choice"" (
    ""id"" serial NOT NULL PRIMARY KEY,
    ""poll_id"" integer NOT NULL REFERENCES ""polls_poll"" (""id"") DEFERRABLE INITIALLY DEFERRED,
    ""choice"" varchar(200) NOT NULL,
    ""votes"" integer NOT NULL
);
COMMIT;

}}}
[[BR]]
3. The command '''python manage.py sqlinitialdata polls''' has been renamed to '''python manage.py sqlcustom polls'''
"		closed	Documentation			fixed	0.96 changes database manage.py sql	dev@…	Ready for checkin	1	0	0	0	0	0