Bob Pawley wrote:
> The folks on the Delphi forum haven't been responsive to this question.
> Perhaps the ones that visit the forum don't know the answer.
>
> I have created a Delphi interface to a Postgresql table containing a
> serial column.
>
> When I try to insert a new value through the interface I get an error
> message that the serial field requires a value.
>
> When I remove the serial column the interface inserts a new value with
> no problem. When I insert directly via sql the serial column updates
> automatically.
>
> What am I missing to make this work through Delphi?
Try using DEFAULT as the serial value.. e.g;
INSERT INTO foo VALUES (DEFAULT, 'Hello');
Where DEFAULT is the serial column.
Sincerely,
Joshua D. Drake
>
> Bob
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/