Thanks for the suggestion, Peter. It looks like pg_comparator is for comparing
the contents of two different servers. I need to compare the contents of two
dump files from the same server separated by time and busy developers.
Regards,
Bob Lunney
--- On Thu, 4/15/10, Peter Eisentraut wrote
tables, so use judiciously.
This is my first patch submission, so I hope I've followed
protocol. If not, please be gentle!
Regards,
Bob Lunney
bob_lunney dot yahoo dot com
diff -cNr src/bin/pg_dump/pg_dump.c.orig
src/bin/pg_dump/pg_dump.c
*** src/bin/pg_dump/pg_dump.c.orig 2
y in pl/pgsql, but I find this
method works for the cases where you need it(logging, huge batch processing
tasks where it's not ideal to process everything in one transaction).
Bob
"Hi all.
Is there a way to have (sub)transactions within a function body?
I'd like to execute some code (a
unsubscribe
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Markus Schaber
Sent: Friday, October 06, 2006 3:34 AM
To: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] pg_dump exclusion switches and functions/types
Hi, Tom,
Tom Lane wrote:
> One issu
Anyone,Hello our server had postgresql 7.4 when updated to 8.1.2 everything is working fine, but the version of pg_dunp is 7.4How do i upgrade pg_dump so I can dump / backup the database?Thanks
Bob
On Nov 21, 2005, at 5:50 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
I don't touch pg_class at all... this is what I'm doing (over and
over again).
-- clone_table is almost always a no-op, but once a day it creates a
new table
SELECT c
On Nov 21, 2005, at 4:33 PM, Alvaro Herrera wrote:
Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
On Nov 21, 2005, at 3:56 PM, Tom Lane wrote:
Well, I count at least a couple hundred deleted versions of that
table
row :-(. What the heck were you doing with it?
T
On Nov 21, 2005, at 3:56 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
Sure, here it is:
http://undefined.org/mochi.pg_class-1.filedump.gz
Well, I count at least a couple hundred deleted versions of that table
row :-(. What the heck were you doing with it? As far as
On Nov 21, 2005, at 3:12 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
Ok, here's the pg_filedump for the pg_class table in the mochi
database that is having the issue:
Thanks. I don't see any live tuples that look like they could have
been
the one we wan
On Nov 21, 2005, at 2:42 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
Ok, so how do I figure out which file(s) are associated with pg_class
so I can feed this thing?
See contrib/oid2name and/or read
http://www.postgresql.org/docs/8.1/static/storage.html
Ok, here
On Nov 21, 2005, at 1:59 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
The attributes look like the names of all the columns in the table,
and reindexing didn't help.
So at this point it seems that the pg_class row disappeared, but there
probably wasn't
On Nov 21, 2005, at 1:43 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
I don't know how to get the oid of a type.. but there are certainly
entries in pg_depend with the other criteria:
Hmph, looks like you still have a pretty full set of dependencies for
the t
On Nov 21, 2005, at 1:14 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
On Nov 21, 2005, at 12:44 PM, Tom Lane wrote:
Try dropping the type.
I did try that, I guess it didn't make it to the list yet:
mochi=# drop type ping_1132387200;
ERROR: cache lookup
On Nov 21, 2005, at 11:31 AM, Bob Ippolito wrote:
I've been running 8.1.0 on a test box since the FreeBSD port has
been available, and it appears that the catalog has become
corrupted. There's plenty of free space on all volumes, so it
hasn't run out of space or anythin
On Nov 21, 2005, at 12:44 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
mochi=# drop table ping_1132387200;
ERROR: table "ping_1132387200" does not exist
mochi=# create table ping_1132387200();
ERROR: type "ping_1132387200" already exists
I'm
ds
\g or terminate with semicolon to execute query
\q to quit
mochi=# drop table ping_1132387200;
ERROR: table "ping_1132387200" does not exist
mochi=# create table ping_1132387200();
ERROR: type "ping_1132387200" already exists
I'
One reason to use a UUID type over a naively stored hash for this purpose is that it takes up half the space as naively stored MD5 and 40% of the space as naively stored SHA1. Granted, it's easy enough to pack them, but packed MD5 does have the same storage requirements as UUID and it won't be qui
uuid_create (again, libc)
Windows: UuidCreate (link to Rpcrt4.dll, IIRC)
Where a native UUID generate is not available, you can include some
implementation, but surely other platforms also include UUID
implementations.
I think Windows portability is a non-issue here.
-bob
--
On Sep 6, 2005, at 6:02 PM, Josh Berkus wrote:
Bob, People,
Let me clarify my stance here, because it seems to be getting
misrepresented.
Mark (and Nathan) pushed at repaired UUID type for possible
inclusion in
the core PostgreSQL distribution. I'm not opposed to that,
provided tha
. A platform UUID implementation, if present, is generally going
to be better than anything included into PostgreSQL itself.
-bob
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
#x27;o UUID implementation) looks to be
suitably licensed for PostgreSQL, and it actually it appears that
someone has already written a PostgreSQL UUID type using this it...
which is unfortunately LGPL'ed (why?!).
-bob
---(end of broadcast)---
TIP 6: explain analyze is your friend
the same license. The GPL license of pguuid is a show-stopper for some (and seems like a silly choice for what it is and who it's for).-bob
My understanding is that EMS Hitech is just doing client side debugging.
That is they are taking your function and creating a new process to follow the flow of the program. So if they mess up something you may thing your program is doing one thing when it is really doing something else. Maybe I
One simple benefit to packages is just organization of related code.On 5/7/05, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:Oracle Style packages on postgresOVERVIEW:
To emulate oracle server side development in postgres I required serverside packages. The following text demonstrates how to do thi
I really hate seeing all the developers wasting time and brain cycles on
this type of stuff. I would much rather that time and brain cycles be put
to the design and development of the code.
Would a project manager type position be of any value to take some of this
off the developers and onto
Sounds like a project manager type should be put into place to organize
this information into a straight stream instead of 50 random mists of water
|-+-->
| | Andrew Dunstan |
| | <[EMAIL PROTECTED]> |
|
This may be out of scope but I'm goign to mention it. Would error trapping
help any of these issues. In Oracle PL/SQL you have an exception section to
handle any known or unknown errors. Is this for the future or does the
nested xacts code include this at all?
|-+---
ome basic examples that you have used in your testing?
Regards
Bob
|-+-->
| | Tatsuo Ishii |
| | <[EMAIL PROTECTED]>|
| | Sent by: |
| |
I think before this can be tested fully by a wide audience there needs to
be some basic documentation. Or is there?
What is the new syntax?
Can we see some basic examples that you have used in your testing?
Regards
Bob
I downloaded it this morning around 8:00 AM CENTRAL TIME. Thanks for the
builds by the way!
|-+-->
| | "Merlin Moncure" |
| | <[EMAIL PROTECTED]|
| | online.com>|
| |
I have binary install from snapshot from the other night on WINDOWS 2000
PRO and had same problem.
|-+-->
| | "Merlin Moncure" |
| | <[EMAIL PROTECTED]|
| | ne.com>|
|
I think great would be an understatement.
Great work all!
|-+-->
| | Bruce Momjian |
| | <[EMAIL PROTECTED]|
| | > |
| | Sent by: |
|
Just so you know I'm very thankful for your hard work and I'm sure many of
us are. I have been waiting for this kind of functionally in Postgresql!
|-+-->
| | Heikki Linnakangas |
| | <[EMAIL PROTECTED]> |
I would be FOR it if the README states the dangers
Bob Henkel 651-738-5085
Mutual Funds I/T Woodbury
Hartford Life
500 Bielenberg Drive
Woodbury, MN 55125
|-+>
| | Hans-Jürgen |
| | Schö
t could be of use as it stands.
Bob Henkel 651-738-5085
Mutual Funds I/T Woodbury
Hartford Life
500 Bielenberg Drive
Woodbury, MN 55125
|-+-->
| | Tom Lane |
| | <[EMAIL PROTECTED]>|
On Nov 8, 2003, at 3:19 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
* I ditched the system.c hack, assuming Apple has fixed them by 10.3
--
because it breaks tcl and python if you do.. I did:
After fixing the ps_status problems, I cannot observe any problem, with
or w
On Nov 8, 2003, at 1:44 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
On Nov 8, 2003, at 1:13 PM, Tom Lane wrote:
As for getting rid of system.c, I am not eager to do that since it
would
certainly break compatibility with OS X 10.1. We could conditionally
compile it out p
On Nov 8, 2003, at 1:13 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
On Nov 8, 2003, at 12:31 AM, Tom Lane wrote:
I have just in the past couple hours realized that ps_status.c is
seriously broken on OS X 10.3.
Er... I meant memcmp.. Have you tried removing the system.
On Nov 8, 2003, at 1:00 AM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
On Nov 8, 2003, at 12:31 AM, Tom Lane wrote:
I have just in the past couple hours realized that ps_status.c is
seriously broken on OS X 10.3. It appears that Apple has randomly
decided to start #define&#x
On Nov 8, 2003, at 12:31 AM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> writes:
Here's my notes on how to build PostgreSQL 7.4 (CVS) on OS X 10.3
(7B85) with (seems to be working, but I haven't really ran any tests)
python, tcl, perl, readline.
I have just in the past coupl
Here's my notes on how to build PostgreSQL 7.4 (CVS) on OS X 10.3
(7B85) with (seems to be working, but I haven't really ran any tests)
python, tcl, perl, readline. I noticed today that you guys are just
about to release, so I figure I should bring this up right now. Please
feel free to e
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Anthony W. Youngman wrote:
>
> >In article <[EMAIL PROTECTED]>, Anthony W. Youngman
> ><[EMAIL PROTECTED]> writes
> > But it does seem strange indexing on a composite field
> >like that ...
> >
> But why does it seem
"Christopher Browne" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Anthony W. Youngman" <[EMAIL PROTECTED]> wrote:
> > In article <[EMAIL PROTECTED]>, Marshall Spight
> > <[EMAIL PROTECTED]> writes
> >>Unless one has data independence, one does not have
> >>this option; one will be
gt; >>than your alternative.
> >>
> >>And please don't tell me that using indexes is not fair or not in the
> >>spirit of the
> >>relational model ;-)
> >>
> >>
> >
> >Well, it does result in data being stored multiple times ;-)
, in which case, with 3 I/O's I would get
> >>- 8 customer rows
> >>- 16 order rows
> >>- 24 order detail rows (which would all apply to one customer)
> >>
> >>Now the amout of I/O's would depend on how many detail rows
> >>we have pe
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Anthony W. Youngman wrote:
>
> >In article <[EMAIL PROTECTED]>, Lauri Pietarinen
> ><[EMAIL PROTECTED]> writes
> >
> >
> >>So in your opinion, is the problem
> >>
> >>1) SQL is so hard that the average programmer will
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Bob Badour wrote:
>
> >"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message
> >news:[EMAIL PROTECTED]
> >
> >>I could now denormalise OrderD
"Marshall Spight" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Bob Badour" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> >
> > All physical structures will bias performance for some operations and
> > against o
t; OK, I get your point.
>
> >>Well, if it is normalised, how easy is it for you to change the
> >>customer_id of an order? Anyway,
> >>
> >>
> >
> >Incredibly easy. Just update the "customer_id" field of the invoice
> >record. A single cha
obody seems to have been prepared to explain the MV model in adequate
> theoretical terms as to allow the gentle readers to compare the theory
> behind it with the other theories out there.
>
> I'm afraid that does not reflect very well on either those lauding MV
> or those trashi
"Dawn M. Wolthuis" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Thank you, Seun, for asking your question with a bit of logic and not
> gut-reaction emotional baggage (and for also asking a question of me
> off-list so I could ramble). I'll try to make this more suscinct.
With al
"Mike Preece" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> [EMAIL PROTECTED] (Dawn M. Wolthuis) wrote in message
news:<[EMAIL PROTECTED]>...
> > Bob Badour" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
>
With all due respect, Dawn, you are an idiot.
"Dawn M. Wolthuis" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Good question. Although I would want to move away from relational
> databases too, if there is an RDBMS and one wants to query it, what
> would I aim for? If you look at
[EMAIL PROTECTED] ("Dann Corbit") wrote in message news:<[EMAIL PROTECTED]>...
> > -Original Message-
> > From: Seun Osewa [mailto:[EMAIL PROTECTED]
> > Sent: Friday, October 03, 2003 11:52 AM
> > To: [EMAIL PROTECTED]
> > Subject: [HACKERS] Dreaming About Redesigning SQL
> >
> >
> > Hi,
"Anthony W. Youngman" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> In article <[EMAIL PROTECTED]>, Lee Fesperman
> <[EMAIL PROTECTED]> writes
> >If you don't care for mathematical principles, there's always ad-hoc database
> >models.
> >Check out Pick, OO and XML databases.
absolutely necessary to do it right - and only then if we determine upon
careful consideration that it really is worth doing. I *think* it *might* be
well worth it - but only real effort will yield a definitive answer.
- Bob Calco
%% -Original Message-
%% From: [EMAIL PROTECTED]
%% [mailto
Thanks for the link - I think I just may give it a go. :)
- Bob
%% -Original Message-
%% From: [EMAIL PROTECTED]
%% [mailto:[EMAIL PROTECTED] Behalf Of Peter Eisentraut
%% Sent: Wednesday, March 05, 2003 5:39 PM
%% To: Bob Calco
%% Cc: Merlin Moncure; Alan Gutierrez; [EMAIL PROTECTED
something truly useful with XQuery concepts.
So I had this idea. If I can find a few good co-conspirators, I'm prepared
to get involved seriously with developing this add-on capability, whatever
it takes. Mostly, I suspect, time...
Sincerely,
Bob Calco
%% -Original Message-
recordsets as XML.
Anybody want to put together a team to explore this seriously? There are
probably several non-trivial semantic issues on the back end, but I only
dimly grasp them at this point.
- Bob Calco
%% -Original Message-
%% From: [EMAIL PROTECTED]
%% [mailto:[EMAIL PROTECTED] Behalf Of
a cdata, Tcl_Interp *interp,
int argc, char *argv[])
{
char buf[64];
sprintf(buf,"%d",SPI_lastoid);
Tcl_SetResult(interp, buf, TCL_VOLATILE);
return TCL_OK;
}
/* end C code */
-bob
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
nction, and a few
other things.. no luck. Does anyone have ANY idea how I can either redesign this
query or make the create/drop thing work properly?
Thanks,
(::) Bob Ippolito
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please
the older releases for now, but this
should be fixed ASAP.
Sincerely,
Bob Deblier
Virtual Unlimited
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
62 matches
Mail list logo
