On Sun, Jun 04, 2000 at 03:46:53AM +0200, Peter Eisentraut wrote:
Louis-David Mitterrand writes:
When creating a child (through CREATE TABLE ... INHERIT (parent)) it
seems the child gets all of the parent's contraints _except_ its PRIMARY
KEY. Is this normal?
It's kind of a bug.
Is
On Sun, 4 Jun 2000 03:46:46 +0200 (CEST), Peter wrote:
Kari Lempiainen writes:
Are there any monitor programs for administrator to find out what
operations are in progress
`ps' should work on many systems.
I know that. I mean to find out what is going on inside the database.
What queries
Hi,
Could somebody help me with this error. It appears when I try to compile
an ecpg program. It seems that it is something with the linking phase and
the ecpg library. Any ideas?
/usr/lib/libecpg.so: undefined reference to `crypt'
collect2: ld returned 1 exit status
Best regards, Jesus.
Marc Tardif wrote:
I'm writing a search engine using python and postgresql which requires to
store a temporary list of results in an sql table for each request. This
list will contain at least 50 records and could grow to about 300. My
options are either to pickle the list and store
Hi all,
I've a small table (3000 rows) that it's UPDATEd very frequently.
create table myTable(theKey char(6) primary key, theMsg varchar(256));
Of course pgSQL does create an index on theKey, to give
me referential integrity: it seems to me that when I do
a vacuum to reclaim unused space and
Do you use PostgreSQL and PHP?
phpPgAdmin is a port of the ever popular phpMyAdmin for MySQL. Most of the
functionality available through the MySQL version has been successfully
ported for use on Postgres (with a few Postgres specific features).
Features include:
* create and drop databases
*
Jesus Aneiros [EMAIL PROTECTED] writes:
Could somebody help me with this error. It appears when I try to compile
an ecpg program. It seems that it is something with the linking phase and
the ecpg library. Any ideas?
/usr/lib/libecpg.so: undefined reference to `crypt'
collect2: ld returned 1
Hello All! :)
I have a sequence that I use to get an unique default value for an
attribute in one of my tables. The sequence is incremented by one each
time I insert a new tuple in the table. Excellent! :)
An example:
Given the sequence 'serial' and the relation 'test':
Table test