On Thu, 21 Sep 2000, Alexey Borzov wrote:
> Greetings, Tom!
>
> At 20.09.2000, 10:41, you wrote:
>
> TL> "Alexey V. Borzov" <[EMAIL PROTECTED]> writes:
> >> Nope, that's not the problem. I just checked and every DB has its own
> >> PG_VERSION. Besides, _all_ of the databases are accessed on reg
Well, thanks to everybody who helped!
It was indeed the problem with opening files - the limit was set
to 1024 with more than 100 possible backends...
Well, I suppose it wouldn't hurt to change the error message in
the future versions of Postgres, 'cause now it is somewhat..
Neil Conway wrote:
> > a BLOB. Conversely, Unix filesystems store directories as unsorted
> > lists, which are a lot slower to search than the database's
> > structured indexes.
> Wow, can anyone confirm this (with Postgres preferrably)? In talking
> with some developers at my old job, they all
Are there any type of replication features in postgresql 7.0?
I would like it where two databases have the same structure, but say at
midnight every night Database 1 synchs up database 2.
Granted, I could always write code to do that, but it wouldn't be very
sophisticated. (If I coded it, woul
On Thu, 21 Sep 2000, Adam Lang wrote:
> Are there any type of replication features in postgresql 7.0?
Not exist some standard solution for PG for DB replication ...
Maybe in a far future (via some WAL logs?).
Karel
Adam Lang wrote:
>
> Are there any type of replication features in postgresql 7.0?
>
> I would like it where two databases have the same structure, but say at
> midnight every night Database 1 synchs up database 2.
>
> Granted, I could always write code to do that, but it wouldn't be very
> sop
i believe that you can get that info from www.allstats.com.
we get our zipcode info from them quarterly.
mikeo
At 05:03 PM 9/20/00 -0700, Adam Haberlach wrote:
> Sometime in the past year, someone mentioned a database that
>contained zipcode, lat/long, and city information--does anyone
Could this possibly be done using triggers? I'm new to
postgres, but I know on a project I was doing using oracle
the dba could setup triggers to run on the OnInsert() (not
sure what it's actually called in oracle...). Do maybe
on the "OnInsert" of table foo you could do:
Insert into foo@remote
in effect, this turns the filesystem into a "poor-mans" balanced tree.
the rdbms gives you a "rich-mans" balanced tree, but along with the
overhead of the rdbms.
cheers
--e--
On Thu, 21 Sep 2000 15:20:39 +0300, Alessio Bragadini wrote:
> Neil Conway wrote:
>
> > > a BLOB. Conversely, Un
actually they're saying two different things :)
first, to explain my example a bit better:
the difference between this:
> > begin;
> > insert into foo (A,B) values (B);
> > select currval('foo_A_seq');
> > commit;
and this:
> > insert into foo (A,B) values (B);
> > select currval('foo_A
On Wed, 20 Sep 2000 21:24:17 -0400, Neil Conway wrote:
> I believe he is using straight Pg - the perl interface to Postgres.
> AFAIK, that's independant of DBI::Pg, which is the Postgres
> driver for DBI.
>
ahhh! "i see" said the blind man :)
> I agree with you, however: I've found DBD::Pg q
On Thu, 21 Sep 2000, Daryl Chance wrote:
> Could this possibly be done using triggers? I'm new to
> postgres, but I know on a project I was doing using oracle
> the dba could setup triggers to run on the OnInsert() (not
> sure what it's actually called in oracle...). Do maybe
> on the "OnInsert
Actually, it looks like currval is defined to give the
value last used in your session. So, the second case
(not in transaction) should still always give the
value of the last nextval, assuming they're part of
the same session.
Stephan Szabo
[EMAIL PROTECTED]
On Thu, 21 Sep 2000, Edward Q. B
Perhaps I was too brief before, wanting to spare folks long quotes from the manual
that we all have, but here goes (quoting from
http://www.postgresql.org/users-lounge/docs/7.0/postgres/sql-createsequence.htm):
"After a sequence is created, you may use the function nextval(seqname) to get a ne
14 matches
Mail list logo
