On Thu, 13 Jan 2005, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
What the client did was a 'delete from pg_attribute where ... ' ...
[ blink... ] Well, that sort of thing is definitely a candidate for the
Darwin Award, but what exactly was the WHERE clause?
We were working on
Hello,
with IMMUTABLE or STABLE function is only 7% slowly. It can be usefull add
into documentation so default flag is immutable, but if its not necessary
its recommended IMMUTABLE or STABLE flag.
Regards
Pavel Stehule
---(end of
Is there anyone who written a patch for a multiple pg_dump like:
pg_dump -t table1 table2 ... tableN dbname
Regards Enrico
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to
On Friday 14 January 2005 11:45, Enrico wrote:
Is there anyone who written a patch for a multiple pg_dump like:
pg_dump -t table1 table2 ... tableN dbname
Yes, I have such a patch lying around(pg_dump -t table1 -t table2 ... dbname).
It's for 7.4, but shouldn't be hard to port to 8.0.
--
Yes, I have such a patch lying around(pg_dump -t table1 -t table2 ... dbname).
It's for 7.4, but shouldn't be hard to port to 8.0.
Oh wonderful, how can I see that? I'm working with 7.4.x version.
Thanks Enrico
---(end of broadcast)---
TIP 1:
yo mero wrote:
you can use this in BASH:
for a in table1 table2 tableN
do
echo $a
pg_dump -t $a dbname $a.sql
done
works fine
leonel
Yes I wrote that, but I wanted to know if is possible to do that without
a bash script,
Regards Enrico
---(end of
I've got an idea for a new internal function. I'm more than willing to
code it myself, but I'd like to run it past the list and thrash out any
conceptual issues before I get too excited about writing a patch.
When dealing with time values, it's not unknown to want to see a
particular time
On Friday 14 January 2005 14:54, Enrico wrote:
Yes, I have such a patch lying around(pg_dump -t table1 -t table2 ...
dbname).
It's for 7.4, but shouldn't be hard to port to 8.0.
Oh wonderful, how can I see that? I'm working with 7.4.x version.
Actually, it's for 7.4beta3, but should
Here it is:
http://dev.officenet.no/~andreak/pg_dump.c.diff
Many Thanks :)))
Enrico
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
On Tue, Jan 11, 2005 at 10:33:44 -0800,
Elein Mustain [EMAIL PROTECTED] wrote:
They probaly released the informix database patents.
This is pertinent to us as several of them were interesting
implementations of things like the function manager.
From what I read of this, the way they released
You can get the list of patents from here:
http://www-106.ibm.com/developerworks/blogs/dw_blog_comments.jspa?blog=384entry=69779
-Original Message-
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 10:29 AM
To: Elein Mustain
Cc: Darcy Buskermolen;
On Thu, 13 Jan 2005, Tom Lane wrote:
I'm still searching the 'net to see if there is somethign that I've
overlooked ... but everything so far is drawing a deadend ... can someone
suggest a web page I should read, a tool I could use, or something, to get
the data out of this, that I'm not finding?
course that won't work, since its link'd to the oid of the table name :(
whose idea was this let's name the files by the OID again? :(
On Fri, 14 Jan 2005, Marc G. Fournier wrote:
On Thu, 13 Jan 2005, Tom Lane wrote:
I'm still searching the 'net to see if there is somethign that I've
overlooked
Marc G. Fournier [EMAIL PROTECTED] writes:
course that won't work, since its link'd to the oid of the table name :(
Not to mention all the other system catalogs. You could maybe make this
idea work by regenerating the entire catalog set, but not by
regenerating just pg_attribute. But if you
On Fri, 14 Jan 2005, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
course that won't work, since its link'd to the oid of the table name :(
Not to mention all the other system catalogs. You could maybe make this
idea work by regenerating the entire catalog set, but not by
Marc G. Fournier [EMAIL PROTECTED] writes:
course that won't work, since its link'd to the oid of the table name :(
whose idea was this let's name the files by the OID again? :(
Actually, I think you can make this work, if you are sure of the schema
of the old database. Try something like
On Fri, 14 Jan 2005, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
course that won't work, since its link'd to the oid of the table name :(
whose idea was this let's name the files by the OID again? :(
Actually, I think you can make this work, if you are sure of the schema
of the old
Marc G. Fournier [EMAIL PROTECTED] writes:
'k, this is looking promising ... but I'm a bit confused on the TOAST
tables ... I can't match on 'relname', since they aren't the same ... the
old has, for instance:
pg_toast_5773565
while the new has:
pg_toast_8709712
is there some sort of
On Sat, 15 Jan 2005, Brendan Jurd wrote:
SELECT time_span( 'minute', now(), interval '10:43:55' );
643
The timestamp argument to this version of the function seems completely
irrelevent.
Kris Jurka
---(end of broadcast)---
TIP 2: you can
On Thu, Jan 13, 2005 at 03:09:19PM -0800, Mark Wong wrote:
On Thu, Jan 13, 2005 at 08:06:23PM -0300, Alvaro Herrera wrote:
On Thu, Jan 13, 2005 at 01:31:36PM -0800, Mark Wong wrote:
We've also started automating sparse analyses in our PLM tool, which
will show an error and warning count.
On Fri, Jan 14, 2005 at 03:53:09PM -0800, Mark Wong wrote:
On Thu, Jan 13, 2005 at 03:09:19PM -0800, Mark Wong wrote:
On Thu, Jan 13, 2005 at 08:06:23PM -0300, Alvaro Herrera wrote:
On Thu, Jan 13, 2005 at 01:31:36PM -0800, Mark Wong wrote:
We've also started automating sparse analyses
Alvaro Herrera [EMAIL PROTECTED] writes:
... And fmgroids.h is
missing; not sure what's the minimal make target to install it, because
make -C src/backend/utils fmgroids.h
generates it, but the symbolic link to src/include/utils is still
needed.
Looks like the symlinks are made in
On Fri, Jan 14, 2005 at 09:54:24PM -0300, Alvaro Herrera wrote:
On Fri, Jan 14, 2005 at 03:53:09PM -0800, Mark Wong wrote:
On Thu, Jan 13, 2005 at 03:09:19PM -0800, Mark Wong wrote:
On Thu, Jan 13, 2005 at 08:06:23PM -0300, Alvaro Herrera wrote:
On Thu, Jan 13, 2005 at 01:31:36PM -0800,
BTW, perhaps one reason for the relatively small number of legitimate
issues picked up by sparse is that I ran sparse on the tree a month or
two ago and fixed some of the stylistic issues it reported. Most of the
stuff I didn't bother to fix looked like either a sparse bug, or a
marginal style
On Fri, Jan 14, 2005 at 10:28:52AM -0600, Bruno Wolff III wrote:
On Tue, Jan 11, 2005 at 10:33:44 -0800,
Elein Mustain [EMAIL PROTECTED] wrote:
They probaly released the informix database patents.
This is pertinent to us as several of them were interesting
implementations of things like
I asked this question a while back and I got an answer but I
lost it.
Where can I get a copy of the SQL specification that PostgreSQL
follows? Who ever answered, as I recall said it was not free if that is any
help.
Benjamin
Ah, so you beat me to it Neil. ;) Out of curiosity, how much worse
was it before you started fixing things?
Mark
On Sat, Jan 15, 2005 at 01:30:37PM +1100, Neil Conway wrote:
BTW, perhaps one reason for the relatively small number of legitimate
issues picked up by sparse is that I ran sparse
Where can I get a copy of the SQL specification that PostgreSQL
follows? Who ever answered, as I recall said it was not free if that
is any help.
http://developer.postgresql.org/readtext.php?src/FAQ/FAQ_DEV.html
+Developers-FAQ#1.16
--
---(end of
You are referring (no doubt) to the ANSI/ISO
SQL Standard.
The papers are $18 each from ANSI in pdf
format (or they were when I bought them some time ago).
There are draft versions scattered about
on the internet for free.
This looks like a set of them:
On Fri, Jan 14, 2005 at 05:50:30PM -0800, Mark Wong wrote:
Yeah, I generate the file list to run sparse against with a
find . -name '*.c'. So that's simple enough. But flex and bison
files don't end in .c, do they?
Generated files do. I have a list of generated files here:
pl_gram.c
FYI, we are on schedule for 8.0.0 packaging this Monday, with a release
on Wednesday, January 19, 2005!
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+
Kris Jurka wrote:
On Sat, 15 Jan 2005, Brendan Jurd wrote:
SELECT time_span( 'minute', now(), interval '10:43:55' );
643
The timestamp argument to this version of the function seems completely
irrelevent.
Kris Jurka
I don't think so. As I pointed out in the OP, to make this function
Brendan Jurd [EMAIL PROTECTED] writes:
Of course, it would be possible to create a shorthand version of the
function which expects (text, interval), and passes directly to
time_span($1, now(), $2).
This bothers me a bit. That essentially says that (text, interval)
has a hidden instability:
Tom Lane wrote:
Brendan Jurd [EMAIL PROTECTED] writes:
Of course, it would be possible to create a shorthand version of the
function which expects (text, interval), and passes directly to
time_span($1, now(), $2).
This bothers me a bit. That essentially says that (text, interval)
has a
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm. Well, it showed the multiple incorrect uses of 0 as NULL in
dllist.c and other places,
Incidentally, while it may not be conformant to your style guidelines, use of
the constant 0 compared to or assigned to a pointer is a perfectly valid ANSI
35 matches
Mail list logo