Hi all,
the patch below plugs one of the missing functions in GDL2's PostgreSQL Adaptor. Works fine here with my almost virgin DB.
Have fun,
Markus
*** /tmp/pbcvsdiff.1732/1.3_Postgres95Channel.m 2002-12-30 17:23:43 +0100
--- /whereever/gdl2/EOAdaptors/Postgres95/Postgres95Channel.m 2002-12-30 17:23:24 +0100
***************
*** 1306,1315 ****
- (NSArray *)describeTableNames
{
! // TODO
! [self notImplemented: _cmd];
! return nil;
}
- (NSArray *)describeStoredProcedureNames
--- 1300,1336 ----
- (NSArray *)describeTableNames
{
! int i, count;
! NSMutableArray *results = [NSMutableArray array];
!
! NSAssert(_pgConn, @"Channel not opened");
!
! _pgResult = PQexec(_pgConn,
! "SELECT tablename FROM pg_tables WHERE pg_tables.schemaname = 'public'");
!
! if (_pgResult == NULL || PQresultStatus(_pgResult) != PGRES_TUPLES_OK)
! {
! _pgResult = NULL;
! [NSException raise: Postgres95Exception
! format: @"cannot read list of tables from database. "
! @"bad response from server"];
! }
!
! [_oidToTypeName removeAllObjects];
! count = PQntuples(_pgResult);
!
! for (i = 0; i < count; i++)
! {
! char* oid = PQgetvalue(_pgResult, i, 0);
!
! [results addObject: [NSString stringWithUTF8String: oid]];
! }
!
! PQclear(_pgResult);
! _pgResult = NULL;
!
! return [NSArray arrayWithArray:results];
}
- (NSArray *)describeStoredProcedureNames
- - - - - - - - - - - - - - - - - - -
Dipl. Ing. Markus Hitter
http://www.jump-ing.de/
_______________________________________________
Bug-gnustep mailing list
[EMAIL PROTECTED]
http://mail.gnu.org/mailman/listinfo/bug-gnustep
