olivierauverlot/pgmetadata

Extracts the PostgreSQL metadata and build an SQL Model (In progress).

pgmetadata's Issues

SqlObject>>#= and SqlObject>>#hash

SqlObject>>#= should be implemented as:

= anObject
	^ self class = anObject class and: [ self oid = anObject oid and: [ self name = anObject name and: [ self owner = anObject owner ] ] ]

SqlObject>>#hash should be implemented as:

hash
	^ (self oid hash bitXor: self name hash) bitXor: self owner hash

Manage OUT parameters in stored procedures

For now such stored procedures can not be created correctly.

SqlView>>#dependencies is not filled when the model is built

Is it normal? How can we access tables/views used by a view from the meta-data?

Unsupported frontend protocol 2.0: server supports 3.0 to 3.0

I downloaded PgMetadata library for Pharo 10 to connect to PostgresQL 14.
I downloaded an updated version that is supported by Pharo 10 from deemOn , as Garage (a dead library) is now replaced by P3Client.

However, an error was thrown while connecting to it as per below screenshot (I guess because of Postgres version) :

I tried the PGMetadata version (developed by olivierauverlot) using Pharo8 image and the new version (fixed by deem0n) on a Pharo 10 image, and both are throwing the same error.

@deem0n , @olivierauverlot any recommendations ?

Importer is stuck when the function of a trigger is not defined in the schema (stub)

Set the namespace to SqlTriggerFunction and subclass when building them

See method PgFunctionExtractor>>#extract

Manage SqlTriggerConstraint references at model building

The object is created but is not well initialised yet.

SqlNotNullConstraint missing?

Bug in PgFunctionExtractor