isco group
where the last update/meeting was 2 years ago. Is there such a group in this
area? Thanks.
--
Rick Genter
rick.gen...@gmail.com
Does ‘minute from interval’ only accept string literals?
>
>
>
> Thanks,
>
> Adam
>
>
>
> Adam Bruss
>
> Development Engineer
>
> AWR Corporation/Simulation Technology & Applied Research
>
> 11520 N. Port Washington Rd., Suite 201
>
> Mequon, WI 5
On May 2, 2011, at 10:52 PM, Craig Ringer wrote:
> SSN? What if they don't live in the US or aren't a citizen?
Non-citizens can have SSNs (they have to if they work in the US).
--
Rick Genter
rick.gen...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
u can't update achievement_attempt_id in
the achievement_attempt table if there is an achievement_attempt_actions
record that refers to it since that would break the reference. (Not that you
want to be updating primary key values in the first place...)
--
Rick Genter
rick.gen...@gmail.com
.
>
So your data is denormalized? (The "category" appears in 2 tables?) Don't do
that. Create a view that joins your two tables together instead if you need
a single entity that contains data from multiple sources. Then you won't
have any of the data integrity issues you
sers EXECUTE access to the functions. The functions run
as the user that created them, so they will have direct INSERT/UPDATE/DELETE
access to the tables while your regular users won't.
--
Rick Genter
rick.gen...@gmail.com
lieve that this accomplishes the goal (increasing available drive space)
with a minimum amount of down time. Am I thinking correctly, or have I
missed something?
--
Rick Genter
rick.gen...@gmail.com
#x27;s not the OLTP just a simple OLAP
> where data is fetched and stored in some meaningful format.
>
>
> What are benefits & why we used memcahed?
>
> What are the bottlenecks to meet?
You need to read about memcached. Memcached is not something you "enable&
On May 16, 2011, at 10:31 PM, Adarsh Sharma wrote:
> Rick Genter wrote:
>>
>> On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
>>
>>
>>> Dear all,
>>>
>>> I need to research on Memcache in the next few days.
>>>
>>&
ate for a "hacker list".
--
Rick Genter
rick.gen...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you can add 360 degrees to a long and get a value that should continue to
work. So, assuming "West" is negative, -175 (175 degrees West) is the same
as -175+360 = 185 (185 degrees East). Then you don't have to worry about
wraparound. If the result is > 180, subtract 360.
--
Rick Genter
rick.gen...@gmail.com
> any difference. If
> I leave out the old alias, it complains about the columns being ambiguous.
> How should the query above be changed to be syntactically correct?
>
> Thanks,
> Andy
>
--
Rick Genter
rick.gen...@gmail.com
is should return a recordset where each row has one column which is the
result of regex_replace() on the corresponding row of table.
--
Rick Genter
rick.gen...@gmail.com
clear.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Rick Genter
rick.gen...@gmail.com
a pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>
--
Rick Genter
rick.gen...@gmail.com
.4. The semicolon is required.
On Tue, Jun 28, 2011 at 3:53 PM, Rich Shepard wrote:
> On Tue, 28 Jun 2011, Rick Genter wrote:
>
> Silly question, but did you try it with a semicolon after the drop table?
>>
>
> Rick,
>
> See my answer to Andy: that's incorrect sy
> Can anyone suggest a way forward?
>
>From the message I'd say that the drupal user doesn't have access to the
sequence, which is a separate object from the table.
--
Rick Genter
rick.gen...@gmail.com
al, so I don't know the correct way to fix this. My
guess is that something wasn't installed/configured correctly.
--
Rick Genter
rick.gen...@gmail.com
; there are in the other tables.
>
> I am a bit perplexed by what is happening here.
>
> Cheers
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Rick Genter
rick.gen...@gmail.com
l.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Rick Genter
rick.gen...@gmail.com
mid. (And for 9.2, as I
understand it, q.mid as well, since I believe in 9.2 PostgreSQL will be able to
compute the result strictly from the indexes without hitting the base tables.)
--
Rick Genter
rick.gen...@gmail.com
of this set"). It seems odd that this should work:
-- drop unique index
-- single update statement
-- apply unique index
But just "single update statement" won't.
--
Rick Genter
rick.gen...@gmail.com
22 matches
Mail list logo
