On Thu, 1 Sep 2011 21:12:59 -0700, Mike Christensen
wrote:
>> Hi all -
>>
>> I'm on openSuse running the latest stable release of Gnome3 (Just
>> trying it out, so far the fact I can't minimize windows is perhaps
>> more than my old school brain can handle)..
>>
>> I've noticed in pgAdmin, basical
Hi everybody!
I've encountered a problem similar to this mentioned on this thread:
http://archives.postgresql.org/pgsql-bugs/2009-12/msg00207.php
I've got the same problem: I'm unable to start PostGreSQL (trough PGAdmin
or the service itself). Message is: "This application failed to start
On Thursday 01 September 2011 11:47:24 Sim Zacks wrote:
> Is there a way to get an md5 or other hash of an entire table?
>
> I want to be able to easily compare 2 tables in different databases.
>
> I thought about using dblink and the EXCEPT query, but then I need to
> know the field list of each
On 02/09/11, Tom Lane (t...@sss.pgh.pa.us) wrote:
> Rory Campbell-Lange writes:
> > I'm doing an UPDATE something like this:
> > UPDATE
> > slots
> > SET
> > a = 'a'
> > ,b = (SELECT uuid_generate_v1())
> > WHERE
> > c = TRUE;
>
> > Each updated row in
So, some following for people who will go trough this problem!
I tried many things to solve this problem, and after a while, I noticed
that a lot of DLL were missing...
Completely hopeless, I decided to erase my installed PostGreSQL version
with fresh binaries downloaded at this adress:
h
Hi all,
I now know it's somewhat an "academic exercise" of little practical
importance, thanks for the clarification!!
Cheers,
Antonio
2011/9/2 Tom Lane :
> Craig Ringer writes:
>> Even better, add a valgrind suppressions file for the warnings and
>> ignore them. They are "leaks" only in the se
>
> In my "-1" example, am I right in assuming that I created a correlated
> subquery rather than an correlated one? I'm confused about the
> difference.
>
>
Correlated: has a where clause that references the outer query
Un-correlated: not correlated
Because of the where clause a correlated s
That's interpretation of subselect is ok, when it contains only stable
functions.
Maybe add a warning when subselect contains volatile function.
2011/9/2, Rory Campbell-Lange :
> On 02/09/11, Tom Lane (t...@sss.pgh.pa.us) wrote:
>> Rory Campbell-Lange writes:
>> > I'm doing an UPDATE something l
There is a view named pg_prepared_xacts which contains list of
prepared transactions in all databases of current instance.
PGXAConnection uses following query to retrive prepared transactions:
"SELECT gid FROM pg_prepared_xacts".
Shouldn't it be the following: "SELECT gid FROM pg_prepared_xacts
w
=?ISO-8859-2?Q?pasman_pasma=F1ski?= writes:
> That's interpretation of subselect is ok, when it contains only stable
> functions.
> Maybe add a warning when subselect contains volatile function.
We're not likely to do that, because this sort of notation is actually
fairly commonly used to hide t
-Original Message-
From: Bill Moran
Sent: Thursday, September 01, 2011 8:19 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Variable column name
http://www.postgresql.org/docs/9.0/static/plpgsql-statements.html
Section 39.5.4
If you're not familiar with plpgsql at all, you mi
On 02/09/2011 18:33, Bob Pawley wrote:
>
>
> -Original Message-
>> From: Bill Moran
> Sent: Thursday, September 01, 2011 8:19 AM
> To: Bob Pawley
> Cc: Postgresql
> Subject: Re: [GENERAL] Variable column name
>
> http://www.postgresql.org/docs/9.0/static/plpgsql-statements.html
> Section
-Original Message-
From: Raymond O'Donnell
Sent: Friday, September 02, 2011 10:38 AM
To: Bob Pawley
Cc: Bill Moran ; Postgresql
Subject: Re: [GENERAL] Variable column name
On 02/09/2011 18:33, Bob Pawley wrote:
-Original Message-
From: Bill Moran
Sent: Thursday, September
In response to "Bob Pawley" :
>
> I am getting an error -- "column "1" does not exist"
> Select "1" into column ;
Where are you selecting "1" from? This query has no FROM clause, so of
course the column doesn't exist.
The previous query, "SELECT 2 INTO point_array" is going to put the
i
I'm searching for information on pg_lock_status() function, but there
seams to be nothing in the docs. Maybe missing? Any hits, at least
what each column outputed is.
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailin
=?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= writes:
> I'm searching for information on pg_lock_status() function, but there
> seams to be nothing in the docs. Maybe missing?
It's not documented because it's an internal function that you shouldn't
call directly. Look at the docs for the pg_locks view, w
Martín Marqués writes:
> I'm searching for information on pg_lock_status() function, but there
> seams to be nothing in the docs. Maybe missing? Any hits, at least
> what each column outputed is.
Have a look at the pg_locks view which wraps this function.
\d+ pg_locks
> MartÃn Marqués
> sel
On Fri, 2011-09-02 at 09:30 +0200, Guillaume Lelarge wrote:
> > I guess the bug can be fixed as:
> >
>
> If the bug is in pgAdmin3...
Could not reproduce any of those issues on Fedora 15.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışman
-Original Message-
From: Bill Moran
Sent: Friday, September 02, 2011 10:53 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Variable column name
In response to "Bob Pawley" :
I am getting an error -- "column "1" does not exist"
Select "1" into column ;
Where are y
On Sep 2, 2011, at 2:31 PM, Bob Pawley wrote:
> It seems to work when I hard code the column name and array point, so I was
> hoping to make it work through a loop using variables for column and array
> point.
>
> Does this make sense??
Building queries this way is tedious & error prone; that'
I know pg_locks, but I thought maybe pg_lock_status had some extra info.
Thanks anyway
2011/9/2 Tom Lane :
> =?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= writes:
>> I'm searching for information on pg_lock_status() function, but there
>> seams to be nothing in the docs. Maybe missing?
>
> It's not docum
All,
I'm looking for an intro-to-SQL book for teaching a class, one aimed at
folks who know *nothing* about RDBMSes, which is not based on MySQL or
MSAccess. The ones I have on my desk are all based on one or the other,
except The Manga Guide to Databases, which I can't use in a serious class.
T
On Fri, 2 Sep 2011, Josh Berkus wrote:
I'm looking for an intro-to-SQL book for teaching a class, one aimed at
folks who know *nothing* about RDBMSes, which is not based on MySQL or
MSAccess. The ones I have on my desk are all based on one or the other,
except The Manga Guide to Databases, whic
On Thu, 2011-09-01 at 13:09 -0400, Jerry LeVan wrote:
> As time goes by the tables on the various computers get out of
> sync.
>
> Is there an elegant way I can get all of the differences (uniquely)
> merged into a single table?
You can try a query involving NOT EXISTS, combined with dblink:
ht
SQL for Dummies is pretty agnostic. Follow that up with SQL Cookbook from
O'Reilly and you have a good one two punch!
On 2 September 2011 19:48, Josh Berkus wrote:
> All,
>
> I'm looking for an intro-to-SQL book for teaching a class, one aimed at
> folks who know *nothing* about RDBMSes, which i
I'm setting up a new server for a CMS I have written (er, partially,
needs work) that uses PostgreSQL as a backend.
All my existing CentOS 5 servers, I use pgrpms for PostgreSQL.
I would like to do the same with CentOS 6 but I also want to keep
SELinux enabled on this box.
Do the RPM's in pg
26 matches
Mail list logo
