theshaner6
Programmer
Hey everyone, new here because my usual community doesn't have much postgresql support, so hopefully I've come to the right place with this question.
I am receiving the error Relation propack_order does not exist. I've attempted putting quotes around the 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 submitting my own SQL with the SQL feature. I have a feeling it has to do something with my sequence number that is suppose to be automatically generated. I'm not sure why it would be seeing that it works perfectly when using the INSERT button and it's setup 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.
Sample SQL looks like:
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). Also, this is a brand new table and sequence added to my DB. I've also dropped both the table and sequence and recreated them to no avail.
Any variation to the SQL or using other SQL queries result in the same error. The only answer I've found on the web (besides using quotes on the table name) is to rebuild the DB and that is NOT an option, hehe.
This is for version 8. Thanks for any help!
-Shane
I am receiving the error Relation propack_order does not exist. I've attempted putting quotes around the 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 submitting my own SQL with the SQL feature. I have a feeling it has to do something with my sequence number that is suppose to be automatically generated. I'm not sure why it would be seeing that it works perfectly when using the INSERT button and it's setup 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.
Sample SQL looks like:
Code:
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). Also, this is a brand new table and sequence added to my DB. I've also dropped both the table and sequence and recreated them to no avail.
Any variation to the SQL or using other SQL queries result in the same error. The only answer I've found on the web (besides using quotes on the table name) is to rebuild the DB and that is NOT an option, hehe.
This is for version 8. Thanks for any help!
-Shane