On Sun, Jun 12, 2005 at 12:24:30PM +0900, Tatsuo Ishii wrote:
> Thank you for interested in PostgreSQL CE. There is a sample
> examination problems page:
>
> http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
>
> You could find some idea what the exam looks like.
My mind broke parsin
> I just noticed that SRA has English language certification now,
> available at a nationwide testing center. That's cool. Only the
> "Silver" is in English so far, the Gold looks more interesting.
>
> There is no syllabus or books that I could find, but I am taking the
> test next wednesday. I
On Sat, 2005-06-11 at 13:29 -0400, Tom Lane wrote:
> Neil Dugan <[EMAIL PROTECTED]> writes:
> > I have been having some trouble with a particular table view. An UPDATE
> > command is not only changing the applicable record it is also creating a
> > new record as well.
>
> I think it's because you
"Ed L." <[EMAIL PROTECTED]> writes:
> But still wondering why 110mb request cannot be satisfied from 2.91gb of =
> free mem or 3.2gb os buffer cache?
Presumably, the shmem segments already in existence are eating almost
all of your kernel SHMMAX limit.
regards, tom lane
-
On Fri, Jun 10, 2005 at 07:24:49PM -0400, Eric E wrote:
> Hi all,
> I'm working on implementing a function in PL/PERL that will ready
> many rows. As such I'd like to use return_next to keep memory usage
> down. When I call return next, I get the following error message:
>
> ERROR: error from P
IpcMemoryCreate:
shmget(key=9099001, size=110002176, 03600) failed: Not enough
space
This error usually means that PostgreSQL's
request for a sharedmemory segment exceeded available memory or swap
space.To reduce the request size (currently 110002176 bytes),
reducePostg
I have an HP ia64 11.23 server with 16gb of
RAM running 6 pgsql clusters. I'm seeing this old error when attempting to
restart a legacy 7.3.4 cluster after a power outage:
./postmaster successfully
startedIpcMemoryCreate: shmget(key=9099001, size=110002176, 03600) fail
Neil Dugan <[EMAIL PROTECTED]> writes:
> I have been having some trouble with a particular table view. An UPDATE
> command is not only changing the applicable record it is also creating a
> new record as well.
I think it's because your UPDATE is updating supplier.account_type which
is part of the
hi Petar, thanks for your answer, I tried it and got this message:
ERROR: SELECT query has no destination for result data
HINT: If you want to discard the results, use PERFORM instead.
CONTEXT: PL/pgSQL function "fn_get_total_remitidoxprovisio
n1" line 5 at SQL statement
could you advice me
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> Honestly, I'd prefer to see pg_autovacuum improved to do O(n) rather
> than O(n^2) table activity. At this point, though, I'm probably not
> too likely to have much time to hack pg_autovacuum before 8.1 is
> released, although if it doesn't
Peter Fein wrote:
> As an uninformed, off-the-wall idea, could one compare snapshots of the
> system tables to generate these diffs? I know next-to-nothing about
> these, but it seems like they'd contain the info you'd need.
Here's another nutty idea: Could one create a (carefully designed) audit
From my point of view, any database versioning system would need to be
able to work with the same version control system that I use for my
code, so I can extract a fully-working system from any point in the past.
I'd be extremely happy if somebody finds such a system that is already
written
hubert depesz lubaczewski wrote:
hi
i guess this should be a simple question:
is it possible to use tsearch2 in a database where i have texts in
different languages?
i.e. it is a database of technical texts written in at least 4
different languages (english, polish, russian and german).
http://
John DeSoi wrote:
Russ,
On Jun 10, 2005, at 2:34 PM, Russ Brown wrote:
This certainly is a far more complex problem than I originally thought
it was. I'd like any solution to be able to work in any version
control system, and to be applicable to any database engine (my
employer is a MySQL ho
Peter Fein wrote:
Come on, we can't be the first people with this problem? Version
control's been around for what, 20, 30 years? Somebody must have tried
to do this before, even if it's with something other than Postgres...
That's what really surprises me too! I've looked around quite a bit
hi
i guess this should be a simple question:
is it possible to use tsearch2 in a database where i have texts in
different languages?
i.e. it is a database of technical texts written in at least 4
different languages (english, polish, russian and german).
probably more languages will be comming.
the
I have been having some trouble with a particular table view. An UPDATE
command is not only changing the applicable record it is also creating a
new record as well.
wholesale=# select * from accounts_supplier;
id | name | contact | addr| addr2 | town |
postcode | s
Karsten Hilbert wrote:
> On Fri, Jun 10, 2005 at 10:38:52AM -0500, Peter Fein wrote:
>
>
>>This is interesting... You'd want to be able to generate either a bunch
>>of CREATEs to create a schema from scratch or a 'patch' of ALTER
>>commands to move b/w arbitrary revisions or to a working copy (i
Hugo wrote:
Hi everybody
I am trying to write a stored procedure that returns a result set but
it is not working
this is the function:
///
CREATE OR REPLACE FUNCTION
remisiones.fn_get_total_remitidoxprovision1("numeric")
RETURNS SETOF record AS
$BODY$
begin
select rm.provision as provisio
Russ,
On Jun 10, 2005, at 2:34 PM, Russ Brown wrote:
This certainly is a far more complex problem than I originally thought
it was. I'd like any solution to be able to work in any version
control system, and to be applicable to any database engine (my
employer is a MySQL house, while I person
Hi everybody
I am trying to write a stored procedure that returns a result set but it is not working
this is the function:
///
CREATE OR REPLACE FUNCTION remisiones.fn_get_total_remitidoxprovision1("numeric") RETURNS SETOF record AS$BODY$begin select rm.provision as provision, drm.prod
Hi everybodyI am trying to write a stored procedure that returns a result set but it is not workingthis is the function:///CREATE OR REPLACE FUNCTION remisiones.fn_get_total_remitidoxprovision1("numeric")
RETURNS SETOF record AS$BODY$begin select rm.provision as provision, drm.producto
22 matches
Mail list logo
