> Not sure --- when are you thinking of, and what was the context?
> I don't usually keep sample data unless the issue still seems open.
I was referring to a dump I provided a link to you called
"pg83-leads-sanitized.db" which was around 20 Dec, with email subject "Re:
[GENERAL] 8.3b2 XPath-based
"Matt Magoffin" <[EMAIL PROTECTED]> writes:
> Do you still happen to have that
> database dump I provided to you previously?
Not sure --- when are you thinking of, and what was the context?
I don't usually keep sample data unless the issue still seems open.
> I also noticed these in my log file,
> This was reported before,
> http://archives.postgresql.org/pgsql-general/2007-12/msg00716.php
> but neither he nor you have provided anything approximating a
> reproducible test case. The interactions with libxml are messy
> enough that I'm not even going to think about fixing this without
> a t
"Matt Magoffin" <[EMAIL PROTECTED]> writes:
> Hello, I'm using 8.3b4 and keep experiencing server crash when I execute
> various queries using XML functions. The crash backtraces look like this:
This was reported before,
http://archives.postgresql.org/pgsql-general/2007-12/msg00716.php
but neither
Hello, I'm using 8.3b4 and keep experiencing server crash when I execute
various queries using XML functions. The crash backtraces look like this:
---
Program received signal EXC_BAD_ACCESS, Could not access memory.
Reason: KERN_INVALID_ADDRESS at address: 0x3f847ae1
0x004b140c in xmlCleanupCharEn
On Dec 17, 2007 6:56 PM, Matthew Dennis <[EMAIL PROTECTED]> wrote:
> in 8.3beta3
>
> create table t0(c1 int);
> create table t1(c1 int);
>
> insert into t0 values (1);
> insert into t0 values (2);
> insert into t0 values (3);
>
> If I execute "delete from t0 returning *" it deletes the rows and r
in 8.3beta3
create table t0(c1 int);
create table t1(c1 int);
insert into t0 values (1);
insert into t0 values (2);
insert into t0 values (3);
If I execute "delete from t0 returning *" it deletes the rows and returns
the deleted rows. I could insert all those rows into t1 by doing "insert
into
On Monday 17 December 2007 3:10 pm, hjenkins wrote:
> Hello, all,
>
> >Dave Page writes:
> >pgAdmin will copy arbitrary blocks of cells to spreadsheets, and will
> >accept rows pasted into the edit grid. It should work out of the box
>
> with >Excel and OpenOffice - if not, check the copy delimiter
On Monday 17 December 2007 1:47 pm, Bill Moran wrote:
> In response to "hjenkins" <[EMAIL PROTECTED]>:
> > Some people in my workplace are asking if there exists a GUI that will
> > allow cut-and-paste of multiple cells directly from (and, preferably,
> > directly to) spreadsheets. pgAdmin III, PGA
On Mon, 17 Dec 2007, Bill Taylor wrote:
Since, I have not been able to re-install. I have tried thoroughly
cleaning machine and registry. The issue always comes back to
a 1920 error, do you have permissions in the event viewer
and always fails to start the service.
Have you wiped out whatever
DELETE FROM WHERE NOT IN (SELECT FROM ORDER BY
DESC LIMIT 50)
Sean Z. escribió:
Hi,
I need to write a maintenance function to delete oldest records of a
table, leaving only a certain number of records, say 50. The task
should run once per day. How can I write it?
The oldest record ca
> --- Original Message ---
> From: "hjenkins" <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Sent: 17/12/07, 21:10:46
> Subject: [GENERAL] spreadsheet interface
>
> Some people in my workplace are asking if there exists a GUI that will
> allow cut-and-paste of multiple cells di
Hi,
I need to write a maintenance function to delete oldest records of a table,
leaving only a certain number of records, say 50. The task should run once per
day. How can I write it?
The oldest record carries the smallest ID.
Thanks a lot!
Sean
__
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 17 Dec 2007 15:52:27 -0600
Bill Taylor <[EMAIL PROTECTED]> wrote:
> Hey,
>
> I am working on testing our windows version of software
> which uses postgress on a machine with XP Pro and 512
> meg of memory.
>
> The very first time I installed
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 17 Dec 2007 16:47:41 -0500
Bill Moran <[EMAIL PROTECTED]> wrote:
> In response to "hjenkins" <[EMAIL PROTECTED]>:
>
> > Some people in my workplace are asking if there exists a GUI that
> > will allow cut-and-paste of multiple cells directly
Hey,
I am working on testing our windows version of software
which uses postgress on a machine with XP Pro and 512
meg of memory.
The very first time I installed, it was fine except for the
fact it was only listening on the localhost 127.0.0.1
and I need it listening on its ip address.
Since, I
In response to "hjenkins" <[EMAIL PROTECTED]>:
> Some people in my workplace are asking if there exists a GUI that will
> allow cut-and-paste of multiple cells directly from (and, preferably,
> directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
> Any suggestions?
To add on
Adrian Klaver wrote:
-- Original message --
From: "hjenkins" <[EMAIL PROTECTED]>
Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III,
hjenkins wrote:
Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
Any suggestions?
By "spreadsheet" I'm going to assume you mean
-- Original message --
From: "hjenkins" <[EMAIL PROTECTED]>
> Some people in my workplace are asking if there exists a GUI that will
> allow cut-and-paste of multiple cells directly from (and, preferably,
> directly to) spreadsheets. pgAdmin III, PGAccess, and TOra d
Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
Any suggestions?
---(end of broadcast)-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
The dates have been confirmed. The new dates for the conference are
March 29th and March 30th (instead of the 28th and 29th). The
conference is being held at the University of Maryland, College Park.
The location is 10 minutes from Washington D
On Dec 17, 2007, at 12:10 PM, Matthew Hixson wrote:
This may be a tad off topic, but thought a PG enthusiast might have
some insight on this. Apple Mail sits on top of Sqlite. I was
wondering if it would be possible to substitute Postgres as the
underlying database. I do know how to vac
--- Sam Mason <[EMAIL PROTECTED]> wrote:
> On Mon, Dec 17, 2007 at 01:29:10PM -0500, Ted Byers
> wrote:
> > I routinely keep my SQL code distinct from my
> Perl,
> > java or C++ code. When a client program needs to
> do
> > something with the database, then either a child
> > process executes a
Not sure I can help much, I only read out of interest, but thought
clarifying a few things may help.
SHARMILA JOTHIRAJAH wrote:
Hi I had posted this in the slony mailing list but no luck in getting
any answers...Pls help me as I'm stuck with this error for the last 4
days
Im trying to replica
This may be a tad off topic, but thought a PG enthusiast might have
some insight on this. Apple Mail sits on top of Sqlite. I was
wondering if it would be possible to substitute Postgres as the
underlying database. I do know how to vacuum Sqlite to speed up
Mail, but with the massive amo
On Mon, Dec 17, 2007 at 01:29:10PM -0500, Ted Byers wrote:
> I routinely keep my SQL code distinct from my Perl,
> java or C++ code. When a client program needs to do
> something with the database, then either a child
> process executes a script I have written, if the
> client program doesn't need
Ted Byers wrote:
--- Colin Wetherbee <[EMAIL PROTECTED]> wrote:
Sam Mason wrote:
On Sun, Dec 16, 2007 at 06:31:56PM -0500, Colin
Wetherbee wrote:
If I write one Perl sub for each operation on the
table (e.g. one that
gets the username and password hash, another that
gets the last name and
Sam Mason wrote:
Luckily I've been able to design most of the programs I work on as
relatively simple layers over a database, I'm not sure if you're able to
work like this.
I'm not at liberty to divulge much of the application concept, but
consider, if you will, an application like Gmail or an
--- Colin Wetherbee <[EMAIL PROTECTED]> wrote:
> Sam Mason wrote:
> > On Sun, Dec 16, 2007 at 06:31:56PM -0500, Colin
> Wetherbee wrote:
> >> If I write one Perl sub for each operation on the
> table (e.g. one that
> >> gets the username and password hash, another that
> gets the last name and
On Mon, Dec 17, 2007 at 12:49:46PM -0500, Colin Wetherbee wrote:
> Because I know Perl a whole lot better than SQL, PostgreSQL, and even
> the Perl DBI, I'm always inclined to wrap the database stuff in a nice
> little package and forget about it. This method has worked well for me
> in the pas
On Mon, 2007-12-17 at 13:53 -0300, marcelo Cortez wrote:
> select chr(165);
> ERROR: requested character too large for encoding:
> 165
> it's one old scrip if not remember wrong works
> postgres in 8.2.4
> any clue?
http://www.postgresql.org/docs/8.3/static/release-8-3.html
"Ensure that chr()
Sam Mason wrote:
On Sun, Dec 16, 2007 at 06:31:56PM -0500, Colin Wetherbee wrote:
If I write one Perl sub for each operation on the table (e.g. one that
gets the username and password hash, another that gets the last name and
first name, etc.), there will be a whole lot of subs, each of which
Thanks to you guys for your help... I appreciate it a lot.
Now, I still have my SHR and RES growing up. How can I know the number at
which those values should stop?
On Dec 14, 2007 5:12 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Richard Huxton <[EMAIL PROTECTED]> writes:
> > Heiner Vega wrote:
>
"robert lazarski" <[EMAIL PROTECTED]> writes:
> Is there any way to get the above insert to work as is, via a function
> or some other way? I tried the function of another poster but it seems
> there is already a cast built in for 8.1.9 for integer to boolean, and
> it didn't work for me on the abo
Il Friday 14 December 2007 19:32:14 Andrej Ricnik-Bay ha scritto:
> On 12/15/07, Vincenzo Romano <[EMAIL PROTECTED]> wrote:
> > Buon giorno.
> > Nel file FILBD.TXT sono presenti dei prodotti per il quali il campo
> > "Unita' di Misura" (offset 182) presenza il valore "PM".
> > Allego la lista dei p
On Dec 14, 2007 12:49 PM, Gregory Stark <[EMAIL PROTECTED]> wrote:
>
> "robert" <[EMAIL PROTECTED]> writes:
>
> > So it has two 'bool' - "includeScenario" and "deleted" . I have an
> > insert like...
> >
> > INSERT INTO "ASSETSCENARIO"
> > ("assetScenarioID",OBJ_VERSION,"includeScenario","scenario
Bruce Momjian wrote:
I do top-post if I am asking _about_ the email, rather than addressing
its content, like "Is this a TODO item"? You don't want to trim the
email because it has context that might be needed for the reply, and
bottom-posting just makes it harder to find my question, and the
qu
Folks
select chr(165);
ERROR: requested character too large for encoding:
165
it's one old scrip if not remember wrong works
postgres in 8.2.4
any clue?
best regars
mdc
info:
select version().
"PostgreSQL 8.3beta3 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.1)"
Hi - been having a few problems like this myself. It's probably a
locale thing.
Here's at one of your problems:
-> Seq Scan on sms_new (cost=0.00..5240444.80
rows=138939341 width=8)
Filter: ((otid)::text !~~ 'ERROR%'::text)
I assume you have an index on sms_new?
Check
Hi
I had posted this in the slony mailing list but no luck in getting any
answers...Pls help me as I'm stuck with this error for the last 4 days
Im trying to replicate between postgres version 7.4.18 and version 8.1.10.
I configured postgres-7.4 with enable-thread-safety option
I configured
Alvaro Herrera wrote:
> Bruce Momjian wrote:
> > Alvaro Herrera wrote:
>
> > > Huh, why is it awkward?
> > >
> > > Alternatively, you can send the signal directly using kill
> > > (or pg_ctl kill TERM [process id]).
> >
> > I think we should mention Windows in there somewhere, because it
Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > Huh, why is it awkward?
> >
> > Alternatively, you can send the signal directly using kill
> > (or pg_ctl kill TERM [process id]).
>
> I think we should mention Windows in there somewhere, because it isn't
> "alternatively" on Windows.
Ac
Alvaro Herrera wrote:
> Bruce Momjian wrote:
> > Howard Cole wrote:
> > >
> > > Which you can do, no? I thought pg_ctl's kill option was invented
> > > specifically to make this less painful on Windows.
> > > > I shall look into the pg_ctl options to see if the kill option does
> > > >
Bruce Momjian wrote:
> Howard Cole wrote:
> >
> > Which you can do, no? I thought pg_ctl's kill option was invented
> > specifically to make this less painful on Windows.
> > > I shall look into the pg_ctl options to see if the kill option does
> > > what taskill cannot (thanks for the
On Sun, 2007-12-16 at 16:11 -0800, Joshua D. Drake wrote:
> On Sun, 16 Dec 2007 17:55:55 -0600
> "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
>
> > On Dec 14, 2007 1:33 AM, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > > I kept looking at the io columns and didn't even think of the swap
> > > partitio
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > We used to have the C defined MAKE_EXPIRED_TUPLES_VISIBLE that would
> > make deleted rows visible, but it seems it was removed in this commit as
> > part of a restructuring:
>
> It was removed because it was utterly useless.
It work
47 matches
Mail list logo
