On Thu, 1 Sep 2011 21:12:59 -0700, Mike Christensen m...@kitchenpc.com
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,
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 r...@campbell-lange.net 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
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:
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 t...@sss.pgh.pa.us:
Craig Ringer ring...@ringerc.id.au writes:
Even better, add a valgrind suppressions file for the warnings and
ignore
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
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 r...@campbell-lange.net:
On 02/09/11, Tom Lane (t...@sss.pgh.pa.us) wrote:
Rory Campbell-Lange r...@campbell-lange.net
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
=?ISO-8859-2?Q?pasman_pasma=F1ski?= pasma...@gmail.com 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
-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
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 39.5.4
-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,
In response to Bob Pawley rjpaw...@shaw.ca:
I am getting an error -- column 1 does not exist
snip
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
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
=?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= martin.marq...@gmail.com 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
Martín Marqués martin.marq...@gmail.com 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
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
-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 rjpaw...@shaw.ca:
I am getting an error -- column 1 does not exist
snip
Select 1 into column ;
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's
I know pg_locks, but I thought maybe pg_lock_status had some extra info.
Thanks anyway
2011/9/2 Tom Lane t...@sss.pgh.pa.us:
=?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= martin.marq...@gmail.com writes:
I'm searching for information on pg_lock_status() function, but there
seams to be nothing in the
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.
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,
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:
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 j...@agliodbs.com wrote:
All,
I'm looking for an intro-to-SQL book for teaching a class, one aimed at
folks who know *nothing* about
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
26 matches
Mail list logo