On Sat, Jun 03, 2000 at 05:37:32PM -0500, Robert J. Sprawls wrote:
I'm trying to learn embedded SQL in C. However, it's not working
and reading the documentation is not answering my question(s). Here is my
Please check the test cases in the source tree. They help a little bit.
#include
Ed Loehr [EMAIL PROTECTED] writes:
Then, start this one in another bash window/terminal/whatever...
% while test 1; do echo -n "`date`: "; psql -d pdb -c "vacuum analyze;
select count(*) from foo;"; sleep 3; done
This seems to consistently crash after the first vacuum with the
following
hi,
i do not know what superuser account i made. so i am not able to do
initdb.. it says..
We are initializing the database system with username X
(uid=500).
This user will own all the files and must also own the server
process.
mkdir: cannot create directory
On Tue, 6 Jun 2000, Marcos Lloret wrote:
hi,
i do not know what superuser account i made. so i am not able to do
initdb.. it says..
We are initializing the database system with username X
(uid=500).
This user will own all the files and must also own the server
process.
Hello,
I have database with large objects?
I did following:
pg_dump database1 database.out
createdb database2
psql -e database2 database.out
And I can not access any large objects on database2.
database2=# select lo_export(picture_immage, '/home/postgres/image2.jpg')
from pictures where
Consider the following:
trbauer=# create table t1 (x numberic(3,2));
trbauer=# \d t1
Attribute | Type | Modifier
X | numeric(3,2) |
trbauer=# create view v1 as select x*2 from t1;
trbauer=# \d v1
Attribute | Type | Modifier
Tom Lane wrote:
Ed Loehr [EMAIL PROTECTED] writes:
Then, start this one in another bash window/terminal/whatever...
% while test 1; do echo -n "`date`: "; psql -d pdb -c "vacuum analyze;
select count(*) from foo;"; sleep 3; done
This seems to consistently crash after the first
Bryan White wrote:
I have a table with a unique index. When I go to insert a new value into
the table my code does not know if the record is already there. To me there
are two choices:
1) Do a select for the record and insert only if not found.
2) Do a blind insert and relay on the
What exactly is a "tuple"? One entire row of a table? Or one "line" of a
reply to a query? (I suspect it's the entire row of a table, but I have had
a case with text fields, where one field was updated with about 7k. All
selects would deal either with that field or the others. The first time the
On Tue, 06 Jun 2000, Ignas Saltis wrote:
Hello,
I have database with large objects?
I did following:
pg_dump database1 database.out
createdb database2
psql -e database2 database.out
And I can not access any large objects on database2.
database2=# select
Travis Bauer [EMAIL PROTECTED] writes:
Consider the following:
trbauer=# create table t1 (x numberic(3,2));
trbauer=# \d t1
Attribute | Type | Modifier
X | numeric(3,2) |
trbauer=# create view v1 as select x*2 from t1;
trbauer=# \d v1
What does 'STATEMENT' refer to in the following description for CREATE
TRIGGER?
CREATE TRIGGER name { BEFORE | AFTER } { event [OR ...] }
ON table FOR EACH { ROW | STATEMENT }
EXECUTE PROCEDURE func ( arguments )
Ron Peterson
[EMAIL PROTECTED]
On Tue, 6 Jun 2000, Robert B. Easter wrote:
pg_dump/all do not dump the large objects (AFAIK).
ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.4.tar.gz
might help you
Nice. Not announced, but users know it :-)
Test it anyone with 7.0?
Karel
/*
Ed Loehr [EMAIL PROTECTED] writes:
% while test 1; do echo -n "`date`: "; psql -d pdb -c "vacuum analyze;
select count(*) from foo;"; sleep 3; done
This seems to consistently crash after the first vacuum with the
following message:
This is a known gotcha that's got nothing to do with any
Is this the mod field of the Field class in JDBC2? Does -1 alway mean, for
numeric types, that the precision is undefined? If so, I could patch up
the ResultSet class to function properly. I traced through the
ResultSet code this morning.
Tom Lane wrote:
Ed Loehr [EMAIL PROTECTED] writes:
% while test 1; do echo -n "`date`: "; psql -d pdb -c "vacuum analyze;
select count(*) from foo;"; sleep 3; done
This seems to consistently crash after the first vacuum with the
following message:
This is a known gotcha that's
Can anyone point me to any online documentation on how to use the
'BETWEEN' operator/function? (As in "SELECT * FROM foo WHERE id BETWEEN
...")
Regards,
Ed Loehr
On Tue, 6 Jun 2000, Eugene Karpachov wrote:
Excuse me, but why postgresql team doesn't release patches? I mean something
like postgresql-7.0-7.0.1.diff.gz etc. It is big waste of traffic to download
all the source distribution again.
we've tried in the past, and so far nobody has been able
I keep seeing the following whenever there is a new client connection to the
database:
Error semaphore semaphore not equal 0
anyone know what this means? Thanks.
- Greg
I wanted to back up a database prior to upgrading to 7.0.2
pg_dump dbname dbname.bak
FATAL 1: Memory exhausted in AllocSetAlloc()
PQendcopy: resetting connection
SQL query to dump the contents of Table 'tblname' did not execute correctly.
After we read all the table contents from the backend,
Ed Loehr [EMAIL PROTECTED] writes:
Tom Lane wrote:
I can't reproduce any problem with just a "vacuum" (with or without
analyze) and no following command.
I did, however, notice that very occasionally the inserting process
would spit out weird error messages like "Function '(int4)' does not
Fellow postgresers:
According to the web site the following syntax is permitted:
PRIMARY KEY clause
SQL92 specifies some additional capabilities for PRIMARY KEY:
Table Constraint definition:
[ CONSTRAINT name ] PRIMARY KEY ( column [, ...] )
[ {INITIALLY DEFERRED | INITIALLY IMMEDIATE} ]
Hi,
I appreciate any help I can get on this...Recently, I've been experimenting
with the user defined base-types (using CREATE TYPE) with successful results.
But, when it comes to handling classes as composite types, things are not
as straight forward. Here is a case. Suppose I define a
At 10:53 AM 05-06-2000 +0200, Marcin Inkielman wrote:
On Mon, 5 Jun 2000, Lincoln Yeoh wrote:
I solved my problem simplier:
drop index oceny_stud_numer_albumu_protokol_id;
and
drop index oceny_stud_numer_albumu_protokoloceny_stud;
failed
so I used:
drop index
The pictures of the subscription CDs still show version 6.5. If I ordered a
subscritpion today, what version whould I get on CD?
**
The information contained in this E-Mail is confidential
and is intended only for the use of the
They are definitely v7.0 ... I've CC'd Jeff in to see about getting that
image updated ... thanks for the poiner ...
On Wed, 7 Jun 2000, George Dau wrote:
The pictures of the subscription CDs still show version 6.5. If I ordered a
subscritpion today, what version whould I get on CD?
[EMAIL PROTECTED] writes:
I appreciate any help I can get on this...Recently, I've been experimenting
with the user defined base-types (using CREATE TYPE) with successful results.
But, when it comes to handling classes as composite types, things are not
as straight forward.
The
Andrew Sullivan [EMAIL PROTECTED] writes:
I have a table mapping names to ips; the access to users is through PHP3.
Now, PHP's module to PostgreSQL does not know about the data type inet. I
could just forget about it, but it seems to me the inet data type offers a
number of advantages for
28 matches
Mail list logo