If ref_id is an instance of id and you are trying to filter that out, then use
a self join
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dann Corbit
Sent: Thursday, June 2, 2016 1:08 PM
To: 'Steve Clark' <steve
This is your request, translated directly into SQL
select max(id) from sometable where sts=0 and ref_id IS NULL
Looking at your sample, it seems that sts is always 1 when ref_id exists, so it
may possibly simplify to:
select max(id) from sometable where sts=0
-Original
Why not use the crosstab stuff in contrib?
http://www.postgresql.org/docs/9.3/static/tablefunc.html
Has it been removed or something?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Paul Jungwirth
Sent: Monday, May 5,
I wonder how this approach:
https://github.com/citusdata/cstore_fdw
compares to this one:
https://github.com/knizhnik/imcs
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dorian Hoxha
Sent: Thursday, April 3, 2014 12:58 PM
To:
Mogwai:
http://sourceforge.net/projects/mogwai/?source=directory
Needs JDBC drivers, but most database systems, including Postgres have one.
It is a little fiddly setting it up, but it seems to work with lots of data
sources.
Make sure the PosgreSQL jdbc driver is in the class path before you
postgresql-9.3.1-1-windows-x64.exe
[cid:image001.png@01CED62F.CDB7E0F0]
Problem running post-install step. Installation may not complete correctly
The database cluster initialization failed.
Is there an installation log I can examine to determine the problem more
completely?
System
[mailto:adrian.kla...@gmail.com]
Sent: Thursday, October 31, 2013 5:03 PM
To: Dann Corbit; 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] postgresql-9.3.1-1-windows-x64.exe does not install
correctly for me
On 10/31/2013 11:53 AM, Dann Corbit wrote:
postgresql-9.3.1-1-windows-x64.exe
To calculate geographic distances, a great circle route calculation is used.
This is not the same thing as the simple calculation for distances between two
points on a sphere.
In order to perform the calculation, various model parameters must be chosen,
such as the ellipsoidal reference model.
I worked on a library project once that needed to perform similarity searches.
The first thing needed was to construct a word dictionary where there was a
number corresponding to each word.
1, 'aardvark'
...
9, 'zygote'
Then you need a list of stop words like 'AND', 'THE':
Of course, you can use regular expressions and LIKE. Without understanding the
structure of your database, I don't know if that can be made efficient. For a
collection of sentences, I suspect it would get complicated. It would probably
be slow. I guess that what you want to do will be hard
[snip]
You want me clean some stuff. Because I installed 'unixODBC-2.3.0'?
I guess that if you did a successful make install of unixODBC-2.3.0 it will
work as your ODBC driver manager.
On the other hand, it is easier and more trouble free to use the standardized
package installer for your
From: Dev Kumkar [mailto:devdas.kum...@gmail.com]
Sent: Tuesday, May 21, 2013 7:33 PM
To: Dann Corbit
Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org
Subject: Re: [ODBC] [GENERAL] ODBC constructs
[snip]
Thanks for the info. Its Red Hat Enterprise Linux Server release 5.5
[snip]
Yeah, hope you got my confusion and inclination now.
Well to work with psqlODBC, will I need to recompile the psqlODBC binary and
any additional stuff to get ODBC working?
http://www.postgresql.org/ftp/odbc/versions/src/ has sources for windows or am
I missing something here?
Regards...
From: Dev Kumkar [mailto:devdas.kum...@gmail.com]
Sent: Tuesday, May 21, 2013 1:59 PM
To: Dann Corbit
Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org
Subject: Re: [ODBC] [GENERAL] ODBC constructs
[snip]
I already have installed this on Linux from above link some days
From: Dev Kumkar [mailto:devdas.kum...@gmail.com]
Sent: Tuesday, May 21, 2013 7:03 PM
To: Dann Corbit
Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org
Subject: Re: [ODBC] [GENERAL] ODBC constructs
[snip]
The link
http://www.enterprisedb.com/products-services-training
From: Dev Kumkar [mailto:devdas.kum...@gmail.com]
Sent: Tuesday, May 21, 2013 7:13 PM
To: Dann Corbit
Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org
Subject: Re: [ODBC] [GENERAL] ODBC constructs
On Tue, May 21, 2013 at 7:09 PM, Dann Corbit
dcor...@connx.commailto:dcor
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dev Kumkar
Sent: Tuesday, May 21, 2013 7:27 PM
To: John R Pierce
Cc: pgsql-general@postgresql.org; pgsql-o...@postgresql.org
Subject: Re: [ODBC] [GENERAL] ODBC constructs
[snip]
Suggestions?
Everything should have an id, and combination tables like person-gene should
have the person id + the gene id.
You might look at this tool to make your life easier:
https://github.com/pgmodeler/pgmodeler
First, read up on this:
http://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model
then,
I like this one too:
http://mogwai.sourceforge.net/erdesignerng.html
It does reverse engineering, but if you are creating a new model, that
capability is not a necessity.
Mogwai is not Postgresql specific, so you can use it with any db.
-Original Message-
From: Dann Corbit
Sent: Friday
Here is the current formal definition for index creation:
http://www.postgresql.org/docs/9.2/static/sql-createindex.html
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Vishalakshi
Navaneethakrishnan
Sent: Thursday, November 15, 2012 3:12 AM
If the numbers do not have to be exact the web applications could use the
cardinality estimates stored in the system tables.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Edson Richter
Sent: Monday, September 17, 2012 9:14 AM
To:
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Atkins
Sent: Monday, September 17, 2012 12:23 PM
To: pgsql-general@postgresql.org General
Subject: Re: [GENERAL] Official C++ API for postgresql?
On Sep 17, 2012,
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Monday, September 17, 2012 1:32 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Official C++ API for postgresql?
On 09/17/12 12:26 PM, Dann
10:42 PM, Dann Corbit wrote:
I just let it sit. 3.5 hours later, it completed.
...
I have several versions of PostgreSQL already installed on this
machine. We need to test compatibility with PostgreSQL database
systems with our products.
I tried to install 9.2 64 bit using the one click
I have several versions of PostgreSQL already installed on this machine. We
need to test compatibility with PostgreSQL database systems with our products.
I tried to install 9.2 64 bit using the one click installer from this location:
http://www.enterprisedb.com/products/pgdownload.do#windows
I
I just let it sit. 3.5 hours later, it completed.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dann Corbit
Sent: Wednesday, September 12, 2012 1:24 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] how long to wait on 9.2 bitrock
This is nice:
http://sourceforge.net/projects/mogwai/?source=directory
The install is fiddly, and the interface is JDBC. But it does a very good job
of reverse engineering a schema and graphically displaying it.
From: pgsql-general-ow...@postgresql.org
If you want to discover how B+Trees or B-Trees work, I suggest a web search. A
database like PostgreSQL is not going to use an ordinary btree for an index,
but they use special trees that have page level structures, such as B-Trees,
GiST trees, etc.For PostgreSQL the list includes {IIRC}
-Original Message-
From: Mike Christensen [mailto:m...@kitchenpc.com]
Sent: Tuesday, June 05, 2012 4:28 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] I'd like to learn a bit more about how indexes work
I'm aware of how B-Trees work, but I only understand them
From:
http://msdn.microsoft.com/en-us/library/windows/desktop/ms710150(v=vs.85).aspx
ODBC type SQL_DECIMAL maps to SQL type DECIMAL(p,s)
Signed, exact, numeric value with a precision of at least p and scale s. (The
maximum precision is driver-defined.) (1 = p = 15; s = p).[4]
ODBC type
PostgreSQL is process based. So it can be configured to use resources as
intensively as you like.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Heine Ferreira
Sent: Monday, June 06, 2011 1:17 PM
To: pgsql-general@postgresql.org
Subject:
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Craig Ringer
Sent: Monday, May 23, 2011 11:00 PM
To: Bailey, Rick
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL and SSIS
On 24/05/11 04:38,
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Rob Sargent
Sent: Monday, May 02, 2011 7:07 PM
To: Jeff Davis
Cc: Greg Smith; pgsql-general@postgresql.org
Subject: Re: [GENERAL] pervasiveness of surrogate (also
It has nothing to do with autocommit and everything to do with batching them
together.
For instance, if you run ten update queries in autocommit mode I would expect
it to take exactly the same time as:
Begin
Exec Query1
Commit
…
Begin
Exec Query10
Commit
From:
Smells like April first to me.
http://en.wikipedia.org/wiki/April_Fools'_Day
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rajasekhar Yakkali
Sent: Friday, April 01, 2011 10:08 AM
To: dp...@postgresql.org
Cc: pgsql-general@postgresql.org;
Perhaps you want to use the ctid. You can query it like any other column:
http://www.postgresql.org/docs/9.0/static/ddl-system-columns.html
The ctid is not permanent. An alternative is to create tables with OID values.
From: pgsql-general-ow...@postgresql.org
Is your application by chance using OLEDB?
If that is the case, then just get a PostgreSQL OLEDB provider that supports
bookmarks.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Konstantin Izmailov
Sent: Tuesday, November 30, 2010 9:50 PM
To:
Oracle from PostgreSQL:
http://www.sqlmag.com/article/sql-server/setting-up-an-oracle-linked-server49687.aspx
PostgreSQL from Oracle:
http://www.postgresql.org/docs/current/static/dblink.html
Or perhaps I do not understand your question.
From: pgsql-general-ow...@postgresql.org
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dan Halbert
Sent: Monday, November 15, 2010 12:01 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Indexes on individual columns of composite primary key
I have a table with four columns.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dann Corbit
Sent: Monday, November 15, 2010 12:21 PM
To: 'Dan Halbert'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Indexes on individual columns of composite primary key
From: pgsql-general
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Clark C. Evans
Sent: Friday, November 12, 2010 12:25 PM
To: Mark Mitchell; 'Tom Lane'
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] More then 1600 columns?
Did you read this:
http://www.postgresql.org/docs/current/static/multibyte.html
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ???SS S
Sent: Friday, November 12, 2010 2:58 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Insert
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Marc Mamin
Sent: Thursday, November 11, 2010 11:46 AM
To: Aram Fingal; Postgres-General General
Subject: Re: [GENERAL] Schema tool
Hello,
may schemaspy help you
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sandeep Srinivasa
Sent: Tuesday, November 09, 2010 10:10 AM
To: Lincoln Yeoh
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Why facebook used mysql ?
hi,
I am the OP.
With due respect
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Rob Brown-Bayliss
Sent: Tuesday, November 09, 2010 8:20 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Libpq is very slow on windows but fast on linux.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of mike stanton
Sent: Friday, November 05, 2010 12:08 PM
To: pgsql-general@postgresql.org
Cc: mike stanton
Subject: [GENERAL] Access postgresql data base from .net
Hello all; we´ve got a project where
providers. This is the entire and fundamental
reason for using these tools. Otherwise, we would all be using custom
database API libraries instead.
From: mike stanton [mailto:mike.stan...@autocastillo.cl]
Sent: Friday, November 05, 2010 2:47 PM
To: Dann Corbit
Subject: Re: [GENERAL] Access
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Reid Thompson
Sent: Thursday, October 28, 2010 12:57 PM
To: st...@subwest.com
Cc: Reid Thompson; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Full Text Search - Slow on common words
On Thu,
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Scott Marlowe
Sent: Thursday, October 28, 2010 6:31 PM
To: Scott Newton
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] MySQL - PostgreSQL conversion issue
If you do not understand what you are doing, it might be a good idea to find
someone in your organization who understands SQL.
You were given the suggestion UPDATE table SET column list FROM from list
... which is documented here:
http://www.postgresql.org/docs/9.0/interactive/sql-update.html
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Tuesday, October 26, 2010 5:18 PM
To: Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]
Cc: pgsql-general@postgresql.org
Subject: Re:
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of sameer malve
Sent: Wednesday, October 20, 2010 12:14 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Installation of postgres server-8.4
Hi sir,
Can you please guide me for installation
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Carlos Mennens
Sent: Monday, October 11, 2010 4:47 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] NoSQL -vs- SQL
Just wondering how you guys feel about
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Wang, Mary Y
Sent: Monday, October 04, 2010 1:00 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to data dump a table content to a CSV or XML
format?
-Original Message-
From: Joshua J. Kugler [mailto:jos...@eeinternet.com]
Sent: Friday, October 01, 2010 10:36 AM
To: pgsql-general@postgresql.org
Cc: Dann Corbit
Subject: Re: Kudos on the 64 bit PostgreSQL for Windows
On Thursday 30 September 2010, Dann Corbit elucidated thus:
I
-Original Message-
From: Dann Corbit
Sent: Friday, October 01, 2010 11:06 AM
To: 'Joshua J. Kugler'; pgsql-general@postgresql.org
Subject: RE: Kudos on the 64 bit PostgreSQL for Windows
-Original Message-
From: Joshua J. Kugler [mailto:jos...@eeinternet.com]
Sent
-Original Message-
From: Craig Ringer [mailto:cr...@postnewspapers.com.au]
Sent: Friday, October 01, 2010 6:08 PM
To: Dann Corbit
Cc: 'Joshua J. Kugler'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Kudos on the 64 bit PostgreSQL for Windows
On 2/10/2010 2:06 AM, Dann
I installed the 64 bit PostgreSQL 9.0 on Windows Server 2008 and it seems to
perform wonderfully.
I moved 1.5 million records that are 3K wide from SQL*Server into PostgreSQL
and rebuilt 6 indexes all in less than 6 minutes.
I was thinking of using SQLite for the project, but I calculate the
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Tuesday, September 14, 2010 8:41 PM
To: Michael Hull
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Search then Delete Performance
CLucene is one possibility:
http://sourceforge.net/projects/clucene/
Since you are asking in the PostgreSQL group, why not use the built-in full
text search:
http://www.postgresql.org/docs/8.4/static/textsearch.html
From: pgsql-general-ow...@postgresql.org
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Patrick May
Sent: Tuesday, July 27, 2010 3:59 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Histogram generator
Hi,
I have a table containing
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Wang, Mary Y
Sent: Thursday, June 24, 2010 4:05 PM
To: pgsql-general
Subject: [GENERAL] Need Some Recent Information on the Differences between
Postgres and MySql
Hi,
I'm trying to find some
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of zach cruise
Sent: Tuesday, June 22, 2010 11:09 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] what happens to postmaster?
...when i am importing a table
Assuming a TCP/IP connection, does the server machine know about your tcp/ip
address in pg_hba.conf?
Otherwise, what kind of connection protocol are you using?
I promise, no Lakers jokes.
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Thursday, June 17, 2010 11:54 AM
To: Felde Norbert
Cc: pgsql-general@postgresql.org; Scott Marlowe
Subject: Re: [GENERAL] postgres crash SOS
Felde
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, June 17, 2010 12:20 PM
To: Dann Corbit
Cc: Felde Norbert; pgsql-general@postgresql.org; Scott Marlowe
Subject: Re: [GENERAL] postgres crash SOS
Dann Corbit dcor...@connx.com writes:
(Personally I'd
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Merlin Moncure
Sent: Thursday, June 17, 2010 12:56 PM
To: Tom Lane
Cc: Felde Norbert; pgsql-general@postgresql.org; Scott Marlowe
Subject: Re: [GENERAL] postgres
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Thom Brown
Sent: Wednesday, May 26, 2010 2:14 PM
To: John Gage
Cc: PostgreSQL - General
Subject: Re: [GENERAL] 110,000,000 rows
On 26 May 2010 21:29, John Gage
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Roger Tannous
Sent: Thursday, March 04, 2010 11:33 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Optimal database table optimization method
Hello,
I have a database table that is growing
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Scott Ribe
Sent: Thursday, January 28, 2010 2:10 PM
To: Thom Brown
Cc: pgsql-general
Subject: Re: [GENERAL] SQL question re aggregates joins
You can't include
From: akp geek [mailto:akpg...@gmail.com]
Sent: Thursday, January 07, 2010 9:04 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Index question on postgres
{snip}
Why would the index I have created not being used?
The index you have created will not be used
If you do a:
VACUUM FULL ANALYZE
for both production and for test and then do an EXPLAIN on your queries,
what do the plans look like?
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of akp geek
Sent: Thursday, January 07, 2010 8:11 PM
To:
Post the results here
From: akp geek [mailto:akpg...@gmail.com]
Sent: Thursday, January 07, 2010 8:30 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Index question on postgres
I did that and the Explain look different
Regards
On Thu, Jan 7, 2010 at 11
-Original Message-
From: Yan Cheng Cheok [mailto:ycch...@yahoo.com]
Sent: Tuesday, January 05, 2010 10:30 PM
To: Craig Ringer
Cc: Dann Corbit; pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL Write Performance
Thanks for the information. I perform benchmarking
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Yan Cheng Cheok
Sent: Monday, January 04, 2010 9:05 PM
To: Scott Marlowe
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL Write Performance
-Original Message-
From: Yan Cheng Cheok [mailto:ycch...@yahoo.com]
Sent: Monday, January 04, 2010 11:30 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL Write Performance
What is the actual problem you are trying to solve?
I am currently
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Peter Geoghegan
Sent: Thursday, December 31, 2009 8:23 PM
To: Andrew Lardinois
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Save MySQL? HA
Andrew,
I
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Andrus
Sent: Tuesday, December 22, 2009 12:03 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to add month.year column validation
Database contains
CREATE DOMAIN Nasty_Month_year AS CHAR(7)
CHECK ( SUBSTR(VALUE, 1, 2) IN ('01', '02', '03', '04', '05', '06',
'07', '08', '09', '10', '11', '12') AND SUBSTR(VALUE, 3, 1) = '.' AND
SUBSTR(VALUE, 4, 4)::int BETWEEN 1980 and 2110 );
CREATE TABLE foo (bar Nasty_Month_year );
This Works:
INSERT INTO
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Sebastian Feher
Sent: Monday, November 16, 2009 10:41 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Update on Insert
Hi Everyone,
Given a table Items
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Artur
Sent: Monday, June 15, 2009 5:00 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] 10 TB database
Hi!
We are thinking to create some stocks related
Look at the cheat-sheet:
http://www.postgresonline.com/journal/index.php?/archives/63-PostgreSQL-
8.3-Pg_dump-Pg_Restore-Cheatsheet-Overview.html
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Anderson dos
Santos Donda
Sent: Wednesday, May
If I have the C locale, can I have multiple character encodings within:
1. A single database?
2. A single table?
More specifically, I would like to be able to have Unicode columns and
ASCII text columns within the same table. Is this possible? If so, how
do I achieve it?
It was not clear to
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of James B. Byrne
Sent: Monday, April 06, 2009 1:46 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] INSERT or UPDATE
I have spent the last couple of days
-Original Message-
From: James B. Byrne [mailto:byrn...@harte-lyne.ca]
Sent: Monday, April 06, 2009 2:06 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] INSERT or UPDATE
On Mon, April 6, 2009 17:00, Dann Corbit wrote:
.
It is a difficult question
-Original Message-
From: James B. Byrne [mailto:byrn...@harte-lyne.ca]
Sent: Monday, April 06, 2009 5:16 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] INSERT or UPDATE
On Mon, April 6, 2009 17:15, Dann Corbit wrote:
The pedagogic solution
-Original Message-
From: James B. Byrne [mailto:byrn...@harte-lyne.ca]
Sent: Monday, April 06, 2009 5:43 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] INSERT or UPDATE
On Mon, April 6, 2009 20:23, Dann Corbit wrote:
If a transaction involves
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Will Rutherdale (rutherw)
Sent: Thursday, March 19, 2009 1:32 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Is there a meaningful benchmark?
Hi. I'm
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Scott Marlowe
Sent: Thursday, March 19, 2009 2:57 PM
To: Will Rutherdale (rutherw)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Is there a meaningful
Here is another interesting benchmark with a particular user's
application:
http://blog.page2rss.com/2007/01/postgresql-vs-mysql-performance.html
P.S.
Oracle won't let you publish any benchmark numbers.
So if you find an Oracle comparison, it's unauthorized
--
Sent via pgsql-general mailing
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joachim Tranvåg
Sent: Monday, March 16, 2009 1:20 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] (0x274D/10061) on Install
Hi, I am trying to install PostgreSQL on Windows Vista 32bit, I
Did you restart the server after making your changes to pg_hba.conf?
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joachim Tranvåg
Sent: Monday, March 16, 2009 2:03 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL]
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Monday, March 16, 2009 8:02 PM
To: Raji Sridar (raji)
Cc: j...@commandprompt.com; Scott Marlowe; r...@iol.ie; pgsql-
gene...@postgresql.org
Subject:
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Carl Sopchak
Sent: Saturday, March 14, 2009 5:41 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] ODBC limitation??
When I run the following query through
If Kerberos V5 is not installed on a Windows platform, the following
error dialog is returned upon attempted installation:
Posgres.exe - Unable to Locate Component
This application has failed to start because krb5_32.dll was not found.
Re-installing the application may fix this problem.
[OK]
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Anderson dos
Santos Donda
Sent: Wednesday, February 04, 2009 12:05 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] SELECT on a table with Time values
Hi all!!
I have a simple table with
My notion is to do a character mode database dump as SQL statements and
then load into the new version by execution of psql against the sql
STATEMENTS.
What are the gotchas we can expect with this approach?
When I say 'ancient' I mean v7.1.3 and the target is v8.3.5.
--
Sent via pgsql-general
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Alvaro Herrera
Sent: Monday, January 12, 2009 12:41 PM
To: Bruno Lavoie
Cc: PostgreSQL
Subject: Re: [GENERAL] Indexing columns with low cardinality:
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Emanuel Calvo Franco
Sent: Wednesday, December 10, 2008 11:27 AM
To: Liraz Siri; General PostgreSQL List
Subject: Re: [GENERAL] The future of Solaris?
2008/12/10 Liraz Siri [EMAIL
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Linden
Sent: Tuesday, December 09, 2008 10:09 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] q query about a bug.
Dear
We have a developer doing an application for us using a Postgre Db. One
of the items is to
1 - 100 of 345 matches
Mail list logo