Tue, Jun 06, 2000 at 03:24:56PM -0300, The Hermit Hacker ÐÉÛÅÔ:
> 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 dis
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
[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 function-r
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?
>
>
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 address
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 "oceny_st
Mihai Gheorghiu <[EMAIL PROTECTED]> writes:
> 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.
Hm
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 composit
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} ]
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 '(int
Travis Bauer <[EMAIL PROTECTED]> writes:
> Is this the mod field of the Field class in JDBC2?
Sounds right, but I haven't looked at the JDBC code.
> Does -1 alway mean, for
> numeric types, that the precision is undefined?
Right. In general, -1 is the default typmod if Postgres doesn't have
an
Hi,
Since everyone here has been so helpful in the past (even when I recently
overlooked something obvious in The Fine Material), I wonder if I might get
a pointer about what to do in this case.
I have a table mapping names to ips; the access to users is through PHP3.
Now, PHP's module to Postg
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, P
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
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
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
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:
> >
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.
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 tha
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
/* -
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]
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
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 lo_exp
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
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 o
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
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
---
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
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
>
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
`/usr/local/pgs
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 th
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.
> #inclu
32 matches
Mail list logo
