Radicore Forum: Bug Reports » Error update column to popup with Postgresql

Home » RADICORE development » Bug Reports » Error update column to popup with Postgresql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Error update column to popup with Postgresql [message #4261 is a reply to message #4259]

Mon, 16 June 2014 09:50

kong
Messages: 90
Registered: December 2011

Member

Installing this patch will show another problem.

When I do table->columns->import columns
for a table with auto increment pkey, system produces error:

[expense_id] col_default: col_default cannot be greater than 40 characters.

and refuses to import any columns.

I suspect auto-increment field in PostgreSQL is imported into Radicore with the default value as

nextval('....................._id_seq'::regclass)

, which sometimes will exceed $fieldspec['size'] characters and therefor cannot pass the validateField() function in std.validate.class.

Report message to a moderator

[Message index]

		Error update column to popup with Postgresql By: kong on Sat, 14 June 2014 09:05
		Re: Error update column to popup with Postgresql By: AJM on Sun, 15 June 2014 05:37
		Re: Error update column to popup with Postgresql By: kong on Mon, 16 June 2014 09:50
		Re: Error update column to popup with Postgresql By: AJM on Mon, 16 June 2014 10:07
		Re: Error update column to popup with Postgresql By: kong on Mon, 16 June 2014 14:05
		Re: Error update column to popup with Postgresql By: AJM on Mon, 16 June 2014 14:19
		Re: Error update column to popup with Postgresql By: kong on Mon, 16 June 2014 21:13
		Re: Error update column to popup with Postgresql By: AJM on Tue, 17 June 2014 03:45
		Re: Error update column to popup with Postgresql By: kong on Fri, 20 June 2014 12:06

Previous Topic:	SQL error upon log in (PostgreSQL)
Next Topic:	Update Multiple Scroll Sequence Behavior

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Dec 23 21:26:08 EST 2024

Total time taken to generate the page: 0.03420 seconds