postgres table exists but it is throwing table not exists error.

[RedEye-Developers]

Error

Npgsql.PostgresException (0x80004005): 42P01: relation "public.last_stream_content" does not exist

2025-11-20.19-26-54.mp4

Issue :

In PgSql "public.last_stream_content" exists but when code was execute it is throwing error "public.last_stream_content" does not exist, i have no idea why.

Used Code.

Aspire AppHost

using LoFIStreamer.EnvLoader.Module;
using Projects;

EnvLoader.Load();

var builder = DistributedApplication.CreateBuilder(args);
var config = builder.Configuration;

var pgSqlUsername = builder.AddParameter("postgres-username", secret: false);
var pgSqlPassword = builder.AddParameter("postgres-password", secret: true);

var postgres = builder.AddPostgres("postgres", pgSqlUsername, pgSqlPassword)
    .WithInitFiles("SqlFiles/Init.sql")
    .WithContainerName("postgres")
    .WithLifetime(ContainerLifetime.Persistent);

var postgresDb = postgres.AddDatabase(config[EnvKeys.Postgres.ConnectionString]!);

builder.AddProject<LoFiStreamer_StreamManager_Api>("loFi-streamerManager-api")
    .WaitFor(postgresDb)
    .WithReference(postgresDb);

builder.Build().Run();

Sql-File

CREATE TABLE IF NOT EXISTS last_stream_content (
    id INT PRIMARY KEY,
    gif_key TEXT NOT NULL,
    audio_key TEXT NOT NULL
);

INSERT INTO last_stream_content (id, gif_key, audio_key)
VALUES (1, '1.gif', '1.mp3')
ON CONFLICT (id) DO NOTHING;

Client-Console-App

EnvLoader.Load();

var builder = WebApplication.CreateBuilder(args);
var config = builder.Configuration;

builder.AddServiceDefaults();

builder.AddNpgsqlDataSource(config[EnvKeys.Postgres.ConnectionString]!);

builder.Services
    .AddOpenApi()
    .AddApplication()
    .AddRepositories()
    .AddPresentation()
    // .AddPostgres(config.GetConnectionString(config[EnvKeys.Postgres.ConnectionString]!)!)
    .AddAwsS3(config[EnvKeys.Aws.S3.BucketName]!,
        config[EnvKeys.Aws.S3.AccessKey]!,
        config[EnvKeys.Aws.S3.SecretKey]!,
        config[EnvKeys.Aws.RegionEndPoint]!);

var app = builder.Build();
if (app.Environment.IsDevelopment())
{
    app.MapOpenApi();
}

app.MapDefaultEndpoints();
app.UseHttpsRedirection();
app.MapPresentation();

var contentManager = app.Services.GetRequiredService<IContentManagerRepository>();
await contentManager.SaveContentAsync(ContentType.Gif, "2.gif");

app.Run();

Method

public async Task SaveContentAsync(ContentType contentType, string content, CancellationToken ct = default)
    {
        var query = contentType switch
        {
            ContentType.Gif => """
                               update public.last_stream_content set gif_key = @gifKey
                               where id = 1; 
                               """,
            ContentType.Audio => """
                                 update public.last_stream_content set audio_key = @audioKey
                                 where id = 1; 
                                 """,
            _ => string.Empty
        };
        
        object parameter = contentType switch
        {
            ContentType.Gif => new {gifKey = content},
            ContentType.Audio => new {audioKey = content},
            _ => throw new ArgumentOutOfRangeException(nameof(contentType), contentType, null)
        };

        // using var connection = await _connectionFactory.CreateConnectionAsync(ct);
        await using var connection = await _dataSource.OpenConnectionAsync(ct);
        await connection.ExecuteAsync(new CommandDefinition(query, parameter, cancellationToken: ct));
    }
    ```

[RedEye-Developers]

sry the database name is wrong, i got little bit confusion in database name.