There might be a problem, but if no one mentions it to the maintainers of
those
fs's, it will not get fixed...
Regards
John
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
> Here is a small list of big TODO items. I was wondering which ones
> people were thinking about for 7.2?
The need for stored procedures that return a record set.
This is required to migrate from MSSQL, Interbase and others.
This is a commonly requested item.
Nested Transactions. This allow
to be a good candidate as
it can contain unconstrained number of var_values. But var_values are of
constant types. Can I just add query as a constant? Anyone had this kind of
implementing experience?
Thanks,
John
---(end of broadcast)---
TIP 4
found var_list to be a good candidate as it can contain unconstrained
number of var_values. But var_values are of constant types. Can I just add
query as a constant? Anyone had this kind of implementing
experience?Thanks,John
ey value not found when it runs.
Best wishes,
John
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
gt;pgstat_info)->tabentry))->t_tuples_fetched;
But the system does not like it and the DB broke down halfway.
Thanks,
John
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
]
[ -s | -t { pa | pl | ex } ] [ -S sort_mem ] [ -W num ] database
adding -s will print the statistis and time. But I have no idea how to call
this using postmaster -o option. Anyone give me a hint? Thanks.
-John
---(end of broadcast
I got an installation problem. There was an old copy of postgres
installed but I want to install the modified postgres. I get problems
related to locating "/usr/local/pgsql/data".I tried:[EMAIL PROTECTED]
~]$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/dataThe files belonging
to this dat
On Sat, Feb 27, 2016 at 9:25 AM, Robert Haas wrote:
> On Sat, Feb 27, 2016 at 7:08 PM, Andrew Dunstan
> wrote:
>
> > Perhaps what we need to do is modify pg_regress.c slightly to allow more
> > than one --temp-config argument. But that could be done later.
>
> Well, I'm pretty interested in usin
is weird.
How can I calculate how long DB can live in this stage?
2016-03-19 0:28 GMT+03:00 Tomas Vondra :
> Hi,
>
> On 03/18/2016 09:42 AM, John Snow wrote:
>
>> Hi everyone!
>>
>> Trying to make VACUUM FREEZE on PG instance and keep getting this error:
>>
Hi everyone!
Trying to make VACUUM FREEZE on PG instance and keep getting this error:
2016-03-18 05:56:51 UTC 46750 WARNING: oldest xmin is far in the past
2016-03-18 05:56:51 UTC 46750 HINT: Close open transactions soon to
avoid wraparound problems.
2016-03-18 05:56:51 UTC 46750 DEBUG:
rstand the general rules where it may be much
harder to try avoidance)
Cheers, John
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ments could be clearer.
Perhaps this is what is meant.
< * (plus alignment), now wasting memory.
> * (plus alignment), not wasting memory.
In slab.c some lines are over 80 characters could be folded.
It would be nice to give each patch version a unique file name.
Nice patch, I enjoyed readi
set->aset, size);
On Sat, Oct 1, 2016 at 10:15 PM, Tomas Vondra
wrote:
> On 10/02/2016 12:23 AM, John Gorman wrote:
>
>> I reproduced the quadradic pfree performance problem and verified that
>> these patches solved it.
>>
>> The slab.c data structures and function
On Tue, Oct 4, 2016 at 10:11 PM, Tomas Vondra
For GenSlab the situation is less clear, as there probably are ways to make
> it work, but I'd vote to keep it simple for now, and simply do elog(ERROR)
> in the realloc() methods - both for Slab and GenSlab. The current use case
> (reorderbuffer) does
Do a web search on setting shared memory the hard way, and I think you'll see
what you really need to do.
--
Jay
Sent from my iPad
> On Nov 10, 2016, at 5:57 PM, leoaaryan wrote:
>
> I am a newbie to databases and Postgres and I am trying to analyze the shared
> memory being calculated and all
will be faster due to not having to examine
more than one hash bucket array most of the time.
--
John Gorman
http://www.enterprisedb.com
dht-v2-resize-cleanup.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
While I do not know QGIS, I'm wondering if it's similar to some of our
applications where they always use the same system login for the database
while each user provides a unique login to the application. Have you ever
set log_connections in your postgresql.conf file? That would show you which
user
-originator of an aio_read to wait on completion
(LWlock instead of polling the aiocb)
This was talked about in several earlier posts and Claudio is also
working on something there
. package up my benchmark
Cheers John
> Date:
> Date: Thu, 19 Jun 2014 15:43:44 -0300
> Subject: Re: Extended Prefetching using Asynchronous IO - proposal and patch
> From: klaussfre...@gmail.com
> To: st...@mit.edu
> CC: hlinnakan...@vmware.com; johnlu...@hotmail.com;
> pgsql-hackers@postgresql.org
ers@postgresql.org
>
> On Mon, Jun 23, 2014 at 2:43 PM, John Lumby wrote:
>> It is when some *other* backend gets there first with the ReadBuffer that
>> things are a bit trickier. The current version of the patch did polling for
>> that case
>> but that drew critic
Asynchronous IO - proposal and patch
>
> On 06/24/2014 04:29 PM, John Lumby wrote:
>>> On Mon, Jun 23, 2014 at 2:43 PM, John Lumby wrote:
>>>> It is when some *other* backend gets there first with the ReadBuffer that
>>>> things are a bit trickier. The current version
However,
considering how much memory it uses, I wonder how many people would
actually use it. I did run Apache / MySQL / PHP on a VAXstation 4000/60
not long ago, but MySQL takes way too much memory, too. Don't even get me
started on how memory PHP uses - someone has to write some good
y
'/usr/pkgsrc/databases/postgresql93-server/work/postgresql-9.3.4/src/port'
../../../src/Makefile.global:423: recipe for target 'submake-libpgport'
failed
gmake: *** [submake-libpgport] Error 2
That's all I have time for tonight. Is there an easier way to ru
L can run on a VAX with only 20 MB or so of
resident memory.
Thanks,
John
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
res=# CREATE SCHEMA testschema;
CREATE SCHEMA
postgres=# CREATE TABLE testschema.testtable (testserial serial PRIMARY
KEY, testchar varchar (100) NOT NULL);
CREATE TABLE
I don't know enough to really test this. Can you recommend a simple script
to do some PostgreSQL testing?
John
--
My cut'n'pasting failed me at one point corrected below.
> discussion about what is the difference between a synchronous read
> versus an asynchronous read as far as non-originator waiting on it is
> concerned.
>
> I thought a bit more about this. There are currently two differences,
> one of
e every week or so (every day would
really eat into cycles for other packages).
John
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
assignment of an int to a
long?" Or to put it another way, "Are there any C compilers that fail to
properly perform integer promotion from int to long?"
As things stand, it looks to me like that function eitol() can be simply
deleted and the 22 calls to that function also removed. Shorter,
simpler,faster code is always a good thing after all.
Thank you for reading,
John Cochran
unk" files
into the directory. The files would mainly consist of man pages and html
files containing documentation for the timezone code. The extra files would
consume approximately 500 kilobytes above what's actually needed, but
otherwise wouldn't have any adverse effects.
Thank you
On Fri, Jul 18, 2014 at 1:21 PM, Tom Lane wrote:
> John Cochran writes:
> > My proposal is the have the following directory structure
>
> ...
> > 1. I would have liked to recommend 2 sub-directories underneath
>
...
>
>
I have exactly zero expectation of using
that pgindent not be
used again on the IANA code so future maintainers can easily perform a diff
between the IANA code and the postgres code to determine the actual
differences. I'll then see about doing the same with the other source files
in timezone.
On Fri, Jul 18, 2014 at 4:27 PM, Tom Lan
On Sat, Jul 19, 2014 at 11:58 AM, Michael Banck wrote:
SNIP
>
> Maybe if you pgindent the IANA code as well, you can more easily diff
> the actual changes between the two, did you try that?
>
>
> Michael
>
Unfortunately, pgindent doesn't work well with the IANA code as evident by
some previous ch
Greetings,
I took at look at the TODO list and got interested in the possible
optimization of the bcTruelen() function. Read the archived messages about
that subject and decided to see what could be done.
I tested the performance of 5 different versions of bcTruelen().
1. The code as it exists in
I just browsed the paper linked by Peter and it looks like the attack has
to be active against a currently executing qsort. In the paper, what
happens is the comparison function is supplied by the attacker and
effectively lies about the result of a comparison. It keeps the lies
consistent in a very
On Thu, Aug 7, 2014 at 11:07 AM, Robert Haas wrote:
> On Tue, Aug 5, 2014 at 8:15 PM, Peter Geoghegan wrote:
> > "The adversarial method works for almost any polymorphic program
> > recognizable as quicksort. The subject quicksort may copy values at
> > will, or work with lists rather than array
I'm writing a pgsql extension in C, which is multithreaded. The SPI
connection is global, so do I have to implement a lock to make sql queries
in each thread, or can I make a connection on a per-thread basis?
"some Salesforce folks" that would be me! It looks like I didn't quite
communicate to Tom just what I was looking for as I do indeed want to have
a variable number of "any" types, as:
CREATE AGGREGATE FOO ( ANYELEMENT, , VARIADIC "any") (
...
STYPE = ANYARRAY
...)
so the corresponding transi
lib/
./src/interfaces/ecpg/ecpglib/
./src/interfaces/ecpg/compatlib/
./src/interfaces/ecpg/preproc/
This is interfering with using "-Wall -Werror" to catch warnings.
Any opinions as to whether this is worth fixing and if so
what the cleanest approach might be?
Thanks, John
I have confirmed that "-Wno-unused-command-line-argument"
suppresses the "-pthread" warning for clang 6.0 and does not
trigger a warning in gcc 4.9.
Works for me!
John
On Fri, Apr 3, 2015 at 5:21 PM, Tom Lane wrote:
> I wrote:
> > Peter Eisentraut writes:
> &g
On OSX:
SELECT asin(2);
> asin
> --
> NaN
> (1 row)
>
SELECT asin(2);
> asin
> --
> NaN
> (1 row)
The attached patch brings OSX into line with the expected behaviour and the
additional regression tests verify this.
Is this worth fixing and if so what is
I see a few old messages referring to ISAM to SQL emulation.
For example:
http://www.postgresql.org/message-id/200402171616.i1hgg9u11...@candle.pha.pa.us
Does anyone know of any actual source code to one of these projects? Any
active projects?
John
loaded from
http://gdzhdb.l10n-support.com/sawndip-fonts/Sawndip.ttf)
The last two words even though included in a dictionary do not get
accepted by ts_vector.
Regards
John
On Mon, Oct 1, 2012 at 11:04 AM, Dan Scott wrote:
> On Sun, Sep 30, 2012 at 1:56 PM, johnkn63 wrote:
>> When usin
On Mon, Oct 1, 2012 at 12:11 PM, Tom Lane wrote:
> john knightley writes:
>> The OS I am using is Ubuntu 12.04, with PostgreSQL 9.1.5 installed on
>> a utf8 local
>
>> A short 5 line dictionary file is sufficient to test:-
>
>> raeuz
>> 我们
>> 𦘭𥎵
&g
On Mon, Oct 1, 2012 at 11:58 AM, Dan Scott wrote:
> Hi John:
>
> On Sun, Sep 30, 2012 at 11:45 PM, john knightley
> wrote:
>> Dear Dan,
>>
>> thank you for your reply.
>>
>> The OS I am using is Ubuntu 12.04, with PostgreSQL 9.1.5 installed on
>> a
ve a proper setup this week but will reply at greater length
next week.
John
rface to
PrefetchBuffer
and add a new DiscardBuffer which I did not include in this snapshot to avoid
confusing.
John
--- src/backend/executor/nodeIndexscan.c.orig 2012-10-31 15:24:12.083163547 -0400
+++ src/backend/executor/nodeIndexscan.c 2012-11-
If I recall, the
glic (librt) aio does have an lio_listio but it is either a noop
or just loops over the list, I forget which (don't have its source right now),
but in any case I am sure there is a potential for implementing such a facility.
But to be r
t thread.
4. Each waiting backend receives the completion
and the last one does the housekeeping and returns the pg_buf_aiocb.
What complicates it is managing the associated pinned buffer
in such a way that every backend takes the correct action
with the correct degree of serialization of the buffer descriptor
during critical sections, but yet allowing all backends in
3. above to concurrently wait/check. After quite a lot of testing
I think I now this correct. ("I just found the *last* bug!" :-)
John
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Bruce Momjian wrote:
>
> On Fri, Nov 2, 2012 at 09:59:08AM -0400, John Lumby wrote:
> > However,the OP describes an implementation based on libaio.
> > Today what we have (for linux) is librt, which is quite different.
>
> Well, good thing we didn't switch to
-
I attach patch based on clone of postgresql.git as of yesterday (120619-145751
EST)
I have tested the patch with INSERT and UPDATE (not tested with DELETE but
should work).
The patch is not expected to be final but just to show how I did it.
John
First, apologies for taking so long to reply to your post.
On Fri, 22 Jun 2012 09:55:13, Robert Haas wrote:
> On Wed, Jun 20, 2012 at 12:24 PM, John Lumby
> wrote:
> > An INSERT which has a RETURNING clause and which is to be rewritten
> >based on
> > a rule
I noticed in postgres you cannot return multiple result sets from a stored
procedure (surprisingly as it looks like a very good dbms).
I would like to suggest adding this feature.
- It is very usefull
- It is supported by all other dbmss I have worked with.
- makes porting applications to postg
program is creative and
needs some thinking and the bulk of it is just a million stupid details.
I just don't follow/understand your thinking. Maybe I am naïve.
I do not have experience with open source and I kind of thought open source
guys
do not need or care about money and time.
OK, how much are we talking about?
From: Josh Berkus
To: John Adams
Cc: PostgreSQL-development
Sent: Fri, September 3, 2010 1:07:03 PM
Subject: Re: [HACKERS] returning multiple result sets from a stored procedure
> I noticed in postgres you cannot ret
operations with a spinlock?
Thanks!
John
This patch implements the first wiki/Todo Configuration Files item
"Consider normalizing fractions in postgresql.conf, perhaps using '%'".
The "Fractions in GUC variables" discussion is here.
http://www.postgresql.org/message-id/467132cf.9020...@enterprisedb.com
This patch implements expressing
On Sun, Jan 11, 2015 at 6:00 PM, Robert Haas wrote:
> On Sun, Jan 11, 2015 at 6:01 AM, Stephen Frost wrote:
> > So, for my 2c, I've long expected us to parallelize at the relation-file
> > level for these kinds of operations. This goes back to my other
> > thoughts on how we should be thinking
On Tue, Jan 13, 2015 at 7:25 AM, John Gorman wrote:
>
>
> On Sun, Jan 11, 2015 at 6:00 PM, Robert Haas
> wrote:
>
>> On Sun, Jan 11, 2015 at 6:01 AM, Stephen Frost
>> wrote:
>> > So, for my 2c, I've long expected us to parallelize at the relation-file
FYI, I was just checking out the contributors page and noticed that he's
listed under Past Contributors.
http://www.postgresql.org/community/contributors/
On Fri, Jul 8, 2011 at 1:55 PM, Bruce Momjian wrote:
> Tom Lane wrote:
> > Robert Haas writes:
> > >> Anyone feels in mood for a comment?
to preserve any available error state.
I am attaching a patch to preserve errno across errmsg() calls.
Does this seem like a good idea?
Best, John
errmsg-errno-v1.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
g just to figure out what the problem is.
Because of this, I've submitted a small patch which fixes the verbosity of
the error message to actually explain what's missing. I hope that this
patch will be considered for the community, and it would be nice if it was
back-patched.
Attached
On Tue, Jul 26, 2016 at 9:44 PM, Michael Paquier
wrote:
> On Wed, Jul 27, 2016 at 12:41 AM, John Harvey
> wrote:
> > Because of this, I've submitted a small patch which fixes the verbosity
> of
> > the error message to actually explain what's missing. I h
On Mon, Aug 1, 2016 at 9:39 PM, Michael Paquier
wrote:
> On Tue, Aug 2, 2016 at 2:08 AM, Robert Haas wrote:
> > Did you add this to the next CommitFest?
>
> I have added it here:
> https://commitfest.postgresql.org/10/691/
> John, it would be good if you could get a comm
for postgres by the tools.
I would like to have this functionality (yesterday :) -- I'm
currently working on this for pgEdit. Let me know if you need help
with review or testing.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broa
sed to speed up a database? If so which part of the database, and what
kind of parallel algorithms would be used?
Thanks, sorry if this is a duplicate message.
-- John Billings
Hi,
How do I connect postgres table structures and view structures to an
existing svn repository?
Thanks,
--
John J. Mitchell
ments which can be a hassle for large
argument lists.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
on
'stringToQualifiedNameList'
plugin_profiler.c: In function 'dumpStatsXML':
plugin_profiler.c:847: warning: format '%07ld' expects type 'long
int', but argument 4 has type 'suseconds_t'
plugin_profiler.c:850: warning: f
On Sep 4, 2007, at 8:55 PM, korry.douglas wrote:
Sorry about that John, there's a fix for this problem (it's an 8.2
versus 8.3 issue) in the CVS repository. I thought I had rolled a
new tarball after committing the fix but I guess not.
You can pull the latest plugin_profi
evening. Possible hint: the function had no IN parameters, but many
OUT parameters.
John
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 6: explain analyze is your friend
out t text, out i integer)
returns record as $$
begin
t := 'test 1';
i := 10;
return;
end;
$$ language plpgsql;
I did the following:
1. Right click the function and chose "Debug" from the "Debugging"
submenu.
2. Clicked the OK button on the di
Hi Korry,
On Sep 6, 2007, at 10:23 AM, korry.douglas wrote:
John, I started writing up the API documentation and then noticed
that most of what I intended to write is already described in the
pldbgapi.c module.
Take a look at that module and let me know if you have any
questions (you
> 2) The constraint doesn't exist on the master, only the slave, so I don't
> beleive EXECUTE SCRIPT will work, no?
No, it does not work. I've tried.
// John
_
John Parnefjord
Samordnare UBIT Utveckling / Coordin
r column names. It would be nice to have something like "declare
$myvar integer;" so it would be very easy to distinguish variable and
parameter names from structure names or reserved words.
John DeSoi, Ph.D.
---(end of broadcast)
i'd like to try to develop some improvements to psqlodbc. is there
source for a test suite available? could anyone point me towards it,
or offer testing source code they've written personally?
thanks,
john
---(end of broadcast)---
TI
s for 8.4. We should be realistic that new bugs probably
will occur in recovery code for existing and new RMs."
Can someone clarify if WAL-logging of hash indexes will be supported
in the 8.4 release?
- John
---(end of broadcast)---
TIP 5: do
Here's a patch:
diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml
index 6750db8..1276c39 100644
*** a/doc/src/sgml/backup.sgml
--- b/doc/src/sgml/backup.sgml
*** if (!triggered)
*** 2018,2024
!Data Definition Language (DML) - INSERT,
ie, they are not needed to build from
>> a source tarball. Otherwise this *is* moving the goalposts on required
>> tool support.
> The patch already does that if I understood John correctly.
Yes, everything output by Perl in my patch is a distprep target.
Some minor changes would
Tom,
It seems I introduced a couple errors in src/tools/msvc/clean.bat in
the bki patch. I'm attaching a cumulative fix. I can resend the
complete updated patch, if you like...
Sorry! :-)
John
> I'm planning to go look at Naylor's bki refactoring patch now. Assuming
FWIW, the old make rule was
fmgroids.h fmgrtab.c: (deps)
which is now
fmgroids.h: fmgrtab.c ;
fmgrtab.c: (deps)
I was going by this comment in parser/Makefile:
# There is no correct way to write a rule that generates two files.
# Rules with two targets don't have that meaning, they are merel
Here's a fix. Sorry, I didn't realize it was ever called without a
version number.
On Wed, Jan 6, 2010 at 11:18 AM, Stefan Kaltenbrunner
> heh that's a nice one the snapshot generation script uses "
> gmake -s VERSION=snapshot dist" and that leads to getting "
> --set-version=snapshot" passed to g
;m not very
proficient with C. If anyone is interested in leading the way, I would
be happy to help.
John DeSoi, Ph.D.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
many different Lisp implementations to provide a
Lisp IDE in Emacs.
BTW, this is Lisp's 50th birthday being celebrated today at OOPSLA.
http://www.lisp50.org/
John DeSoi, Ph.D.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
t;,
and "Multirow FETCH is not allowed in PL/pgSQL."
Everything else looks good to me.
John
> Hi Selena and John,
>
> Pavel's latest patch seems to address all the issues you raised in
> your initial review. Do you have any comments on this new revision?
> If you&#x
CHEMA implementation for MySQL 5.x, but not yet for PostgreSQL.
Why this? We were a web hosting Company and were absolutely
maddened that no simple tools existed to tell us who was causing
usage spikes on a DB server shared by multiple users. We now
know!
Best regards!
--
ing real to test against.
We were trying to decided what later release to target, looks
like we'll go for 8.4 and 8.5 as staff/work permits. Any feedback on
the syntax/output is welcome.
Best regards!
--
John
_
n the tables
have more stability and are updated on an ongoing basis? If you have
any pointers to schema table creation that would be great!
Best regards!
--
John
____
John Murtar
tation specific.
As you can see, the goal here is reporting on activity
at the SQL level.
Regarding the GPL limitation. That will probably be
removed on code we release to PostgreSQL -- hadn't really thought
about the fact it would be a show stopper. Thanks for bringing
that u
TION SCHEMA.
>
> I don't really get the point of the SHOW STATISTICS command. There is
> already a command whose purpose is to retrieve data in tabular form,
> namely SELECT.
Okay, thank you. We will take another look at those items.
Best regards!
-
for standardization at the
SQL level. We will keep your other remarks in mind as we proceed.
Best regards!
--
John
John MurtariSoftware Workshop Inc.
jmu
rc/include/catalog/pg_statistic.h| 259 -
src/include/catalog/pg_tablespace.h | 63 -
src/include/catalog/pg_trigger.h | 113 -
src/include/catalog/pg_trigger_fn.h | 42 +
src/include/catalog/pg_ts_config.h| 60 -
src/include/
to
> pg_proc and that this not mean that I have to edit almost every single
> line of the damn monster file.
One could conceivably write a script against Catalog.pm that generated
DATA(); statements to copy and paste into a header file. It might be a
useful tool, if only for error checking. For
d one will fail.
5. Given the current dataset, the error always occurs on line 926 of
the COPY (even if the values at line 926 are changed).
6. // typically always corresponds to that
of temp2 on my system.
Thanks.
- John
[Resending since didn't see this posted on pgsql-hackers]
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
that PREPARE TRANSACTION is not
supported, and indeed due to the lack of a check in Postgres today, it
seems as though it is supported. Do you think there is a risk in
breaking applications?
Thanks.
- John
2pc.sql
Description: Binary data
commit.sql
Description: Binary data
--
Sent via pg
regards, tom lane
Any help would be appreciated as the pg_class table is constantly
growing which i'm guessing is going to start to affect performance
fairly soon. I'd like to avoid a full restore from backup if possible.
Thanks
JOHN
**
learned about the -P
option to the server which may have helped here). The corruption in
pg_class manifested itself as multiple rows (for this and another table)
with the same OIDs
So not sure at what point what if anything got corrupted and what my
subsequent actions did to compound this..
T
Cheers, i'll give it ago. I'm probably going to do a full restore over
the weekend while i can shut things down without too many complaints...
I can save any of the files if you are interested in them later on...
JOHN
Tom Lane wrote:
John Lister writes:
Any help would be appr
pointer to the protocol where
the client specifies the return type(s) so i can check the client code
(mainly jdbc) to see what is going on?
Thanks
JOHN
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Does libpqtypes pass the array "over the wire" as an array? Ideally i'd like
to do this with jdbc, but might give me a pointer...
Thanks
- Original Message -
From: "Andrew Chernow"
To: "John Lister"
Cc:
Sent: Tuesday, April 07, 2009 8:15 PM
1 - 100 of 462 matches
Mail list logo
