Le 6/07/2010 17:17, Tom Lane a écrit :
Arnaud Lesauvage writes:
As you have understood, I am not very savvy about postgresql's
internals, but from what you say my guess is that the problem is int the
psqlODBC is getting the default value of the sequence ?
I have no idea, because you haven'
On 06/03/2010 08:26 AM, Chris Browne wrote:
len.wal...@gmail.com (Len Walter) writes:
I need to populate a new column in a Postgres 8.3 table. The SQL would be something
like "update t set col_c = col_a +
col_b". Unfortunately, this table has 110 million rows, so running that query
runs out of
On Tue, Jul 6, 2010 at 11:57 AM, Thom Brown wrote:
> On 6 July 2010 16:50, John R Pierce wrote:
>> On 07/05/10 2:43 PM, Dennis Gearon wrote:
>>>
>>> I belong to MANY email listservers, probably like all of us.
>>>
>>> All of them, I am on digest.
>>>
>>
>> I quit using digests many years ago when
On 06/07/10 17:47, Davor J. wrote:
> Thanks Craig.
>
> I still find it a bit awkward that we have to use "priv check function"-s
> because we can't define triggers on or reference to system tables. I think
> that allowing it would significantly extend Postgres possibilities.
Certainly being abl
I was notified last week that we have a booth at OSCON. \o/ I'll
need booth staff during the following times:
Wed (the 21st) 10am - 430pm
Thurs (the 22nd) 10am - 5pm
I'll also need someone(s) for set-up either Tuesday evening or early
Wednesday, and tear-down Thursday evening. This usually inv
Excerpts from Luca Ferrari's message of mar jul 06 02:53:03 -0400 2010:
> Hi,
> I don't see any direct link between the TupleDesc structure and the HeapTuple
> one, and it seems strange to me since to manipulate a tuple you often need
> the
> descriptor. What is the trick here?
You're supposed
I have gis data in layers, and a pin might appear in either layer, or
both (parcelPoly, parcelPoint), or neither (and I dont care which I
find)... so I have this view:
create view howardia.getPoint(shapeid, x, y, acres, pin, extent) as
SELECT gid,
st_x(st_centroid(the_geom)) AS x,
On 7/6/2010 3:06 AM, GrGsM wrote:
Hi all
I am using the following query for data to be displayed in crosstab :
SELECT closedate,status,
SUM (CASE WHEN empcode = 'NT-028' THEN 1 ELSE 0 END) AS NT028,
SUM (CASE WHEN empcode = 'NT-031' THEN 1 ELSE 0 END) AS NT031,
On 6 July 2010 16:50, John R Pierce wrote:
> On 07/05/10 2:43 PM, Dennis Gearon wrote:
>>
>> I belong to MANY email listservers, probably like all of us.
>>
>> All of them, I am on digest.
>>
>
> I quit using digests many years ago when threaded email clients with
> filtering support came along.
On 07/05/10 2:43 PM, Dennis Gearon wrote:
I belong to MANY email listservers, probably like all of us.
All of them, I am on digest.
I quit using digests many years ago when threaded email clients with
filtering support came along. instead, I have a postgres folder in my
mail client (cur
On Fri, Jul 2, 2010 at 12:22 PM, Tim wrote:
> I've had a website up for a couple of months and it's starting to get
> these db timeouts as traffic has increased to say 1k pageviews a day.
>
Are you using any two-phase commit (ie, prepared transactions?)
We find that if you try to insert data tha
Daniel Schuchardt writes:
> CREATE OR REPLACE FUNCTION show_transform_problem(with_transform BOOL)
> RETURNS BOOL AS $$
> DECLARE result BOOL;
> BEGIN
> IF with_transform THEN
> SET transform_null_equals TO ON;
> END IF;
> RESULT:=NULL=1;
> SET transform_null_equals TO OFF;
> RETU
On Tue, Jul 06, 2010 at 12:06:06AM -0700, GrGsM wrote:
> SELECT closedate,status,
>SUM (CASE WHEN empcode = 'NT-028' THEN 1 ELSE 0 END) AS NT028,
>SUM (CASE WHEN empcode = 'NT-031' THEN 1 ELSE 0 END) AS NT031,
>SUM (CASE WHEN empcode = 'NT-050' THEN 1 ELSE 0
GrGsM, 06.07.2010 09:06:
Now i need a column in the same result of the query which shows the
difference between the two columns .
For Example :
the result shoud be
Closedate , status , NT028, NT031, NT050,NT062 , NT028-NT031
Please note the last column in bold, i need the difference .
Alr
Hi all
I am using the following query for data to be displayed in crosstab :
SELECT closedate,status,
SUM (CASE WHEN empcode = 'NT-028' THEN 1 ELSE 0 END) AS NT028,
SUM (CASE WHEN empcode = 'NT-031' THEN 1 ELSE 0 END) AS NT031,
SUM (CASE WHEN empcode = 'NT-0
Hy Group,
we use:
PostgreSQL 9.0alpha4, compiled by Visual C++ build 1400, 32-bit
and i tried to set Transform_null_equals in a Trigger to avoid a complex
If Statement with many Coalesce, but it didnt work. You can try it
easily with that example:
CREATE OR REPLACE FUNCTION show_transform_
Dennis Gearon:
By using the 'subjects contents' table at the top of the digest
email, and the back button, it is VERY easy to investigate only the
subjects one is intersted in, without having to scan through the
whole digest. There are other, better-than-pgsql-mail-program
convenience attributes
Arnaud Lesauvage writes:
> As you have understood, I am not very savvy about postgresql's
> internals, but from what you say my guess is that the problem is int the
> psqlODBC is getting the default value of the sequence ?
I have no idea, because you haven't showed us what's happening, only
you
Hi Alban,
I have finally managed to get to the bottom of the problem I was facing.
I thought I'd share my findings, as I managed to waste a lot of time
trying to solve the problem.
As previously mentioned I have several complicated triggers that run after an
insert on a given table. Some of the
Le 6/07/2010 16:22, Tom Lane a écrit :
Arnaud Lesauvage writes:
After some research, we found in psqlODBC's log that before the restore
psqlODBC was getting the sequence's nextval with a schema qualified
call, and after the restore the call was not schema qualified.
I checked in pg_attrdef
Hello,
We have been developing a high-availability and
version control solution for Postgres, called
ChronicDB[1], that aims to combine live schema
changes, replication, live connection migration,
and scalability in a cohesive manner. We are
requesting feedback[2] on the most desireable
features P
Arnaud Lesauvage writes:
> After some research, we found in psqlODBC's log that before the restore
> psqlODBC was getting the sequence's nextval with a schema qualified
> call, and after the restore the call was not schema qualified.
> I checked in pg_attrdef before and after the dump/restore, a
On 6 Jul 2010, at 13:03, Andre Lopes wrote:
> Hi Alban,
>
> But in my application I have more than one way of uniquely identify the
> record. Could be by the email field or by the id field.
Unique is unique. There is no other record that could possibly be identified by
the same unique identifi
On Tue, Jul 06, 2010 at 12:55:22PM +0100, Andre Lopes wrote:
> update aau_utilizadores
> set group_id = 3
> where email = pEMAIL;
[..]
> If I use the clause WHERE only in "id" will not work fot both cases, or will
> work?
Yes, it'll do the "right thing". OLD always refers
Hi,
Thanks for the reply.
In the application there are two kinds of UPDATES to this table.
[code]
update aau_utilizadores
set group_id = 3
where email = pEMAIL;
[/code]
and
[code]
update aau_utilizadores
set password = 3
where id = pNEWPASSWORD;
On Tue, Jul 06, 2010 at 12:28:35PM +0100, Andre Lopes wrote:
> Ok, I have done the UPDATE RULE like this and works!
> where
> (id = OLD.id or username = OLD.username or email = OLD.email)
I'm pretty sure you just want to be using the id column above. Using an
OR expression as you're doing could
Ok, I have done the UPDATE RULE like this and works!
[code]
update atau_utilizadores
set group_id = NEW.group_id,
password = NEW.password,
salt = NEW.salt,
email = NEW.email,
activation_code = NEW.activation_code,
forgotten_password_code = NEW.forgotten_password_code,
remember_code = NEW.remember_
Hi Alban,
But in my application I have more than one way of uniquely identify the
record. Could be by the email field or by the id field.
Thera are update that are done by the WHERE email clause and other by the
WHERE id clause.
It is possible to deal with this?
Best Regards,
On Tue, Jul 6,
On 6 Jul 2010, at 12:28, Andre Lopes wrote:
> Now I need also to add an INSTEAD UPDATE rule and an INSTEAD DELETE rule, but
> I have some doubts about it... let me explain...
>
> Ok, I need to create an INSTEAD UPDATE rule in this view, but I don't know
> how to use the clause WHERE in the UPDA
Hi,
I'am using rules in views, but I'am not sure about how the rules work... let
me explain...
For example, I have this table:
[code]
CREATE TABLE "atau_utilizadores" (
"id" int4 NOT NULL,
"group_id" int4 NOT NULL,
"ip_address" char(16) NOT NULL,
"username" varchar(50) NOT NULL,
Hi,
I'am using rules in views, but I'am not sure about how the rules work... let
me explain...
For example, I have this table:
[code]
CREATE TABLE "atau_utilizadores" (
"id" int4 NOT NULL,
"group_id" int4 NOT NULL,
"ip_address" char(16) NOT NULL,
"username" varchar(50) NOT NULL,
Great option!
Thanks Andreas
""A. Kretschmer"" wrote in message
news:20100706093242.gd13...@a-kretschmer.de...
> In response to Davor J. :
>> I couldn't find it on the net. I also coudn't find any reference to it in
>> the psql source?
>>
>> Anyone any suggestions?
>
> Start your psql with optio
Hi Alban,
Thanks again for your response.
On Tue, Jul 06, 2010 at 11:57:14AM +0200, Alban Hertroys wrote:
> On 6 Jul 2010, at 11:33, Sebastian Ritter wrote:
>
> > In what order will the triggers be executed?
> >
> > Will it be:
> >
> > INSERT row
> > INVOKE TRIGGER A (First call)
> > INVOKE TR
Hi lists !
We ran into a problem after restoring a database dump.
Postgesql version is 8.4.3 on Win32.
The tables are linked with psqlODBC (v8.03.0400) and have SERIAL primary
keys (that's why I cross-posted to psql-odbc).
Before the restore, insertion in MSAccess was fine. After the restore,
On 6 Jul 2010, at 11:33, Sebastian Ritter wrote:
> I have a table with 4 AFTER INSERT triggers defined for a table.
>
> For example purposes lets call them A,B,C,D.
>
> I know that they will execute in alphabetical order as per the
> PostgreSQL docs.
>
> However, on occasion, trigger B will c
Thanks Craig.
I still find it a bit awkward that we have to use "priv check function"-s
because we can't define triggers on or reference to system tables. I think
that allowing it would significantly extend Postgres possibilities.
>From a quick google it seems that triggers on system tables is
Hi All,
I posted a few questions earlier last week about how triggers are
executed and wanted to expand on them, if possible.
I have a table with 4 AFTER INSERT triggers defined for a table.
For example purposes lets call them A,B,C,D.
I know that they will execute in alphabetical order as per
In response to Davor J. :
> I couldn't find it on the net. I also coudn't find any reference to it in
> the psql source?
>
> Anyone any suggestions?
Start your psql with option -E to display the query behind:
kretsch...@tux:~$ psql -E test
psql (8.4.2)
Type "help" for help.
test=# \dp foo
I couldn't find it on the net. I also coudn't find any reference to it in
the psql source?
Anyone any suggestions?
Regards,
Davor
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I don't see any direct link between the TupleDesc structure and the HeapTuple
one, and it seems strange to me since to manipulate a tuple you often need the
descriptor. What is the trick here?
Thanks,
Luca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
40 matches
Mail list logo
