# Logfile created on Sat Nov 20 00:07:06 -0700 2010 by logger.rb/22285 SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1)) SQL (1.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1)) SQL (1.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass... ^ : SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1)) PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (1.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass... ^ : SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass... ^ : SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1)) SQL (1.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass... ^ : SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass... ^ : SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (1.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass... ^ : SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass... ^ : SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1)) SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass... ^ : SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass... ^ : SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (1.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: schema "(SELECT DISTINCT "tariffs"" does not exist LINE 1: SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_... ^ : SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_id" SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (1.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: schema "(SELECT DISTINCT "tariffs"" does not exist LINE 1: SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_... ^ : SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_id" SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE PGError: ERROR: schema "(SELECT DISTINCT "tariffs"" does not exist LINE 1: SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_... ^ : SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_id" SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE TypeError: wrong argument type Arel::SelectManager (expected String): # SQL (1.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (1.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (1.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "i" does not exist LINE 1: SELECT COUNT(DISTINCT i) FROM "products" LEFT OUTER JOIN "pr... ^ : SELECT COUNT(DISTINCT i) FROM "products" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."product_id" = "products"."id" SQL (1.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "tariff_idstart_date" does not exist LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE... ^ : SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date" SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "tariff_idstart_date" does not exist LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE... ^ : SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date" PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (29.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: null value in column "product_id" violates not-null constraint : UPDATE "product_tariffs" SET "product_id" = NULL WHERE "product_tariffs"."product_id" = 1 AND "product_tariffs"."product_id" = 1 AND "product_tariffs"."tariff_id" = 2 AND "product_tariffs"."tariff_start_date" = '2010-11-20' SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (1.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (15.6ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (15.6ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "tariff_idstart_date" does not exist LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE... ^ : SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date" PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (15.6ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "tariff_idstart_date" does not exist LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE... ^ : SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date" PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: null value in column "franchise_id" violates not-null constraint : INSERT INTO "restaurants_suburbs" ("suburb_id", "city_id") VALUES (22, 22) SQL (0.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (1.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (1.0ms) SHOW TIME ZONE PGError: ERROR: column "tariff_idstart_date" does not exist LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE... ^ : SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date" PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "tariff_idstart_date" does not exist LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE... ^ : SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date" PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1)) SQL (0.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "tariff_idstart_date" does not exist LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE... ^ : SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date" PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1)) SQL (35.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (1.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "tariff_idstart_date" does not exist LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE... ^ : SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date" PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1)) SQL (1.0ms) SHOW client_min_messages SQL (0.0ms) SET client_min_messages TO 'panic' SQL (0.0ms) SET standard_conforming_strings = on SQL (0.0ms) SET client_min_messages TO 'notice' SQL (0.0ms) SHOW TIME ZONE PGError: ERROR: column "tariff_idstart_date" does not exist LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE... ^ : SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date" PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1)) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1))