Hi,
We are using PostgreSQL Database for our Desktop application using
VB.Net. It works well. Now we are going to develop online application. We
are new to online application. So please guide me, What should do to
implement online postgresql database?
Can we use VPS to create online databse? o
hi i am a newbie to sql statments , I am running postgres 8.1 with
application called opennms version 1.8.5 due to an application bug
queries that I execute aginst the DB which returns raw-count=0 are being
ignored and will not process a certain trigger I need to process.
My question is : Can I
lookup CASE WHEN END in docs.
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I would like to use copy to populate a single row in table with data
from a tsv file for further transformations.
I seem not find a way to stop copy from seeing that the tsv file does
indeed contain fields.
This my current query
COPY raw_data
(
raw_r
On 07/12/2010 11:07, Allan Kamau wrote:
I would like to use copy to populate a single row in table with data
from a tsv file for further transformations.
I seem not find a way to stop copy from seeing that the tsv file does
indeed contain fields.
This my current query
COPY raw_da
Le mardi 07 décembre 2010 à 13:42 +0530, Kalai R a écrit :
> So please guide me, What should do to implement online postgresql
> database?
You need a web server to generate and process html forms that display
the data. One is Apache, with the right module to process your forms'
data. In your cas
On Tue, Dec 7, 2010 at 2:14 PM, Raymond O'Donnell wrote:
> On 07/12/2010 11:07, Allan Kamau wrote:
>>
>> I would like to use copy to populate a single row in table with data
>> from a tsv file for further transformations.
>> I seem not find a way to stop copy from seeing that the tsv file does
>>
Le lundi 06 décembre 2010 à 18:27 -0600, Sairam Krishnamurthy a écrit :
You should start a new thread for this
> Is there a way to call a rule when I use "COPY FROM" instead of
> "INSERT INTO"
>
from the doc :
COPY FROM will invoke any triggers and check constraints on the
destination table.
Tom Lane wrote:
> Taken at face value from a Postgres perspective, these statements seem
> to imply that different ownership and permissions apply to a synonym
> than to its referenced object; which seems like a completely horrid idea
> from a security standpoint. But maybe they are only
Hey Daniel,
Again link to oracle.com...
During this thread I believe that synonyms gives nothing
except confusion and mess.
2010/12/7 Daniel Verite
>Tom Lane wrote:
>
> > Taken at face value from a Postgres perspective, these statements seem
> > to imply that different ownership and pe
On Mon, Dec 6, 2010 at 2:31 PM, Joshua D. Drake wrote:
> Command Prompt is currently considering writing a patch to provide
> synonyms to PostgreSQL. Is this something the community is interested
> in? Do we have use cases for it? MSSQL, DB2 and Oracle support them.
>
I must be missing something,
On Mon, Dec 6, 2010 at 4:38 PM, Tom Lane wrote:
> [ shrug... ] Beauty is in the eye of the beholder, I guess. To me the
> search_path change seems like the natural way to do that, and flipping a
> mess of synonyms the hack. What happens when you miss one synonym?
>
That's exactly what I thought
Hi, everyone. I'm working on a project that is using 8.3.0; among other
things, I'm helping them to move to 9.0. The project is running on
Windows XP.
Someone from this project asked me earlier today why a particular
database restore was taking a long time. How long? Well, it has been
ru
Vick Khera wrote:
> On Mon, Dec 6, 2010 at 2:31 PM, Joshua D. Drake
> wrote:
> > Command Prompt is currently considering writing a patch to provide
> > synonyms to PostgreSQL. Is this something the community is interested
> > in? Do we have use cases for it? MSSQL, DB2 and Oracle support
I won't press the issue for Postgres any further, but I will attest that
synonyms work quite elegantly in Oracle, provide valuable functionality,
and do not generally sow confusion among skilled developers. It sounds
like the proposed "synonym" feature for Postgres perhaps had a different
inte
Ack, I misspoke in my example last night about our use-case for
synonyms: we would ust them for trans-*schema* object referencing, not
trans-*database*.
Sorry about that--I fear that may have caused more confusion than necessary.
/m
--
Sent via pgsql-general mailing list (pgsql-general@post
hi thanks for the reply I did look at the CASE statement however cannot seem
to alter the returned row-count ...
CASE WHEN (@@ROW-COUNT = 0) THEN
[what do I write here?] @@ROW-COUNT = 1?
END
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/if-clause-to-an-ex
Hi,
I want to understand why one of my postgresql functions takes an eternity to
finish.
Here's an example:
UPDATE comptes SET belongs_to_compte_id=42009 WHERE (codi_compte LIKE '1%'
AND empresa_id=2 AND nivell=11); // takes forever to finish
QUERY PLAN
Quoting Raimon Fernandez :
I want to understand why one of my postgresql functions takes an
eternity to finish.
Here's an example:
UPDATE comptes SET belongs_to_compte_id=42009 WHERE (codi_compte LIKE
'1%' AND empresa_id=2 AND nivell=11); // takes forever to finish
[...]
but the same S
Hello All,
I am working with a postgresql database that has two columns.
One for an ip address and another for the netmask. Both of these
columns are char varying(30). I would like to convert to just
one column as inet. Any one know a slick way to convert the
dotted quad netmask, E.G. 255.255.128
On 12/7/2010 8:12 AM, Daniel Verite wrote:
Vick Khera wrote:
On Mon, Dec 6, 2010 at 2:31 PM, Joshua D. Drake
wrote:
Command Prompt is currently considering writing a patch to provide
synonyms to PostgreSQL. Is this something the community is interested
in? Do we have use cases for it?
Hi gurus,
When I try to
pg_restore -d teste -v -j 16 < teste.dmp 2>> teste.log &
I give error:
pg_restore: opção inválida -- j
Tente "pg_restore --help" para obter mais informação.
How can using parallel resource in new postgres?
Regards
Paulo
Hi:
8.3.4 on linux
This query fails with this message...
mydb=# select distinct fivr from alphaview where name ~ ''^foo'';
ERROR: type "foo" does not exist
(note: those are two single quotes before the ^ and after foo, NOT double
quotes)
Could someone explain the error message?
Thanks in Adva
2010/12/7 Andy Colson
> On 12/7/2010 8:12 AM, Daniel Verite wrote:
>
>>Vick Khera wrote:
>>
>> On Mon, Dec 6, 2010 at 2:31 PM, Joshua D. Drake
>>> wrote:
>>>
Command Prompt is currently considering writing a patch to provide
synonyms to PostgreSQL. Is this something the communi
On Tuesday 07 December 2010 3:58:46 am kobi.biton wrote:
> hi thanks for the reply I did look at the CASE statement however cannot
> seem to alter the returned row-count ...
>
> CASE WHEN (@@ROW-COUNT = 0) THEN
>
> [what do I write here?] @@ROW-COUNT = 1?
>
> END
> --
> View this message
"Gauthier, Dave" writes:
> mydb=# select distinct fivr from alphaview where name ~ ''^foo'';
> ERROR: type "foo" does not exist
> (note: those are two single quotes before the ^ and after foo, NOT double
> quotes)
You realize of course that you've got too many quotes there.
> Could someone exp
On Tue, Dec 7, 2010 at 9:17 AM, Steve Clark wrote:
> Hello All,
>
> I am working with a postgresql database that has two columns.
> One for an ip address and another for the netmask. Both of these
> columns are char varying(30). I would like to convert to just
> one column as inet. Any one know a
Yes, someone is using too many quotes, I think in a script because the log file
gets bursts of these messages. I need to foind out who's doing this. I know
pg_stat_activity is the key in that endevour, but these are remote db queries,
so I have to figure out how to deal with that indirection.
On 12/07/2010 10:30 AM, Jon Nelson wrote:
On Tue, Dec 7, 2010 at 9:17 AM, Steve Clark wrote:
Hello All,
I am working with a postgresql database that has two columns.
One for an ip address and another for the netmask. Both of these
columns are char varying(30). I would like to convert to ju
Hi everyone,
I am very pleased to see the addition of the pg_last_xact_replay_timestamp
function in Postgresql 9.1 since this, in combination with hot standby and WAL
log streaming, will seriously boost the performance of our postgresql database
cluster. pg_last_xact_replay_timestamp is importa
Steve Clark writes:
> Thanks for the response Jon. I should have stated this PG 8.1.x and '&'
> doesn't exist for network functions.
I don't think & does what you want anyway. It just does a bit AND on
the two addresses, it doesn't change the masklen property.
There's probably only a small num
On Dec 7, 2010, at 4:58 AM, kobi.biton wrote:
>
> hi thanks for the reply I did look at the CASE statement however cannot seem
> to alter the returned row-count ...
Well, yeah. The row count is the count of rows returned. If there are no rows
matched by the query, then what exactly do you expect
On tis, 2010-12-07 at 11:49 +0800, Craig Ringer wrote:
> This is driving me nuts when working with PgJDBC via various ORM
> layers (I know, I know, but they're life at this point) that would
> work happily with these types if they were implicitly castable to/from
> strings, but don't understand how
Hi,
as the Subject says i want pgpool to talk only to my slony slaves.
In my company we have a Slony Setup with 1 master replicating to 2
slaves. Our application only does read queries (never ever writes) to
the 2 slaves through pgpool. While upgrading to pgpool 3.0.1 (from
2.2.5) i detected t
On 12/07/2010 11:43 AM, Tom Lane wrote:
Steve Clark writes:
Thanks for the response Jon. I should have stated this PG 8.1.x and '&'
doesn't exist for network functions.
I don't think& does what you want anyway. It just does a bit AND on
the two addresses, it doesn't change the mask
On Dec 7, 2010, at 9:58 AM, Kobi Biton wrote:
>
> I know it does not sound logic however I do need to set the row count
> to 1 in case row count returns 0
Perhaps I didn't make myself clear: you can't do that. The only thing you can
do is make sure your query returns a row, and in the case where
paulo matadr wrote:
> When I try to
> pg_restore -d teste -v -j 16 < teste.dmp 2>> teste.log &
>
> I give error
What do you get from?:
pg_restore --version
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.p
On 7 Dec 2010, at 14:51, Reuven M. Lerner wrote:
> My guess is pg_dump in 8.3 is somehow causing a problem in the dumpfile on or
> around that large object.
Which version of pg_dump did you use? The one that came with the 9.0 install or
the one from the old 8.3 one? It should have been the first
as we get more and more questions from users of their software, maybe it
would be helpfull for both sides if they decide to get more involved within
the PostgreSQL community.
Harald
--
GHUM GmbH
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
Amtsgericht Stuttgart, HRB 7
On 12/07/2010 08:04 AM, Kobi Biton wrote:
Adrian hi,
Thanks for the reply can you please show me how to incorporate the below
into my below statement ?
SELECT a.eventuei AS _eventuei,
a.nodeid AS _nodeid,
a.ipaddr AS _ipaddr,
now()
On Tue, 2010-12-07 at 08:31 -0500, Vick Khera wrote:
> On Mon, Dec 6, 2010 at 2:31 PM, Joshua D. Drake
> wrote:
> > Command Prompt is currently considering writing a patch to provide
> > synonyms to PostgreSQL. Is this something the community is interested
> > in? Do we have use cases for it? MSS
On Tue, 2010-12-07 at 09:14 -0500, Michael C Rosenstein wrote:
> I won't press the issue for Postgres any further, but I will attest that
> synonyms work quite elegantly in Oracle, provide valuable functionality,
> and do not generally sow confusion among skilled developers. It sounds
> like th
Hi List,
What is the best tool of data modeling and ER diagram for PostgreSQL.
--
Thanks & Regards
DJ
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material.
Any review, re-transmission, dissemi
Hey Jaiswal,
"Best" is relative word. It is matter of taste. I recommend dbWrench.
http://www.dbwrench.com/
2010/12/7 Jaiswal Dhaval Sudhirkumar
>
> Hi List,
>
> What is the best tool of data modeling and ER diagram for PostgreSQL.
>
>
> --
> Thanks & Regards
> DJ
>
>
> The information transmi
On Dec 7, 2010, at 10:39 AM, Jaiswal Dhaval Sudhirkumar wrote:
> Hi List,
>
> What is the best tool of data modeling and ER diagram for PostgreSQL.
>
http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools
Hello
2010/12/7 Joshua D. Drake :
> On Tue, 2010-12-07 at 09:14 -0500, Michael C Rosenstein wrote:
>> I won't press the issue for Postgres any further, but I will attest that
>> synonyms work quite elegantly in Oracle, provide valuable functionality,
>> and do not generally sow confusion among ski
"Joshua D. Drake" writes:
> On Tue, 2010-12-07 at 08:31 -0500, Vick Khera wrote:
>> I must be missing something, but really, what's the point of synonyms?
>> What's the real-world use case for them?
> For a PostgreSQL Person? I see no real benefit to be honest. For people
> coming from Oracle, DB
> What is the best tool of data modeling and ER diagram for PostgreSQL.
> http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools
Although it may not be considered a tool for use in the design (per
se) of a database, I would highly recommend that SchemaSpy
(http://schemaspy.sourceforge.net/) be
On 12/07/2010 10:45 AM, Joshua D. Drake wrote:
On Tue, 2010-12-07 at 08:31 -0500, Vick Khera wrote:
On Mon, Dec 6, 2010 at 2:31 PM, Joshua D. Drake wrote:
Command Prompt is currently considering writing a patch to provide
synonyms to PostgreSQL. Is this something the community is interested
in
On 7 Dec 2010, at 15:45, Michał Roszka wrote:
>> but the same SELECT count, it's immediate:
>>
>> SELECT count(id) FROM comptes WHERE codi_compte LIKE '1%' AND
>> empresa_id=2 AND nivell=11;
>
> Maybe there is any check or constraint on belongs_to_compte_id.comptes that
> might take longer?
I know it does not make sens "application bug" however consider the
following scenarion , looking at the Statement I sent I would like to
check if over the last 10 minutes a certain type of event was logged and
if NOT (row-count=0) then I would like to trigger and action.
hope it makes more sense.
Scott hi,
I know it does not sound logic however I do need to set the row count
to 1 in case row count returns 0 , can you show how to add that case
clause and dummy line in my below code ?
SELECT a.eventuei AS _eventuei,
a.nodeid AS _nodeid,
a.ipaddr AS _ipaddr,
Adrian hi,
Thanks for the reply can you please show me how to incorporate the below
into my below statement ?
SELECT a.eventuei AS _eventuei,
a.nodeid AS _nodeid,
a.ipaddr AS _ipaddr,
now() AS _ts
FROM events a
=?utf-8?b?TWljaGHFgg==?= Roszka writes:
> Quoting Raimon Fernandez :
>> I want to understand why one of my postgresql functions takes an
>> eternity to finish.
> Maybe there is any check or constraint on belongs_to_compte_id.comptes that
> might take longer?
Or maybe the UPDATE is blocked on a l
On 7dic, 2010, at 15:45 , Michał Roszka wrote:
> Quoting Raimon Fernandez :
>
>> I want to understand why one of my postgresql functions takes an
>> eternity to finish.
>>
>> Here's an example:
>>
>> UPDATE comptes SET belongs_to_compte_id=42009 WHERE (codi_compte LIKE
>> '1%' AND empresa_
On 12/7/2010 1:07 PM, Adrian Klaver wrote:
On 12/07/2010 10:45 AM, Joshua D. Drake wrote:
On Tue, 2010-12-07 at 08:31 -0500, Vick Khera wrote:
On Mon, Dec 6, 2010 at 2:31 PM, Joshua D. Drake
wrote:
Command Prompt is currently considering writing a patch to provide
synonyms to PostgreSQL. Is th
"Reuven M. Lerner" writes:
> Using the Windows process monitor, we saw that pg_restore was using
> about 50 percent of the CPU, doing an enormous (about 60 billion, by
> this point) reads from the disk, but zero writes. The dumpfile does
> contain a number of large (binary) objects, as well as
On Tue, 2010-12-07 at 19:54 +0100, Pavel Stehule wrote:
> Hello
>
> 2010/12/7 Joshua D. Drake :
> > On Tue, 2010-12-07 at 09:14 -0500, Michael C Rosenstein wrote:
> >> I won't press the issue for Postgres any further, but I will attest that
> >> synonyms work quite elegantly in Oracle, provide val
On Tue, Dec 7, 2010 at 1:54 PM, Pavel Stehule wrote:
> Hello
>
> 2010/12/7 Joshua D. Drake :
> > Your perception has been mirrored on the Oracle free list. Really what
> > PostgreSQL people need to come to grips with is whether or not we want
> > to make it easier for others to port to Pg or not.
gwch...@gmail.com (Gary Chambers) writes:
>> What is the best tool of data modeling and ER diagram for PostgreSQL.
>> http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools
>
> Although it may not be considered a tool for use in the design (per
> se) of a database, I would highly recommend that
Hi, everyone. Alban wrote:
Which version of pg_dump did you use? The one that came with the 9.0 install or
the one from the old 8.3 one? It should have been the first of these two.
The dump was done by someone using the old, existing system, which runs
under 8.3. She complained that she was h
"Reuven M. Lerner" writes:
> Hi, everyone. Alban wrote:
>> Which version of pg_dump did you use? The one that came with the 9.0 install
>> or the one from the old 8.3 one? It should have been the first of these two.
> The dump was done by someone using the old, existing system, which runs
> un
I received absolutely no reply to my question on the CentOS mailing
list so I have to turn to this venue again for help.
I note the following things:
postgresql-server.i386 8.4.4-2PGDG.el5
installed
openssl.i686 0.9.8e-12.el5_4.6
On Tue, 2010-12-07 at 16:54 -0500, James B. Byrne wrote:
> I received absolutely no reply to my question on the CentOS mailing
> list so I have to turn to this venue again for help.
>
> I note the following things:
>
> postgresql-server.i386 8.4.4-2PGDG.el5
> insta
On Tue, December 7, 2010 16:56, Joshua D. Drake wrote:
>
> No those lib differences are both still 32bit. You would have a
> problem if one was 64bit. So you should be fine there.
>
> Joshua D. Drake
>
Ok. How do I get postgresql to cough up more processing detail on
startup? The message that
"James B. Byrne" writes:
> Ok. How do I get postgresql to cough up more processing detail on
> startup? The message that I presently get makes no sense at all to
> me.
The message isn't coming from postgres --- it's openssl that you're
wishing would be more verbose.
What I'd try next is strace
Hi,
I am using pg_standby in the recovery_command of recover.conf, and with the
d option I am getting an entry every few seconds when it checks for the
trigger and WAL files.
If I leave out the d option, I seem to get nothing. What messages should I
see without the d option? ( I want to try
Hi -
I have searched the lists for comments about using PG with EFS and/or
TrueCrypt in order to encrypt the entire database transparently. I found a
few posts making reference to this possibility so I have tried them both,
but I didn't get either to work.
I have PG-8.3 running on Windows server
Hi Everyone,
What does PG do with data that has been inserted into a table, but was
never committed? Does the data get discarded once the connection dies?
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.o
On Tue, Dec 07, 2010 at 05:15:45PM -0500, James B. Byrne wrote:
>
> On Tue, December 7, 2010 16:56, Joshua D. Drake wrote:
>
> >
> > No those lib differences are both still 32bit. You would have a
> > problem if one was 64bit. So you should be fine there.
> >
> > Joshua D. Drake
> >
>
> Ok. How
On Wed, 2010-12-08 at 00:56 +, Jonathan Tripathy wrote:
> Hi Everyone,
>
> What does PG do with data that has been inserted into a table, but was
> never committed? Does the data get discarded once the connection dies?
Yes, the transaction will rollback.
>
> Thanks
>
--
PostgreSQL.org
I'm creating a data queue on top of postgres and I'm wondering if I've made
an incorrect assumption about isolation or synchronization or some similar
issue.
Every item in the queue is given a unique ID from a sequence.
CREATE TABLE data_queue
(
sequence_num BIGINT PRIMARY KEY,
sender_key B
I have now tracked down and resolved the problem. There were clues
to the solution in the error message but I lacked sufficient
experience with ssl to realize it. The error was an uncommented
line in /etc/pki/tls/openssl.cnf that depended upon an environment
variable (ALTNAME) being set (subjec
I could not get the service to start on my business Windows XP laptop
where I am not an administrator. I had been running it and then it
would not start. I don't know if a corporate download changed
something or what.
I kept getting a message from AdminIII that the server was not
listening.
Aft
On Wed, Dec 8, 2010 at 1:31 AM, Gabi Julien wrote:
> pg_last_xact_replay_timestamp() returns null when the server is restarted
> until a new transaction is streamed to the hot standby server. It might take
> a long time before this happens. Because of this, we can't rely this function
> complet
Hello all,
I'm creating a data queue on top of postgres and I'm wondering if I've made
an incorrect assumption about isolation or synchronization or some similar
issue.
Every item in the queue is given a unique ID from a sequence.
CREATE TABLE data_queue
(
sequence_num BIGINT PRIMARY KEY,
On 12/07/10 6:04 PM, bubba postgres wrote:
Hello all,
I'm creating a data queue on top of postgres and I'm wondering if I've
made an incorrect assumption about isolation or synchronization or
some similar issue.
Every item in the queue is given a unique ID from a sequence.
CREATE TABLE data
77 matches
Mail list logo
