I am writing a C program which includes embeded SQL.
When I compile it with gcc, I am told:
'EXEC' undeclared (first use in this function)
Must I include a special library to use embeded SQL?
Thank you very much,
Rosa M. Carro
--
Rosa Maria Carro Salas
Dpto. Ingenieria Informatica
Univers
Hi,
I have just installed PostgreSQL on
SCO OpenServer 5.05 but I am having problems creating a database. My pg_hba.conf
file reads:
local
all
trusthost
all
127.0.0.1 255.255.255.255
trust
When I try to create a dat
On Mon, 13 Dec 1999, Mark Alliban wrote:
> Postgres$ createdb test
> Connection to database 'template1' failed.
do
initdb
You just don't have "default" database.
mazek
I have already done this, and it completed successfully.
There is a /usr/local/pgsql/data/base/template1 directory with a lot of pg_
files in it.
Mark.
>> Postgres$ createdb test
>> Connection to database 'template1' failed.
>do
>initdb
>You just don't have "default" database.
>mazek
*
On Mon, 13 Dec 1999, Mark Alliban wrote:
> I have already done this, and it completed successfully.
> There is a /usr/local/pgsql/data/base/template1 directory with a lot of pg_
> files in it.
You may chceck if postmaster is running...
mazek
"Ross J. Reedstrom" wrote:
>
> Hmm, sounds like a vote for nested transactions. The JDBC driver developer
> (Peter Mount) was musing that nested transaction would make large object
> support easier for him, as well.
>
> As to the other example of Oracle not forcing a rollback, I have a feeling
>
Yes the postmaster process is running.
nohup postmaster -i >pgserver.log 2>&1 &
The log file is empty until I try to create the database, then it gives the
error.
>> I have already done this, and it completed successfully.
>> There is a /usr/local/pgsql/data/base/template1 directory with a lot of
On Mon, 13 Dec 1999, Mark Alliban wrote:
> Yes the postmaster process is running.
> nohup postmaster -i >pgserver.log 2>&1 &
> The log file is empty until I try to create the database, then it gives the
> error.
then the last thing I can think of, is location of data files:)
chceck enviromant var
Wim Ceulemans <[EMAIL PROTECTED]> writes:
| I can't seem to install the latest postgresql opn Suse linux 6.3 (kernel
| 2.2.13, glibc 2.1.2). I always get the following message when I run
| ./configure :
|
| checking for c++... c++
| checking wheather the C++ compiler (C++ ) works...
"Ross J. Reedstrom" wrote:
>
> Hmm, sounds like a vote for nested transactions. The JDBC driver developer
> (Peter Mount) was musing that nested transaction would make large object
> support easier for him, as well.
>
> As to the other example of Oracle not forcing a rollback, I have a feeling
>
The environment variables are set OK and export'd.
>> Yes the postmaster process is running.
>> nohup postmaster -i >pgserver.log 2>&1 &
>> The log file is empty until I try to create the database, then it gives
the
>> error.
>then the last thing I can think of, is location of data files:)
>chcec
Hello,
when I vacuum analyze my db (6.5.3 on Linux) I cannot access
some data afterwards because the vacuum terminates with
ERROR: Tuple is too big: size 8596
I did pg_dump -o and read in back again, still the same error.
Eg. accessing data after vacuum results in
SELECT envpart_map.*,
Marcin Mazurek - Multinet SA - Poznan wrote:
> Hi,
> I'm put several gifa into a table. I did as a exercise:) form psql using:
> INSERT INTO images (id, data)
> VALUES (3, lo_import('/usr/local/apache/servlets/images/a.gif'));
are you sure this lo_import(...) thing in the SQL will work? I hav
I'm seeing a few intermittent show-stopper errors (some of which I've asked
about previously in these forums) which go away after vacuum is run. Pgsql
documentation recommends to vacuum nightly or after copying a large class
(not sure exactly what that means) or deleting a large number of records
Hello,
I am using PostgreSQL 6.4.2. and it seems I can't create indexes on BOOL
columns. I tried this:
$ psql template1
template1=> CREATE DATABASE test\g
CREATEDB
template1=> CREATE TABLE users (id INT DEFAULT 0 NOT NULL,name TEXT,preferred_name
I've upgraded to 6.5.3 from RPM but 'set client_encoding' still says
'unknow variable'. How can I know whether RPM was compiled
with --enable-locale and --with-mb=LATIN2? And if it wasn't,
could I humbly suggest it for next version?
If I knew it wasn't compiled with the right options, I could ju
Robert wrote:
>
> I've upgraded to 6.5.3 from RPM but 'set client_encoding' still says
> 'unknow variable'. How can I know whether RPM was compiled
> with --enable-locale and --with-mb=LATIN2? And if it wasn't,
> could I humbly suggest it for next version?
The default 6.5.3-2 RPM's are compiled
Question: is it safe to insert/update/delete during VACUUM?
Ed
On 13 Dec 1999, Manuel Lemos wrote:
> Hello,
>
> I am using PostgreSQL 6.4.2. and it seems I can't create indexes on
> BOOL columns. I tried this:
>
> ...snip...
>
> However, if I change the BOOL type to CHAR (1) it works.
I'm not a developer, so I don't know if it's a bug or a logic error
y
On Sat, 11 Dec 1999, Wim Ceulemans wrote:
> I can't seem to install the latest postgresql opn Suse linux 6.3 (kernel
> 2.2.13, glibc 2.1.2). I always get the following message when I run
> ./configure :
>
> checking for c++... c++
> checking wheather the C++ compiler (C++ ) works... no
> conf
Peter Eisentraut wrote:
>
> On 1999-12-13, Lamar Owen mentioned:
>
> > The default 6.5.3-2 RPM's are compiled with --enable-locale, but not
> > with --with-mb=LATIN2.
>
> Perhaps the next set of RPMs could be compiled with --enable-locale and
> --with-mb=SQL_ASCII. At least do it like now: the
On 1999-12-13, Lamar Owen mentioned:
> The default 6.5.3-2 RPM's are compiled with --enable-locale, but not
> with --with-mb=LATIN2.
Perhaps the next set of RPMs could be compiled with --enable-locale and
--with-mb=SQL_ASCII. At least do it like now: the non-locale/non-multibyte
version for perf
Hi,
when trying to precompile the following code with
> ecpg -I/usr/include/pgsql ecpg_test.pc
I am getting the following error message
ecpg_test.pc:27: invalid datatype 'zipcode_record'
this is probably something very simple, but I don't get this error,
when processing the code with Oracle.
I
23 matches
Mail list logo
