Certainly an interesting article. Alot of negative comments about existing
OODBMS. Personally I have been using a persistence layer to acheive similiar
results on top of postgres. The main drawback is the speed degradation
imposed by the persistence layer. The upside is that I have direct mapping
Hallo!
I temporary solved the problem with the sequences by making a query:
select id from ports order by id desc limit 1;
But I am not convinced this is "the real way" to get the number of element
the table ports has
Saluti!
Ludwig
---(end of broadcast)
Keystone not withstanding (we didn't like it much), can anyone recommend a
good tracking system that runs with a PgSQL backend, and, at minimum,
would provide the ability for a client to have a login id/pass that they
can login to add/comment on/close and view their own tickets, while our
help de
Thanks for the responses to my question.
Tried the RH rpm's and fell into endless layers of
dependencies.
Solved the problem with purchase of Red Hat 7.1.
I always appreciate the efforts that listers make.
Hope to repay in kind.
-Bill
--- Trond Eivind Glomsrød <[EMAIL PROTECTED]> wrote:
Occasionally and without warning I get this from my daily vacuum
cronjob:
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
I don't understand what these mean. Should I be concerned about them
and what do they signify?
--
creaky halls
PGP
> In the table, you're storing the OID of the large object itself, so if you
> copy all the contents of the table, so far as I can see, yes, you'd still
> have the reference to your large object.
Thanks. I did see this in a quick test, but I wasn't sure if the data would
be removed when I droppe
On Fri, 4 May 2001 [EMAIL PROTECTED] wrote:
> On Fri, May 04, 2001 at 12:48:24PM -0400, Joel Burton wrote:
> >
> > What is the system call? Could you do this in pl/tclu, the
> > untrusted version of pl/tcl?
> >
>
> I don't know anything about pl/tcl and all
> that stuff. I will take a look l
On Fri, 4 May 2001 [EMAIL PROTECTED] wrote:
> On Fri, May 04, 2001 at 12:47:02PM -0400, Joel Burton wrote:
> >
> > Hmmm... this raises an interesting question.
> >
> > Would it be possible to hook into (via trigger or other mechanism) so that
> > we could execute a function on commit? There are
Hallo!
I created several tables using a id-sequence for each:
create sequence portid;
create table ports(id integer primary key default nextval('portid'), name
varchar);
Now, since it is a web-application I am working on, I have several
Perl-scripts acting on/with the database.
THe informations
On Fri, 4 May 2001, David Wall wrote:
> Sorry to bother you personally, but I read your "Updating columns in PostgreSQL
>tables effectively" page and had a question.
>
> Will the temporary table scheme work if the table contains blobs (identified by
>OIDs)? In my case, I don't need to preserv
> CLASSPATH=/usr/lib/java/lib/classes.zip:/usr/share/java/postgresql.jar:.
> /export/home/markm/Java/test > java SimpleConnection org.postgresql.Driver
> jdbc:postgress://l2/template1 markm xxx
> java.lang.NoClassDefFoundError: java/util/ArrayList
> I built Postgresql myself with the java opti
Maybe this helps you:
starttime datetime default now(),
endtime datetime default (now() + interval('1 hour'))
- Original Message -
From: "Stuart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 2001. április 30. 21:18
Subject: [GENERAL] datetime arithmatic
> Folks,
>
> I am new to
I'll quote Thomas F.O'Connell on this one as it has been discussed just
some days ago:
first of all, i recommend checking out the syntax for the CREATE TABLE
command. it's available here:
http://postgresql.readysetnet.com/users-lounge/docs/7.1/postgres/sql-cre
atetable.html
for a quick exampl
On Sat, May 05, 2001 at 02:33:22PM +0200, Gyozo Papp wrote:
> Ok. I'm looking for another solution.
>
> The reason why I'm not dealing with sequence's increment is that
> there is no way to set an appropiate limit, sometimes I need 5, sometimes 17.
CREATE TABLE myseq (
val integer NOT
Ok. I'm looking for another solution.
The reason why I'm not dealing with sequence's increment is that
there is no way to set an appropiate limit, sometimes I need 5, sometimes 17.
Thanks for your help,
Papp Gyozo
- [EMAIL PROTECTED]
- Original Message -
From: "Tom Lane" <[EMAIL PR
On Sat, May 05, 2001 at 01:49:31PM +0700, Muhammad Rusydi wrote:
> Hi,
> if i have created this tables:
> create table lab (
> kd_lab varchar(4) check (kd_lab ~'[0][1-4][0-9][0-9]'),
> name varchar(10),
> primary key (kd_lab));
>
> create table tb2 (
> kd_lab varchar(4) references lab (kd_lab),
>
Hi Anand,
> basically copy the table to some other table..
> Drop the old table..
> recreate it with the constraints changed
> Repopulate the table..
would you show me with my two tables?
is it like this?
> >if i create another table named lab2 with same fields and then i move
> >all tuples from
basically copy the table to some other table..
Drop the old table..
recreate it with the constraints changed
Repopulate the table..
Hope this helps
Anand
On Sat, May 05, 2001 at 01:49:31PM +0700, Muhammad Rusydi wrote:
>Hi,
>if i have created this tables:
>create table lab (
>kd_lab varchar(4) c
18 matches
Mail list logo