O Dennis Sacks έγραψε στις Jan 31, 2005 :
> Sam Adams wrote:
>
> >Anyway, I was wondering which would be a better way to store a large
> >amount of files each a few megabytes in size. There could be hundreds of
> >thousands of files altogether. If stored as BYTEAs this would put them
> >all in a
[EMAIL PROTECTED] writes:
> In my hands it looks like a user with INSERT/DELETE/UPDATE rights on table1
> cannot do "update table1 set field1=xx where field2=yy" without also being
> granted select rights. However, the user can do "update table1 set field1=xx".
> Is this right?
Yes. Otherwise you
hi,
I'm not familiar with iso2709 but there is a program called Octopus that may do what
you want. It's open source software and can be found at octopus.enhydra.org -
worth a try anyway.
Regards
Iain
- Original Message -
From:
Matteo
Braidotti
To: pgsql-sql@postgres
On Jan 31, 2005, at 1:59 PM, Ing. Jhon Carrillo wrote:
ERROR: function tschema.sp_actualizar_contacto(integer, "unknown",
"unknown", "unknown", "unknown", "unknown", "unknown", integer,
"unknown", "unknown", "unknown", "unknown", "unknown", "unknown",
"unknown", "unknown", "unknown", "unknown",
As I read the docs, a temp table doesn't solve our problem, as it does
not persist between sessions. With a web page there is no guarentee
that you will receive the same connection between requests, so a temp
table doesn't solve the problem. It looks like you either have to
create a real table (w
Hi PFC
Thanks for this! It has sped up complete - now in fact there is no delay!
A few tweaks had to be made to the code ; here it is:
select breakdown.alignment, sum(cnt) as num FROM
( (select alignment.name as class, count(1) as cnt
from weapons,
alignment
where weapons
Hi,
i have a problem with the following
sentence:
CREATE OR REPLACE FUNCTION
tschema.sp_actualizar_contacto(p_idpers
text,
p_nombre
text,
p_apellido
text,
Hi... People
I would like to know if inside of a function that has been called by
a trigger, what instruction the SQL called, i do not wanna know if it´s
a insert or a update or a delete (tg_op)... i need the full instruction.
For example:
I wanna know the number of the instruction:
update te
Hi, I need a script or a program that convert and
esport my data from sql database to a file in the iso2709 format
thanks
bye
PostgreSQL 8.0.0 on WinXP Pro, libpq
In my hands it looks like a user with INSERT/DELETE/UPDATE rights on table1
cannot do "update table1 set field1=xx where field2=yy" without also being
granted select rights. However, the user can do "update table1 set field1=xx".
Is this right? Any explanations
Quoting Dennis Sacks <[EMAIL PROTECTED]>:
> Bruno Wolff III wrote:
> >On Tue, Jan 25, 2005 at 21:21:08 -0700,
> > Dennis Sacks <[EMAIL PROTECTED]> wrote:
> >>One of the things you'll want to do regularly is run a "vacuum analyze".
> >>You can read up on this in the postgresql docs. This is essent
Hi,
What you could do is create a table containing all the fields from your SELECT,
plus a per-session unique ID. Then you can store the query results in there,
and use SELECT with OFFSET / LIMIT on that table. The WHERE clause for this
temp-results table only needs to contain the per-session u
Sam Adams wrote:
Anyway, I was wondering which would be a better way to store a large
amount of files each a few megabytes in size. There could be hundreds of
thousands of files altogether. If stored as BYTEAs this would put them
all in a single table. Would this effect performance considerablely?
Don Drake <[EMAIL PROTECTED]> writes:
> On Mon, 31 Jan 2005 16:32:02 -0800 (PST), Stephan Szabo
> <[EMAIL PROTECTED]> wrote:
>> Actually, now that I think about it, I wonder if that's a good thing to
>> use because I don't think that'll use indexes to do the search. You may
>> want to do some test
Hi,
Apologies if I've already sent a post asking this but I'm not sure if it
actually went through last time as it doesn't seem to be in my sent
items box.
Anyway, I was wondering which would be a better way to store a large
amount of files each a few megabytes in size. There could be hundreds of
I'm constraining on other columns as well and it's still picking up the index.
Thanks again.
-Don
On Mon, 31 Jan 2005 16:32:02 -0800 (PST), Stephan Szabo
<[EMAIL PROTECTED]> wrote:
> On Mon, 31 Jan 2005, Don Drake wrote:
>
> > You learn something new everyday. I've never seen that syntax befo
On Mon, 31 Jan 2005, Don Drake wrote:
> You learn something new everyday. I've never seen that syntax before,
> and it works like a charm!!
Actually, now that I think about it, I wonder if that's a good thing to
use because I don't think that'll use indexes to do the search. You may
want to do
On Mon, Jan 31, 2005 at 08:29:42PM -0200, Luiz Rafael Culik Guimaraes wrote:
>
> i´m trying to solve the follow message
> current transaction is aborted, queries ignored until end of transaction
> block
A previous command in the transaction has failed; no more commands
will be executed until you
On Mon, 2005-01-31 at 16:29, Luiz Rafael Culik Guimaraes wrote:
> Hi Michael Fuhr
> >> how i can increse the number of commands in an transaction block
> >
> > What do you mean? What problem are you trying to solve?
>
> iÂm trying to solve the follow message
> current transaction is aborted, quer
Hi Michael Fuhr
how i can increse the number of commands in an transaction block
What do you mean? What problem are you trying to solve?
i´m trying to solve the follow message
current transaction is aborted, queries ignored until end of transaction
block
some one tell me this is defined inside pos
You learn something new everyday. I've never seen that syntax before,
and it works like a charm!!
Thanks a ton.
-Don
On Mon, 31 Jan 2005 13:31:34 -0800 (PST), Stephan Szabo
<[EMAIL PROTECTED]> wrote:
>
> On Sun, 30 Jan 2005, Don Drake wrote:
>
> > OK, I have a function that finds records tha
On Mon, Jan 31, 2005 at 07:54:45PM -0200, Luiz Rafael Culik Guimaraes wrote:
>
> how i can increse the number of commands in an transaction block
What do you mean? What problem are you trying to solve?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of broadcast)---
Dear Friends
how i can increse the number of commands in an transaction block
i use postgres 7.4.5 on linux
Regards
Luiz
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Don Drake" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, January 31, 2005 7:31 PM
Subject: Re: [SQL] plpgsql
On Sun, 30 Jan 2005, Don Drake wrote:
> OK, I have a function that finds records that changed in a set of
> tables and attempts to insert them into a data warehouse.
>
> There's a large outer loop of candidate rows and I inspect them to see
> if the values really changed before inserting.
>
> My
As far as I know, you didn't post your actual table definitions (or
full queries) earlier, so I'm not exactly sure what you mean.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-00
My outer query to get the candidates has an outer join, that works
just fine and I get the null OMCR_ID's.
It's when I have to query the dimension table (no joins) to see if a
row exists with a (sometimes) null OMCR_ID I'm forced to write 2
queries, when I think I should only have to write one.
T
This sounds like a perfect candidate for a LEFT OUTER JOIN. See:
http://www.postgresql.org/docs/7.4/static/queries-table-
expressions.html#QUERIES-FROM
Yours would looks something like:
SELECT *
FROM ...
LEFT JOIN candidate AS c
ON <...>.omcr_id = c.omcr_id
AND ...
-tfo
--
Thomas F. O'Connell
Co-
27 matches
Mail list logo
