Shelby Cain wrote on 08.09.2007 20:57:
Compared to that, I don't really understand follow your argument as to why
installing Postgresql as a service and stopping/starting it through the
service control panel such a big deal.
Or stopping/starting using a batch file (with "net start pgsql")
Thom
2007/9/9, novice <[EMAIL PROTECTED]>:
> > > > The result I'm expecting for the above to be
> > > >
> > > >notification_time| finished_time | actual
> > > > ++-
> > > > 2007-07-06 15:50:00+10 | 2007-07-09 07:10:00+
Merlin,
Its just about three columns - not any column. Two columns are
varchars and the third is
a date. The date column value is NULL for the rows for which
I want to delete the duplicates.
Yes, please, be a bit more specific!
/regards, Håkan Jacobsson
>Ursprungligt meddelande
>Frå
On 9/9/07, Håkan Jacobsson <[EMAIL PROTECTED]> wrote:
> Merlin,
>
> Its just about three columns - not any column. Two columns are
> varchars and the third is
> a date. The date column value is NULL for the rows for which
> I want to delete the duplicates.
getting ready to go on vacation :). Th
Benjamin Arai <[EMAIL PROTECTED]> writes:
> Is there a way to pass a query to PostgreSQL to check if the
> TSeasrch2 search text is valid? For example,
> SELECT to_tsquery('default', '!');
> returns an error. I want to know if there is a way get true/false
> for the '!' portion of the query?
OK, this has been very informative and I'd like to thank the three of you.
Asynchronous replication to readonly slaves is something I will look into.
I've never touched posgtres replication; and Scott mentioned that he was not
familiar with PGCluster, so there must be some other replication syst
Gregory Stark wrote:
Christian Schröder <[EMAIL PROTECTED]> writes:
...
-> Seq Scan on table2 (cost=0.00..186.64 rows=2 width=4) (actual time=0.052..2.259 rows=42 loops=1)
Filter: (c ~~ '1131%'::text)
...
-> Seq Scan on table2 (cost=0.00..200.89 rows
On 9/8/07, Robert Fitzpatrick <[EMAIL PROTECTED]> wrote:
>
> I have a trigger function that I want to apply to several tables, hence
> my use of TG_RELNAME. I just want the record to get inserted if an
> UPDATE comes from my view rule if the record for the client doesn't
> already exist. This is wh
Thanx Merlin, have a nice one (vacation)!
It turns out I have'nt described the problem accurately=(
Data may actually differ in two of the columns (the varchar
columns).
I still want to remove rows which share the same data in those
two columns and have the date column
set to NULL.
I.e. row 1,2,
Run it as a service. This is the best way.
--
___
Andrew J. P. Maclean
Centre for Autonomous Systems
The Rose Street Building J04
The University of Sydney 2006 NSW
AUSTRALIA
Ph: +61 2 9351 3283
Fax: +61 2 9351 7474
URL: http://www.acfr.usyd.edu.au/
__
Håkan Jacobsson wrote:
Thanx Merlin, have a nice one (vacation)!
It turns out I have'nt described the problem accurately=(
Data may actually differ in two of the columns (the varchar
columns).
I still want to remove rows which share the same data in those
two columns and have the date column
Time zones are a new issue for me. I have read around a bit and learned some.
I have a bunch of questions still because I've not found a really good
overview of how all of the factors tie in together.
At this time my app will be hosted on a server at a single location. Users
will be updating and
novnov <[EMAIL PROTECTED]> writes:
> At this time my app will be hosted on a server at a single location. Users
> will be updating and viewing from various time zones. I would like to
> present the datetime of the last update to each user according to the time
> zone that they've entered into their
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/09/07 22:29, novnov wrote:
[snip]
>
> But it doesn't particularly make sense to set the server's clock to UTC.
> It'd seem to skew a lot of server functionality which I'd think should
> normally be geared around local time. So I'd guess that the
Ok, this appears to have worked but I have to check for exception
code "OTHERS" because I could not figure out what the actual code
being thrown was. Is there a specific exception code for:
ERROR: no operand in tsearch query: "("
Thanks for the help!
Benjamin
On Sep 9, 2007, at 7:54 AM,
On Sat, 08 Sep 2007 19:28:52 +0400, Scott Marlowe
<[EMAIL PROTECTED]> wrote:
On 9/7/07, Max Zorloff <[EMAIL PROTECTED]> wrote:
On Fri, 07 Sep 2007 10:58:36 +0400, Marko Kreen <[EMAIL PROTECTED]>
wrote:
>> The pgpool (I tried 3.1, 3.4 and pgpool-II 1.2) works fine but has
the
>> followin
16 matches
Mail list logo
