On Wed, Oct 6, 2010 at 10:47 PM, Magnus Hagander wrote:
> On Thu, Oct 7, 2010 at 05:09, Mike Christensen wrote:
>> On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane wrote:
>>> Mike Christensen writes:
>>>> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote:
>>>&
Hi, I'm trying to require SSL for Postgres connections from certain
IPs.. This is on Postgres 9.0.
First, I've followed the directions at:
http://www.postgresql.org/docs/9.0/static/ssl-tcp.html
I've created the files server.crt and server.key. I've also removed
the passphrase from the key so P
7;root'.
> In my case I run Red Hat which uses the 'postgres' user, so:
>
> chown postgres.postgres /var/lib/pgsql/data/server.*
>
>
> On Sun, Oct 10, 2010 at 2:52 PM, Mike Christensen
> wrote:
>>
>> Hi, I'm trying to require SSL for Postgres co
In
> any event, you should have another user; running programs or servers as root
> when they don't need root powers is generally a bad idea.) -- Darren Duncan
>
> Mike Christensen wrote:
>>
>> Hi, I'm trying to require SSL for Postgres connections from certain
&
While I do appreciate the vote of confidence, rest assured you will
never see a post from me that starts with "So I've been hacking the pg
code and..."
On Sat, Oct 9, 2010 at 11:54 PM, Scott Marlowe wrote:
> On Sat, Oct 9, 2010 at 10:04 PM, Darren Duncan
> wrote:
>> The owner of these new files
Okay my required n00b question of the week, hopefully this'll be an easy one..
I decided to give pgAgent a shot, because there's this stored sproc
(sorry, function) I need to run nightly and I think spending hours
figuring out pgAgent would somehow be better than the 3 minutes it
would take to add
On Mon, Oct 18, 2010 at 2:07 AM, Dave Page wrote:
> On Sun, Oct 17, 2010 at 2:32 PM, Mike Christensen wrote:
>> Okay my required n00b question of the week, hopefully this'll be an easy
>> one..
>>
>> I decided to give pgAgent a shot, because there's this sto
On Mon, Oct 18, 2010 at 2:21 AM, Mike Christensen wrote:
> On Mon, Oct 18, 2010 at 2:07 AM, Dave Page wrote:
>> On Sun, Oct 17, 2010 at 2:32 PM, Mike Christensen wrote:
>>> Okay my required n00b question of the week, hopefully this'll be an easy
>>> one..
>
On Mon, Oct 18, 2010 at 2:34 AM, Dave Page wrote:
> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen wrote:
>> Sorry, it looks like it defaulted to the wrong DB. I created the
>> schema in the "postgres" database and now I see a Jobs node..
>
> :-)
>
>>
On Mon, Oct 18, 2010 at 2:43 AM, Dave Page wrote:
> On Mon, Oct 18, 2010 at 10:41 AM, Mike Christensen wrote:
>> On Mon, Oct 18, 2010 at 2:34 AM, Dave Page wrote:
>>> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen
>>> wrote:
>>>> Sorry, it look
On Mon, Oct 18, 2010 at 3:07 AM, Dave Page wrote:
> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen wrote:
>> Okay I found one that I can use..
>>
>> One question.. Should the connection string in the script have the
>> password for "root" hard coded i
On Mon, Oct 18, 2010 at 3:37 AM, Dave Page wrote:
> On Mon, Oct 18, 2010 at 11:34 AM, Mike Christensen wrote:
>> On Mon, Oct 18, 2010 at 3:07 AM, Dave Page wrote:
>>> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen
>>> wrote:
>>>> Okay I found one
. I think now it's legit now..
On Fri, Oct 22, 2010 at 7:00 PM, Alexia Lau wrote:
> Does anyone know where I can see what’s already fixed at 9.0.2?
>
> Thanks,
>
> Alexia
>
> On 2010-10-07 09:54, Dave Page wrote:
>> On Thu, Oct 7, 2010 at 3:56 AM, Tom Lane wrote:
&
I have a Postgres 9 server running on a server out on the Internet and
I connect to it with pgAdmin on OS/X over an SSL connection.
I notice if I keep the connection open and idle for maybe an hour or
so, when I try to run a query it either times out or pgAdmin just
kinda freezes up and I have to
Maybe that's it.. It's definitely some sort of SSL thing since it
didn't start happening until I enabled SSL. I guess I'll just have to
close pgAdmin when I'm not using it..
On Sat, Oct 30, 2010 at 12:57 AM, Basil Bourque wrote:
>
> On Oct 29, 2010, at 15:36,
Gz.
Maybe you can lease a bunch of Amazon EC2 high computing slices and
parallelize it? I think throwing ridiculous amounts of hardware at
things is always the best approach.
On Sat, Oct 30, 2010 at 2:48 PM, Viktor Bojović
wrote:
> Hi,
> i have very big XML documment which is larger tha
If I understand your question correctly, a Dialect is an abstraction
layer that allows Hibernate to talk with different database backends
(MySQL, PG, Oracle, SQLServer, etc). Since different databases have
different syntaxes, various features, etc. This seems more of a
Hibernate question though,
On Mon, Nov 22, 2010 at 12:26 AM, Andreas wrote:
> Am 22.11.2010 08:32, schrieb Adarsh Sharma:
>>
>> I am reading about Dialects of different databases. Yet I can't understand
>> what is the need of dialect in Postgres or any other like Hibernate uses
>> Dialect of all Databases for ORM.
>> What i
> A project in which i'm involved, make use of json data type for storing
> some data sets. I have read that there is some work in progress to implement
> json datatype support in postgres. So my question is; when and in which
> version of postgres we can expect this implementation?
I actually st
On Mon, Dec 6, 2010 at 7:49 PM, Craig Ringer
wrote:
> Hi all
>
> I'm finding a few areas where PostgreSQL's refusal to implicitly cast
> from 'text' to another type is causing real problems, particularly when
> using the PgJDBC driver. I'd like to propose a couple of relaxations of
> the implicit
2011/1/5 Grzegorz Jaśkiewicz :
> On Wed, Jan 5, 2011 at 2:37 PM, Scott Ribe
> wrote:
>> On Jan 5, 2011, at 1:31 AM, Radosław Smogura wrote:
>>
>>> * simple to generate, and 128bit random is almost globally unique,
>>
>> Almost? Should be totally unique, as long as your random source is decent
>>
> I have a machine on which MS SQL Server 2005 is already installed. Now I
> want to install PostgreSQL 8.3 along with MS SQL Server.
>
>
>
> Can this combination cause any problems to any of the database servers?
You should not run into any problems, both servers run on different
ports (by defa
I'm trying to install the Postgres gem on OS/X but getting errors no
matter what I try.. In theory, it should be as simple as "gem install
postgres", correct? Here's what I get:
>sudo gem install postgres
Building native extensions. This could take a while...
ERROR: Error installing postgres:
le not created
Gem files will remain installed in
/Library/Ruby/Gems/1.8/gems/postgres-0.7.9.2008.01.28 for inspection.
Results logged to
/Library/Ruby/Gems/1.8/gems/postgres-0.7.9.2008.01.28/ext/gem_make.out
/Library/PostgreSQL/9.0>
On Fri, Jan 28, 2011 at 5:46 PM, Thom Brown wrote:
> On 2
m just learning for now)..
However, if anyone has any ideas how to install the native adapter, lemme know!
On Fri, Jan 28, 2011 at 5:50 PM, Mike Christensen wrote:
> Now I get:
>
> /Library/PostgreSQL/9.0>export ARCHFLAGS='-arch i386'
> /Library/PostgreSQL/9.0>sudo -E
> You might have to tell it where the PostgreSQL binaries live first then:
>
> export PATH=$PATH:/Library/PostgreSQL/9.0/bin
Hey that seems to have fixed it! Thanks!
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
My goal is to learn Ruby by porting one of my existing PG web
applications over to Rails.. However, my existing data heavily relies
on the UUID data type. I've noticed when I create a new model with
something like:
guidtest name:string value:uuid
And then do a rake:migrate, the CREATE TABLE tha
> My goal is to learn Ruby by porting one of my existing PG web
> applications over to Rails.. However, my existing data heavily relies
> on the UUID data type. I've noticed when I create a new model with
> something like:
>
> guidtest name:string value:uuid
>
> And then do a rake:migrate, the CR
Here's the error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for
relation pantryitems
pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE
Does the user need to be a superuser, or is there some way to GRANT
this permission (if
>> Here's the error:
>>
>> pg_dump: SQL command failed
>> pg_dump: Error message from server: ERROR: permission denied for
>> relation pantryitems
>> pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE
>> MODE
>>
>> Does the user need to be a superuser, or is there some way to
Here's my query:
SELECT R.RecipeId, R.Title, R.Description, R.ImageUrl, R.Rating,
R.PrepTime, R.CookTime, R.OwnerId, U.Alias
FROM Recipes R
INNER JOIN Users U ON U.UserId = R.OwnerId
WHERE (R.PrepTime <= :maxprep)
ORDER BY R.Rating DESC LIMIT 100;
SELECT COUNT(*) FROM Recipes R
WHERE (R.PrepTime <
On Fri, Feb 18, 2011 at 1:05 AM, Dean Rasheed wrote:
> On 18 February 2011 07:19, Mike Christensen wrote:
>> Here's my query:
>>
>> SELECT R.RecipeId, R.Title, R.Description, R.ImageUrl, R.Rating,
>> R.PrepTime, R.CookTime, R.OwnerId, U.Alias
>> FROM Recip
Judging from:
http://www.postgresql.org/docs/8.1/static/sql-copy.html
It looks like you have to specify your own NULL string with the NULL
AS parameter of the COPY command.
On Fri, Feb 18, 2011 at 3:12 PM, Rich Shepard wrote:
> On Fri, 18 Feb 2011, Rich Shepard wrote:
>
>> Do I need an explicit
>> It looks like you have to specify your own NULL string with the NULL
>> AS parameter of the COPY command.
>
> Mike,
>
> I completely missed that option when I've read the copy page. My
> apologies!
>
> Rich
Awesome, I'm the one usually asking easy questions on this mailing
list so I'm just gla
On Sat, Mar 5, 2011 at 1:08 PM, matty jones wrote:
> I already have a domain name but I am looking for a hosting company that I
> can use PG with. The few I have contacted have said that they support MySQL
> only and won't give me access to install what I need or they want way to
> much. I don't
Sounds like you just have to wait until it finishes..
On Mon, Jul 7, 2014 at 12:56 PM, Prabhjot Sheena <
prabhjot.she...@rivalwatch.com> wrote:
> Hello
>We are using postgresql 8.3 database for last 5 yrs for this
> production database and its running fine. This is our critical database
I'm curious why this query returns 0:
SELECT 'AAA' ~ '^A{,4}$'
Yet, this query returns 1:
SELECT 'AAA' ~ '^A{0,4}$'
Is this a bug with the regular expression engine?
, David G Johnston <
david.g.johns...@gmail.com> wrote:
> Mike Christensen-2 wrote
> > I'm curious why this query returns 0:
> >
> > SELECT 'AAA' ~ '^A{,4}$'
> >
> > Yet, this query returns 1:
> >
> > SELECT 'AAA'
Yea looks like Postgres has it right, well.. per POSIX standard anyway.
JavaScript also has it right, as does Python and .NET. Ruby is just weird.
On Thu, Jul 24, 2014 at 1:57 PM, Tom Lane wrote:
> Mike Christensen writes:
> > I'm curious why this query returns 0:
> > S
http://meta.stackoverflow.com/questions/270574/an-experiment-stack-overflow-tv?cb=1
This is the number one requested feature on Uservoice:
http://postgresql.uservoice.com/forums/21853-general/suggestions/247548-materialized-views
On Mon, Apr 8, 2013 at 9:27 AM, John R Pierce wrote:
> On 4/7/2013 11:58 PM, Zahid Quadri wrote:
>
>
> is it possible to created materialized view
If I have this:
CREATE OR REPLACE VIEW Link.Foo AS
select * from dblink(
'hostaddr=123.123.123.123 dbname=KitchenPC user=Website
password=secret',
'select * from Foo') as ...
Then it works. However, if I do:
CREATE OR REPLACE VIEW Link.Foo AS
select * from dblink(
'hostaddr=db.d
Excellent! Thanks so much.
On Tue, May 14, 2013 at 9:25 PM, Adrian Klaver wrote:
> On 05/14/2013 09:17 PM, Mike Christensen wrote:
>
>> If I have this:
>>
>> CREATE OR REPLACE VIEW Link.Foo AS
>>select * from dblink(
>> 'hostaddr=123.
Though I'm a bit curious why there's a host and hostaddr. Why can't it
just resolve whatever you give it?
On Tue, May 14, 2013 at 9:31 PM, Mike Christensen wrote:
> Excellent! Thanks so much.
>
>
> On Tue, May 14, 2013 at 9:25 PM, Adrian Klaver wrote:
>
&
Ah, gotcha! I guess whatever sample I was originally copying from used
hostaddr for some reason.. Thanks for the clarification, Tom!
On Wed, May 15, 2013 at 6:08 AM, Tom Lane wrote:
> Mike Christensen writes:
> > Though I'm a bit curious why there's a host and host
On Thu, May 23, 2013 at 2:51 PM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> On 05/23/2013 02:36 PM, Oscar Calderon wrote:
>
>> Hi, this question isn't technical, but is very important for me to know.
>> Currently, here in El Salvador our company brings PostgreSQL support, but
>> Ora
I was reading about Postgres stored procs in the FAQ:
https://wiki.postgresql.org/wiki/FAQ#Does_PostgreSQL_have_stored_procedures.3F
It claims that an alternative syntax to:
SELECT theNameOfTheFunction(arg1, arg2);
Is:
PERFORM theNameOfTheFunction(arg1, arg2);
However, when I try the followin
Ah ok that makes sense. The FAQ wasn't exactly clear about that.
On Mon, Jul 8, 2013 at 9:38 PM, Tony Theodore wrote:
>
> On 09/07/2013, at 2:20 PM, Mike Christensen wrote:
>
>
> PERFORM MyInsert(1,101,'2013-04-04','2013-04-04',2,'f' );
>
You passed in:
22/1/2013
Which is 22 divided by 1, divided by 2013 - which is an integer..
On Tue, Jul 9, 2013 at 10:17 AM, giozh wrote:
> ok, it works. But why on error message i had that two unknown data type? if
> was an error on date type, why it don't signal that?
>
>
>
> --
> View this
Hi all -
I'm considering changing all my "timestamp" columns to "timestamp with
timezone" columns instead. The reason is I want to use UTC time for
everything in the DB and on the web server, and only ever convert to local
time on the client itself. I could use a timestamp and just "know" that t
:
> Mike Christensen wrote:
> > Hi all -
> >
> > I'm considering changing all my "timestamp" columns to "timestamp with
> > timezone" columns instead. The reason is I want to use UTC time for
> > everything in the DB and on the web serve
Strange, maybe there's some server setting because I get different results
on mine..
set timezone to 'Europe/London';
select '2008-01-01 12:00:00 GMT+2'::timestamptz;
Result: '2008-01-01 14:00:00+00'
set timezone to 'Europe/Moscow';
select '2008-01-01 12:00:00 GMT+2'::timestamptz;
Result: '2008-
I just tracked down a bug in my software due to an "unexpected" behavior in
Postgres.. Can someone clarify why this doesn't work (I haven't tried it on
MSSQL or anything else, so I'm not sure if this is the official SQL standard
or anything)..
CREATE TABLE test
(
value uuid
);
INSERT INTO test
> > From: spam_ea...@gmx.net
> > Subject: Re: [GENERAL] What's wrong with this query?
> > Date: Mon, 22 Jun 2009 00:37:41 +0200
>
> >
> > Mike Christensen wrote on 22.06.2009 00:10:
> > > I just tracked down a bug in my software due to an "unexpected"
>
; est interdite. Ce message sert à l'information seulement et n'aura pas
> n'importe quel effet légalement obligatoire. Étant donné que les email
> peuvent facilement être sujets à la manipulation, nous ne pouvons accepter
> aucune responsabilité pour le contenu fourni.
>
&
Rubyrep looks very interesting, I just watched their 5min video and looks
very easy to setup.
Few questions.. The left/right database looks very limiting (you can only
replicate two databases at a time).. Their documentation says that the
solution is to setup a chain. To keep A, B and C in sync
>
> Hi Mike
>
> thanks for your interest in rubyrep. I developed rubyrep. Let me
> answer your questions.
>
> On Jun 23, 4:16 pm, m...@kitchenpc.com (Mike Christensen) wrote:
> > There will be a set of triggers for each replication. Since MySql
> doesn't
>
We need to stop this thread, you guys are making me want to ditch Postgres
and get Oracle (after taking out a second mortgage on my house that is)..
Mike
On Wed, Jun 24, 2009 at 9:40 AM, Thomas Kellerer wrote:
> Craig Ringer wrote on 24.06.2009 04:07:
>
>> Thomas Kellerer wrote:
This behavior kinda gets me sometimes too, especially in WHERE clauses..
I'm a bit curious as to why this is so bad. I could see why it would
be expensive to do, since your clause wouldn't be indexed - but why is
the syntax itself not allowed? Repeating the clause isn't gonna gain
you any speed,
One thing I like about Microsoft SQL is you can write a sproc that does:
SELECT * FROM TableA
SELECT * FROM TableB
And in .NET, you'll have a DataSet object with two DataTables, one for
each table. Do either of the techniques outlined below provided this
functionality, though I suppose in .NET y
(Sorry for the super-easy question)
I want to store sales tax (as a percent) in the DB, such as 9.5%.
What's the best data type for this? I'm guessing numeric(2,3) should
be fine, yes? I'm not too familiar with the numeric type (I was using
"real" before), but as I understand the data will be st
8, 2009 at 4:38 PM, Merlin Moncure wrote:
> On Thu, Oct 8, 2009 at 6:04 PM, Mike Christensen wrote:
>> (Sorry for the super-easy question)
>>
>> I want to store sales tax (as a percent) in the DB, such as 9.5%.
>> What's the best data type for this? I'm gue
5:23 PM, Rich Shepard wrote:
> On Thu, 8 Oct 2009, Mike Christensen wrote:
>
>> I'll probably just use 3,3 and store this value between 0 and 1, since all
>> I'll be doing with this number is using it to multiply against a subtotal.
>> 3,3 gives me 0.000 through 0.9
simply
because it seems "cleaner" to me. At work, we use multipliers all
over the place in our DB and it has turned into a complete nightmare.
I'm somewhat of a believer in just storing data exactly how you need
to use it.
Thanks!
Mike
On Fri, Oct 9, 2009 at 4:13 AM, Sam Ma
Can you explain what you mean by "put it in a domain" - I'd love extra
style points, but this sounds like a feature I haven't learned about
yet.
On Fri, Oct 9, 2009 at 3:38 AM, Peter Eisentraut wrote:
> On Fri, 2009-10-09 at 00:10 -0700, Mike Christensen wrote:
>>
e
On Fri, Oct 9, 2009 at 11:46 AM, Christophe Pettus wrote:
>
> On Oct 9, 2009, at 11:36 AM, Mike Christensen wrote:
>
>> Can you explain what you mean by "put it in a domain" - I'd love extra
>> style points, but this sounds like a feature I haven&
Hmm would this be a bad time to ask for PostGres 1.0 support?
On Fri, Oct 16, 2009 at 1:55 PM, Jeff Davis wrote:
> On Fri, 2009-10-16 at 11:26 +0100, Neha Patel wrote:
>> We are running with postgres sql 7.3.2. We were trying to create an
>> index on a big table. The create index command ran for
I tried Power Architect for about 5 minutes, just enough time to
notice it had no support for UUIDs which makes it all but useless.. I
mean, seriously who doesn't use UUIDs :)
Maybe they'll fix that, it does look promising..
>>
>> Search the archives this came up within the last couple of months
Hi -
I have a fairly simple design question that I'd like some input on. I
have a table called "Orders" which, along with various order
information, contains an "OrderState" column. OrderState can contain
one of the following values:
1 - Order is in preview mode and has not been committed yet.
How about something incredibly cheesy like
SELECT * FROM Mug;
On Mon, Sep 9, 2013 at 8:22 AM, Karsten Hilbert wrote:
> Inside of the mug:
>
> - runs of 0's and 1's = data
> - neatly aligned or in compartments/boxes/shelved ?
>
> Outside of mug:
>
> 10 elephants
>
>
Oooh can we make the handle an elephant trunk? (Ok, now I'm sure I'm adding
all sorts of expense - but hey you'll save so much money using Postgres you
can afford an expensive coffee mug!)
On Thu, Sep 12, 2013 at 5:30 AM, Andreas 'ads' Scherbaum <
adsm...@wars-nicht.de> wrote:
> On 09/10/2013 10
It seems I need NpgsqlServices to use Npgsql with EF6, however I can't
figure out where you get this thing!
I've tried installing it through NuGet:
PM> Install-Package Npgsql -pre
Installing 'Npgsql 2.0.14.1'.
Successfully installed 'Npgsql 2.0.14.1'.
Adding 'Npgsql 2.0.14.1' to EFTest.
Successfu
ityFramework.dll in the EntityFramework/bin folder.
>
> I hope it helps.
>
> Let me know if you have any question.
>
>
>
> On Thu, Dec 12, 2013 at 1:24 AM, Mike Christensen wrote:
>
>> It seems I need NpgsqlServices to use Npgsql with EF6, however I can't
>&g
I've had the same problem as well with NHibernate (On .NET) with Postgres
ENUM types. Luckily, NHibernate is incredibly powerful and you *can* get
everything working flawlessly, however it takes some serious digging into
the source code and reading the docs to figure it out. The main issue is
tha
On Tue, Jan 28, 2014 at 2:46 PM, John R Pierce wrote:
> On 1/28/2014 2:35 PM, Mike Christensen wrote:
>
>> This works. However, to agree with the original poster's point, if
>> Postgres could be a little more forgiving about values that could be
>> interpreted as
How do you create casts in Postgres?
On Tue, Jan 28, 2014 at 3:24 PM, Andrew Sullivan wrote:
> On Tue, Jan 28, 2014 at 02:55:03PM -0800, Mike Christensen wrote:
>
> > I'd be curious as to what types of bugs were caused by these implicit
> > casts..
>
> Typically, t
Oh. The CREATE CAST command. Wow, I was totally unaware of this entire
feature!
On Tue, Jan 28, 2014 at 3:36 PM, Mike Christensen wrote:
> How do you create casts in Postgres?
>
>
> On Tue, Jan 28, 2014 at 3:24 PM, Andrew Sullivan wrote:
>
>> On Tue, Jan 28, 2014 at 0
Hi all -
For most of my database I use UUIDs as primary keys because, well, I
just like it better and like being able to generate a key in the
middle tier when I create new data. However, I have one table that
has a very fixed and immutable set of data with a few thousand
ingredients in it. This
On Wed, Jun 8, 2011 at 1:06 PM, David Johnston wrote:
>> -Original Message-
>> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
>> ow...@postgresql.org] On Behalf Of Mike Christensen
>> Sent: Wednesday, June 08, 2011 2:57 PM
>> To: pgsql-gen
>> I'm assuming I can still have a "Serial" column that is NOT a primary key,
> and
>> it'll incremement just the same as I add rows? If that's the case, I
> think that's
>> a superior approach..
>>
>> BTW, this table is too small to worry about disk space of UUIDs and/or
>> perhaps any sort of pe
I know I can setup a FK constraint to make sure Table1.ColA exists in
Table2.Key, however what if I want to do the reverse?
I want to ensure Table1.ColA does NOT exist in Table2.Key.. Can I do
this with any sort of CHECK constraint, trigger, custom function, etc?
Thanks!
Mike
--
Sent via pgsq
Did anyone ever fix the annoying thing where uuid_generate_v4()
doesn't work on Windows 64bit?
On Wed, Jun 15, 2011 at 9:46 PM, Tom Lane wrote:
> Craig Ringer writes:
>> Any chance of flagging patches on the commitfest when they're platform
>> specific? I'm hurting for time but will check out Wi
Wouldn't it be faster/better/easier if Postgres just had its own built
in UUID generator? Last I tested generating a bunch of UUIDs, it was
quite slow (well compared to MS SQL anyway)..
On Wed, Jun 15, 2011 at 10:23 PM, Tom Lane wrote:
> Mike Christensen writes:
>> Did anyon
On Wed, Jun 15, 2011 at 10:34 PM, Tom Lane wrote:
> Mike Christensen writes:
>> Wouldn't it be faster/better/easier if Postgres just had its own built
>> in UUID generator?
>
> Why would it be? If you think you can easily improve on uuid-ossp,
> you should go help
>> I know I can setup a FK constraint to make sure Table1.ColA exists in
>> Table2.Key, however what if I want to do the reverse?
>>
>> I want to ensure Table1.ColA does NOT exist in Table2.Key.. Can I do
>> this with any sort of CHECK constraint, trigger, custom function, etc?
>
>
> The most comm
>> I know I can setup a FK constraint to make sure Table1.ColA exists in
>> Table2.Key, however what if I want to do the reverse?
>>
>> I want to ensure Table1.ColA does NOT exist in Table2.Key.. Can I do
>> this with any sort of CHECK constraint, trigger, custom function, etc?
>> Thanks!
>
>
> Pe
I know I can setup a FK constraint to make sure Table1.ColA exists in
Table2.Key, however what if I want to do the reverse?
I want to ensure Table1.ColA does NOT exist in Table2.Key.. Can I do
this with any sort of CHECK constraint, trigger, custom function, etc?
Than
;
tcp_keepalives_count = 5# TCP_KEEPCNT;
Hope this helps someone else!
On Sat, Oct 30, 2010 at 4:21 AM, Mike Christensen wrote:
> Maybe that's it.. It's definitely some sort of SSL thing since it
> didn't start happening until I enabled SSL. I guess I'll ju
> 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, basically no popup works. If I right click
> on the "Databases" branch an
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, basically no popup works. If I right click
on the "Databases" branch and select "New
I have a table that looks something like this:
url - character varying(1024)
date - timestamptz
body - text
Url is a unique primary key. Body can potentially be a couple hundred
k of text.
There will at first be perhaps 100,000 rows in this table, but at some
point it might get into the million
> On Sat, Sep 17, 2011 at 6:46 PM, Mike Christensen wrote:
>> I have a table that looks something like this:
>>
>> url - character varying(1024)
>> date - timestamptz
>> body - text
>>
>> Url is a unique primary key. Body can potentially be a cou
Here's my situation. I have a table with a bunch of URLs and crawl
dates associated with them. When my program processes a URL, I want
to INSERT a new row with a crawl date. If the URL already exists, I
want to update the crawl date to the current datetime. With MS SQL or
Oracle I'd probably us
So I used to think materialized views in Postgres would be an awesome
feature. That is until I had to endure the hell hole which is Oracle's
implementation.. what a complete joke.. did MS SQL's indexed views do any
better? Hopefully if PG 10 implements this, they'll make it actually useful
to p
e pg guys to do
materialized views right!
On Sep 21, 2011 1:54 PM, "Ben Chobot" wrote:
> On Sep 21, 2011, at 1:17 PM, Mike Christensen wrote:
>
>> So I used to think materialized views in Postgres would be an awesome
feature. That is until I had to endure the hell hole which is Orac
>> Hmm I think a materialized view you have to update yourself is called a
>> "table".. but after dealing with the nightmare that is Oracle 11g, I
>> think it'd be much more fun going that route with triggers and
>> everything. Yes this thread is a complete vent, and also a plea to the
>> pg guys
On Wed, Sep 21, 2011 at 11:34 PM, Craig Ringer wrote:
[snip]
> This can get complicated when you have triggers acting recursively on a
> table and it isn't always that easy to understand exactly what a trigger
> will see.
I do agree with most all your points. The value I got out of this
experien
> ~
> I have been searching for a PostgreSQL-derived project with a
> "less-is-best" Philosophy. Even though I have read about quite a bit
> of PG forks out there, what I have in mind is more like a baseline
> than a fork.
> ~
> My intention is not wrapping the same thing in a different package o
>> PgSQL has just one old NPGSQL driver for .NET, which is itself sluggish.
>> The ODBC driver works better as compared to NPGSQL, but I suspect the ODBC
>> driver is not the right choice for ORM framework of .NET.
>>
>> I want to know whether there is any efficient .NET provider and is PGSQL
>> co
>> I don't see the problem - you can have a dictionary, which does all work
>> on recognizing bare letters and output several versions. Have you seen
>> unaccent
>> dictionary ?
>
> This seems to be the direction that everyone is suggesting, and I'm quite
> grateful for that. (I really hadn't ever
1 - 100 of 289 matches
Mail list logo
