From: | Memphisto <szoli(at)valerie(dot)inf(dot)elte(dot)hu> |
---|---|
To: | PostgreSQL mailinglist <pgsql-general(at)postgreSQL(dot)org> |
Subject: | No clue for embedded SQL |
Date: | 1998-10-08 13:14:06 |
Message-ID: | Pine.GSO.3.96.981008150654.21140A-100000@valerie.inf.elte.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm sorry to say that I have no clue what happens within PgSQL when I try
to run my (still examplar) SQL programs. This time I just try to write a
little program that does _anything_ in the database, without success. I
know it's weird, but don't know why does not anything happen.
Here's a little app that supposed to create a table called perftest in
the DB 'szoli1'. It doesn't do that and does not reports errors, too.
Meanwhile with the same account I can do it manually.
What went wrong?
Thanks in advance
Sebestyén Zoltán
#include <stdio.h>
#include <sys/time.h>
#include <unistd.h>
exec sql include sqlca;
exec sql whenever sqlerror sqlprint;
exec sql whenever not found sqlprint;
int main()
{
exec sql begin declare section;
long i;
exec sql end declare section;
exec sql connect 'szoli1';
exec sql create table perftest(number int4, ascii varchar(16));
exit(0);
}
--------------------------------------------------------------------------------
Sebestyén Zoltán AKA Memphisto It all seems so stupid,
it makes me want to give up.
szoli(at)neumann(dot)cs(dot)elte(dot)hu But why should I give up,
when it all seems so stupid?
MAKE INSTALL NOT WAR And please avoid Necrosoft Widows
From | Date | Subject | |
---|---|---|---|
Next Message | Memphisto | 1998-10-08 14:11:44 | to my last letter about embedded SQL |
Previous Message | Jun Kuwamura | 1998-10-08 08:51:38 | [pgsql-jp 5574] Re: Is array_iterator.c work? (fwd) |