On 08/17/10 10:45 PM, Lord_Devi wrote:
Hello,
Here is the catch. The SQL database itself exists at a 'home office',
and these workers are wanting to be able to enter this data remotely; in
an 'offline mode' as it were. Because they are required to fill out
these forms away from the office,
On 8/18/10 7:42 AM, Vikram Patil wrote:
Joshua,
Thanks for reply. But I tried 8.4.4 and it still doesn't work with local
administrator account on windows 2003 . I don't want to create additional
"postgres" user to start service on windows rather I want to use my currently
logged in user
Hello,
I am new to the mailing list here, so I'd like to introduce myself
quickly. My name is Casey Quibell, and I am also rather new to the
concept of programming a database (Or in this case, more specifically
using an ODBC connector to tie OpenOffice into it.)
Just a bit of technical preamble
I'm getting infrequent backend crashes on a windows instance of PostgreSQL. The
error I get is in the log below. It seems to relate to the share memory each
time. Does anyone have any ideas what the problem is here, or what additional
things I can do to get more information out next time the ba
Joshua,
Thanks for reply. But I tried 8.4.4 and it still doesn't work with local
administrator account on windows 2003 . I don't want to create additional
"postgres" user to start service on windows rather I want to use my currently
logged in user. User can be administrator or non-administ
On 08/17/10 12:19 PM, Lazaro Ruben Garcia Martinez wrote:
Hello:
I have two servers and I want create a database cluster in a SAN
(storage area network), can any send my any link or any web site in
that I can read and study about it.
"Cluster" means different things to different people and/
Lazaro Ruben Garcia Martinez wrote:
I have two servers and I want create a database cluster in a SAN
(storage area network), can any send my any link or any web site in
that I can read and study about it.
This is turning into something that needs more of a detailed FAQ than
the ones already a
Hello:
I have two servers and I want create a database cluster in a SAN (storage area
network), can any send my any link or any web site in that I can read and study
about it.
Thank you very much for your time.
I'm trying to compile libpq from the 8.4.4 source to use the static
runtime (/MT) with VS 2005, but it fails on dosmaperr being redefined in
win32error.c
Here is the error message.
LIBCMT.lib(dosmap.obj) : error LNK2005: __dosmaperr already defined in
libpq.lib(win32error.obj)
fatal error
On 17 Aug 2010, at 18:28, Chris Barnes wrote:
> psql database -t -c "select ||'select count (*) from
> '||schemaname||'.'||relname from pg_stat_user_tables where relname like
> 'table_%'"|more
> ERROR: operator does not exist: || unknown
> LINE 1: select ||'select count (*) from '||schemaname|
I have a (stupid) question regarding using concatenation operator.
I would like to get the list of tables from the database and output the select
count(*) for each of them
I don't want the schema name proceeding the select, how can I omit without
receiving the error below.
psql eventdb0
On 17 August 2010 16:00, Thom Brown wrote:
> On 17 August 2010 13:45, Thom Brown wrote:
>> On 17 August 2010 04:05, Tom Lane wrote:
>>> Andy writes:
Your results of 867MB for Postgresql & 3,576 MB for InnoDB are surprising.
Do you know why it is so much smaller for Postgresql? Are th
>
> All that stuff is buried in the "query" option. You can do something
> like
>
> INSERT INTO table SELECT ... WHERE ...
>
> so the full power of SELECT is available already.
>
> regards, tom lane
>
Thank you Michael, Tom; I must have missed the nonterminal symbol
On 17 August 2010 13:45, Thom Brown wrote:
> On 17 August 2010 04:05, Tom Lane wrote:
>> Andy writes:
>>> Your results of 867MB for Postgresql & 3,576 MB for InnoDB are surprising.
>>> Do you know why it is so much smaller for Postgresql? Are there any indexes?
>>
>> If I understood the origina
Maurice Gittens writes:
> The syntax includes a where clause allowing qualified declarative
> control over what is deleted.
> Why would the same not hold for the insert statement?
All that stuff is buried in the "query" option. You can do something
like
INSERT INTO table SELECT ... WHE
On Aug 17, 2010, at 4:32 , Maurice Gittens wrote:
> More specifically; the INSERT statement is currently defined as:
>
> INSERT INTO table [ ( column [, ...] ) ]
>{ DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [,
> ...] | query }
^
INSERT INTO table [ ( column [,
Hi,
the postgresql 8.4 documentation defines the syntax of the DELETE statement as:
DELETE FROM [ ONLY ] table [ [ AS ] alias ]
[ USING usinglist ]
[ WHERE condition | WHERE CURRENT OF cursor_name ]
[ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]
The syntax include
On Tue, Aug 17, 2010 at 11:02:20AM +0700, tuanhoanganh wrote:
> On Sat, Aug 14, 2010 at 10:00 AM, tuanhoanganh wrote:
> > The process cannot access the file because it is being used by another
> > process.
> > C:\...\8.3\pg_xlog\00010007001B
Exclude pg_log from the backup or rm that f
On 17 August 2010 04:05, Tom Lane wrote:
> Andy writes:
>> Your results of 867MB for Postgresql & 3,576 MB for InnoDB are surprising.
>> Do you know why it is so much smaller for Postgresql? Are there any indexes?
>
> If I understood the original report correctly, they were complaining
> mostly
Alvaro Herrera írta:
> Excerpts from Boszormenyi Zoltan's message of lun ago 16 14:45:07 -0400 2010:
>
>> Matthew Wilson írta:
>>
>
>
>>> I don't care if the code is rearranged so that c is replaced with an
>>> inline definition during compilation. I'm not concerned about
>>> efficiency
On Tue, Aug 17, 2010 at 4:15 AM, Philippe Lang
wrote:
>> Hi,
>>
>> I have a non-reentrant plperlu function, which does no database
>> modification. It basically stores input data into a file, calls a unix
>> shell command, and reads the result back from another file.
>>
>> I don't really care abou
Hi VBI,
DBLINK was a great idea. I have written the code to do that and it works
perfectly.
Regards,
Atul Goel
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian von Bidder
Sent: 16 August 2010 12:27
To: pgsql-ge
Thanks Alban,
I was able to do this using DBLINK. Thanks a lot for your help.
Regards,
Atul Goel
-Original Message-
From: Alban Hertroys [mailto:dal...@solfertje.student.utwente.nl]
Sent: 16 August 2010 18:07
To: Atul Goel
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] good exce
> Hi,
>
> I have a non-reentrant plperlu function, which does no database
> modification. It basically stores input data into a file, calls a unix
> shell command, and reads the result back from another file.
>
> I don't really care about database isolation here, phantom reads and
> such. It is n
Hi,
I have a non-reentrant plperlu function, which does no database modification.
It basically stores input data into a file, calls a unix shell command, and
reads the result back from another file.
I don't really care about database isolation here, phantom reads and such. It
is not likely to
25 matches
Mail list logo
