On Sat, 22 Jul 2006 05:19:14 -0400
Jan Wieck <[EMAIL PROTECTED]> wrote:
> Please get me the output of the following two queries for any table
> where this still occurs:
Attached..
> as well as a full schema description of the table, including primary
> keys, unique and not null constraints.
I have attached the output of 'pg_dump -s -t User laterooms' - is this all that
is required?
The Booking table is probably more important, but I am interested to hear your
views on the data from the User table - hopefully then I'll be able to learn
and apply the same technique to the Booking table.
In fact, given that I've dropped Booking from replication, it might even be
likely that it 'fixes itself' when I add a new temporary set, then merge back
into set 1.
> The only way I could imagine how slony got into that stage is that you
> have executed DDL like ALTER TABLE DROP COPUMN directly while the table
> was replicated (directly meaning not done via EXECUTE SCRIPT). Doing so
> would get the key attributes out of sync with respect to their position
> within all non-attisdroped columns.
Interesting, it's entirely possible, but the thing that doesn't make sense is
why this only started happening at 4am this morning, just after the nightly
backups + vacuum :)
Cheers,
Gavin.
attname | attnum
-------------------------+--------
tableoid | -7
cmax | -6
xmax | -5
cmin | -4
xmin | -3
oid | -2
ctid | -1
ID | 1
Email | 2
Gender | 3
LanguageID | 4
SiteLanguageID | 5
CurrencyID | 6
Forename | 7
Surname | 8
Title | 9
Address1 | 10
Address2 | 11
Address3 | 12
City | 13
Postcode | 14
Password | 15
Mobile | 16
Tel | 17
DOB | 18
DateCreated | 19
CurrentlySubscribed | 20
LastCampaignSent | 21
MemorableQuestion | 22
MemorableQuestionAnswer | 23
CountryID | 24
RequestCount | 25
UserName | 26
ContactEmail | 27
TelephoneSTD | 28
CompanyName | 29
BusinessAddress | 30
MyLateRoomsActive | 31
MyRewards | 32
DisplayThumbs | 33
DisplayNumberRooms | 34
DisplayShortList | 35
DisplayDistance | 36
AgeCategoryID | 37
BusinessLeisure | 38
PDAOwner | 39
CompletedMyPreferences | 40
ChildrenUnder16 | 41
DisplayTown | 42
(49 rows)
--
-- PostgreSQL database dump
--
SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = true;
--
-- Name: User; Type: TABLE; Schema: public; Owner: nik; Tablespace:
--
CREATE TABLE "User" (
"ID" integer DEFAULT nextval(('public.user_id_seq'::text)::regclass) NOT
NULL,
"Email" character varying(255) DEFAULT ''::character varying NOT NULL,
"Gender" character(1) DEFAULT 'M'::bpchar,
"LanguageID" integer DEFAULT -1,
"SiteLanguageID" integer DEFAULT -1,
"CurrencyID" character varying(3) DEFAULT 'GBP'::character varying,
"Forename" character varying(30) DEFAULT ''::character varying,
"Surname" character varying(30) DEFAULT ''::character varying,
"Title" character varying(6) DEFAULT 'Mr'::character varying,
"Address1" character varying(80) DEFAULT ''::character varying,
"Address2" character varying(80) DEFAULT ''::character varying,
"Address3" character varying(80),
"City" character varying(30),
"Postcode" character varying(10) DEFAULT ''::character varying,
"Password" character varying(32),
"Mobile" character varying(20) DEFAULT ''::character varying,
"Tel" character varying(20) DEFAULT ''::character varying,
"DOB" date DEFAULT '1970-01-01'::date,
"DateCreated" date DEFAULT (now())::date,
"CurrentlySubscribed" boolean DEFAULT false,
"LastCampaignSent" integer,
"MemorableQuestion" character varying(100),
"MemorableQuestionAnswer" character varying(100),
"CountryID" integer,
"RequestCount" integer DEFAULT 0 NOT NULL,
"UserName" character varying(255) DEFAULT ''::character varying NOT NULL,
"ContactEmail" character varying(255) DEFAULT ''::character varying,
"TelephoneSTD" character varying(10),
"CompanyName" character varying(150),
"BusinessAddress" boolean DEFAULT false NOT NULL,
"MyLateRoomsActive" boolean,
"MyRewards" boolean DEFAULT false,
"DisplayThumbs" boolean DEFAULT false,
"DisplayNumberRooms" boolean DEFAULT false,
"DisplayShortList" boolean DEFAULT false,
"DisplayDistance" boolean DEFAULT false,
"AgeCategoryID" integer,
"BusinessLeisure" character(1),
"PDAOwner" boolean,
"CompletedMyPreferences" boolean DEFAULT false,
"ChildrenUnder16" boolean DEFAULT false,
"DisplayTown" boolean DEFAULT true
);
ALTER TABLE public."User" OWNER TO nik;
--
-- Name: COLUMN "User"."BusinessLeisure"; Type: COMMENT; Schema: public; Owner:
nik
--
COMMENT ON COLUMN "User"."BusinessLeisure" IS 'This is added through My
Preferences. NULL = neither, b = Business, l = Leisure.';
--
-- Name: customer_pkey; Type: CONSTRAINT; Schema: public; Owner: nik;
Tablespace:
--
ALTER TABLE ONLY "User"
ADD CONSTRAINT customer_pkey PRIMARY KEY ("ID");
--
-- Name: fki_customer_areaid_m2o; Type: INDEX; Schema: public; Owner: nik;
Tablespace:
--
CREATE INDEX fki_customer_areaid_m2o ON "User" USING btree ("CountryID");
--
-- Name: fki_customer_cityid_m2o_s; Type: INDEX; Schema: public; Owner: nik;
Tablespace:
--
CREATE INDEX fki_customer_cityid_m2o_s ON "User" USING btree ("City");
--
-- Name: fki_customer_currencyid_m2o_s; Type: INDEX; Schema: public; Owner:
nik; Tablespace:
--
CREATE INDEX fki_customer_currencyid_m2o_s ON "User" USING btree ("CurrencyID");
--
-- Name: fki_customer_languageid_m2o_s; Type: INDEX; Schema: public; Owner:
nik; Tablespace:
--
CREATE INDEX fki_customer_languageid_m2o_s ON "User" USING btree ("LanguageID");
--
-- Name: fki_customer_sitelanguge_id_m2o; Type: INDEX; Schema: public; Owner:
nik; Tablespace:
--
CREATE INDEX fki_customer_sitelanguge_id_m2o ON "User" USING btree
("SiteLanguageID");
--
-- Name: fki_user_countryid; Type: INDEX; Schema: public; Owner: nik;
Tablespace:
--
CREATE INDEX fki_user_countryid ON "User" USING btree ("CountryID");
--
-- Name: ix_user_email; Type: INDEX; Schema: public; Owner: nik; Tablespace:
--
CREATE INDEX ix_user_email ON "User" USING btree ("Email");
--
-- Name: ix_username; Type: INDEX; Schema: public; Owner: nik; Tablespace:
--
CREATE INDEX ix_username ON "User" USING btree ("UserName");
--
-- Name: _replication_logtrigger_80; Type: TRIGGER; Schema: public; Owner: nik
--
CREATE TRIGGER _replication_logtrigger_80
AFTER INSERT OR DELETE OR UPDATE ON "User"
FOR EACH ROW
EXECUTE PROCEDURE _replication.logtrigger('_replication', '80',
'kvvvvvvvvvvvvvvvvvvvvvvvvvv');
--
-- Name: customer_currencyid_m2o; Type: FK CONSTRAINT; Schema: public; Owner:
nik
--
ALTER TABLE ONLY "User"
ADD CONSTRAINT customer_currencyid_m2o FOREIGN KEY ("CurrencyID")
REFERENCES "Currency"("ID") ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: customer_languageid_m2o; Type: FK CONSTRAINT; Schema: public; Owner:
nik
--
ALTER TABLE ONLY "User"
ADD CONSTRAINT customer_languageid_m2o FOREIGN KEY ("LanguageID")
REFERENCES "Language"("ID") ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: customer_sitelanguge_id_m2o; Type: FK CONSTRAINT; Schema: public;
Owner: nik
--
ALTER TABLE ONLY "User"
ADD CONSTRAINT customer_sitelanguge_id_m2o FOREIGN KEY ("SiteLanguageID")
REFERENCES "Language"("ID") ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: user_agecategoryid; Type: FK CONSTRAINT; Schema: public; Owner: nik
--
ALTER TABLE ONLY "User"
ADD CONSTRAINT user_agecategoryid FOREIGN KEY ("AgeCategoryID") REFERENCES
"AgeCategory"("ID") ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- Name: user_countryid; Type: FK CONSTRAINT; Schema: public; Owner: nik
--
ALTER TABLE ONLY "User"
ADD CONSTRAINT user_countryid FOREIGN KEY ("CountryID") REFERENCES
"Area"("ID");
--
-- PostgreSQL database dump complete
--
tgrelid | tgname | tgfoid | tgtype | tgenabled |
tgisconstraint | tgconstrname | tgconstrrelid |
tgdeferrable | tginitdeferred | tgnargs | tgattr |
tgargs
----------+--------------------------------+----------+--------+-----------+----------------+------------------------------------+---------------+--------------+----------------+---------+--------+------------------------------------------------------------------------------------------------------------
32312048 | RI_ConstraintTrigger_108277194 | 1648 | 9 | t | t
| noavailability_staffid | 108277175 | f
| f | 6 | |
noavailability_staffid\000NoAvailability\000User\000UNSPECIFIED\000StaffID\000ID\000
32312048 | RI_ConstraintTrigger_108277196 | 1649 | 17 | t | t
| noavailability_staffid | 108277175 | f
| f | 6 | |
noavailability_staffid\000NoAvailability\000User\000UNSPECIFIED\000StaffID\000ID\000
32312048 | RI_ConstraintTrigger_108201445 | 1648 | 9 | t | t
| booking_bookerid | 32311664 | f
| f | 6 | |
booking_bookerid\000Booking\000User\000UNSPECIFIED\000BookerID\000ID\000
32312048 | RI_ConstraintTrigger_108201446 | 1649 | 17 | t | t
| booking_bookerid | 32311664 | f
| f | 6 | |
booking_bookerid\000Booking\000User\000UNSPECIFIED\000BookerID\000ID\000
32312048 | RI_ConstraintTrigger_108210746 | 1648 | 9 | t | t
| bookingpark_staffid | 108210731 | f
| f | 6 | |
bookingpark_staffid\000BookingPark\000User\000UNSPECIFIED\000StaffID\000ID\000
32312048 | RI_ConstraintTrigger_108210749 | 1649 | 17 | t | t
| bookingpark_staffid | 108210731 | f
| f | 6 | |
bookingpark_staffid\000BookingPark\000User\000UNSPECIFIED\000StaffID\000ID\000
32312048 | RI_ConstraintTrigger_108210753 | 1648 | 9 | t | t
| bookingpark_bookerid | 108210731 | f
| f | 6 | |
bookingpark_bookerid\000BookingPark\000User\000UNSPECIFIED\000BookerID\000ID\000
32312048 | RI_ConstraintTrigger_108210754 | 1649 | 17 | t | t
| bookingpark_bookerid | 108210731 | f
| f | 6 | |
bookingpark_bookerid\000BookingPark\000User\000UNSPECIFIED\000BookerID\000ID\000
32312048 | _replication_logtrigger_80 | 40509349 | 29 | t | f
| | 0 | f
| f | 3 | |
_replication\00080\000kvvvvvvvvvvvvvvvvvvvvvvvvvv\000
32312048 | RI_ConstraintTrigger_32312905 | 1648 | 9 | t | t
| elementcustomer_customerid_m2o_s | 32311755 | f
| f | 6 | |
elementcustomer_customerid_m2o_s\000ElementUser\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312906 | 1649 | 17 | t | t
| elementcustomer_customerid_m2o_s | 32311755 | f
| f | 6 | |
elementcustomer_customerid_m2o_s\000ElementUser\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312915 | 1648 | 9 | t | t
| emaillist_user_s | 32311761 | f
| f | 6 | |
emaillist_user_s\000EmailList\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312916 | 1649 | 17 | t | t
| emaillist_user_s | 32311761 | f
| f | 6 | |
emaillist_user_s\000EmailList\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312935 | 1648 | 9 | t | t
| enquiry_userid | 32311769 | f
| f | 6 | |
enquiry_userid\000Enquiry\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312936 | 1649 | 17 | t | t
| enquiry_userid | 32311769 | f
| f | 6 | |
enquiry_userid\000Enquiry\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312945 | 1648 | 9 | t | t
| enquirypark_staffid | 32311778 | f
| f | 6 | |
enquirypark_staffid\000EnquiryPark\000User\000UNSPECIFIED\000StaffID\000ID\000
32312048 | RI_ConstraintTrigger_32312946 | 1649 | 17 | t | t
| enquirypark_staffid | 32311778 | f
| f | 6 | |
enquirypark_staffid\000EnquiryPark\000User\000UNSPECIFIED\000StaffID\000ID\000
32312048 | RI_ConstraintTrigger_32312980 | 1654 | 9 | t | t
| hits_userid | 32311804 | f
| f | 6 | |
hits_userid\000Hits\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312981 | 1655 | 17 | t | t
| hits_userid | 32311804 | f
| f | 6 | |
hits_userid\000Hits\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32313185 | 1648 | 9 | t | t
| journal_customerid_m2o_s | 32311930 | f
| f | 6 | |
journal_customerid_m2o_s\000Journal\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32313186 | 1649 | 17 | t | t
| journal_customerid_m2o_s | 32311930 | f
| f | 6 | |
journal_customerid_m2o_s\000Journal\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32313250 | 1648 | 9 | t | t
| partner_userid_s | 32311965 | f
| f | 6 | |
partner_userid_s\000Partner\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32313251 | 1649 | 17 | t | t
| partner_userid_s | 32311965 | f
| f | 6 | |
partner_userid_s\000Partner\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312735 | 1648 | 9 | t | t
| accessroles_userid_m | 32311625 | f
| f | 6 | |
accessroles_userid_m\000AccessRoles\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32313335 | 1648 | 9 | t | t
| savedsearch_customerid_m2o_s | 32312033 | f
| f | 6 | |
savedsearch_customerid_m2o_s\000SavedSearch\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32313336 | 1649 | 17 | t | t
| savedsearch_customerid_m2o_s | 32312033 | f
| f | 6 | |
savedsearch_customerid_m2o_s\000SavedSearch\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32313375 | 1648 | 9 | t | t
| userotherinformation_userid_s | 32312073 | f
| f | 6 | |
userotherinformation_userid_s\000UserOtherInformation\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32313376 | 1649 | 17 | t | t
| userotherinformation_userid_s | 32312073 | f
| f | 6 | |
userotherinformation_userid_s\000UserOtherInformation\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32313385 | 1654 | 9 | t | t
| userurlsegment_userid | 32312076 | f
| f | 6 | |
userurlsegment_userid\000UserUrlSegment\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32313386 | 1655 | 17 | t | t
| userurlsegment_userid | 32312076 | f
| f | 6 | |
userurlsegment_userid\000UserUrlSegment\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312736 | 1649 | 17 | t | t
| accessroles_userid_m | 32311625 | f
| f | 6 | |
accessroles_userid_m\000AccessRoles\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312810 | 1648 | 9 | t | t
| booking_staffid | 32311664 | f
| f | 6 | |
booking_staffid\000Booking\000User\000UNSPECIFIED\000StaffID\000ID\000
32312048 | RI_ConstraintTrigger_32312811 | 1649 | 17 | t | t
| booking_staffid | 32311664 | f
| f | 6 | |
booking_staffid\000Booking\000User\000UNSPECIFIED\000StaffID\000ID\000
32312048 | RI_ConstraintTrigger_32312815 | 1654 | 9 | t | t
| booking_userid | 32311664 | f
| f | 6 | |
booking_userid\000Booking\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312816 | 1655 | 17 | t | t
| booking_userid | 32311664 | f
| f | 6 | |
booking_userid\000Booking\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312860 | 1648 | 9 | t | t
| campaigncustomer_customerid_m2o_s | 32311716 | f
| f | 6 | |
campaigncustomer_customerid_m2o_s\000CampaignUser\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312861 | 1649 | 17 | t | t
| campaigncustomer_customerid_m2o_s | 32311716 | f
| f | 6 | |
campaigncustomer_customerid_m2o_s\000CampaignUser\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_32312883 | 1644 | 5 | t | t
| customer_currencyid_m2o | 32311734 | f
| f | 6 | |
customer_currencyid_m2o\000User\000Currency\000UNSPECIFIED\000CurrencyID\000ID\000
32312048 | RI_ConstraintTrigger_32312884 | 1645 | 17 | t | t
| customer_currencyid_m2o | 32311734 | f
| f | 6 | |
customer_currencyid_m2o\000User\000Currency\000UNSPECIFIED\000CurrencyID\000ID\000
32312048 | RI_ConstraintTrigger_32312888 | 1644 | 5 | t | t
| customer_languageid_m2o | 32311939 | f
| f | 6 | |
customer_languageid_m2o\000User\000Language\000UNSPECIFIED\000LanguageID\000ID\000
32312048 | RI_ConstraintTrigger_32312889 | 1645 | 17 | t | t
| customer_languageid_m2o | 32311939 | f
| f | 6 | |
customer_languageid_m2o\000User\000Language\000UNSPECIFIED\000LanguageID\000ID\000
32312048 | RI_ConstraintTrigger_32312893 | 1644 | 5 | t | t
| customer_sitelanguge_id_m2o | 32311939 | f
| f | 6 | |
customer_sitelanguge_id_m2o\000User\000Language\000UNSPECIFIED\000SiteLanguageID\000ID\000
32312048 | RI_ConstraintTrigger_32312894 | 1645 | 17 | t | t
| customer_sitelanguge_id_m2o | 32311939 | f
| f | 6 | |
customer_sitelanguge_id_m2o\000User\000Language\000UNSPECIFIED\000SiteLanguageID\000ID\000
32312048 | RI_ConstraintTrigger_143475435 | 1648 | 9 | t | t
| hotelfeedback_userid_s | 143475410 | f
| f | 6 | |
hotelfeedback_userid_s\000HotelFeedback\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143475436 | 1649 | 17 | t | t
| hotelfeedback_userid_s | 143475410 | f
| f | 6 | |
hotelfeedback_userid_s\000HotelFeedback\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143475559 | 1648 | 9 | t | t
| townfeedback_userid_s | 143475535 | f
| f | 6 | |
townfeedback_userid_s\000TownFeedback\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143475560 | 1649 | 17 | t | t
| townfeedback_userid_s | 143475535 | f
| f | 6 | |
townfeedback_userid_s\000TownFeedback\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143476063 | 1648 | 9 | t | t
| myrewards_userid_s | 143476040 | f
| f | 6 | |
myrewards_userid_s\000MyRewards\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143476064 | 1649 | 17 | t | t
| myrewards_userid_s | 143476040 | f
| f | 6 | |
myrewards_userid_s\000MyRewards\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143476709 | 1644 | 5 | t | t
| user_countryid | 32311401 | f
| f | 6 | |
user_countryid\000User\000Area\000UNSPECIFIED\000CountryID\000ID\000
32312048 | RI_ConstraintTrigger_143476710 | 1645 | 17 | t | t
| user_countryid | 32311401 | f
| f | 6 | |
user_countryid\000User\000Area\000UNSPECIFIED\000CountryID\000ID\000
32312048 | RI_ConstraintTrigger_143476830 | 1644 | 5 | t | t
| user_agecategoryid | 143476823 | f
| f | 6 | |
user_agecategoryid\000User\000AgeCategory\000UNSPECIFIED\000AgeCategoryID\000ID\000
32312048 | RI_ConstraintTrigger_143476831 | 1645 | 17 | t | t
| user_agecategoryid | 143476823 | f
| f | 6 | |
user_agecategoryid\000User\000AgeCategory\000UNSPECIFIED\000AgeCategoryID\000ID\000
32312048 | RI_ConstraintTrigger_143477219 | 1648 | 9 | t | t
| userpreferencesarea_userid_s | 143477202 | f
| f | 6 | |
userpreferencesarea_userid_s\000UserPreferencesArea\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143477220 | 1649 | 17 | t | t
| userpreferencesarea_userid_s | 143477202 | f
| f | 6 | |
userpreferencesarea_userid_s\000UserPreferencesArea\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143477465 | 1648 | 9 | t | t
| userpreferenceskeyword_userid_s | 143477441 | f
| f | 6 | |
userpreferenceskeyword_userid_s\000UserPreferencesKeyword\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143477466 | 1649 | 17 | t | t
| userpreferenceskeyword_userid_s | 143477441 | f
| f | 6 | |
userpreferenceskeyword_userid_s\000UserPreferencesKeyword\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143477609 | 1648 | 9 | t | t
| userpreferencesappeal_userid_s | 143477564 | f
| f | 6 | |
userpreferencesappeal_userid_s\000UserPreferencesAppeal\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143477610 | 1649 | 17 | t | t
| userpreferencesappeal_userid_s | 143477564 | f
| f | 6 | |
userpreferencesappeal_userid_s\000UserPreferencesAppeal\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143477871 | 1648 | 9 | t | t
| userpreferencesfacility_userid_s | 143477857 | f
| f | 6 | |
userpreferencesfacility_userid_s\000UserPreferencesFacility\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143477872 | 1649 | 17 | t | t
| userpreferencesfacility_userid_s | 143477857 | f
| f | 6 | |
userpreferencesfacility_userid_s\000UserPreferencesFacility\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143478129 | 1648 | 9 | t | t
| userpreferencestime_userid_s | 143478111 | f
| f | 6 | |
userpreferencestime_userid_s\000UserPreferencesTime\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143478130 | 1649 | 17 | t | t
| userpreferencestime_userid_s | 143478111 | f
| f | 6 | |
userpreferencestime_userid_s\000UserPreferencesTime\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143478584 | 1648 | 9 | t | t
| userpreferencesstarrating_userid_s | 143478570 | f
| f | 6 | |
userpreferencesstarrating_userid_s\000UserPreferencesStarRating\000User\000UNSPECIFIED\000UserID\000ID\000
32312048 | RI_ConstraintTrigger_143478585 | 1649 | 17 | t | t
| userpreferencesstarrating_userid_s | 143478570 | f
| f | 6 | |
userpreferencesstarrating_userid_s\000UserPreferencesStarRating\000User\000UNSPECIFIED\000UserID\000ID\000
(65 rows)
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
