Tod McQuillin wrote:
> On Wed, 1 Nov 2000 [EMAIL PROTECTED] wrote:
>
> > The db schema we have need to do a cycle references. I.e.,
> > an attribute in table_1 references the key in table_2 and
> > an attribute in table_2 references the key in table_1. However,
> > PostgreSQL does not allow us t
I have a database of questions and I would like to be able to pull them
out randomly from the database using query.
I'm thinking of something along the lines of:
SELECT random() as RND,question
FROM Problems
ORDER BY RND;
Where random() is a user defined or built in function that returns a
ran
> Has anyone considered enabling truly globally unique identifiers (outside
of the data tree)? This could be done by concatenating the MAC Address(or
decimal equivalent) of Eth0 to generated OID's.
MAC Ethernet addresses aren't guranteed to be unique. On the other hand,
what if a host has no
Frank Miles <[EMAIL PROTECTED]> writes:
> query: delete from units where unit_id = 5;
> ProcessQuery
> /opt/pgsql/bin/postmaster: reaping dead processes...
> /opt/pgsql/bin/postmaster: CleanupProc: pid 21004 exited with status 139
> Server process (pid 21004) exited w
Matt Beauregard <[EMAIL PROTECTED]> writes:
> I get the following error trying to make my backups:
> !2188 marauder@bofh:~$ pg_dump -h tweedledee -D ds >ds_1108.sql
> getTypes(): SELECT failed. Explanation from backend: 'ERROR:
> Relation 'pg_user' does not exist
Hmm, did you do something silly
=?iso-8859-1?Q?Micha=EBl_Fiey?= <[EMAIL PROTECTED]> writes:
> I'm looking for an explanation of the variable PGBUFFERS.
That's easy: it doesn't exist. Perhaps it did once, but I see
no such animal in current sources, nor as far back as 6.5.
There is an NBuffers (-B switch) ... is that what you
* Limin Liu <[EMAIL PROTECTED]> [001107 19:11] wrote:
> Hi,
>
> I am new in PostgreSQL and have a simple question:
> Is there any way we can find out which db the current client is working
> with?
>
> In psql, the prompt tells us the current open db, but I may need to
> access that information i
Dear Mailing List,
I would like to know more about Postgresql's applications in scientific
areas. In addition, I am interested in performance issues. For example,
how fast are SQL queries processed in comparison to other databases. Do
applications exist in which this issue was crucial? Any pointe
Hi,
I am new in PostgreSQL and have a simple question:
Is there any way we can find out which db the current client is working
with?
In psql, the prompt tells us the current open db, but I may need to
access that information in a C client on the fly with may db opened. I
wonder if this is possi
How is the support for embedded database applications? has it been used
in embedded environment?
dbadmin point of view?
What is the largest installation of postgresql?
Sandeep
Greetings !
How could I support images types ?
How could I support binary data types ?
I have read about support to blob type usind oid, but in this model I have
to use a native functions . is that the only way to work with images ?
thanks
Michel
_
Thanks,
I had allready played around with those files with elog(DEBUG,...), but
elog(...) did never do any output. But when you confirmed that those were
the files, Ive used fprintf(stderr,...) instead and it worked.
Why does not elog(DEBUG,...) work everywhere?
Well who cares, _NOW_ when I kno
Yes, I just did the awhile back :)
Its time stamped and outputs a file which can be globbed in via. psql. This
way you can check for errors before you go insert.
Yann
Here is my version of the script:
#!/usr/bin/perl
#dvf=> \d products
##Table "products"
# Attribute | T
Hi,
I would like to compile my simple test program, but I need to use static
compilation.
I'm using postgres 7.0.2 on debian 2.2 .
Enviroment settings:
LD_LIBRARY_PATH=/usr/local/pgsql/lib
The whole install was done following readme in sources downloaded from
www.postgresql.org
I compile this
On Mon, Nov 06, 2000 at 04:14:51PM +1000, Sean Weissensee wrote:
> We have 2 Web Servers running,
>
> what I like to do is have the postgres DB on a file server so that
both Web Servers can access this information,
I'm pretty sure that this won't work. You would be better to run one
database se
I defined a procedure
CREATE FUNCTION meta_class (varchar) RETURNS varchar AS '
...
' LANGUAGE 'pltcl';
This works fine. But when I want to call it from another tcl procedure I
get errors:
bf2=# CREATE FUNCTION foo (varchar) RETURNS varchar AS '
return [meta_class $1]
' LANGUAGE 'pltcl';
b
Here is a sample of the code which demonstrates the memory problem I am having. The
problem does not occur immediately after memory has been maxed
out. It appears that there is an attempt to recover some memory, about 1 Kbytes,
once max is near. This works for about a half a day to one full
We have 2 Web Servers running,
what I like to do is have the postgres DB on a file
server so that both Web Servers can
access this information,
1). Do I copy the /var/lib/pgsql tree to the file
server ?
Is this all I need to
copy.
2) The file server is a Samba server, is this going
Tom Lane wrote:
>
Thanks for doing it ;)
I have some comments too ...
> One of the
> longest-running parts of the discussion had to do with giving good error
> messages and how it is hard to get friendly messages when you rely on the
> database to do error checking. I thought this pointed up t
I get the following error trying to make my backups:
!2188 marauder@bofh:~$ pg_dump -h tweedledee -D ds >ds_1108.sql
getTypes(): SELECT failed. Explanation from backend: 'ERROR:
Relation 'pg_user' does not exist
How can I fix the error without losing any of our data, or at least
get my dumps wo
the following behavior seems like a bug.
in postgresql-ODBC, an INSERT which fails because of a referential integrity
problem silently fails without returning an error codes.
however, running the same INSERT at the command line with psql properly fails. i've
searched
the source for some time
You have 2 small mistake that I point below.
On Sat, 4 Nov 2000, Kisala Muhavi wrote:
> #!/usr/local/bin/perl
> #
> #perl sample program
>
> use pg;
use Pg;
>
> $conn =pg::connectdb("dbname=test");
> die $conn->errorMessage unless PGRES_CONNECTION_OK eq $conn->status;
>
> print "Enter User na
I tried mailing this last week, but I think it didn't get sent:
I defined a procedure
CREATE FUNCTION meta_class (varchar) RETURNS varchar AS '
...
' LANGUAGE 'pltcl';
This works fine. But when I want to call it from another tcl procedure I
get errors:
bf2=# CREATE FUNCTION foo (varchar) RETUR
Hello,
Has anyone considered enabling truly globally
unique identifiers (outside of the data tree)? This could be done by
concatenating the MAC Address(or decimal equivalent) of Eth0 to generated
OID's. Since the MAC is unique in the world (we would hope), and the OID is
unique within the se
Hi,
Does pg have "default timestamp" and "default autoinc" as default values
(used in CREATE TABLE).
And where is the PostgreSQL reference guide. Or actually/maybe how do I make
html files of the sgml files that are included with the CVS tree (what do I
need, jade? and where do I get it?)?
// J
Hello all:
I have a simple database which is now exhibiting some strange symptoms.
The most obviously sick is where I try to delete a record in a table, and
get the response:
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend
Hi,
i'm searching for documentation about instruments
that postgresql offers about distribution of databases on different machines
and
comunications beetwen the dbs.
Thank you.
Enrico Mangano
NETHOUSE S.r.l.Cso Re Umberto I, 57 - 10128
Torino - ITALYTel. +39-011-581.581 - Fax +39-011-5
When upgrading from 6.5 to 7.0 we backuped all data with pg_dump and
so we lost our blobs. I just have the xinv and xinx-files from a
file-backup. The blobs are stored in the xinvx-files, but there is
a long leading header. Can anyone point me to the exact format of this
files, so I can write
The Hermit Hacker wrote:
>> Also, as an FYI, I'm getting 404s trying to browse the archives of that
>> list at any recent link off of
>> http://www.postgresql.org/mhonarc/pgsql-announce/
>
> Okay, just loaded up that link here and it came up quick, so not sure why
> the 404 errors ... are you
Is CurrentMemoryContext a postgres symbol that I can link against?
Sorry if this is not a postgres question, it may be down to my ignorance
of C, perl or something else.
I've got a bit of code (a stemmer written in C) that I want to make
accessable to postgres, as a .so, and perl. The .so bit wo
Hi!
I'm rather new on pgsql and on this list, so forgive me if this question has been
asked (and answered) before. But I could not find a answer on the webstite or the
archive. The question is, are there any recovery tools if a database has been
corrupted?
My db (that is one table) has been d
31 matches
Mail list logo
