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
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
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
; 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
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
> 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
.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
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
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
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
> 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
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
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
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.
>>>
>>&
#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&
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
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
.
>
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
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
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
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
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
22 matches
Mail list logo
