On 24 March 2010 05:17, Nilesh Govindarajan li...@itech7.com wrote:
On 03/24/2010 12:45 AM, Dean Rasheed wrote:
On 23 March 2010 11:07, Nilesh Govindarajanli...@itech7.com wrote:
Hi,
I want to find out the userid, nodecount and comment count of the userid.
I'm going wrong somewhere.
--- On Tue, 3/23/10, Tom Lane t...@sss.pgh.pa.us wrote:
Yeah --- that SELECT will result in no change to the
variables, ie,
they'll still be NULL. So the OVERLAPS always fails.
Tom Andreas, I thank you for your help. Renaming the variables solved the
problem. :-)
Regards,
Tuo
--
Sent
Hi,
can you help me with this tricky concat i have?
I have a function with an execute statement, one line of it doing an md5
hash of some concatenated xml paths with values. I cannot get this one
work, postgres is always complaing about some things, like: functions
and operators can take at
On 03/24/2010 01:14 PM, Dean Rasheed wrote:
On 24 March 2010 05:17, Nilesh Govindarajanli...@itech7.com wrote:
On 03/24/2010 12:45 AM, Dean Rasheed wrote:
On 23 March 2010 11:07, Nilesh Govindarajanli...@itech7.comwrote:
Hi,
I want to find out the userid, nodecount and comment count
Dear, Psqlers,
I encountered an out of memory error during executing un INSERT into
table1(v1,v2,v3) SELECT c1,c2,c3 from table2 where .
The recordset of Select query is around 30M record. And I got following
Message :
--- ERROR: out of memoryDETAIL: Failed on request of size 40.' in
On 24 March 2010 10:57, yue peng pengyueb...@gmail.com wrote:
Is there any other ways to still insert same amount of data and avoid this
OOM error ?
I'd expect COPY to be the most effective way of bulk loading data into a
database. http://www.postgresql.org/docs/current/static/sql-copy.html
Frank jansen wrote:
can you help me with this tricky concat i have?
I have a function with an execute statement, one line of it doing an md5
hash of some concatenated xml paths with values. I cannot get this one
work, postgres is always complaing about some things, like: functions
and
On Wed, Mar 24, 2010 at 6:22 AM, Frank jansen jan...@fumarium.de wrote:
Hi,
can you help me with this tricky concat i have?
I have a function with an execute statement, one line of it doing an md5
hash of some concatenated xml paths with values. I cannot get this one work,
postgres is
Am 24.03.2010 14:41, schrieb Merlin Moncure:
On Wed, Mar 24, 2010 at 6:22 AM, Frank jansenjan...@fumarium.de wrote:
Hi,
can you help me with this tricky concat i have?
I have a function with an execute statement, one line of it doing an md5
hash of some concatenated xml paths with
yue peng pengyueb...@gmail.com writes:
I encountered an out of memory error during executing un INSERT into
table1(v1,v2,v3) SELECT c1,c2,c3 from table2 where .
Most likely the OOM is because of growth of the pending-trigger-event
queue --- do you have any foreign key references in that
On Mon, Mar 22, 2010 at 9:21 AM, Ogden li...@darkstatic.com wrote:
I have looked all over but could not find any detailed docs on setting up a
warm standby solution using PostgreSQL 8.4. I do know of
http://www.postgresql.org/docs/8.4/static/warm-standby.html but was
wondering if there was a
Hi,
I would like a setup with the following:
Three users - one, called OWNER, that owns the tables and can drop,
alter and change data in the tables; another called USER that can edit
data in the tables created by the owner but cannot create new tables or
drop any tables and a third user
Tony Webb a...@sanger.ac.uk writes:
I can grant table privileges to the USER and RO but how do I stop these
two users from creating new tables etc?
Revoke CREATE privilege on the public schema from PUBLIC (and then grant
it back to OWNER and whoever else you want to have it).
If you don't
I have the following domain defined:
CREATE DOMAIN percentage AS real
CONSTRAINT percentage_check CHECK (((VALUE = 0.0) AND (VALUE =
1.0)));
The various values (aa,bb,cc and dd) defined as percentage can increase over
time, to a maximum value of 1.0. In fact, I have one table
Thanks Tom,
I think I'm still doing something wrong.
As a superuser I run:
#revoke create on schema public from public;
REVOKE
As the read only user straight after running the above:
create table barney2(col1 integer);
CREATE TABLE
\d barney2
Table public.barney2
Column | Type |
In response to a private email from someone else on this list, I thought I
should send the following clarification.
I have a table with four values which are constantly lowered by user action.
These four values must rise over time, in five minute intervals. The core of
the function, in
Tony Webb a...@sanger.ac.uk writes:
Thanks Tom,
I think I'm still doing something wrong.
As a superuser I run:
#revoke create on schema public from public;
REVOKE
As the read only user straight after running the above:
create table barney2(col1 integer);
CREATE TABLE
It works for me:
Ovid curtis_ovid_...@yahoo.com writes:
I have a table with four values which are constantly lowered by user action.
These four values must rise over time, in five minute intervals. The core of
the function, in pseudo-code, would look something like this:
FOREACH row IN SELECT * FROM
Hi Tom,
Thanks for your help and the hint (off-line) to use the \dn+ command.
You've hit the nail on the head sir!
\dn+
WARNING: nonstandard use of \\ in a string literal at character 281
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Hello @all,
I know, i can do:
select * from (select ... row_number() over (...) ...) foo where row_number N
to limit the rows per group, but the inner select has to retrieve the
whole set of records and in the outer select most of them discarded.
Why isn't there an over ( ... LIMIT N) ?
- Original Message
From: Tom Lane t...@sss.pgh.pa.us
You could code that directly with CASE
operations, but it would probably
be easier to use GREATEST/LEAST, along the
lines of
new_percentage = LEAST(num_intervals * .1,
1);
Ah, I didn't know about the LEAST function! I
Hi,
running a geo-database from a dump restore where still one of the most
important indexes is missing and so the search is slow.
Whenever I try to add the follwing index to the table placex, one of
the postmaster processes dies and the server restarts.
I try:
CREATE INDEX idx_placex_sector ON
Frans Hals fha...@googlemail.com writes:
Whenever I try to add the follwing index to the table placex, one of
the postmaster processes dies and the server restarts.
Can you provide a stack trace from the crash?
I try:
CREATE INDEX idx_placex_sector ON placex USING btree
Can you do?
alter table placex add column geometry_sector integer;
update placex set geometry_sector = geometry_sector(geometry);
P.
On Wed, Mar 24, 2010 at 1:15 PM, Frans Hals fha...@googlemail.com wrote:
Hi,
running a geo-database from a dump restore where still one of the most
important
Hi,
I want to know if it is possible to search for a string of characters inside
an attribute for example I have the following table and values
cod_unidad | nombre_uni
+-
1 | Facultad de Ciencias Naturales y
2010/3/24 Karina Guardado kguard...@gmail.com
Hi,
I want to know if it is possible to search for a string of characters
inside an attribute for example I have the following table and values
cod_unidad | nombre_uni
+-
Thanks a lot for your help that's exactly what I wanted. It worked fine.
regards,
karina
On Wed, Mar 24, 2010 at 3:25 PM, Szymon Guz mabew...@gmail.com wrote:
2010/3/24 Karina Guardado kguard...@gmail.com
Hi,
I want to know if it is possible to search for a string of characters
inside an
Hi,
Is there a special data type to use to store a lot of text and tables of
data in a column or attribute?
thanks in advance,
regards,
karina
El Salvador, Centroamerica
2010/3/24 Karina Guardado kguard...@gmail.com
Hi,
Is there a special data type to use to store a lot of text and tables of
data in a column or attribute?
thanks in advance,
regards,
karina
El Salvador, Centroamerica
Normally text can be stored in a type named TEXT. Maybe there would
On 24/03/2010 21:48, Karina Guardado wrote:
Hi,
Is there a special data type to use to store a lot of text and tables of
data in a column or attribute?
For large amounts of text, just use the TEXT data type:
http://www.postgresql.org/docs/8.4/static/datatype-character.html
Not sure
for example something like the following :
*Table 9-25. Date/Time Operators*
OperatorExampleResult + date '2001-09-28' + integer '7'date '2001-10-05' + date
'2001-09-28' + interval '1 hour'timestamp '2001-09-28 01:00:00' + date
'2001-09-28' + time '03:00'timestamp '2001-09-28 03:00:00' + interval
On 24/03/2010 22:01, Karina Guardado wrote:
for example something like the following :
*Table 9-25. Date/Time Operators*
Operator Example Result
+ date '2001-09-28' + integer '7' date '2001-10-05'
+ date '2001-09-28' + interval '1 hour' timestamp '2001-09-28 01:00:00'
+
On 24/03/2010 22:01, Karina Guardado wrote:
what should be the data type to store a file that can be xls, doc, pdf
for example.
Sorry, I missed this bit - for binary files you can use the bytea type.
Look under Binary data types in the docs.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
Hi Tony,
Thanks VERY much! That got me on my way. I'm going to try and convert this to a
PG stored function, Since you know that the script has limitations, you or
othres reading might want to know the ones I've found:
1) Regardless of what you set the schema to, the only ones that are dumped
You know I need to design a table where some attributes have a data type
that allow me to store text mixed with tables and other information. I use
PHP code to get the information and store it in to the database so I wonder
if this is posible to do. I found in the link you provided me that If
On 24/03/2010 22:39, Karina Guardado wrote:
You know I need to design a table where some attributes have a data type
that allow me to store text mixed with tables and other information. I
use PHP code to get the information and store it in to the database so I
wonder if this is posible to do.
http://welltrade-hydraulik.com/virginie.html
_
Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
http://clk.atdmt.com/GBL/go/210850552/direct/01/
Hi All,
Following is the error when i try to describe the catalog table.
Version Info
postgres=# select version();
version
Hello,
I am new to pgSQL. I would like to know if there is a way to do the
following using pure SQL:
1. Retrieve list of all Tables in a database
2. Retrieve list of all Functions, Triggers, Sequences, Views, etc.
3. Retrieve list of all Group Roles
4. Retrieve list of all Login Roles
5.
Tadipathri Raghu traghu@gmail.com writes:
Following is the error when i try to describe the catalog table.
postgres=# \d pg_class
ERROR: column reltriggers does not exist at character 41
STATEMENT: SELECT relhasindex, relkind, relchecks, reltriggers,
relhasrules,
relhasoids ,
Hi Yogi Yang,
Psql is a very strong tool, and easy to use. Please find the answers for
your queries
1. Retrieve list of all Tables in a database
2. Retrieve list of all Functions, Triggers, Sequences, Views, etc.
3. Retrieve list of all Group Roles
postgres=#\d{t|i|s|v|S|g|n}
you can use any of
Hi Tom,
As you are best always on this Community Fourm. Thanks for your help. It got
resolved.
Regards
Raghavendra
On Thu, Mar 25, 2010 at 10:03 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Tadipathri Raghu traghu@gmail.com writes:
Following is the error when i try to describe the catalog
Yogi Yang 007 wrote:
Hello,
I am new to pgSQL. I would like to know if there is a way to do the
following using pure SQL:
1. Retrieve list of all Tables in a database
2. Retrieve list of all Functions, Triggers, Sequences, Views, etc.
3. Retrieve list of all Group Roles
4. Retrieve list of
43 matches
Mail list logo