[GENERAL] Test to pgsql-general@postgresql.org

Test

Re: [GENERAL] Test letter

El 15/09/16 a las 11:57, Alex Sviridov escribió: Hi all, I have suspicions that my message don't get to pgsql-general mailing list. Please, someone, answer this message if this get the mailing list. Best regards, Alex Arrived ok. -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón

Re: [GENERAL] Test letter

@postgresql.org Subject: [GENERAL] Test letter Hi all, I have suspicions that my message don't get to pgsql-general mailing list. Please, someone, answer this message if this get the mailing list. Best regards, Alex

[GENERAL] Test letter

Hi all, I have suspicions that my message don't get to pgsql-general mailing list. Please, someone, answer this message if this get the mailing list. Best regards, Alex

Re: [GENERAL] Test CMake build

Andy Colson wrote: cmake and make -j2 fine, but then You can try again I removed some features from CMake 3.x . Realy big thanks for testing! -- Yury Zhuravlev Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-general mailing list

Re: [GENERAL] Test CMake build

On 02/13/2016 04:33 AM, Yury Zhuravlev wrote: Andy Colson wrote: cmake and make -j2 fine, but then You can try again I removed some features from CMake 3.x . Realy big thanks for testing! My pleasure. Still didn't work. 'make check' seems to make it through make install first, but

Re: [GENERAL] Test CMake build

Andy Colson wrote: Still didn't work. 'make check' seems to make it through make install first, but then same sort of error: Now it looks like I can do "make check" only cmake 3.x (I will try to solve it later). But "make installcheck" with DESTDIR should work. I now have no close system

Re: [GENERAL] Test CMake build

I tried it on FreeBSD 64-bit, 16Gb, SSD, Core i7 ( ./configure && gmake all; ) 168,99s user 15,46s system 97% cpu 3:09,61 total ( cmake . && gmake all; ) 75,11s user 11,34s system 100% cpu 1:26,30 total Cmake 2 times faster, that is good, but I don't understand why. Which optimization level

Re: [GENERAL] Test CMake build

Teodor Sigaev wrote: I tried it on FreeBSD 64-bit, 16Gb, SSD, Core i7 ( ./configure && gmake all; ) 168,99s user 15,46s system 97% cpu 3:09,61 total ( cmake . && gmake all; ) 75,11s user 11,34s system 100% cpu 1:26,30 total ( CFLAGS='-O2' cmake . && gmake all; ) 141,87s user 12,18s system

Re: [GENERAL] Test CMake build

Teodor Sigaev wrote: > Cmake 2 times faster, that is good, but I don't understand why. Which > optimization level does cmake buld use by default? Which compiler does it > take? It's not obvious, because cmake build hides actual compiler command > line. Hm, I don't think having the compile/link

Re: [GENERAL] Test CMake build

Teodor Sigaev wrote: > >Hm, I don't think having the compile/link lines be hidden up is > >acceptable. Many times we need to debug some compile problem, and the > >output is mandatory. > > +1 > > Although it could be fixed by > VERBOSE=1 make Verbose needs to be the default. Having a QUIET

Re: [GENERAL] Test CMake build

Hm, I don't think having the compile/link lines be hidden up is acceptable. Many times we need to debug some compile problem, and the output is mandatory. +1 Although it could be fixed by VERBOSE=1 make -- Teodor Sigaev E-mail: teo...@sigaev.ru

Re: [GENERAL] Test CMake build

Alvaro Herrera writes: > Teodor Sigaev wrote: >> Cmake 2 times faster, that is good, but I don't understand why. Which >> optimization level does cmake buld use by default? Which compiler does it >> take? It's not obvious, because cmake build hides actual compiler

Re: [GENERAL] Test CMake build

On 2/12/2016 9:47 AM, Yury Zhuravlev wrote: Andy Colson wrote: Is the installcheck important to you? Hello! You can try new make check. Also "make install" started support DESTDIR. cmake and make -j2 fine, but then andy@mapper:~/projects/postgres_cmake/build$ make check Scanning

Re: [GENERAL] Test CMake build

Tom Lane wrote: The other make switch I use all the time is -jN (with varying values of N depending on what machine I'm on). If cmake can't provide an equivalent feature, that would be a large minus, because if you have a decent number of cores -j makes a huge difference in build time. Of

Re: [GENERAL] Test CMake build

Andy Colson wrote: Its not important, but is pretty nice. It's not hard and I think I will do soon. Anyway, thanks for all your work on this. Looking good. Thanks! -- Yury Zhuravlev Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via

Re: [GENERAL] Test CMake build

Andy Colson wrote: Is the installcheck important to you? Hello! You can try new make check. Also "make install" started support DESTDIR. -- Yury Zhuravlev Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-general mailing list

Re: [GENERAL] Test CMake build

Tom Lane wrote: Really? That sure seems misleading as can be, and not something we'd want to be part of a new user's very first impression of Postgres. In configure we have similar messages: checking for int8... no checking for uint8... no checking for int64... no checking for uint64... no

Re: [GENERAL] Test CMake build

Yury Zhuravlev writes: > Tom Lane wrote: >> Really? That sure seems misleading as can be, and not something we'd >> want to be part of a new user's very first impression of Postgres. > In configure we have similar messages: > checking for int8... no > checking for

Re: [GENERAL] Test CMake build

Alban Hertroys wrote: I was under the impression that the FreeBSD port already uses cmake? I tested on a 32-bit FreeBSD. All tests passed. -- Yury Zhuravlev Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-general mailing list

Re: [GENERAL] Test CMake build

Yury Zhuravlev wrote: I will try to fix soon. I write as a corrected. You can try again. Thanks! -- Yury Zhuravlev Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Test CMake build

On четверг, 11 февраля 2016 г. 22:37:12 MSK, Tom Lane wrote: Hm, well, configure does not use the word "failed" to describe expected cases. Well, it does not confuse CMake users. (MySQL, KDE) Just the other tradition, I do not see the problem here. :) -- Yury Zhuravlev Postgres Professional:

Re: [GENERAL] Test CMake build

On 2/11/2016 10:44 AM, Andy Colson wrote: On 2/11/2016 9:49 AM, Yury Zhuravlev wrote: Yury Zhuravlev wrote: I will try to fix soon. I write as a corrected. You can try again. Thanks! That seems better: -- Found Readline: /usr/include -- Found Curses: /usr/lib64/libcurses.so Is this bad?

Re: [GENERAL] Test CMake build

On 2/11/2016 9:49 AM, Yury Zhuravlev wrote: Yury Zhuravlev wrote: I will try to fix soon. I write as a corrected. You can try again. Thanks! That seems better: -- Found Readline: /usr/include -- Found Curses: /usr/lib64/libcurses.so Is this bad? -- Check size of int64 -- Check size of

Re: [GENERAL] Test CMake build

Andy Colson wrote: Is this bad? -- Check size of int64 -- Check size of int64 - failed -- Check size of uint64 -- Check size of uint64 - failed -- Check size of int8 -- Check size of int8 - failed This is normal behavior for linux. -- Yury Zhuravlev Postgres Professional:

Re: [GENERAL] Test CMake build

Yury Zhuravlev writes: > Andy Colson wrote: >> Is this bad? >> -- Check size of int64 >> -- Check size of int64 - failed >> -- Check size of uint64 >> -- Check size of uint64 - failed >> -- Check size of int8 >> -- Check size of int8 - failed > This is normal behavior

Re: [GENERAL] Test CMake build

I used to use "make install-strip", is that not a thing anymore? I think it's plans for the near future. Please create issue in GitHub. /home/andy/projects/postgres_cmake/build/src/timezone//zic: Cannot create directory /usr/local/pg99: Permission denied I will fix it. sh:

Re: [GENERAL] Test CMake build

Andy Colson wrote: the end of CMakeFiles/CMakeError.log shows: Many thanks! I think I understand what the problem is. I will try to fix soon. I write as a corrected. -- Yury Zhuravlev Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-general

Re: [GENERAL] Test CMake build

On 2/10/2016 12:09 PM, Yury Zhuravlev wrote: Hello all. Please test build Postgres using cmake. If you are of course interested. Still not everything is ready but most of the work. Assembly instructions as does the repository is on github: https://github.com/stalkerg/postgres_cmake The

[GENERAL] Test CMake build

Hello all. Please test build Postgres using cmake. If you are of course interested. Still not everything is ready but most of the work. Assembly instructions as does the repository is on github: https://github.com/stalkerg/postgres_cmake The compilation will be enough (tests even better). I

Re: [GENERAL] Test CMake build

On 2/10/2016 2:45 PM, Andy Colson wrote: On 2/10/2016 12:09 PM, Yury Zhuravlev wrote: Hello all. Please test build Postgres using cmake. If you are of course interested. Still not everything is ready but most of the work. Assembly instructions as does the repository is on github:

Re: [GENERAL] Test CMake build

On 2/10/2016 2:50 PM, Andy Colson wrote: On 2/10/2016 2:45 PM, Andy Colson wrote: On 2/10/2016 12:09 PM, Yury Zhuravlev wrote: Hello all. Please test build Postgres using cmake. If you are of course interested. Still not everything is ready but most of the work. Assembly instructions as does

Re: [GENERAL] Test CMake build

> On 10 Feb 2016, at 19:09, Yury Zhuravlev wrote: > > Hello all. > Please test build Postgres using cmake. If you are of course interested. > Still not everything is ready but most of the work. Assembly instructions as > does the repository is on github: >

Re: [GENERAL] Test CMake build

On 2/10/2016 12:09 PM, Yury Zhuravlev wrote: Hello all. Please test build Postgres using cmake. If you are of course interested. Still not everything is ready but most of the work. Assembly instructions as does the repository is on github: https://github.com/stalkerg/postgres_cmake The

Re: [GENERAL] Test disk reliability (or HGST HTS721010A9E630 surprisingly reliable)

On 12/21/15 8:22 AM, Bill Moran wrote: Why? Just because a disk isn't enterprise-grade doesn't mean it has to lie > >about fsync, which is the only thing diskchecker.pl tests for. > > > >I was thinking that since the disk have a 32M write-cache (with not >battery) it would lie to the OS (and

Re: [GENERAL] Test disk reliability (or HGST HTS721010A9E630 surprisingly reliable)

On Mon, 21 Dec 2015 14:54:14 +0100 Félix GERZAGUET wrote: > On Mon, Dec 21, 2015 at 12:31 AM, Jim Nasby > wrote: > > > On 12/20/15 1:09 PM, Félix GERZAGUET wrote: > > > >> After reading > >>

Re: [GENERAL] Test disk reliability (or HGST HTS721010A9E630 surprisingly reliable)

On Mon, Dec 21, 2015 at 12:31 AM, Jim Nasby wrote: > On 12/20/15 1:09 PM, Félix GERZAGUET wrote: > >> After reading >> http://www.postgresql.org/docs/current/static/wal-reliability.html, I >> tried the recommended diskchecker.pl >>

Re: [GENERAL] Test disk reliability (or HGST HTS721010A9E630 surprisingly reliable)

On 12/20/15 1:09 PM, Félix GERZAGUET wrote: After reading http://www.postgresql.org/docs/current/static/wal-reliability.html, I tried the recommended diskchecker.pl but I am not satisfied: I always get: Total errors: 0 even if I tested with with a

[GENERAL] Test disk reliability (or HGST HTS721010A9E630 surprisingly reliable)

Hello, I am trying to assess disk reliability. After reading http://www.postgresql.org/docs/current/static/wal-reliability.html, I tried the recommended diskchecker.pl but I am not satisfied: I always get: Total errors: 0 even if I tested with with a

[GENERAL] Test failover for PosgreSql 9.2

Hello, I am new to posgresql. I've configured replication for my database . It li working fine, but I need to test failover capabilities. According to manual I have to kill completely Master and "touch" a trigger to make Slave new Master. Could you please recommend me a way to kill Master in

Re: [GENERAL] Test failover for PosgreSql 9.2

On 09/25/2015 11:20 AM, yuryu wrote: According to manual I have to kill completely Master and "touch" a trigger to make Slave new Master. You don't have to do anything in the master. If you have configured the slave to check for a file, then it will become Read Write when that file is

Re: [GENERAL] Test for char errors

On Wed, Jun 17, 2015 at 5:15 PM, Gao wrote: I don't know why the files are not the same but tests all passed. Helps are appreciated, thanks! Some tests have multiple expected outputs. In the case of char, there is not only char.out, but as well char_1.out and char_2.out. In your case

Re: [GENERAL] Test for char errors

On Fri, Jun 19, 2015 at 8:29 AM, 夏高 xiagao1...@gmail.com wrote: Thanks Michael! Could you tell me which option determines what expected output is used? Have a look at results_differ() in pg_regress.c ;) The file selected as expected output is the one with less lines of diffs. -- Michael --

Re: [GENERAL] Test for char errors

On Wed, Jun 17, 2015 at 5:15 PM, 夏高 wrote: I don't know why the files are not the same but tests all passed. Helps are appreciated, thanks! Some tests have multiple expected outputs. In the case of char, there is not only char.out, but as well char_1.out and char_2.out. In your case char_1.out

[GENERAL] Test for char errors

I downloaded psotgresql-9.4.4 source code and build it on Centos 6.5 x64 edition. Then I run 'make test' and it reported that 'All 145 tests passed'. But the expected output and actual output of test 'char' are not same. The expected output of in 'src/test/regress/expected/char.out' is: SELECT

[GENERAL] Test

I tried sending email reply to this list and it was flagged as spam. Just testing Thanks, -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Test

On 02/23/2014 10:57 AM, Adrian Klaver wrote: I tried sending email reply to this list and it was flagged as spam. Just testing Thanks to quick response from Stefan Kaltenbrunner, the problem has been identified. I was responding to John Smiths email and it turns out that tripped the spam

[GENERAL] Test, please ignore.

$subject! -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres:

[GENERAL] Test ODBC connection failed. Pleae help me to take a look. Thanks.

These odbc drivers (psqlodbc-08.02.0400 psqlodbc-08.03.0400 psqlodbc-09.00.0200 psqlodbc-08.02.0500 psqlodbc-08.04.0200) were installed. But I can't fine where the odbc.ini. After I set up my .odbc.ini. And setup the driver and driver manager environment variables, I still can't get the isql

Re: [GENERAL] Test ODBC connection failed. Pleae help me to take a look. Thanks.

On Mon, Apr 30, 2012 at 12:32 PM, leaf_yxj leaf_...@163.com wrote: These odbc drivers (psqlodbc-08.02.0400  psqlodbc-08.03.0400 psqlodbc-09.00.0200 psqlodbc-08.02.0500  psqlodbc-08.04.0200) were installed. But I can't fine where the odbc.ini. After I set up my .odbc.ini. And setup the driver

Re: [GENERAL] Test ODBC connection failed. Pleae help me to take a look. Thanks.

Hi Scott, I amn't farmiliar with isql. Why I said isql is because that I did some research. they said something related to isql. No matter it's isql or psql. 1)How can I test the odbc function? 2) what's isql, in which circumstances , we use isql. Thanks. Regards. Grace At 2012-05-01

Re: [GENERAL] Test ODBC connection failed. Pleae help me to take a look. Thanks.

you want psql not isql. On Mon, Apr 30, 2012 at 3:19 PM, yxj leaf_...@163.com wrote: Hi Scott, I amn't farmiliar with isql. Why I said isql is because that I did some research. they said something related to isql. No matter it's isql or psql. 1)How can I test the odbc function? 2) what's

Re: [GENERAL] Test ODBC connection failed. Pleae help me to take a look. Thanks.

Hi Chris, Actually I only want to test ODBC. But I didn't have any idea to test. We have pgsqlodbc installed, but I don't how to test it. Please give me some clue. Thanks. Grace At 2012-05-01 03:54:36,Chris Curvey ch...@chriscurvey.com wrote: you want psql not isql. On Mon, Apr 30, 2012

Re: [GENERAL] Test for cascade delete in plpgsql

On 10/13/2011 5:45 PM, David Johnston wrote: the company record should not be visible if you execute a SELECT against the companies table using the given company_id value. The previous is not tested and I am not totally sure about the visibility rules in this situation (mainly whether the

[GENERAL] Test for cascade delete in plpgsql

My contacts table has a FK with cascade delete to foreign table companies using the company_id column. I have a DELETE AFTER trigger on my contacts table that checks to see if there are any contacts left with an email address or it won't allow you to delete the record for a company. However, if

Re: [GENERAL] Test for cascade delete in plpgsql

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Robert Fitzpatrick Sent: Thursday, October 13, 2011 4:39 PM To: PostgreSQL Subject: [GENERAL] Test for cascade delete in plpgsql My contacts table has a FK with cascade

[GENERAL] test

test -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] test data

I seem to like having more realistic test data, to that end I have collected a large number of first names and last names over the last few years. Now I'd kinda like to collect business names. I've been searching around and cannot find anything. I was wondering if anyone had any business

Re: [GENERAL] test data

-general-ow...@postgresql.org] On Behalf Of Andy Colson Sent: Friday, March 04, 2011 8:42 PM To: PostgreSQL general Subject: [GENERAL] test data I seem to like having more realistic test data, to that end I have collected a large number of first names and last names over the last few years. Now I'd kinda

[GENERAL] Test build of postgres v8.4.2 available

I have compiled postgres for AIX and tested installation on a fresh installation of AIX 6.1.3. I am interested in feedback on the package and shall make improvements in the packaging as needed. for enhanced portability readline and zlib were not included in the build. I'll be looking into that at

[GENERAL] test data

Hi, Is there such a thing as a test dataset for postgresql? Coming from the project i mean. Cheers, WBL -- Patriotism is the conviction that your country is superior to all others because you were born in it. -- George Bernard Shaw -- Sent via pgsql-general mailing list

Re: [GENERAL] test data

Willy-Bas Loos, 17.11.2009 12:15: Hi, Is there such a thing as a test dataset for postgresql? Coming from the project i mean. Cheers, WBL Try this: http://pgfoundry.org/projects/dbsamples/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Postgres alpha testing docs and general test packs

On ons, 2009-10-28 at 14:13 +, Thom Brown wrote: http://developer.postgresql.org/pgdocs/postgres/release-8-5.html Thanks Adrian. I just wasn't looking hard enough obviously :) That list still doesn't appear to be explicit enough though as we have Multiple improvements in

Re: [GENERAL] Postgres alpha testing docs and general test packs

2009/11/1 Peter Eisentraut pete...@gmx.net: On ons, 2009-10-28 at 14:13 +, Thom Brown wrote: I'm not really asking for the answer to those questions.  I'm pointing out that it isn't clear (at least to me) how to determine what exactly has been fixed in order to test it.  This doesn't apply

Re: [GENERAL] Postgres alpha testing docs and general test packs

Le jeudi 29 octobre 2009 à 02:13:51, Greg Smith a écrit : On Wed, 28 Oct 2009, Thom Brown wrote: All we have are a summary of changes. We can find out all the information if we do plenty of searching of mailing lists and comparing old and new documentation, but obviously this can be

[GENERAL] Postgres alpha testing docs and general test packs

Hi, Are there any test guides/plans generated for alpha releases, or are such things only distributed to other developers?  I've seen postings which mention what the new features are, and links to documentation and other postings as to what it can do, but no single page outlining the changes

Re: [GENERAL] Postgres alpha testing docs and general test packs

have you seen that one: http://it.toolbox.com/blogs/database-soup/alpha2-is-out-and-we-need-you-to-test-it-35032?rss=1 ?

Re: [GENERAL] Postgres alpha testing docs and general test packs

2009/10/28 Grzegorz Jaśkiewicz gryz...@gmail.com: have you seen that one: http://it.toolbox.com/blogs/database-soup/alpha2-is-out-and-we-need-you-to-test-it-35032?rss=1 ? That's partly why I was asking. It mentions the areas where the changes have occurred, but not necessarily the changes

Re: [GENERAL] Postgres alpha testing docs and general test packs

On Wednesday 28 October 2009 6:46:13 am Thom Brown wrote: 2009/10/28 Grzegorz Jaśkiewicz gryz...@gmail.com: have you seen that one: http://it.toolbox.com/blogs/database-soup/alpha2-is-out-and-we-need-you-t o-test-it-35032?rss=1 ? That's partly why I was asking. It mentions the areas where

Re: [GENERAL] Postgres alpha testing docs and general test packs

2009/10/28 Adrian Klaver akla...@comcast.net: Entirely new features are easier to deal with though.  I still would, however, want something like a detailed version of Josh's post which breaks down where the changes have occurred.  It seems quite scattered and unclear at the moment. Thom

Re: [GENERAL] Postgres alpha testing docs and general test packs

Le mercredi 28 octobre 2009 à 15:13:06, Thom Brown a écrit : 2009/10/28 Adrian Klaver akla...@comcast.net: Entirely new features are easier to deal with though. I still would, however, want something like a detailed version of Josh's post which breaks down where the changes have occurred.

Re: [GENERAL] Postgres alpha testing docs and general test packs

Le mercredi 28 octobre 2009 à 23:30:01, Adrian Klaver a écrit : - Guillaume Lelarge guilla...@lelarge.info wrote: Le mercredi 28 octobre 2009 à 15:13:06, Thom Brown a écrit : Similarly: Fix encoding handling in binary input function of xml type. What was the problem before? See

Re: [GENERAL] Postgres alpha testing docs and general test packs

- Guillaume Lelarge guilla...@lelarge.info wrote: Le mercredi 28 octobre 2009 à 23:30:01, Adrian Klaver a écrit : - Guillaume Lelarge guilla...@lelarge.info wrote: Le mercredi 28 octobre 2009 à 15:13:06, Thom Brown a écrit : Similarly: Fix encoding handling in binary input

Re: [GENERAL] Postgres alpha testing docs and general test packs

2009/10/28 Adrian Klaver akla...@comcast.net: - Guillaume Lelarge guilla...@lelarge.info wrote: Le mercredi 28 octobre 2009 à 15:13:06, Thom Brown a écrit : Similarly: Fix encoding handling in binary input function of xml type. What was the problem before? See attached screen

Re: [GENERAL] Postgres alpha testing docs and general test packs

Thom Brown escribió: Obviously PostgreSQL has survived very well without this, but I would expect this would help more users perform more testing. Keep in mind alphas are new. Last time around, we only released a test version when we were going to go to beta. And the alpha idea was accepted

Re: [GENERAL] Postgres alpha testing docs and general test packs

On Wednesday 28 October 2009 3:55:02 pm Thom Brown wrote: 2009/10/28 Adrian Klaver akla...@comcast.net: - Guillaume Lelarge guilla...@lelarge.info wrote: Le mercredi 28 octobre 2009 à 15:13:06, Thom Brown a écrit : Similarly: Fix encoding handling in binary input function of xml

Re: [GENERAL] Postgres alpha testing docs and general test packs

2009/10/28 Alvaro Herrera alvhe...@commandprompt.com: If anyone (you?) wants to step up and produce the document you request, it'll probably be linked to.  But please do not request the current development team to work on it, because most of them are overloaded already (or have other reasons

Re: [GENERAL] Postgres alpha testing docs and general test packs

On Wed, 28 Oct 2009, Thom Brown wrote: All we have are a summary of changes. We can find out all the information if we do plenty of searching of mailing lists and comparing old and new documentation, but obviously this can be off-putting and is duplicated for everyone who wants to

[GENERAL] Test for optimizer

I want to test the optimizer of postgresql. Can anyone give me any idea about which kinds of query I should test? large query for path an geqo? subquery?

[GENERAL] test message -- Is this post getting to the list?

-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] test aggregate functions without a dummy table

Hi, I want to test the behavior of an an aggregate without creating a dummy table for it. But the code for it is horrible. Is there no simpler way? select max(foo) from (select 1 as foo union select 2 as foo)bar; thx

Re: [GENERAL] test aggregate functions without a dummy table

Willy-Bas Loos [EMAIL PROTECTED] writes: I want to test the behavior of an an aggregate without creating a dummy table for it. But the code for it is horrible. Is there no simpler way? select max(foo) from (select 1 as foo union select 2 as foo)bar; Perhaps VALUES? regression=# select

Re: [GENERAL] test aggregate functions without a dummy table

On Fri, Jun 20, 2008 at 10:11:08AM -0400, Tom Lane wrote: Willy-Bas Loos [EMAIL PROTECTED] writes: I want to test the behavior of an an aggregate without creating a dummy table for it. But the code for it is horrible. Is there no simpler way? select max(foo) from (select 1 as foo

[GENERAL] test ignore

test -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -- Sent via

[GENERAL] Test text value as interval

Been searching for a way to do this, but haven't found what I was hoping to find. Is there any way in pl/pgsql to test a text value to see if it would be a valid interval without having to try and store in a field? In a trigger, I'd like to test a NEW text type field. Right now, I have just the

Re: [GENERAL] Test text value as interval

On Thu, 2008-02-07 at 19:37 -0500, Robert Fitzpatrick wrote: Been searching for a way to do this, but haven't found what I was hoping to find. Is there any way in pl/pgsql to test a text value to see if it would be a valid interval without having to try and store in a field? In a trigger, I'd

Re: [GENERAL] Test text value as interval

Robert Fitzpatrick [EMAIL PROTECTED] writes: Yes, this looks like it might work, thanks! But not sure which condition to look for or if I'm doing this correctly. I tried syntax_error condition, but I'm still receiving the same cast error trying this in a trigger function... SYNTAX_ERROR is

Re: [GENERAL] Test text value as interval

On Thu, 2008-02-07 at 16:58 -0800, Jeff Davis wrote: On Thu, 2008-02-07 at 19:37 -0500, Robert Fitzpatrick wrote: Been searching for a way to do this, but haven't found what I was hoping to find. Is there any way in pl/pgsql to test a text value to see if it would be a valid interval

[GENERAL] test message

Sorry People, this is a test message as it seems mail I'm writing to this list isn't going through-- I just want to see if I get a rebound of it... Please apologize. -- Pedro Doria Meunier Ips da Olaria Edf. Jardins do Garajau, 4 r/c Y 9125-163 Caniço Madeira Portugal GSM: +351 96 17 20 188

[GENERAL] test

[GENERAL] test

Mail from this ML doesn't seem to arrive at our office anymore (you haven't been silent for 4 days, have you?). Hence a small test. Sorry for the inconvenience. -- Alban Hertroys [EMAIL PROTECTED] magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A:

[GENERAL] test

[GENERAL] Test, ignore ...

Just testing ... ignore ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 9: In versions below 8.0, the

[GENERAL] test

wtf? my messages are not getting posted Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ---(end of broadcast)--- TIP 9: In versions below 8.0,

[GENERAL] Test for array slice?

Hi- I want to do something like this (pardon my pseudocode): A=ARRAY[4, 5, 6, 7, 8] B=ARRAY[5, 6] is_sliceof(A, B), i.e., there exists a slice of A that equals B. My best thought ATM is to convert both to strings and use pattern matching - any better ideas? --Pete

Re: [GENERAL] Test for array slice?

Peter Fein wrote: I want to do something like this (pardon my pseudocode): A=ARRAY[4, 5, 6, 7, 8] B=ARRAY[5, 6] is_sliceof(A, B), i.e., there exists a slice of A that equals B. My best thought ATM is to convert both to strings and use pattern matching - any better ideas? I can't think of a

Re: [GENERAL] Test for array slice?

On Jun 3, 2005, at 12:32 PM, Joe Conway wrote: Peter Fein wrote: I want to do something like this (pardon my pseudocode): A=ARRAY[4, 5, 6, 7, 8] B=ARRAY[5, 6] is_sliceof(A, B), i.e., there exists a slice of A that equals B. My best thought ATM is to convert both to strings and use pattern

Re: [GENERAL] Test for array slice?

Sean Davis wrote: On Jun 3, 2005, at 12:32 PM, Joe Conway wrote: Peter Fein wrote: I want to do something like this (pardon my pseudocode): A=ARRAY[4, 5, 6, 7, 8] B=ARRAY[5, 6] is_sliceof(A, B), i.e., there exists a slice of A that equals B. My best thought ATM is to convert both to

[GENERAL] test

please ignore -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Test

Test

  1   2   >