Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA02524; Thu, 29 Apr 93 09:43:57 -0700
Message-Id: <9304291643.AA02524@postgres.Berkeley.EDU>
From: Nat Howard <nrh@uunet.uu.net>
Subject: 
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Date: Thu, 29 Apr 93 12:44:08 -0400
From: Nat Howard <nrh@uunet.uu.net>


The shell script at the bottom of this message appears to 
break postgres -- the final "retrieve" gets an error.  

If you change this line:

        current_contacts=bytea

to 
        rent_contacts=bytea

it works.  (You may have to restart postmaster -- there's evidently
some difficulty about destroying and remaking classes).


Here's the ascii version:


#! /bin/sh
destroydb test_db
createdb test_db
monitor -TN test_db <<EOF

/* these match the things in canon.ticket */
create tt_ticket (		/* create the trouble-ticket class */
	ticket_number=int4,		/* unique ticket number */
	ticket_status=char16,	/* open, closed, hold_customer, hold_vendor, hold_us */
	current_contacts=bytea
)


\\g


/* Now create the ticket number */

create tt_number ( tt_number= int4 )  \\g
append tt_number (tt_number = 1) \\g
EOF


monitor -TN test_db <<EOF

begin replace tt_number (tt_number = tt_number.tt_number + 1 )

                 append tt_ticket (ticket_number = tt_number.tt_number, 
ticket_status = "open"

)

end
\\g
  
EOF


monitor -TN test_db <<EOF
retrieve(tt_ticket.all)\g
EOF

There error message you get is:

...
Go 
* 
Query sent to backend is "retrieve(tt_ticket.all)"
Error: Unexpected identfier in dump_data:


Here's the uuencoded version, so various backslashes survive:

begin 644 killpsg
M(R$@+V)I;B]S: ID97-T<F]Y9&(@=&5S=%]D8@IC<F5A=&5D8B!T97-T7V1B
M"FUO;FET;W(@+51.('1E<W1?9&(@/#Q%3T8*"B\J('1H97-E(&UA=&-H('1H
M92!T:&EN9W,@:6X@8V%N;VXN=&EC:V5T("HO"F-R96%T92!T=%]T:6-K970@
M* D)+RH@8W)E871E('1H92!T<F]U8FQE+71I8VME="!C;&%S<R J+PH)=&EC
M:V5T7VYU;6)E<CUI;G0T+ D)+RH@=6YI<75E('1I8VME="!N=6UB97(@*B\*
M"71I8VME=%]S=&%T=7,]8VAA<C$V"2\J(&]P96XL(&-L;W-E9"P@:&]L9%]C
M=7-T;VUE<BP@:&]L9%]V96YD;W(L(&AO;&1?=7,@*B\**0H*"EQ<9PH*"B\J
M($YO=R!C<F5A=&4@=&AE('1I8VME="!N=6UB97(@*B\*"F-R96%T92!T=%]N
M=6UB97(@*"!T=%]N=6UB97(](&EN=#0@*2 @7%QG"F%P<&5N9"!T=%]N=6UB
M97(@*'1T7VYU;6)E<B ](#$I(%Q<9PI%3T8*"@IM;VYI=&]R("U43B!T97-T
M7V1B(#P\14]&"@IB96=I;B!R97!L86-E('1T7VYU;6)E<B H='1?;G5M8F5R
M(#T@='1?;G5M8F5R+G1T7VYU;6)E<B K(#$@*0H*(" @(" @(" @(" @(" @
M("!A<'!E;F0@='1?=&EC:V5T("AT:6-K971?;G5M8F5R(#T@='1?;G5M8F5R
M+G1T7VYU;6)E<BP@"G1I8VME=%]S=&%T=7,@/2 B;W!E;B(*"BD*"F5N9 I<
M7&<*(" *14]&"@H*;6]N:71O<B M5$X@=&5S=%]D8B \/$5/1@IR971R:65V
792AT=%]T:6-K970N86QL*5QG"D5/1@H@
 
end



Any hints?  Any help?  Thanks!