Fix interface example errors causes by backend changes.

bmomjian · bmomjian · commit ce4a287f43f5 · 2002-06-07T03:55:15.000Z
Permaine Cheung
diff --git a/src/interfaces/libpgeasy/examples/pginsert.c b/src/interfaces/libpgeasy/examples/pginsert.c
@@ -41,7 +41,7 @@ main(int argc, char **argv)
 			afloat 	float4, \
 			adouble float8, \
 			achar	char, \
-			achar16	char16, \
+			achar16	char(16), \
 			abpchar char(10), \
 			avarchar varchar(50), \
 			atext	text, \
diff --git a/src/interfaces/libpgeasy/examples/pgnulltest.c b/src/interfaces/libpgeasy/examples/pgnulltest.c
@@ -52,7 +52,7 @@ main(int argc, char **argv)
             afloat  float4, \
             adouble float8, \
             achar   char, \
-            achar16 char16, \
+            achar16 char(16), \
             abpchar char(10), \
             avarchar varchar(50), \
             atext   text, \
diff --git a/src/interfaces/libpq++/examples/testlibpq4.sql b/src/interfaces/libpq++/examples/testlibpq4.sql
@@ -2,4 +2,4 @@ CREATE TABLE TBL1 (i int4);
 
 CREATE TABLE TBL2 (i int4);
 
-CREATE RULE r1 AS ON INSERT TO TBL1 DO [INSERT INTO TBL2 values (new.i); NOTIFY TBL2];
+CREATE RULE r1 AS ON INSERT TO TBL1 DO (INSERT INTO TBL2 values (new.i); NOTIFY TBL2);
diff --git a/src/interfaces/libpq++/examples/testlibpq6.cc b/src/interfaces/libpq++/examples/testlibpq6.cc
@@ -25,7 +25,7 @@ int main()
   else cout << "Connected to database '" << dbName << "'..." << endl;
 
   // Create a new table
-  if ( !data.ExecCommandOk("CREATE TABLE foo (a int4, b char16, d float8)") ) {
+  if ( !data.ExecCommandOk("CREATE TABLE foo (a int4, b char(16), d float8)") ) {
       cerr << "CREATE TABLE foo command failed" << endl;
       exit(1);
   }

Original file line number	Diff line number	Diff line change
`@@ -2,4 +2,4 @@ CREATE TABLE TBL1 (i int4);`
`2`	`2`
`3`	`3`	`CREATE TABLE TBL2 (i int4);`
`4`	`4`
`5`		`-CREATE RULE r1 AS ON INSERT TO TBL1 DO [INSERT INTO TBL2 values (new.i); NOTIFY TBL2];`
	`5`	`+CREATE RULE r1 AS ON INSERT TO TBL1 DO (INSERT INTO TBL2 values (new.i); NOTIFY TBL2);`
Original file line number	Diff line number	Diff line change
`@@ -25,7 +25,7 @@ int main()`
`25`	`25`	`else cout << "Connected to database '" << dbName << "'..." << endl;`
`26`	`26`
`27`	`27`	`// Create a new table`
`28`		`- if ( !data.ExecCommandOk("CREATE TABLE foo (a int4, b char16, d float8)") ) {`
	`28`	`+ if ( !data.ExecCommandOk("CREATE TABLE foo (a int4, b char(16), d float8)") ) {`
`29`	`29`	`cerr << "CREATE TABLE foo command failed" << endl;`
`30`	`30`	`exit(1);`
`31`	`31`	`}`