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
You aren't including the crypt library, or your system doesn't have
it. Try adding
-lcrypt
to the end of your compile command and try again.
At 12:44 PM 6/4/00, Jesus Aneiros wrote:
>Hi,
>
>Could somebody help me with this error. It appears when I try to compile
>an ecpg program. It seems tha
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 retu
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 to
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
*
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
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.
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 q
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 b