Topics tagged postgresql

Topic	Replies	Views	Activity
Ecto - how to select all posts that have more than N comments with a single query Questions / Help ecto , postgresql , troubleshooting	0	86	January 28, 2021
Typecasting tuple results with Ecto Questions / Help ecto , postgresql , feature-request	2	172	January 26, 2021
Why does the first query return a result while the second one return an error (unless Ecto.UUID.dump/1 or Ecto.UUID.cast!/1 are called)? Questions / Help ecto , postgres , postgrex , postgresql	2	114	January 22, 2021
How do I load ecto structs from a postgresql function? Questions / Help postgresql , ecto-query , function	3	239	December 12, 2020
How to read Postgrex SQL ERROR 42703 Questions / Help postgres , postgrex , postgresql	6	189	November 15, 2020
Ecto put_assoc with compsoite foreign key issue Questions / Help ecto , postgresql	0	117	October 29, 2020
Ecto SQL query does not return the expected value Questions / Help ecto , sql , postgres , postgresql	9	268	October 7, 2020
Ecto runtime repo creation Chat / Discussions ecto , book-programming-elixir , postgresql	2	136	September 30, 2020
Ecto Postgres Index vs Unique Index Questions / Help ecto , phoenix , postgres , postgresql , unique_index	10	457	September 20, 2020
Repo.stream triggers more queries than expected Questions / Help ecto , postgres , postgresql	3	808	September 7, 2020
INSERT … SELECT in Ecto using Ecto.Query Questions / Help ecto , sql , postgresql	7	640	August 26, 2020
Moving roles to postgres Chat / Discussions ecto , phoenix , postgresql	2	446	July 25, 2020
Odd problem with Elixir worker, RabbitMQ, Ecto and Postgresql inserts with triggers Questions / Help ecto , rabbitmq , postgresql	2	272	June 21, 2020
Need options and tradeoffs for storing and accessing digraphs (directed graphs) Questions / Help ecto , postgresql	5	339	June 2, 2020
Validating PostgreSQL naming and values Questions / Help postgres , postgrex , postgresql , ecto_sql	2	363	May 30, 2020
Preload and filter or multiple queries? Questions / Help postgresql , ecto-query	3	279	May 18, 2020
Ecto type that maps to postgresql's timetz (time with a time zone) Questions / Help ecto , postgresql , timetz	1	199	May 7, 2020
Could not compile dependency :ecto_sql, "mix compile" failed Questions / Help phoenix , postgresql , ecto_sql	2	349	April 23, 2020
Delete file from aws(arc) fom postgres trigger Questions / Help ecto , postgresql , arc	11	403	April 15, 2020
Deconstructing CTE into an Ecto query Questions / Help ecto , postgresql	6	510	April 11, 2020
Ecto CTE Recursively preload children Questions / Help ecto , recursion , postgresql	2	685	March 18, 2020
Ecto.create failure Questions / Help ecto , phoenix , postgres , postgresql	10	782	March 9, 2020
Postgrex start_link returns {:ok, pid} in case of an error Questions / Help databases , postgrex , postgresql	5	328	March 9, 2020
Please can you help me in choosing a good database model to facilitate search queries using PostgreSQL full text search? Questions / Help ecto , postgresql , database , ecto-query , fulltext-search , ecto_sql	7	462	February 18, 2020
Postgres / psql Hooks with Ecto...? Questions / Help ecto , postgresql	2	349	February 14, 2020
Postgres connection count always increasing, never drops Questions / Help ecto , deployment , postgresql	8	713	January 15, 2020
Ecto Migration throwing error - (Postgrex.Error) ERROR 42601 (syntax_error) Questions / Help ecto , postgrex , postgresql , troubleshooting	1	447	October 7, 2019
Performing a find-or-create in Ecto? Questions / Help ecto , sql , postgresql	8	1732	September 7, 2019
Unique Index with multiple columns Questions / Help ecto , databases , postgresql	6	1727	August 30, 2019
Are there any Ecto-specific reasons not to use natural keys as primary keys? Questions / Help ecto , phoenix , postgres , postgresql	8	623	August 9, 2019