It is unlikely that the examples you want for this package have been written. You might also look at https://github.com/JuliaDB/PostgreSQL.jl If you think there is something that is not working properly, you could post an issue at https://github.com/NCarson/Postgres.jl/issues.
On Monday, July 11, 2016 at 10:11:11 AM UTC-4, Johann Spies wrote: > > I am fairly new to julia and am trying out the Postgres package from > https://github.com/NCarson/Postgres.jl > > While testing it on this table: > > js=# \d customer > Table "public.customer" > Column | Type | Modifiers > ----------+-----------------------+----------- > cust_no | integer | not null > customer | character varying(28) | not null > city | character varying(25) | > country | character varying(15) | > Indexes: > "ct_customer_pk" PRIMARY KEY, btree (cust_no) > > like this: > > conn = connect(PostgresServer, db="js") > # > > *PostgresConnection(@ 0x0000000005f70230 : ok)curs = cursor(conn)d*f = > query(curs, "select * from customer") > > *#Postgres.BufferedPostgresCursor( > # PostgresConnection(@ 0x0000000005f70230 : ok), > # Nullable{Postgres.Results.PostgresResult}())* > > > df = query(curs, "select * from customer") > > I got this error: > > #*LoadError: MethodError: `unsafe_column` has no method matching > unsafe_column(::Ptr{Postgres.Libpq.PGresult}, ::Int64, ::Int32, > ::Postgres.Types.PostgresType{Int32}) > #Closest candidates are: > # unsafe_column{T}(::Ptr{Postgres.Libpq.PGresult}, ::Int64, !Matched::Int64, > ::Postgres.Types.AbstractPostgresType{T}) > #while loading In[27], in expression starting on line 1 > # > # in column at /home/js/.julia/v0.4/Postgres/src/results.jl:173 > # in fetch at /home/js/.julia/v0.4/Postgres/src/postgres.jl:402 > # in query at /home/js/.julia/v0.4/Postgres/src/postgres.jl:418* > > > How do I solve this? > > Second question: I have seen the example in the readme on how to add a > custom type. But some assumptions in the explanation are not valid for > example the type 'uuid' and ' citext' in PostgreSQL. > (There are at least four fields of the type OID in pg_type and the README > example refers to one containing the OID 600. That field does contain a 0 > for both uuid and citext. ) > > Is there an example on how to define a custom type for citext and for uuid > (Base.Random.UUID) for usage for this package? > > Regards > Johann >
