On Mon, 29 Sep 2008, Matthew Pulis wrote:
I need to perform some timed testing, thus need to make sure that disk cache
does not affect me. Is clearing the OS (Ubuntu) disk cache, ( by running:
sudo echo 3 | sudo tee /proc/sys/vm/drop_caches ) enough to do this?
What you should do is:
1) Shutd
Hi all,
I am following the steps present in this link:
http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html
But failed to complete step # 13. Here I am unable to get CREATE NEW
SUBSCRIPTION. Can any body guide me plz.
On Sun, 28 Sep 2008 21:43:49 -0700,
"Richard Broersma" <[EMAIL PROTECTED]> wrote:
[...]
> Well, I was able to get PostgreSQL Update-able views to work nearly as
> well as the update-able queries did in Access.
Would you mind sharing a sample schema?
> As a side note, you'll notice that MS-Acce
On Sun, Sep 28, 2008 at 5:31 PM, Seb <[EMAIL PROTECTED]> wrote:
> I've read this thread with great interest as I'm coming to PostgreSQL
> from the MS Access world of databases, where one can enter new data into
> queries/forms and tables get automatically updated/deleted/inserted into
> where expec
Hi,
I need to perform some timed testing, thus need to make sure that disk cache
does not affect me. Is clearing the OS (Ubuntu) disk cache, ( by running:
sudo echo 3 | sudo tee /proc/sys/vm/drop_caches ) enough to do this? If not
can you please point me to some site please since all I am finding
Matthew Wilson wrote:
I'm trying to comprehend how NULL values interact with unique indexes.
It seems like I can insert two rows with NULL values in a column with a
unique constraint just fine.
Is there something special about NULL? Can anyone post some links to
explain what is going on?
h
Matthew Wilson <[EMAIL PROTECTED]> writes:
> It seems like I can insert two rows with NULL values in a column with a
> unique constraint just fine.
This is per SQL spec and quite well-documented in our manual ...
regards, tom lane
--
Sent via pgsql-general mailing list (
Matthew Wilson wrote:
I'm trying to comprehend how NULL values interact with unique indexes.
It seems like I can insert two rows with NULL values in a column with a
unique constraint just fine.
Is there something special about NULL? Can anyone post some links to
explain what is going on?
When
I'm trying to comprehend how NULL values interact with unique indexes.
It seems like I can insert two rows with NULL values in a column with a
unique constraint just fine.
Is there something special about NULL? Can anyone post some links to
explain what is going on?
Here's the example that stump
On Tue, 17 Jun 2008 12:46:27 -0700,
"Richard Broersma" <[EMAIL PROTECTED]> wrote:
> On Tue, Jun 17, 2008 at 12:34 PM, Michael Shulman <[EMAIL PROTECTED]> wrote:
>> Would it be possible to actually do something like this in an update
>> rule? You couldn't write the "begin/commit", but it seems tha
"Abraham, Danny" <[EMAIL PROTECTED]> writes:
> set standard_conforming_strings=on;
> select 'abcd\efg' like 'abcd\efg' ==> F (I expected it to be T)
> select 'abcd\efg' like 'abcd\\efg' ==> T (I expected it to be F)
Backslash is the default LIKE escape character.
regards,
On Sun, 2008-09-28 at 08:35 -0700, Joshua D. Drake wrote:
> Ivan Zolotukhin wrote:
> > Hello,
> >
> > Nothing bad both in system and postgres logs :( No serious activity
> > during backup. I've had to change statement_timeout for backup user to
> > make it work. But I cannot reproduce this case u
Ivan Zolotukhin wrote:
Hello,
Nothing bad both in system and postgres logs :( No serious activity
during backup. I've had to change statement_timeout for backup user to
make it work. But I cannot reproduce this case unfortunately.
This is actually not uncommon and PostgreSQL shows exactly noth
Hello,
Nothing bad both in system and postgres logs :( No serious activity
during backup. I've had to change statement_timeout for backup user to
make it work. But I cannot reproduce this case unfortunately.
Regards,
Ivan
On Tue, Sep 23, 2008 at 6:18 AM, Bruce Momjian <[EMAIL PROTECTED]> wrote:
set standard_conforming_strings=on;
select 'abcd\efg' like 'abcd\efg' ==> F (I expected it to be T)
select 'abcd\efg' like 'abcd\\efg' ==> T (I expected it to be F)
Thanks
Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list
On Sun, Sep 28, 2008 at 12:52:56AM -0400, Ashutosh Chauhan wrote:
> select a,b
> from (billing.item JOIN (
> select *
> from ( billing.invoice JOIN billing.customer
> on (id_customer_shipped =
> cust
On Sun, 28 Sep 2008, Ashutosh Chauhan wrote:
> Hi all,
>
> This has been asked before and answered as well.
> http://archives.postgresql.org/pgsql-sql/2007-12/msg2.php but I
> still cant figure out why postgres throws this error message even when
> I have provided the aliases. My query:
>
> se
Dear all,
I am proud to announce the "GIS Virtual Machine" FOSS4G 2008 Special Edition,
available at: http://www.gisvm.com
This full-feature GIS Workstation, based exclusively on free GIS software, now
also includes "Kosmo 1.2" and the "uDIG 1.1" Sanity Check release. The one that
will be used
Hi all,
This has been asked before and answered as well.
http://archives.postgresql.org/pgsql-sql/2007-12/msg2.php but I
still cant figure out why postgres throws this error message even when
I have provided the aliases. My query:
select a,b
from (billing.item JOIN (
19 matches
Mail list logo
