I have created a custom type as a domain based on text, which adds a
check constraint using a regexp to limit it to containing digits and
'.'. However I am finding I can add values with other characters to a
column of this type. Is this to be expected for some reason?
Or alternately, did I def
Thank you! (Slapping head)
Your regexp seems to do the trick.
On 10/29/2015 01:49 PM, Rob Sargent wrote:
On 10/29/2015 11:41 AM, Eric Schwarzenbach wrote:
I have created a custom type as a domain based on text, which adds a
check constraint using a regexp to limit it to containing digits and
On 10/29/2015 03:44 PM, Alvaro Herrera wrote:
Rob Sargent wrote:
Also thought I should mention that there is an ip address type if that's
what you're trying to accomplish.
Looking at the domain name, I wonder whether contrib/ltree would be
helpful.
Very observant! This is indeed part of a hi
Thank you! (Slapping head)
Your regexp seems to do the trick.
On 10/29/2015 01:49 PM, Rob Sargent wrote:
On 10/29/2015 11:41 AM, Eric Schwarzenbach wrote:
I have created a custom type as a domain based on text, which adds a
check constraint using a regexp to limit it to containing digits and
On 10/30/2015 09:53 AM, Jim Nasby wrote:
On 10/29/15 5:29 PM, Eric Schwarzenbach wrote:
I'm just now converting that path to use a custom domain (along with
custom operators) instead of just being a string. (The custom operators
allow the paths to be sorted properly without each segment ne
On 12/06/2016 01:30 PM, Rich Shepard wrote:
With no experience of storing binary data in a bytea column I don't
know
when its use is appropriate. I suspect that for an application I'm
developing it would be better to store row-related documents outside the
database, and want to learn if that i
On 12/06/2016 01:34 PM, Joshua D. Drake wrote:
On 12/06/2016 10:30 AM, Rich Shepard wrote:
My thinking is to not store these documents in the database, but to
store
them in subdirectories outside the database.
Your thoughts?
Due to the widely variable size of a PDF document, I would say
On 12/06/2016 02:40 PM, Joshua D. Drake wrote:
On 12/06/2016 11:12 AM, Eric Schwarzenbach wrote:
On 12/06/2016 01:34 PM, Joshua D. Drake wrote:
On 12/06/2016 10:30 AM, Rich Shepard wrote:
My thinking is to not store these documents in the database, but to
store
them in subdirectories
On 04/22/2016 06:21 AM, David Goodenough wrote:
On Thursday 21 April 2016 13:36:54 Guyren Howe wrote:
Anyone familiar with the issue would have to say that the tech world would
be a significantly better place if IBM had developed a real relational
database with an elegant query language rather t
Alan Hodgson wrote:
> On Tuesday 02 June 2009, "Carlos Oliva" wrote:
>
>> Is there a way to create a database or a table of a database in its own
>> folder? We are looking for ways to backup the sytem files of the
>> database to tape and one to exclude some tables from this backup. We
>> can
My rule of thumb for when to use to not use cascading deletes is this:
If the what the record represents can essentially be thought of a "part
of" what the record that it references represents, I use cascading
deletes. If what the record represents has an independent existence,
that it, it does no
Alban Hertroys wrote:
> On 25 Jul 2009, at 11:36, MS wrote:
>
>>> can we see an explain analyze at least?
>>>
>>
>> Hi,
>> Well, it won't be necessary - I mean it looks just like the explain I
>> sent in my first post.
>
> What first post? The only thing I can find is a reference in a message
> by
Bayless Kirtley wrote:
> Yes, I'm afraid you're gonna be out of luck on finding the array type
> in any
> of
> the smaller embedded databases. Honestly, the beg project I've been on
> for a
> year or so has used Postgres right through full development and testing.
> It's
> not hard to start and sto
I'm in the process taking a large SELECT statement which had been
written using implicit join syntax (that is, just listing all the tables
in the FROM clause, and listing join conditions in the WHERE clause) and
rewriting it to use explicit JOIN syntax (they are all inner joins).
This has sped up t
Um, ok. You've listed some conditions in order of how well they should
perform and these generally agree with my understanding. But how does
this relate to the relative performance of the semantically equivalent
explicit and implicit join syntaxes?
Eric
Martin Gainty wrote:
> here is my best -> w
ting the better performance anyway, but I'm just
wondering if this behavior is expected.
Eric
Eric Schwarzenbach wrote:
> I'm in the process taking a large SELECT statement which had been
> written using implicit join syntax (that is, just listing all the tables
> in the FROM clau
Tom Lane wrote:
> David Waller writes:
>
>> I'm struggling with a database query that under some circumstances returns
>> the error "ERROR: number of columns (2053) exceeds limit (1664)".
>> Confusingly, though, no table is that wide.
>>
>
> This limit would be enforced against the out
I've got a particular query that is giving me ridiculously erratic query
performance. I have the SQL in a pgadmin query window, and from one
execution to another, with no changes, the time it takes varies from
half a second to, well, at least 10 minutes or so at which point I give
up an cancel the
This is in a sense a followup to my post with subject "Wildly erratic
query performance".
The more I think about it the only thing that makes sense of my results
is if the query planner really WAS choosing my join order truly randomly
each time. I went digging into the manual and Section 49.3.1.
"
his problem (the only question is when I will
have time to do it).
Thanks again,
Eric
Tom Lane wrote:
> Eric Schwarzenbach <[EMAIL PROTECTED]> writes:
>
>> Now ordinarily I would interpret this use of the word "random" loosely, to
>> mean "arbitrarily&qu
me,
but it would certainly answer my question.
Eric
Dann Corbit wrote:
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
>> [EMAIL PROTECTED] On Behalf Of Eric Schwarzenbach
>> Sent: Friday, October 31, 2008 12:35 PM
>> To: pgsql-general@pos
This is in a sense a followup to my post with subject "Wildly erratic
query performance". The more I think about it the only thing that makes
sense of my results is if the query planner really WAS choosing my join
order truly randomly each time. I went digging into the manual and
Section 49.3.1. "G
problem (the only question is when I will
have time to do it).
Thanks again,
Eric
Tom Lane wrote:
> Eric Schwarzenbach <[EMAIL PROTECTED]> writes:
>
>> Now ordinarily I would interpret this use of the word "random" loosely, to
>> mean "arbitrarily"
Robert Treat wrote:
> On Tuesday 09 December 2008 19:43:02 Liraz Siri wrote:
>
>> Greg has a good point. Ubuntu is a bit of a moving target. In contrast,
>> Debian has a much slower release cycle than Ubuntu and is thus
>> considered by many people to be preferable for production server
>> appli
Dara Olson wrote:
>
> Happy spring.
>
> I am new to postgres/postgis and am trying to figure out the best way
> to approach documenting metadata within postgres. Has there been
> anything developed to add FGDC or Dublin Core standard metadata
> records into postgres for each table within the datab
Bill Moran wrote:
> In response to "Robert Pepersack" :
>
>
>> I read the document on array data types. Do they have anything at all to do
>> with PostgreSQL being "object-oriented"?
>>
>
> If you want to be pedantic, not really. Technically, Postgres isn't
> "object-oriented", it's "obj
Gauthier, Dave wrote:
>
> Is there a way to read an XML file into a postgres DB? I’m thinking
> that it will create and relate whatever tables are necessary to
> reflect whatever’s implied by the XML file structure.
>
>
>
> Thanks for any pointers !
>
That's a pretty common problem, and not one
27 matches
Mail list logo
