Examples SQL scripts for PG?

Examples SQL scripts for PG?

Login or register to post comments

2 replies [Last post]

Fri, 07/15/2011 - 08:45

Vaibhav

Offline

Joined: 10/11/2010

I am not sure about the reason but the database script for the examples database is not available for PostgreSQL. Since I am using PG for development, sometimes I need to get to the examples and there is no examples script!!

Is there any plan on supplying that?

Regards,
Vaibhav

Fri, 07/15/2011 - 10:08

#1

Vaibhav

Offline

Joined: 10/11/2010

I tried to create a script but when using it, it shows the error:

TypeTable project_status_type's second column is not a unique VARCHAR.

Any idea on whats wrong?

EDIT: Is it because postgreSQL says its 'character varying' instead of 'varchar'?

Sat, 07/16/2011 - 23:30

#2

rahulakacyrus

Offline

Joined: 12/06/2010

Hi Vaibhav,

I am sorry that you dint get any replies, maybe the experts are onto something awesome!!

As for the error you are getting,type tables need two things

1- unique ID(int)
2 unique name(varchar)

Please read the example at:
http://examples.qcu.be/assets/_core/php/examples/more_codegen/type_table...