Problem in postgres

When we are uploading our form in ODK Aggregate, postgres is creating more tables and the data we upload is not getting published. Can anyone help me by saying the way how to reduce the columns in postgres which is being backend for ODK aggregate or the reason why it is creating more columns because our form hardly has 5 columns but postgres is creating nearly 32 columns.

Thanks and Regards
Nithya

Hi Nithya,

ODK's database structure is described at
https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure.
Are you seeing different behavior?

Yaw

··· On Mon, Apr 10, 2017 at 11:47 PM, wrote: > When we are uploading our form in ODK Aggregate, postgres is creating more tables and the data we upload is not getting published. Can anyone help me by saying the way how to reduce the columns in postgres which is being backend for ODK aggregate or the reason why it is creating more columns because our form hardly has 5 columns but postgres is creating nearly 32 columns. > > Thanks and Regards > Nithya > > -- > You received this message because you are subscribed to the Google Groups "ODK Developers" group. > To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.

unwanted columns are created

··· On Wed, Apr 19, 2017 at 5:52 AM, Yaw Anokwa wrote:

Hi Nithya,

ODK's database structure is described at
https://github.com/opendatakit/opendatakit/wiki/
Aggregate-Database-Structure.
Are you seeing different behavior?

Yaw

On Mon, Apr 10, 2017 at 11:47 PM, nithya25594@gmail.com wrote:

When we are uploading our form in ODK Aggregate, postgres is creating
more tables and the data we upload is not getting published. Can anyone
help me by saying the way how to reduce the columns in postgres which is
being backend for ODK aggregate or the reason why it is creating more
columns because our form hardly has 5 columns but postgres is creating
nearly 32 columns.

Thanks and Regards
Nithya

--
You received this message because you are subscribed to the Google
Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/opendatakit-developers/egmcqCiLxo4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Nithya,

If you'd like help, you'll need to provide a lot more information
(e.g., a test form, schema of what the tables look like before and
after the form, versions of Aggregate, Tomcat, PostgreSQL, OS, etc).

Yaw

··· On Tue, Apr 18, 2017 at 10:55 PM, Nithya Jeevanand wrote: > unwanted columns are created > > > On Wed, Apr 19, 2017 at 5:52 AM, Yaw Anokwa wrote: >> >> Hi Nithya, >> >> ODK's database structure is described at >> >> https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure. >> Are you seeing different behavior? >> >> Yaw >> >> On Mon, Apr 10, 2017 at 11:47 PM, wrote: >> > When we are uploading our form in ODK Aggregate, postgres is creating >> > more tables and the data we upload is not getting published. Can anyone help >> > me by saying the way how to reduce the columns in postgres which is being >> > backend for ODK aggregate or the reason why it is creating more columns >> > because our form hardly has 5 columns but postgres is creating nearly 32 >> > columns. >> > >> > Thanks and Regards >> > Nithya >> > >> > -- >> > You received this message because you are subscribed to the Google >> > Groups "ODK Developers" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> > an email to opendatakit-developers+unsubscribe@googlegroups.com. >> > For more options, visit https://groups.google.com/d/optout. >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "ODK Developers" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/opendatakit-developers/egmcqCiLxo4/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> opendatakit-developers+unsubscribe@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. > > > -- > You received this message because you are subscribed to the Google Groups > "ODK Developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit-developers+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.