Thanks everyone for the help. I have it working now. Unfortunately I'm not
sure why it wasn't working before or what was causing the problem. I spent
all day taking piece after piece out of my "logging package" (Depesz - this
is a program that I wrote and modified over the past few years) until I
found the part that was causing the error. I was still unable to figure out
why this particular part wasn't working so I just replaced it with some
other code I had for a different project that was based off of this problem
code. Long story short, it's working now, but I'm not sure why it's working
this way but not the other way. Hopefully sometime soon I'll have time to go
back and figure out what happened. If I do, I'll let ya'll know!
Thanks again for the help!
Matt
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, November 14, 2012 2:03 PM
To: Matthew Kuss
Cc: depesz@depesz.com; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #7657: Create Table doesn't create columns
"Matthew Kuss" <matt@rigminder.com> writes:
> Depesz -
> I'm fairly sure it's not a problem with something I'm doing wrong because
I've used the same code before. It has to be something wrong on the DB side.
But just to entertain you I did as you requested:
> RigMinder_NewDBTest02=# \d test
> Table "public.test"
> Column | Type | Modifiers
> --------+------+-----------
> RigMinder_NewDBTest02=#
> Before I ran this I created a table using the following:
> create table "test" ("column1" text, "column2" float);
Hm ... maybe that's creating the table somewhere other than schema public?
What have you got search_path set to? Try
\dt *.test
to see if there's more than one table named "test".
regards, tom lane