# Why do \_id and \_owner auto-fill in Wix with Google Cloud SQL, but \_createdDate and \_updatedDate do not?

**URL:** <https://forum.wixstudio.com/t/why-do-id-and-owner-auto-fill-in-wix-with-google-cloud-sql-but-createddate-and-updateddate-do-not/67736>\
**Category:** Ask the community\
**Tags:** wix-data, wix-stores, code\
**Created:** [January 20, 2025, 3:07pm UTC](https://forum.wixstudio.com/t/why-do-id-and-owner-auto-fill-in-wix-with-google-cloud-sql-but-createddate-and-updateddate-do-not/67736 "2025-01-20T15:07:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![user4656](https://avatars.discourse-cdn.com/v4/letter/u/ee59a6/32.png) [@user4656](https://forum.wixstudio.com/u/user4656)\
**Post date:** [January 20, 2025, 3:07pm UTC](https://forum.wixstudio.com/t/why-do-id-and-owner-auto-fill-in-wix-with-google-cloud-sql-but-createddate-and-updateddate-do-not/67736/1 "2025-01-20T15:07:38Z")

</div>

# [False and 0 Values Not Inserted in PostgreSQL via Wix Velo bulkInsert](https://stackoverflow.com/questions/79371629/false-and-0-values-not-inserted-in-postgresql-via-wix-velo-bulkinsert)

I’m using Wix Velo to insert data into a PostgreSQL database. Everything works except for the integer 0 and the boolean false. These values are not stored correctly in the table and are instead left empty. Here’s the situation:

**PostgreSQL Table Structure:**

```javascript
CREATE TABLE jouw_tabel1 (
    "_id" SERIAL PRIMARY KEY,
    "_createdDate" TIMESTAMP NOT NULL,
    "_updatedDate" TIMESTAMP NOT NULL,
    "_owner" VARCHAR(255),
    "numeric_value" INTEGER NOT NULL,
    "is_active" BOOLEAN NOT NULL
);

```

**Wix Velo Code for Insert:**

```javascript
const records = [
    { extra_info: "Extra info 1", numeric_value: 0, is_active: true },
    { extra_info: "Extra info 2", numeric_value: 0, is_active: false },
    { extra_info: "Extra info 3", numeric_value: 1, is_active: false }
];

wixData.bulkInsert("wix_velo_gcp_connection/jouw_tabel1", records)
    .then((result) => {
        console.log(`Successfully inserted ${result.inserted}`);
    })
    .catch((err) => {
        console.error("Error:", err);
    });

```

**What Happens:**

- Non-zero integers and true values are inserted correctly.
- numeric\_value: 0 and is\_active: false are not stored and result in empty fields in the database.

[![enter image description here](https://us1.discourse-cdn.com/wix/original/3X/9/f/9f8fa8498fe705e10e705f645ac84de55ea7b523.png)](https://i.sstatic.net/AJDhgYB8.png)

**What I Know:**

- If I manually insert 0 or false via a SQL prompt (outside of Wix), it works as expected.
- This suggests the issue likely lies with how Wix Velo processes and sends these values to PostgreSQL.

**Troubleshooting Steps Taken:**

- Verified table structure with SELECT column\_name, data\_type, is\_nullable FROM information\_schema.columns.
- Ran queries to fetch records with 0 or false values (e.g., SELECT \* FROM jouw\_tabel1 WHERE numeric\_value = 0;). These return no results.
- Wix does not show errors during insertion, and there are no obvious logs in PostgreSQL indicating a problem.

I’m using PostgreSQL 16.6. Is there something specific in Wix Velo that could cause this behavior? How can I debug or fix this issue?