I'm trying to insert data with parameters to PostgreSQL 16 in C#. I have the following code: using (var myConnection = new NpgsqlConnection(myConnectionString)) { myConnection.Open(); var insertAllData = $@" DO $$ DECLARE new_production_item_id INTEGER; BEGIN INSERT INTO public.production_items (my_data_type_id, created_by,…
I have an postgres 16 DB in Docker container with volume. I wanted to hide standard postgres user and changed it's name to super (as example). Now I try to make something with any tables (DDL operations like ALTER TABLE)…
Please take a look at this query: SELECT COUNT(*) FROM events e WHERE (e.event_data -> 'state')::int = -1; The query works and everything is actually ok, but... This is how the JSON object looks like when I read it from…
I just upgraded from spring-boot 3.2.3 -> 3.3.0. After the upgrade flyway refuses to connect to postgres: Caused by: org.flywaydb.core.api.FlywayException: Unsupported Database: PostgreSQL 16.2 at org.flywaydb.core.internal.database.DatabaseTypeRegister.getDatabaseTypeForConnection(DatabaseTypeRegister.java:105) at org.flywaydb.core.internal.jdbc.JdbcConnectionFactory.<init>(JdbcConnectionFactory.java:73) at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:134) at org.flywaydb.core.Flyway.migrate(Flyway.java:147) What is the expected way to connect to…
I have two columns: column1 with two distinct values (0, 1) and column2 with 3 distinct values ('A', 'B', 'C'). Value in column1 is always 0 for 'A' and 'B' in column2, but if the value in column2 is 'C'…
Refer this! I was creating a database and got this error i tried to uninstall and then reinstall postgresql-16 and pgadmin4 but it didn't work for me! It creates a database but gives this error i am worried that what…
I have the following code in which I am trying to extract JSON as follows: DROP TABLE IF EXISTS tmp2; CREATE TEMP table tmp2 ( c TEXT ); insert into tmp2 values ( N'{"SerialNumber":"907578","SoftwareVersion":"1.2.777","Build":"4829","ProductCode":"TR-3500-A","BuildDate":null,"Description":"Study desk","ConnectionType":2,"Capabilities":[2,3], "ChannelListDto":[ {"ChannelId":0,"ConversionType":0,"DeviceSerialNumber":null,"Dimension":"","FixedName":null,"Name":"test2","InstrumentationChannel":-1,"IsAlarmable":false,"IsInternal":true,"IsEnableable":false,"IsEnabled":false,"JournalledReadingBytes":0,"LowerLimit":null,"Precision":null,"Symbol":"","TypeId":5,"UpperLimit":null}, {"ChannelId":1,"ConversionType":0,"DeviceSerialNumber":null,"Dimension":"","FixedName":null,"Name":null,"InstrumentationChannel":-1,"IsAlarmable":false,"IsInternal":true,"IsEnableable":false,"IsEnabled":false,"JournalledReadingBytes":0,"LowerLimit":null,"Precision":null,"Symbol":"","TypeId":5,"UpperLimit":null}, {"ChannelId":2,"ConversionType":0,"DeviceSerialNumber":null,"Dimension":"","FixedName":null,"Name":null,"InstrumentationChannel":-1,"IsAlarmable":false,"IsInternal":true,"IsEnableable":false,"IsEnabled":false,"JournalledReadingBytes":0,"LowerLimit":null,"Precision":null,"Symbol":"","TypeId":5,"UpperLimit":null} ]…
I have the following tables which i want to write a function to return data from Table Definitions create table device ( deviceid uuid not null constraint pk__device__49e123311461d246 primary key, serialnumber varchar(255), productcode varchar(255), description varchar(255), softwareversion varchar(255), build varchar(255),…
Hello i am 2 days stuck trying to install POSTGRE SQL. Today it is on version 16 but already attempted versions 14, 13, 15.... It looks like the bindata folder, which is the db cluster folder, has some kind of…
I have tables level_one_table, level_two_table, and level_three_table. level_one_table to level_two_table: one to multiple rows level_two_table to level_three_table: one to one row Goal: select them all and level_two_table rows able to use LIMIT and ORDER BY. Return data structure like below:…