Is there any possibility to mention max time a query can execute from DBCP
side? our DB is Postgres and Container is tomcat 6. we dont want to give the
timeout in postgres for all query but need to set in application side based
on differnet needs? Is it possible?
Is there anyother way to specify
In response to S Arvind :
Is there any possibility to mention max time a query can execute from DBCP
side? our DB is Postgres and Container is tomcat 6. we dont want to give the
timeout in postgres for all query but need to set in application side based on
differnet needs? Is it possible?
S Arvind wrote:
Is there any possibility to mention max time a query can execute from
DBCP side? our DB is Postgres and Container is tomcat 6. we dont want to
give the timeout in postgres for all query but need to set in
application side based on differnet needs? Is it possible?
Is there
Rastislav Hudak wrote:
I'd like to get an array containing distinct values (always
integers) form a column in a table that is provided as a
parameter. So I created this function:
CREATE OR REPLACE FUNCTION get_distinct_values(table_name text, param_name
text)
RETURNS integer[] AS
I've encountered this error for the first time
psql:./import_stock_scratch.sql:9: ERROR: deadlock detected
DETAIL: Process 11095 waits for AccessExclusiveLock on relation
250545 of database 248569; blocked by process 11099. Process 11099
waits for AccessShareLock on relation 250510 of database
Hi All!
I've seen sometning unexpected here. I'd apreciate it if someone could
give me a hint of why this have happened and may be a sugesstion of a
workaround.
I'm writing Building Access Control System (BACS). My environment is
Debian testing with their current postgresql version: 8.3.7.
I my
I am having a vexing problem with a script I am writing to populate reference
tables in a new database.
I am running postgreSQL 8.3 with psql 8.3.7.
Psql reads this SQL statement:
INSERT INTO META_AUTH.DOMAIN_META_ASSERTION (TITLE, DESCRIPTION,
META_ASSERTION)
VALUES ('Super-User
By George, I think you've got it!
(Imagine a hokey imitation British accent.)
I only had to make one small change. It complained it didn't know about a
column named charge. When I changed it to:
select charge, (cn).* from (select charge, chargeneeds(charge) as cn from
charge) q;
it
Rafal Pietrak wrote:
Now I'd like to write a RULE, that automatically updates references
between EVENTLOG and STATUS:
The NEW tuple of the table EVENTLOG, in its ID field at the moment of
RULE execution has a value of 5! But after everything is finished, the
actual value deposited in that
On Fri, 2009-06-05 at 14:32 +0100, Richard Huxton wrote:
Rafal Pietrak wrote:
The NEW tuple of the table EVENTLOG, in its ID field at the moment of
RULE execution has a value of 5! But after everything is finished, the
actual value deposited in that record is 4.
A rule rewrites the
Grand, Mark D. mgr...@emory.edu writes:
... I get this message:
ERROR: invalid byte sequence for encoding UTF8: 0xab
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by client_encoding.
It is complaining about
On Thu, Jun 04, 2009 at 11:11:29AM -0400, Bruce Momjian wrote:
Jennifer Trey wrote:
Hi,
What file should I be working with?
Just shut down the server and move the directory whever you want and
restart the server. There are no file contents that need changing.
Of course should adjust
Hi all,
Is there any way, to know the name of indexes on a table, defined in a
database. I mean can I query something like
Select Index_name from pg_class where relname = Table_name . Thanks in
advance.
--- Thanks Reagrds
Anirban Pal | Software Engineer
Newgen Software
I'm attempting to create a Foreign Key Constraint between a table and a
view in PostgreSQL 8.3. Ex:
ALTER TABLE public.table ADD CONSTRAINT table_to_view_fk
FOREIGN KEY (view_key)
REFERENCES public.view (view_key)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE;
However, I get an error
Hey there,
I developed a program where you must authenticate on startup. Now my
users already authenticate themselves when they login on Windows, so
basically they authenticate twice. To avoid this, the docs told me to
use GSSAPI or SSPI as psql authentication method, so my program could
use the
I came across this curious behaviour today, at least in the 2009-03-24
beta (I can't run a newer beta), that I couldn't find in the docs,
although maybe I missed it. I found this really confusing until I
figured it out, so I thought I should share, and if it's not in the
docs, it should probably
Hi,
I keep having this need to create a function that will change the row data
as I am walking through the data. For example, I process each row in order,
if column1 change from previous row, set column2 to true.
Is this possible? I can run another query to modify the data, but that
doesn't
On 6月4日, 下午1时52分, youngvon...@gmail.com youngvon...@gmail.com
wrote:
hello,all
i want to understand database knowledge about ipc,store,etc with a
project,ie,postgresql. I want to ask postgresql source code is very
good, is worth to learn .
thanks.
I want to ask if postgresql source code
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I've encountered this error for the first time
psql:./import_stock_scratch.sql:9: ERROR: deadlock detected
DETAIL: Process 11095 waits for AccessExclusiveLock on relation
250545 of database 248569; blocked by process 11099. Process 11099
hello,all
i want to understand database knowledge about ipc,store,etc with a
project,ie,postgresql. I want to ask postgresql source code is very
good, is worth to learn .
thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi,
I'd like to get an array containing distinct values (always integers) form a
column in a table that is provided as a parameter. So I created this
function:
CREATE OR REPLACE FUNCTION get_distinct_values(table_name text, param_name
text)
RETURNS integer[] AS
$BODY$
DECLARE
_values
Would the backup be unrecoverable if I shutdown the databse first?
Chris Browne cbbro...@acm.org wrote in message
news:87ab4qfs48@dba2.int.libertyrms.com...
Carlos Oliva car...@pbsinet.com writes:
Is there a way to create a database or a table of a database in its own
folder? We are
hello,
i am new to postgresql.actually i use openoffice for my database needs
but i see over internet people talking postgresql is the best solution
for database needs.i would love to make tables,queries,reports etc.can
you guide me what product i should download and use?
thanks and GOD
Thank you for your response. The tablespace should work for us. Perhaps you
can help me with the following questions:
1) If we were to create a different table space for a database that has
archival tables -- they will be backed up once, is it sufficient to backup the
tablespace folder once?
Thank you for your response. The tablespace should work for us. Perhaps you
can help me with the following questions:
1) If we were to create a different table space for a database that has
archival tables -- they will be backed up once, is it sufficient to backup the
tablespace folder once?
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the
database to tape and one to exclude some tables from this backup. We
can selectively backup folders of the file system so we figure that if
we can create a
Hi all,
When RETURNING from a DELETE statement (or similar), how do you access the
results being returned?
Something like:
SELECT COUNT(*) FROM (DELETE FROM a RETURNING *) ;
sounds reasonable but results in a syntax error. I am able to return single
results into a variable or record, but not
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the
database to tape and one to exclude some tables from this backup. We
can selectively backup folders of the file system so we figure that if
we can create a
Hi all,
When RETURNING from a DELETE statement (or similar), how do you access the
results being returned?
Something like:
SELECT COUNT(*) FROM (DELETE FROM a RETURNING *) ;
sounds reasonable but results in a syntax error. I am able to return single
results into a variable or record, but
yes, it is called table space. Check this groups archive, it was
discussed quite recently.
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
oops, I just realised you asked that question before :P
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
The easiest way to get started is to use your package management
system to install PG for you. If you are on a Fedora/Centos or
similar based system then this is easily accomplished with the 'yum'
command. The minimal packages to add would likely be :
postgresql-server
postgresql
The latter
On Tuesday 02 June 2009, Carlos Oliva carl...@pbsinet.com wrote:
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the
database to tape and one to exclude some tables from this backup. We
can selectively
On Tuesday 02 June 2009, Carlos Oliva carl...@pbsinet.com wrote:
Thank you for your response. The tablespace should work for us. Perhaps
you can help me with the following questions:
1) If we were to create a different table space for a database that has
archival tables -- they will be
On Fri, Jun 5, 2009 at 9:57 AM, Tom Lanet...@sss.pgh.pa.us wrote:
The ASCII code for '' is 0x3c, not 0xab. I am not sure what you are
actually typing; although it's suggestive that the LATIN1 code 0xab
corresponds to a symbol that looks approximately like ''. The most
likely bet is that you
Anirban Pal anirban@newgen.co.in writes:
Is there any way, to know the name of indexes on a table, defined in a
database. I mean can I query something like
Select Index_name from pg_class where relname = Table_name . Thanks in
advance.
You need to join through pg_index, specifically
p == pgmaili...@codecraft.se writes:
p On 4 jun 2009, at 22.17, Richard Broersma wrote:
p On Thu, Jun 4, 2009 at 1:13 PM, Brandon Metcalf
p bran...@geronimoalloys.com wrote:
p Is there a way when creating a table to limit it to one row? That
p is,
p without using a stored procedure?
What would be the best way to maintain referential integrity in the
following situation? Let's say I have the following table
CREATE TABLE workorder (
workorder_id INTEGER NOT NULL,
part_id INTEGER DEFAULT NULL,
generic BOOLEAN DEFAULT FALSE,
PRIMARY KEY
Dear list,
Here's the situation: I want to create a functional API to a Postgresql
database, in such a way that instead of issuing raw SQL commands (SELECT,
INSERT, etc), the client will only invoke functions from this API.
For example, to get all people in the database, the client will invoke
youngvon...@gmail.com wrote:
On 6月4日, 下午1时52分, youngvon...@gmail.com youngvon...@gmail.com
wrote:
i want to understand database knowledge about ipc,store,etc with a
project,ie,postgresql. I want to ask postgresql source code is very
good, is worth to learn .
I want to ask if
We want to implement a mechanism by which if any database function is
created or modified in one database, then the same should automatically get
done in another (1 or more) database(s).
It seems triggers on system catalogs like pg_proc are not allowed. Is there
any way in postgres to do this,
On Wed, Jun 03, 2009 at 01:46:00PM -0500, Louis Lam wrote:
So if I need to find out what table, view and function are granted to
user or role. I should be force to use pg_class and pg_proc? Unless I
can have superuser access?
Use \dv+ on the information_schema view you want and copy the
Jean Hoderd jhod...@yahoo.com writes:
I have tried the following, but it's not accepted:
create type result as (name text not null, age int4 not null);
Frankly, the notion that a not null condition might be associated with
a SQL data type is simply a bad idea. The SQL committee let this happen
Hi Matijn,
Thank you very much for the suggestion. I was able to figure this out
yesterday by running this query to get the source code from the view
then strip out the permission check and it work great.
select * from pg_views where viewname = 'table_privileges'
Thank you and Tom Lane for
On Fri, 2009-06-05 at 13:12 -0400, Atul Chojar wrote:
We want to implement a mechanism by which if any database function is
created or modified in one database, then the same should
automatically get done in another (1 or more) database(s).
It seems triggers on system catalogs like
Brandon Metcalf wrote:
What would be the best way to maintain referential integrity in the
following situation? Let's say I have the following table
CREATE TABLE workorder (
workorder_id INTEGER NOT NULL,
part_id INTEGER DEFAULT NULL,
generic BOOLEAN DEFAULT
On Fri, Jun 5, 2009 at 6:27 PM, Brandon
Metcalfbran...@geronimoalloys.com wrote:
What would be the best way to maintain referential integrity in the
following situation? Let's say I have the following table
CREATE TABLE workorder (
workorder_id INTEGER NOT NULL,
part_id
Thanks Chris kretschmer. But one small doubt in it,, What happens to
update or insert query?
- Arvind S
*
Many of lifes failure are people who did not realize how close they were to
success when they gave up.
-Thomas Edison
*
On Fri, Jun 5, 2009 at 11:59 AM, Chris dmag...@gmail.com wrote:
S
Alan Hodgson wrote:
On Tuesday 02 June 2009, Carlos Oliva carl...@pbsinet.com wrote:
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the
database to tape and one to exclude some tables from this backup.
Hi,
So I don't recommend you try to do this. What is the actual problem
you are trying to solve? Why do you want the client library to be
concerned with attnotnull at all?
In general the client library needs to check attnotnull to make sure
that the client is not making a type mistake. If
On Fri, 05 Jun 2009 10:46:11 -0400
Tom Lane t...@sss.pgh.pa.us wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I've encountered this error for the first time
psql:./import_stock_scratch.sql:9: ERROR: deadlock detected
DETAIL: Process 11095 waits for AccessExclusiveLock on
On Fri, 2009-06-05 at 10:58 -0700, Jean Hoderd wrote:
The above example was absurdly simple, but in the real world the query
is complex enough that instead of being just a SELECT is actually the
return of a PL/PGSQL function. I just want a way to tell the client
which fields from the return
Could you give some examples of such utilities?
Thanks!
atul
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Friday, June 05, 2009 1:37 PM
To: Atul Chojar
Cc: pgsql-general@postgresql.org
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I don't get it.
Why dropping the triggers would cause a deadlock anyway?
I bet it is due to my naïve view of the problem but I think a
trigger is a function. Unless there is concurrent access to the
table where the function is defined... I
On Mon, Jun 01, 2009 at 04:21:27PM +0100, Shak wrote:
When RETURNING from a DELETE statement (or similar), how do you access the
results being returned?
Something like:
SELECT COUNT(*) FROM (DELETE FROM a RETURNING *) ;
sounds reasonable but results in a syntax error. I am able to return
Joshua Tolley eggyk...@gmail.com writes:
On Mon, Jun 01, 2009 at 04:21:27PM +0100, Shak wrote:
Something like:
SELECT COUNT(*) FROM (DELETE FROM a RETURNING *) ;
sounds reasonable but results in a syntax error. I am able to return single
results into a variable or record, but not more than
On Fri, Jun 5, 2009 at 6:51 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Joshua Tolley eggyk...@gmail.com writes:
On Mon, Jun 01, 2009 at 04:21:27PM +0100, Shak wrote:
Something like:
SELECT COUNT(*) FROM (DELETE FROM a RETURNING *) ;
sounds reasonable but results in a syntax error. I am able to
Merlin Moncure mmonc...@gmail.com writes:
On Fri, Jun 5, 2009 at 6:51 PM, Tom Lanet...@sss.pgh.pa.us wrote:
I think you can loop over the results in plpgsql, for instance
also sql functions can direct 'returning' results directly to the
return of the function (at least in 8.4).
That bit is
Hi everyone,
I hope, I am on the right list. If not my apology.
I'd like to insert multiple lines as following with PLPython:
SQL statement:
INSET INTO table1 (field1, field2, field3)
VALES ('abc', 'abc', TRUE),
('def', 'def', FALSE),
('ghi', 'ghi', TRUE);
59 matches
Mail list logo