TheShaner
05-09-2007, 04:26 PM
Why oh why do I get this? I've attempted putting quotes around my table name in my SQL query, but it still does not remedy this. I shouldn't need the quotes anyway, seeing that the table name is in all lowercase. When working in phpPgAdmin, I can insert rows just fine using the INSERT feature, but cannot when using the SQL feature. I have a feeling it has to do something with my sequence number that is suppose to be automatically generated, although it's copied and used exactly like my other sequences.
The default value of my order_id field in my propack_order table is set to nextval('"propack_order_order_id_seq"'::text). That sequence is just an integer, starts at 1 and increments by 1.
SQL looks like:
INSERT INTO propack_order (member) VALUES ('Shane')
Which should result in an automatic assignment of the next integer in the sequence for order_id and a member name of Shane and the rest of the columns null (and yes, they're allowed to be null).
-Shane
The default value of my order_id field in my propack_order table is set to nextval('"propack_order_order_id_seq"'::text). That sequence is just an integer, starts at 1 and increments by 1.
SQL looks like:
INSERT INTO propack_order (member) VALUES ('Shane')
Which should result in an automatic assignment of the next integer in the sequence for order_id and a member name of Shane and the rest of the columns null (and yes, they're allowed to be null).
-Shane