Thanks, i'll test it tomorrow
pau
2007/12/11, Richard Broersma Jr <[EMAIL PROTECTED]>:
>
> --- On Tue, 12/11/07, Pau Marc Munoz Torres <[EMAIL PROTECTED]> wrote:
> > could i use a sentence similar to the mysql sentence
> >
> > insert if not exist into SP values
> > ('cesp','sp');
> >
> > in postg
Well said Greg. I have the same problem too of having a crippled mail
reader :) Really I find mid posting hard to follow especially if I'm
the one that posted the question. I hope we aren't going to hit people
with hammers over this minor infraction. It really makes one feel
unwelcome.
I gues
--- On Tue, 12/11/07, Pau Marc Munoz Torres <[EMAIL PROTECTED]> wrote:
> Thanks, i'll test it tomorrow
OOPS, I just noticed a mistake.
INSERT INTO SP
SELECT a, b
FROM ( VALUES ( 'cesp', 'sp' )) AS tmp( a, b )
LEFT JOIN Sp
ON (Sp.col1,Sp.col2)=(tmp.a,tmp.b)
WHERE (Sp.
On 11/12/2007 17:41, Bill Moran wrote:
Again, you're asking a community to offer you free help in spite of the
fact that your tools suck. I'm not saying nobody will do it, all I'm
saying is that if you make it too difficult for people to help, they
won't.
I think this is the most important po
Hello everyone,
I take it from the lack of response that nobody knows how to kill a
connection from the postgresql side on windows? Is there another way
around this? In the end I created another database and changed all my
code to use the new database, the original database is still there (now
Howard Cole wrote:
> Hello everyone,
>
> I take it from the lack of response that nobody knows how to kill a
> connection from the postgresql side on windows?
You can't, short of sending a signal to the process or restarting the
service.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39ยบ 49'
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Howard Cole wrote:
>> I take it from the lack of response that nobody knows how to kill a
>> connection from the postgresql side on windows?
> You can't, short of sending a signal to the process or restarting the
> service.
Which you can do, no? I th
> "Matt Magoffin" <[EMAIL PROTECTED]> writes:
>> Hello, I'm trying to write a query to return an XML document like
>>
>>
>>
>> ...
>>
>
> Something like this:
>
> regression=# select xmlelement(name root, xmlagg(x)) from
> regression-# (select xmlelement(name range, xmlattributes(string
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Howard Cole
> Sent: Tuesday, December 11, 2007 2:21 PM
> To: 'PgSql General'
> Subject: Re: [GENERAL] Killing a session in windows
>
> Hello everyone,
>
> I take it from the lack of resp
On Tue, 11 Dec 2007 12:00:00 -0600
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> You're certainly not. I can't tell you how many times I've
> carefully replied to someone with inline quoting, only to get some
> top post response. I then ask them politely not to top post, fix
> the format, reply,
On Tue, 11 Dec 2007, Collin Kidder wrote:
I believe that my conforming to the "rule" shows that I am willing to
cater to the wishes of the overly anal people on this list. That they
cannot allow any deviation from their narrow mindset shows you that the
real problem we've been talking about is
"Obe, Regina" <[EMAIL PROTECTED]> writes:
> Well said Greg. I have the same problem too of having a crippled mail
> reader :) Really I find mid posting hard to follow especially if I'm
> the one that posted the question. I hope we aren't going to hit people
> with hammers over this minor infra
I recently discovered the hashtext() function, and I'm interested in using
> it to reduce the size of one of the biggest indexes in my database.
>
...
The problem with either MD5 or hashtext() is that neither can guarantee
> unique output even if the inputs are all unique.
>
...
>
> The problem I
Greg Stark shaped the electrons to read:
> "Obe, Regina" <[EMAIL PROTECTED]> writes:
>
> > Well said Greg. I have the same problem too of having a crippled mail
> > reader :) Really I find mid posting hard to follow especially if I'm
> > the one that posted the question. I hope we aren't going
On Tue, 2007-11-12 at 19:32 -0500, Tom Lane wrote:
> Marc Munro <[EMAIL PROTECTED]> writes:
> > This works fine:
> > "str2"varchar(40)
> > This does not:
> > "str2""pg_catalog"."varchar"(40)
>
> Yeah. That's because in all existing PG releases, type modifie
Hi all,
I run a PostgreSQL 8.1 server that hosts two main applications -- both
web-based OLTP-type work -- with a few databases for each. I'm currently
using pg_dump for backups, but the clients for one of the applications
we're hosting as asked to be moved to PITR because they like the idea o
Marc Munro <[EMAIL PROTECTED]> writes:
> This works fine:
> "str2"varchar(40)
> This does not:
> "str2""pg_catalog"."varchar"(40)
Yeah. That's because in all existing PG releases, type modifiers are
handled by hard-wired grammar productions that *only* work
On Tuesday 11 December 2007 16:11, Scott Marlowe wrote:
> read the old
> messages in this thread, you'll see that I too said it was perfectly
> acceptable some times. Things like "Thanks, that solved it!" are fine
> top posted, although you really should crop the majority of the
> message you're
"Matt Magoffin" <[EMAIL PROTECTED]> writes:
> Thanks very much, that helps. Now I'm wondering if it's also possible to
> then fill in another nested element level in the XML output, from the rows
> that are aggregated into the count.
Something involving xmlagg in the sub-query, perhaps? No time
Is it possible to create aggregate functions using pl/pgsql?
If not possible in plpgsql, is there any other way to create these types of
functions?
If anyone could point to the correct documentation I would be most appreciative.
Regards,
Richard Broersma Jr.
---(end of
Thomas Hart wrote:
Andrew Sullivan wrote:
I don't think top posting is always the crime it's made to be (and I
get a
little tired of lectures to others about it on these lists).
A
I agree. Obviously there is convention, and I will post in the style
generally accepted in the list, but to
On 12/11/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
>
> Is it possible to create aggregate functions using pl/pgsql?
Yes, the sfunc and ffunc can be functions written in plpgsql.
If not possible in plpgsql, is there any other way to create these types of
> functions?
Yes, but I don't k
Hello,
I have an interesting thing going on here...
2007-12-11 21:10:36 EST LOG: restored log file
"000107CC0012" from archive
2007-12-11 21:10:47 EST LOG: restored log file
"000107CC0013" from archive
2007-12-11 21:11:02 EST LOG: restored log file
"
All,
I want to use the ENCRYPT and DECRYPT functions from contrib, but they
require inputs of BYTEA.
My data is in VARCHAR and TEXT fields and when I try to use the contrib
functions, they complain about wrong datatypes. Is there a string
function or something that will take a VARCHAR or TE
--- On Tue, 12/11/07, Matthew Dennis <[EMAIL PROTECTED]> wrote:
> http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html
> is for
> 8.3 where there were some changes to the number of
> arguments an aggregate
> could take. I believe it's also more descriptive
> documentation.
>
> of c
"Matthew Dennis" <[EMAIL PROTECTED]> writes:
> http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html is for
> 8.3 where there were some changes to the number of arguments an aggregate
> could take. I believe it's also more descriptive documentation.
Also see the overview at
http://ww
Tom Lane wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
... Now I understand that restoring log files can be slow but this is a big
machine.
Yeah, restoring is known to be less than speedy, because essentially
zero optimization work has been done on it.
Heikki has improved matters a bit
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> ... Now I understand that restoring log files can be slow but this is a big
> machine.
Yeah, restoring is known to be less than speedy, because essentially
zero optimization work has been done on it.
Heikki has improved matters a bit in 8.3, but I
Ivan Sergio Borgonovo wrote:
On Tue, 11 Dec 2007 12:00:00 -0600
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
You're certainly not. I can't tell you how many times I've
carefully replied to someone with inline quoting, only to get some
top post response. I then ask them politely not to top post,
Dear,
I think database has its own operation journal, and different journal
filesystem does give different performance. So if I put database file on a
non-journal filesystem, would it be safe? Does this like using a raw device?
Thanks.
---(end of broadcast)--
For those interested in the I/O results (as reported by iostat) of
moving where the stats files are written (using the method I
described in http://archives.postgresql.org/pgsql-general/2007-12/
msg00106.php) on our production system: service time has dropped from
an average of 95.76ms to ab
On Dec 11, 2007 9:55 PM, Magicloud Wang <[EMAIL PROTECTED]> wrote:
> Dear,
> I think database has its own operation journal, and different journal
> filesystem does give different performance. So if I put database file on a
> non-journal filesystem, would it be safe? Does this like using a
> "Matt Magoffin" <[EMAIL PROTECTED]> writes:
>> Thanks very much, that helps. Now I'm wondering if it's also possible to
>> then fill in another nested element level in the XML output, from the
>> rows
>> that are aggregated into the count.
>
> Something involving xmlagg in the sub-query, perhaps
Gregory Williamson wrote:
* a lot of us have to use what ever the company provides as mail server.
Exchange sucks but I'd rather not quit my job just because _you_ have a
problem reading mail that does not conform to the "T" to your
expectations.
I'm guessing you use Outlook to connect to you
I'm trying to understand the explain output, but I can't find any
references to the meanings of the following terms:-
merge join
nested loop
merge left join
nested loop left join
I'm using 7.4.
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 041
--- On Tue, 12/11/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Also see the overview at
> http://www.postgresql.org/docs/8.3/static/xaggr.html
Thanks Tom!
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
I am attempting to implement (in a driver)(PG JDBC) support for
specifying which column indexes (that generated keys) to return, so I'm
searching for a way to get the server to return the values of the
columns by their index, not name. By name, it is simply to append the
RETURNING clause and co
"Chris Velevitch" <[EMAIL PROTECTED]> writes:
> I'm trying to understand the explain output, but I can't find any
> references to the meanings of the following terms:-
> merge join
> nested loop
> merge left join
> nested loop left join
http://developer.postgresql.org/pgdocs/po
Ken Johanson <[EMAIL PROTECTED]> writes:
> While the values of an API that specifies the table's columns by
> ordinaility may seem dubious, it is an API that I think should be
> implemented anyway.
Every few weeks we get a complaint from someone who thinks that it
should be easy to rearrange the
On 12/11/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> On Tue, 11 Dec 2007 06:48:35 -0800
> "Keith Turner" <[EMAIL PROTECTED]> wrote:
> > I apologize; I had assumed that the threads were simply grouped by
> > subject. If this is such a problem, probably it should be laid out on
> > the list in
On 12/11/07, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> Now, a gripe rightly attributable to the to PG mailing list setup is
> that every time I reply, I have to:
>
> (1) use reply all, because reply is set to go to the individual rather
> than the list
>
> (2) delete all the individual addressees
On Wed, 12 Dec 2007, Tom Lane wrote:
Every few weeks we get a complaint from someone who thinks that it
should be easy to rearrange the logical order of table columns.
If that comes to pass, it would be a seriously bad idea to have
encouraged applications to rely on table column numbers.
I t
I've a multithread application running on Linux. In each thread i've a loop
performing a single INSERT operation on the DB.
Sometimes (not always), two of the three thread die apparently without any
reason. The strange thing is that if I remove the store operation from
the threads, all runs fine. V
This brings up a second question. How should I do byte order
conversion for 8 byte ints? I can't use hton ntoh routines as they
max out at 32 bits. Is there a better way? Also, are floating point
numbers guaranteed uniform?
If any one knows a a clean code example of binary binding of
Kris Jurka <[EMAIL PROTECTED]> writes:
> I think the expectation is that:
> CREATE TABLE t(a int, b int);
> INSERT INTO t(b,a) VALUES (1,2) RETURNING *;
> will return 1,2 instead of 2,1 as it does now.
Hmm ... I see your point, but on what grounds could one argue that
a "*" targetlist here shoul
How can it be a simple 8 byte int or float and specify a timezone?
This is only a time interval from a fixed date/time. Where is the
timezone part?
On Nov 8, 2007, at 7:18 AM, Tom Lane wrote:
Samantha Atkins <[EMAIL PROTECTED]> writes:
What can I expect for a date format from a PGresult
101 - 146 of 146 matches
Mail list logo
