pgsql error?

sri2002

I am having a problem in creating my pgsql table. This is my script.
CREATE TABLE SAUSMailingAddress (
MailingListID serial NOT NULL primary key,
Source varchar(40) NULL,
Source2 varchar(40) NULL,
Source3 varchar(40) NULL,
Title varchar(30) NULL,
FirstName varchar(50) NULL,
LastName varchar(50) NULL,
Salutation varchar(30) NULL,
Postin varchar(50) NULL,
Department varchar(50) NULL,
HigherEduInstitution varchar(50) NULL,
Address varchar(255) NULL,
Address1 varchar(255) NULL,
City varchar(50) NULL,
StateProvince varchar(25) NULL,
PostalCode varchar(20) NULL,
Country varchar(15) NULL,
EmailAddress varchar(50) NULL,
WorkPhone varchar(50) NULL,
SAPartner varchar(50) NULL,
FaxNumber varchar(30) NULL,
DatePrintMailing date NULL,
DateSecondMailing date NULL,
DateEmailSent date NULL,
DateSecondEmail date NULL,
DateFollowupQuestions date NULL,
DateQuestionsReturn date NULL,
DatePhoneCall1 date NULL,
QuestionaireContact varchar(50) NULL,
DateReply date NULL,
AddrReturnedMail date NULL,
DateDataEntry date NULL,
ToFollowUp date NULL,
FileUserName varchar(20) NOT NULL,
SecretaryAssistantName varchar(20) NULL,
SecretaryAssistantPhone varchar(20) NULL,
Notes text NULL
);
It is erroring out from this line
-DateSecondMailing date NULL,
Help pls!
Thanks
Sri

DigitalExpl0it

I dont know if date can be null try not null

sri2002

Nope still erroring out... And that too the same line....

CREATE TABLE SAUSMailingAddress (
MailingListID serial NOT NULL primary key,
Source varchar(40) NULL,
Source2 varchar(40) NULL,
Source3 varchar(40) NULL,
Title varchar(30) NULL,
FirstName varchar(50) NULL,
LastName varchar(50) NULL,
Salutation varchar(30) NULL,
Postin varchar(50) NULL,
Department varchar(50) NULL,
HigherEduInstitution varchar(50) NULL,
Address varchar(255) NULL,
Address1 varchar(255) NULL,
City varchar(50) NULL,
StateProvince varchar(25) NULL,
PostalCode varchar(20) NULL,
Country varchar(15) NULL,
EmailAddress varchar(50) NULL,
WorkPhone varchar(50) NULL,
SAPartner varchar(50) NULL,
FaxNumber varchar(30) NULL,
DatePrintMailing date NOT NULL,
DateSecondMailing date NOT NULL,
DateEmailSent date NOT NULL,
DateSecondEmail date NOT NULL,
DateFollowupQuestions date NOT NULL,
DateQuestionsReturn date NOT NULL,
DatePhoneCall1 date NOT NULL,
QuestionaireContact varchar(50) NULL,
DateReply date NOT NULL,
AddrReturnedMail date NOT NULL,
DateDataEntry date NOT NULL,
ToFollowUp date NOT NULL,
FileUserName varchar(20) NOT NULL,
SecretaryAssistantName varchar(20) NULL,
SecretaryAssistantPhone varchar(20) NULL,
Notes text NULL
);

Thanks
Sri

LordShryku

What is the error message it is giving you?

LordShryku

Using your post, I had no problems creating it....

NOTICE: CREATE TABLE will create implicit sequence 'sausmailingad_mailinglistid
_seq' for SERIAL column 'sausmailingaddress.mailinglistid'
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'sausmailingaddre
ss_pkey' for table 'sausmailingaddress'
CREATE

sri2002

How do I check the error. I use ssh to connect to the pgsql db. When I try to execute this create table statement the query stops at that paticular line. The session is like this:
consult(> CREATE TABLE SAUSMailingAddress (
MailingListID serial NOT NULL primary key,
Source varchar(40) NULL,
Source2 varchar(40) NULL,
Source3 varchar(40) NULL,
Title varchar(30) NULL,
FirstName varchar(50) NULL,
LastName varchar(50) NULL,
Salutation varchar(30) NULL,
Postin varchar(50) NULL,
Department varchar(50) NULL,
HigherEduInstitution varchar(50) NULL,
Address varchar(255) NULL,
Address1 varchar(255) NULL,
City varchar(50) NULL,
StateProvince varchar(25) NULL,
PostalCode varchar(20) NULL,
Country varchar(15) NULL,
EmailAddress varchar(50) NULL,
WorkPhone varchar(50) NULL,
SAPartner varchar(50) NULL,
FaxNumber varchar(30) NULL,
PrintMailing date NOT NULL,
SecondMailing date NOT NULL,
EmailSent date NOT NULL,
SecondEmail date NOT NULL,
FollowupQuestions date NOT NULL,
QuestionsReturn date NOT NULL,
PhoneCall1 date NOT NULL,
QuestionaireContact varchar(50) NULL,
Reply date NOT NULL,
AddrReturnedMail date NOT NULL,
DataEntry date NOT NULL,
ToFollowUp date NOT NULL,
FileUserName varchar(20) NOT NULL,
SecretaryAssistantName varchar(20) NULL,
SecretaryAssistantPhone varchar(20) NULL,
Notes text NULL
);consult(> MailingListID serial NOT NULL primary key,
consult(> Source varchar(40) NULL,
consult(> Source2 varchar(40) NULL,
consult(> Source3 varchar(40) NULL,
consult(> Title varchar(30) NULL,
consult(> FirstName varchar(50) NULL,
consult(> LastName varchar(50) NULL,
consult(> Salutation varchar(30) NULL,
consult(> Postin varchar(50) NULL,
consult(> Department varchar(50) NULL,
consult(> HigherEduInstitution varchar(50) NULL,
consult(> Address varchar(255) NULL,
consult(> Address1 varchar(255) NULL,
consult(> City varchar(50) NULL,
consult(> StateProvince varchar(25) NULL,
consult(> PostalCode varchar(20) NULL,
consult(> Country varchar(15) NULL,
consult(> EmailAddress varchar(50) NULL,
consult(> WorkPhone varchar(50) NULL,
consult(> SAPartner varchar(50) NULL,
consult(> FaxNumber varchar(30) NULL,
consult(> PrintMailing date NOT NULL,
consult(> SecondMailing date

Thanks
Sri

LordShryku

Yours may be different than mine, but it looks like it's in the middle of a statement already. The beginning of your create statement goes

consult(> CREATE TABLE SAUSMailingAddress (

Where your database is named consult, mine would look like this:

consult=> CREATE TABLE SAUSMailingAddress (

and would have a "(>" only in the middle of a statement in progress. You may want to quit your session, restart, and try again.

sri2002

Hi
Thanks. I restarted the session and this was my first line
consult=> CREATE TABLE SAUSMailingAddress (
But still the same error. It stops in between.

Any other ideas/pointers?
Thanks much
Sri🙁

LordShryku

Wow man, you got me stumped now. I don't see any errors when I do it, and I don't see any real errors in you post. Might be some kind of echo function in the SSH session. Could try regular Telnet. That's about all I can think of. Sorry.

DigitalExpl0it

if you can i recomend installing phpmyadmin

sri2002

I restarted the session and it worked. Now I get this error message:
NOTICE: CREATE TABLE will create implicit sequence 'sausmailingad_mailinglistid_seq' for SERIAL column 'sausmailingaddress.mailinglistid'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'sausmailingaddress_pkey' for table 'sausmailingaddress'

ERROR: Relation 'sausmailingad_mailinglistid_seq' already exists

Help pls.
Thanks
Sri

LordShryku

phpMyAdmin won't work for Postgres, but they do have a phpPgAdmin, and I would highly recommend using it. This error is telling you that the sequence 'sausmailingad_mailinglistid_seq' already exists, probably in another table. You can probably rename the field to get around this.

sri2002

Thanks that did the trick...Thanks a lot.
Thanks much
Sri