Hello
I have a simple table 'location' :
id -> Int (associated with a sequence)
name -> Character varying (100)
I have to delete all records where values in name field are all in upper
case. For example, if the test data is as follows:
idname
1abcc
2Abc dsase
3CDF FDER
4A
On Sat, Aug 27, 2011 at 03:12:44PM +0530, Amitabh Kant wrote:
> Hello
>
> I have a simple table 'location' :
> id -> Int (associated with a sequence)
> name -> Character varying (100)
>
> I have to delete all records where values in name field are all in upper
> case. For example, if the test dat
On Sat, Aug 27, 2011 at 3:40 PM, Martijn van Oosterhout
wrote:
> On Sat, Aug 27, 2011 at 03:12:44PM +0530, Amitabh Kant wrote:
> > Hello
> >
> > I have a simple table 'location' :
> > id -> Int (associated with a sequence)
> > name -> Character varying (100)
> >
> > I have to delete all records wh
El 27/08/2011, a las 02:40, John Moran escribió:
> I'm wondering how it's possible to upgrade my fedora system's pg to
> the latest minor release. I'm using the PGDG RPMs. A "yum update"
> leaves me on version 9.0.2. I'd expect it to put me on 9.0.4. What am
> I doing wrong? I installed from pgdg
On tor, 2011-08-25 at 14:05 +0200, Massa, Harald Armin wrote:
> > conclusion was that it's not documented because it's internal and
> > you're not supposed to use/rely on it.
> >
> > My impression is that people are allready using it, relying their sharding
> on it, even building indexes on it.
I
I ran into the same problem (no 9.0.4 rpm) on CentOS 6. I downloaded the
SRPM from the x86_64 directory at http://yum.postgresql.org/srpms/9.0/ and
built a fresh set of rpm with rpmbuild.
You might need to do the same.
Regards,
Brett
2011/8/27 José María Terry Jiménez
> El 27/08/2011, a las
Do you tried "," ?
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi.
Is this possible to limit number of connections for given user/role?
Postgres 8.4.8.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Everybody wants to be happy! You will be happy with it!...
http://masdeltechno.com/com.page.php?ihotmailID=12ek8
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
pasman pasmañski writes:
> Hi.
>
> Is this possible to limit number of connections for given user/role?
> Postgres 8.4.8.
Yes. Read up on ...
create/alter role
alter role $role connection limit 10;
>
> pasman
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresq
While trying to install 9.0.4, I ran into this:
Problem running post-install step. Installation may not
complete correctly
The database cluster initialisation failed.
A little bit of digging revealed reports to the effect that the PostGres
installer did not yet handle Lion. Is there a workarou
Kenneth McDonald wrote:
While trying to install 9.0.4, I ran into this:
Problem running post-install step. Installation may not
complete correctly
The database cluster initialisation failed.
A little bit of digging revealed reports to the effect that the PostGres
installer did not yet handl
Hello,
In a PL/pgSQL trigger function, I try to select a record from table
"town" below.
I am only interested in the result if the returned result set contains
exactly one result.
If there is more than one result, I want to log the fact.
EXAMPLE pseudo code
select
country_fk, region_fk, id
fro
On Sat, 27 Aug 2011 18:45:42 -0300
Osvaldo Kussama wrote:
>2011/8/27, Tarlika Elisabeth Schmitz
>:
>> Hello,
>>
>> In a PL/pgSQL trigger function, I try to select a record from table
>> "town" below.
>>
>> I am only interested in the result if the returned result set
>> contains exactly one resul
Kenneth McDonald wrote:
Unfortunately, "initdb" has not been installed into a directory on the shell
search path, and I can't find it by inspecting other likely places. I do like
OS X, but sometimes its unique approach to doing things causes problems.
I don't believe that is an OS X problem but
Tarlika Elisabeth Schmitz writes:
> SELECT INTO
> country_id, region_id, town_id
> country_fk, region_fk, id
> FROM town
> WHERE ...;
> GET DIAGNOSTICS cnt = ROW_COUNT;
> RAISE DEBUG 'COUNT %', cnt;
> always returns 1
Yeah. By default, SELECT INTO just fetches one row and stops;
it doesn't
In Oracle, when the table has few records, used frequently, it would use
"storage(buffer_pool keep)" to keep the data in cache instead of LRU
algorithm.
if the function exists in a pgsql table or not?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Whether-the-function-
Hi,
I am attempting to import a csv file into a predefined, empty table
using the following commands:
COPY ContactUpdates
FROM '/media/Fred/Work/SQL_Server/AP/ContactUpdates.csv'
WITH DELIMITERS ',' CSV
When testing the query I get the following error message
ERROR: syntax error at or near "CO
On 19 August 2011 04:16, Merlin Moncure wrote:
>> It's been around for a long time already:
>>
>> http://asmith.id.au/mod_libpq.html
> mod_libpq looks like it hasn't been updated in quite a while (apache
> 1.3 only) -- I think a node.js http server is superior in just about
> every way for this c
What if you run this query using psql?
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
The whole point of "with" is to factor out redundancy, and yet here you are
going and repeating the 2 "with" declarations; also the declarations have the
same names, which would be a problem, besides being redundant.
Try it like this instead:
with ...
(select ...)
union all
(select ...)
order
21 matches
Mail list logo
