Michael Glaesemann wrote:
On Sep 19, 2007, at 23:13 , C wrote:
ERROR: insert or update on table "clients" violates foreign key
constraint "the_title"
DETAIL: Key (ticode)=( ) is not present in table "titles".
Sorry, I have no idea where I am going wrong...Any help would be great
You've
Hi
I have a question regarding foreign keys, I just cannot get it to create
them for meI must be doing something wrong but I have no idea what
that might be :)
I have a table "clients"
clientID (primary)
ticode
Firstname
SecondName
I have a second table "titles"
ticode (primary)
Title
Hi
Just a quick one, I have been around Postgres for a little while and
have never found an answer to this.
Can you numerically sort a set of integers stored in a char column, I
guess change the cast of the column for the "sort by" process.
and, if you can how...Unfortunatly I have no choi
On Mon, 30 Aug 2004, Wes Palmer wrote:
> PostgreSQL: 7.4.1
>
> Last week, I had a corrupt index on one table with 2 million rows. On a
> specific search, the database would SEGV. I dropped and recreated the index
> involved in the search, and did a REINDEX on the primary key. That problem
> went
