I understand that the query plan of a function is determined at CREATION and remains the same whatever the parameter(s) value. I suppose then that this plan is stored somewhere in a system table ? Is it possible to consult this plan ?
Thanks,Paul
Stephan Szabo wrote:
On Thu, 4 May 2006, Rich Doughty wrote:
I have a foreign key constraint that I'd like to alter. I'd rather not
drop and re-create it due to the size of the table involved. All I need
to do is add an ON UPDATE CASCADE.
Is it ok to set confupdtype to 'c' in pg_constraint (a
"Paul Mackay" <[EMAIL PROTECTED]> writes:
> I understand that the query plan of a function is determined at
> CREATION and remains the same whatever the parameter(s) value. I
> suppose then that this plan is stored somewhere in a system table ?
You are misinformed. It's determined the first time
hi all,
i want to capture individual sqlexceptions and for each different
exception i want to display a different message to the user. the
problem is how should i capture from the exception of its type-content
and then display a customised message.
all help appreciated.
thanks.
--
Greetings to everyone on the list
I am attempting to write a system which would copy primary key values
to another table after insert. To achieve this, I wrote a trigger
function in Perl. I also wanted to make the function reusable, so the
fields included in the query are passed as function
Hi,
We desire to implement a multi-site server that unifies
data from distant Postgres databases in a nightly batch. The distant databases
have all the same architecture (schema). The size of data exchanged between
distant servers and the multi-site manager has to be reduced to the strictl
Dear all,
I have a syntax problem but I don't find the clue.
Actually I adapt an mySQL query to a postgreSQL but I got a message
error that I can't interpret.
SELECT g.id, t1.name, substring(g.path, 1, (6*(-1+l.id)) + 5) as
subpath,l.id-1 as level
FROM graph_path g
INNER JOIN term AS t1
Hello,
I have the following Query with Subqueries.
This query gives the error : ERROR: more than one row returned by a subquery
used as an expression. Is there a solution to solve this problem:
SELECT tbl_wk_wedstrijd.wedstrijdid,
tbl_wk_wedstrijd.thuisploeg AS thuisploegid,
tbl
Hi all, hope this is the right list.
I have postgres 8.1 running on linux. We have tests that mostly run on
windows. I want to run these tests on linux.
On these windows boxes, pg_hba.conf has just one line:
hostall all 127.0.0.1/32 md5
They use 'postgres' as the us
On Fri, May 05, 2006 at 11:50:05AM +0300, Tuukka Norri wrote:
> However, I would rather use PL/PgSQL, since the Perl interpreter
> might not be installed by default. Is there a way to access the NEW
> record without knowing the field names in advance?
No. pl/pgsql is not flexible enough as a l
I would add that I also found on the pgsql-admin list a similar pltcl
way to do what you're after posted in October of 04 by Ian.
One way or the other though likely you will need to install first the
ActiveTCL
AND/OR
ActivePerl
From
http://www.activestate.com
if may also want to read in the
On Wed, 3 May 2006, Arjan Vroege wrote:
> Hello,
>
> I have the following Query with Subqueries.
> This query gives the error : ERROR: more than one row returned by a subquery
> used as an expression. Is there a solution to solve this problem:
Scalar subqueries (like the ones in your select list)
"Fred" <[EMAIL PROTECTED]> writes:
> I have a syntax problem but I don't find the clue.
> Actually I adapt an mySQL query to a postgreSQL but I got a message
> error that I can't interpret.
> SELECT g.id, t1.name, substring(g.path, 1, (6*(-1+l.id)) + 5) as
> subpath,l.id-1 as level
> FROM graph_p
Fred wrote:
Dear all,
I have a syntax problem but I don't find the clue.
Actually I adapt an mySQL query to a postgreSQL but I got a message
error that I can't interpret.
SELECT g.id, t1.name, substring(g.path, 1, (6*(-1+l.id)) + 5) as
The thing that stands out to me is the syntax for the su
On Fri, 2006-05-05 at 04:21, Houssais Hugues wrote:
> Hi,
>
> We desire to implement a multi-site server that unifies data from
> distant Postgres databases in a nightly batch. The distant databases
> have all the same architecture (schema). The size of data exchanged
> between distant servers and
On Fri, 2006-05-05 at 12:49 -0400, Tom Lane wrote:
> "Fred" <[EMAIL PROTECTED]> writes:
> > I have a syntax problem but I don't find the clue.
> > Actually I adapt an mySQL query to a postgreSQL but I got a message
> > error that I can't interpret.
>
> > SELECT g.id, t1.name, substring(g.path, 1,
[I apologize if this message gets out twice. I accidentally sent the first one from the wrong email address]Hi,We're having a problem with a couple of our tables.I have 2 tables, attribute and attribute_value: Table "public.attribute" Column | Type |
Russ Brown <[EMAIL PROTECTED]> writes:
> On Fri, 2006-05-05 at 12:49 -0400, Tom Lane wrote:
>> "Fred" <[EMAIL PROTECTED]> writes:
>>> SELECT g.id, t1.name, substring(g.path, 1, (6*(-1+l.id)) + 5) as
>>> subpath,l.id-1 as level
>>> FROM graph_path g
>>> INNER JOIN term AS t1
>>> INNER JOIN term AS
Brendan Duddridge <[EMAIL PROTECTED]> writes:
> They both have a click_count column that we update with "update
> attribute set click_count = click_count + 1;" and the same for the
> attribute_value table. Postgres is getting hung up on any transaction
> that attempts to update the click_coun
Hi Tom,
There must have been something like that because when we stopped and
started postgres again, it worked.
Thanks,
Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED]
ClickSpace Interactive Inc.
Suite L100
On Friday 05 May 2006 13:06, Douglas McNaught wrote:
> "Paul Mackay" <[EMAIL PROTECTED]> writes:
> > I understand that the query plan of a function is determined at
> > CREATION and remains the same whatever the parameter(s) value. I
> > suppose then that this plan is stored somewhere in a system t
A little self advertising:
Here is a link to my proposal that was sent to google:
http://www.technion.ac.il/~tzahi/proposal.txt
Full Disjunction is an operator.
Without any long introductions (see link above)...
An excerpt:
Example of an input and output of a full disjunctions:
A
I have to log each time a user selects data from a table by inserting
record in another table.
For example
I have table xzy
user test selects id, name from table xyz.
I want to insert into table xyz_log
user, action, fields, timestamp
test, select, id name, 12/1/05 02:00:21
How can i do this u
Dany De Bontridder <[EMAIL PROTECTED]> writes:
> And after a vacuum analyze, the plan can change ??
I don't *think* that the pl/pgsql query plan cache is ever currently
flushed in the lifetime of a given connection. If you disconnect and
reconnect with a fresh backend it will be planned again th
Hi,
I'm reading through the source code of intarray contrib module. Despite
being at the beginning, I've some questions to ask. I'd be so
appreciated if anybody can help.
[1]
What's the function of execute() in _int_bool.c? As far as I can
understand, some other functions (eg. execconsistent())
Sean,
I am looking to do the same thing...
I have so far posted with little relevant response to pgsql-admin,
pgsql-general and pgsql-sql
If you get any help please forward my way...
I will do the same..
What I can tell you is that it is possible to write the Select
Statements submitted to the
On 5/5/06, Sean Hamilton <[EMAIL PROTECTED]> wrote:
I have to log each time a user selects data from a table by inserting
record in another table.
For example
I have table xzy
user test selects id, name from table xyz.
I want to insert into table xyz_log
user, action, fields, timestamp
test, sele
"Tzahi Fadida" <[EMAIL PROTECTED]> writes:
> The output of the full disjunctions FD(A,B,C):
> FD
> X Y Z
> a | b | c
> a | b | d
> This output cannot be generated using standard SQL statements.
Does anybody care? Your example looks to me like nothing but a poorly
de
On 5 May 2006 02:22:32 -0700, robert <[EMAIL PROTECTED]> wrote:
Hi all, hope this is the right list.
I have postgres 8.1 running on linux. We have tests that mostly run on
windows. I want to run these tests on linux.
On these windows boxes, pg_hba.conf has just one line:
hostall al
This is best done by using a trigger on the table.
http://www.varlena.com/GeneralBits/38.php shows how
to do it with both a trigger and with a rule.
--elein
[EMAIL PROTECTED]
On Fri, May 05, 2006 at 04:48:28PM -0400, Sean Hamilton wrote:
> I have to log each time a user selects data from a table
http://www.enterprisedb.com/news_events/press_releases/04_24_06.do
Was wondering if anyone had used that to import an Oracle .dmp file
and then export a Postgres 8.1 dump file for import into a regular
PostgreSQL database.
-M@
---(end of broadcast)-
By "regular PostgreSQL" do you mean a PostgreSQL 7.x install?
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Matthew Hixson wrote:
http://www.enterprisedb.com/news_events/press_releases/04_24_06.
Just a normal, downloaded from www.postgresql.org, PostgreSQL 8.1
database.
-M@
On May 5, 2006, at 4:56 PM, Terry Fielder wrote:
By "regular PostgreSQL" do you mean a PostgreSQL 7.x install?
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf H
Hello.
I have an MS - Access front end which connects to PostgreSQL 8.1.3.
Almost everything is working great, I especially love how I can use
rules in PostgreSQL to be able to update and insert into views, which
is awesome.
Now my only issue, and I'm not sure this is even possible but here it
is
It's meant for heterogeneous data sources and, as you put it,
scheme graph where you want to take out information you did not
initially design for. It is not unheard of to have a cycle in your
scheme graph, in which case Full disjunction is the only way to pull
out all the information with no subs
"Karen Hill" <[EMAIL PROTECTED]> writes:
> Can one base an MS Access form on a PostgreSQL table using only
> ADO and have it be updateable and insertable?
Damifino, but the people who would know probably hang out in pgsql-odbc,
not here ...
regards, tom lane
-
Terry Fielder wrote:
By "regular PostgreSQL" do you mean a PostgreSQL 7.x install?
No he probably means the current Open Source release from the PostgreSQL
Development group thus 8.1.3.
Joshua D. Drake
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Matthew Hixson wrote:
> Just a normal, downloaded from www.postgresql.org, PostgreSQL 8.1
> database.
I imagine Terry's question stems from what would appear to be a
straightforward scenario, and hence the need to ask. For the second
part of your question, are you asking simply if you can dump a
On 3 May 2006 19:16:17 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
hi all,
i want to capture individual sqlexceptions and for each different
exception i want to display a different message to the user. the
problem is how should i capture from the exception of its type-content
and then dis
39 matches
Mail list logo
