On Fri, Jul 07, 2006 at 09:09:22AM -0700, Richard Broersma Jr wrote:
> I think that in twenty years, I think most of us will be more worried about
> our retirement than
> the long terms data conserns of the companies we will no longer be working
> for. :-D
You may want to take precautions now s
Magnus Hagander wrote on 08.07.2006 06:21:
This looks exactly like the issues we've seen with broken antivirus or
personal firewall software. Make sure you don't have any such installed
(actualy installed, not just enabled), and if you do try to uninstall
them. If you don't, but had before, check
>
> Unfortunately it would appear that I cannot vacuum full either as I get an
> out of memory error:
>
>
> # - Memory -
>
> shared_buffers = 5000 # min 16, at least max_connections*2, 8KB
> each work_mem = 131072 # min 64, size in KB
> maintenance_work_mem = 524288 # min
> [mailto:[EMAIL PROTECTED] On Behalf Of
>
> On 7 Jul 2006 12:50:22 -, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> > What is the most appropriate way to migrate a database form
> Sybase (SQL Anywhere 5.504) to Postgres? I found some
> shareware of freeware migration tools on the net,
pg_config is telling us that we are running version 7.3.6-RH, but when
we start psql it shows that we are running 8.1.4 (which is the correct
version).
[EMAIL PROTECTED] bin]$ pg_config --version
PostgreSQL 7.3.6-RH
[EMAIL PROTECTED] bin]$ which postmaster
~/bin/postmaster
[EMAIL PROTECTED]
their forum on sf seems inactive, so i ask in this group to see if
anyone know the status
Q. is OpenFTS dead ? or the current beta is alreay mature enough to be
used in production?
FTS will get more and more important for a DBMS system, i think pgsql
should also consider improving this, isn't?
I'm inserting data into two tables, the second table has a forigen key that
points to the primary key of the first table.
After I insert a row into the first table, I need to take the primary key
value created in "SERIAL" column and store it so I can insert it as the
forigen key value on the s
I think I found the answer, you use the CURRVAL() function.
Just to cover all the bases, consider this scenario in chronological order:
1. You insert data and the primary key is set to 20.
2. Someone else inserts data and the next key is set to 21.
3. If you call currval() will it return 20?
> I think I found the answer, you use the CURRVAL() function.
>
> Just to cover all the bases, consider this scenario in chronological order:
> 1. You insert data and the primary key is set to 20.
> 2. Someone else inserts data and the next key is set to 21.
> 3. If you call currval() will it r
On Jul 8, 2006, at 9:57 , [EMAIL PROTECTED] wrote:
FTS will get more and more important for a DBMS system, i think pgsql
should also consider improving this, isn't?
I believe a very common FTS solution used with PostgreSQL is
tsearch2, which is included in contrib/. Have you looked at tsea
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> > 3. If you call currval() will it return 20? I would think it does.
Yes it does.
> My understanding is that it will provided your are within a transaction.
As long as you're in the same session you're fine. You would have to go out of
your w
> > > 3. If you call currval() will it return 20? I would think it does.
>
> Yes it does.
>
> > My understanding is that it will provided your are within a transaction.
>
> As long as you're in the same session you're fine. You would have to go out of
> your way to break it but if you're usin
12 matches
Mail list logo
