pg

pg copied to clipboard

Arrays of composite type?

2

Go version: 1.12.4 go-pg version: go.mod says `github.com/go-pg/pg v8.0.4+incompatible`. Commit a70a1ce postgres version: `PostgreSQL 11.1 (Debian 11.1-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit` With the following...

ORBAT

Table-based multitenancy (tenant_id column in each table)

6

I'm trying to figure out how to implement a **table-based multitenancy** (tenant_id column in each table) system in my go-pg project. I can use a `where` statement (as I have...

frederikhors

foreign key to non pk but with unique and not null constraints.

3

```go type Answers struct { TestResultsId string `pg:",pk,type:uuid" json:"test_results_id"` TestResults *TestResults `json:"test_results,omitempty"` QuestionId string `json:"question_id" pg:"type:uuid,pk"` Question *Question `json:"question"` } type TestResults struct { Id string `json:"id" pg:",unique,notnull,type:uuid,default:uuid_generate_v4(),nopk"` TestId string...

MohitKS5

Query timeouts cause model mismatch errors

3

A while back we tried the following change: ``` opts.ReadTimeout = 3 * time.Second // max time for SELECT opts.WriteTimeout = 3 * time.Second // max time for INSERT, UPDATE,...

ericgorlin

Inheritance like hibernet

1

Well I saw an issue already: https://github.com/go-pg/pg/issues/885 Ive something like below: type Actor struct { Id int Profile Profile ProfileId int } type Singer struct { Id int Profile Profile...

suren4Kites

Ignore model parameter when specifying table function

4

As go-pg uses ```db.Model()``` parameter (given model name) to create queries reference table, when ```Table()``` or ```TableExpr()``` is used, pg create two referenced table in queries and its lead to...

saeid-ir

https://www.2ndquadrant.com/en/blog/postgresql-10-identity-columns/

vmihailenco

How to do prepare transaction (two-phase commit)?

8

I am already using transactions for inserts against one database. But I would like to do cross-database transactions with `PREPARE TRANSACTION`, see https://www.postgresql.org/docs/current/static/sql-prepare-transaction.html. I looked at documentation for transactions and...

matthewvalimaki

Recursively retrieve relations of the model?

3

Is there any way to get relations recursively? for example I've got the following struct: ``` type Tree struct { ID int Parent *Tree ParentID string Name string } ```...

latipovsharif

Problem storing array of struct

5

I am trying to create schema from the following struct: ``` type Product struct { Base PublishedAt time.Time `json:"published_at"` Title string `json:"title"` Description string `json:"body_html"` Vendor string `json:"vendor"` ProductType string...

sudhanshug16