[SQL] INSERT FOLLOW WITH OTHER INSERT

hi all i have a table like this CREATE SEQUENCE seq_student_id INCREMENT 1 START 1; CREATE TABLE students ( student_id INT4 NOT NULL DEFAULT NEXTVAL('seq_student_id'), student_name text, student_address text, primary key(student_id) ) CREATE TABLE student_club ( student_id INT4 NOT NU

Re: [SQL] ODBC 7.1

Keith Gray wrote: > > Greetings All, > > Is this the correct forum to discuss ODBC driver issues? > No, pgsql-odbc is the right forum. > I have a Linux/PostgreSQL server which has been upgraded > to run 7.1 - the main reason was to be able to use the > TOAST extensions. We have some documentat

[SQL] ODBC 7.1

Greetings All, Is this the correct forum to discuss ODBC driver issues? I have a Linux/PostgreSQL server which has been upgraded to run 7.1 - the main reason was to be able to use the TOAST extensions. We have some documentation attached to fields which is up to 64kb. After upgrading the serv

Re: [SQL] what does this error mean?

Carolyn Lu Wong <[EMAIL PROTECTED]> writes: > When trying to delete data from a table, get the following error: > ExecutePlan: (junk) `ctid' is NULL!=ODBC.QueryDef May we see the query and table schema? regards, tom lane ---(end of broadcast)-

[SQL] Re: Adding an INTERVAL to a variable

Thanks for the inspiration Vivek! Didn't quite work, but when I made it... dSalesHdrDateDue + (iAcctPayDaysAv || 'Days')::INTERVAL BINGO! it works. Happiness is :-) Graham Coates "Vivek Khera" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > "GC" == Gra