I have posted this before without receiving replies
My code is as follows:
Public dbRemote As New Connection
Public rsData As New Recordset
dbRemote.Properties("Data Source").Value = "DSM"
dbRemote.Properties("Initial Catalog").Value = "BCM_DSM"
dbRemote.Properties("User ID").Value = "johan"
db
hai
have to solve one problem
i have two mechine in diffrent network range , one is main database server(n/w is 10.1.2.0) and other is back bone server(n/w 10.1.7.0)
i need to take pg_dump from back bone server .
what configuration needed in pg_hba.conf
thx
""Relyea, Mike"" <[EMAIL PROTECTED]> wrote
> I've just started receiving an out of memory error with my most complex
> query.
Can you post the memory usage log after the error the server reports?
Regards,
Qingqing
---(end of broadcast)---
TIP 6:
hi everybody.
i am writing stored procedures.
lots of them have out parameters.
i dont know how to test them
from an sql query tool(ex: pgAdmin query tool).
i am trying to test them from my program, but it is not so efficient.
i want to test from a query tool.
i can do with procedures withou
On Jun 14, 2006, at 6:29 PM, Chris Hoover wrote:
How do you set it up to search for "how now brown cow" vs how now
brown cow? The first example is looking for the exact phrase of
words, while the second is just looking for all of the works.
Your select would have two conditions, one to fi
On Wed, Jun 14, 2006 at 10:53:36AM +0200, Daniel McBrearty wrote:
> Hi all,
>
> I have a table "phrases" that looks like this :
>
> create table phrases(
> id serial ,
> language integer references langauges(id),
> content text
> );
Might want to avoid bareword 'id' as a field name... it's a gr
You can use ALTER DATABASE.
Argh! I somehow missed that despite reading the Run-time Configuration
section three times ... Thanks, folks!
- John D. Burger
MITRE
---(end of broadcast)---
TIP 6: explain analyze is your friend
kleptog@svana.org (Martijn van Oosterhout) writes:
> On Tue, Jun 13, 2006 at 05:23:56PM -0400, Christopher Browne wrote:
>> > [3]
>> > http://www.intelligententerprise.com/010327/celko_online.jhtml;jsessionid=NDIHEWXGL4TNKQSNDBNSKHSCJUMEKJVN
>>
>> The sample problem in [3] is one that shows pret
"John D. Burger" <[EMAIL PROTECTED]> writes:
> Is there any way to set DEFAULT_STATISTICS_TARGET on a permanent basis
> for a particular database? SET DEFAULT_STATISTICS_TARGET is only per
> session, apparently, and I'm not sure I want to set it for the whole
> cluster in the config file. I kn
On Wed, Jun 14, 2006 at 06:21:35PM -0400, John D. Burger wrote:
> Is there any way to set DEFAULT_STATISTICS_TARGET on a permanent basis
> for a particular database?
You can use ALTER DATABASE. New sessions will get the new value;
you'll need to reconnect to see the effect.
http://www.postgresq
[EMAIL PROTECTED] wrote:
Starting with this:
create sequence languages_seq increment by 1;
create table languages (
id integer primary key default nextval('languages_seq'),
language_name varchar(100)
);
(I like specifying my own sequence names, instead of using "serial",
plus
using a d
I have some general questions on tsearch2. How do you set it up to search for "how now brown cow" vs how now brown cow? The first example is looking for the exact phrase of words, while the second is just looking for all of the works.
Secondly, if you want to split a text field based on multiple
Is there any way to set DEFAULT_STATISTICS_TARGET on a permanent basis
for a particular database? SET DEFAULT_STATISTICS_TARGET is only per
session, apparently, and I'm not sure I want to set it for the whole
cluster in the config file. I know I can fix it per-column with ALTER
TABLE, but tha
thanks Susan for your idea.
I thought that was it for a moment, then I saw a problem (I think) -
it works, but gets quite inefficient.
when you have 2 phrases which are a translation, that is just one entry
when you have 3, that is 3
4 => 6
and so on.
In practice we might have 15, 20 language
On Wednesday 14 June 2006 03:57 pm, Terry Lee Tucker <[EMAIL PROTECTED]> thus
communicated:
--> Hello List:
-->
--> I've been told that an update to a record is equivalent to a delete and
insert --> operation. We have a utility written in Perl that brings into
sync certain --> elements of 50 tho
Starting with this:
create sequence languages_seq increment by 1;
create table languages (
id integer primary key default nextval('languages_seq'),
language_name varchar(100)
);
insert into languages (id, language_name) values (1, 'English');
insert into languages (id, language_name) values (2
On Wednesday 14 June 2006 13:24, Greg Stark <[EMAIL PROTECTED]> wrote:
> One way it would be unequal is if you can do your DELETE as a single
> query and the insert operation as using a single large COPY FROM.
This is definitely the fastest way to update tens of thousands of rows if
you know the
Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> Hello List:
>
> I've been told that an update to a record is equivalent to a delete and
> insert
> operation. We have a utility written in Perl that brings into sync certain
> elements of 50 thousand records on 8 structurally identical databases.
Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> Hello List:
>
> I've been told that an update to a record is equivalent to a delete
> and insert operation. We have a utility written in Perl that brings
> into sync certain elements of 50 thousand records on 8 structurally
> identical databases. We t
Hello List:
I've been told that an update to a record is equivalent to a delete and insert
operation. We have a utility written in Perl that brings into sync certain
elements of 50 thousand records on 8 structurally identical databases. We
threw together the script and decided to just delete th
Thanks Tom,
OFFSET is even better solution for me .
Regards. Milen
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 3:57 PM
To: Milen Kulev
Cc: 'Jim C. Nasby'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Partitioning...
"Milen Kulev"
I've just started receiving an out of memory error with my most complex
query. It has been running fine for the past 9 months. It's a snapshot
materialized view that I update every night using the functions from
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
The error I'm
Hi,
Is there a way to log the initdb output when running on Windows XP.
I have created my own Merge Module to install postgresql on XP with my
.net application MSI project.
It works fine for most installs but occasionally the initdb fails, and
as it is run in a seperate process under the post
Hi Jasbinder,
On Wed, 2006-06-14 at 12:13 -0400, Jasbinder Bali wrote:
> How do i actually work on the database after starting the postgres
> service at the command line.
Use pgadmin3: http://www.pgadmin.org
This is a powerful gui for PostgreSQL. We have a prebuilt RPM for Fedora
Core 4:
http
Hi,I'm a new user of Postgresql and using it on Fedora core 4. After following all the installation steps and completing them successfully, I'm in a confusion. How do i actually work on the database after starting the postgres service at the command line.
I can sense that i have to use something ca
Louis,
Thank you very much for the info on the -h flag. Somehow I missed that
in the postmaster man pages. That did the trick!
Regards,
J. Bart Casey
-Original Message-
From: louis gonzales [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 2:42 AM
To: louis gonzales
Cc: Casey,
"Casey, J Bart" <[EMAIL PROTECTED]> writes:
> I have read message after message and searched the internet for hours,
> yet I still can't get a remote computer to connect to port 5432 on my
> Fedora Core 3 system running Postgresql 7.4.7.
You need to restart (not just SIGHUP) the postmaster to get
"Milen Kulev" <[EMAIL PROTECTED]> writes:
> Thanks Jim, the "trick" worked for me !
>> You might need to add an ORDER BY to the subquery to ensure
>> PostgreSQL doesn't pull it into the main query.
Actually, the usual trick is "OFFSET 0", which works just as well as
an optimization fence and doe
Filip Rembiałkowski wrote:
let's assume that we keep Unicode text data in the column.
sometimes we want to sort it according to specific collation order.
how can we force collation when running a query?
Hi Filip,
I had the same problem you have. As a solution I implemented a wrapper
function
On 14.06.2006, at 14:12 Uhr, A. Kretschmer wrote:
Is there an easy way to copy the content including the table
structure,
indexes and so on from one db to another?
Create the new db with the old db as template.
Thanks, but as far as I can see, I have to disconnect all clients
from the p
am 14.06.2006, um 13:56:06 +0200 mailte Guido Neitzer folgendes:
> Hi.
>
> Is there an easy way to copy the content including the table structure,
> indexes and so on from one db to another?
Create the new db with the old db as template.
Andreas
--
Andreas Kretschmer(Kontakt: siehe Head
On 14.06.2006, at 14:02 Uhr, Thomas Kellerer wrote:
pg_dump: http://www.postgresql.org/docs/8.1/static/app-pgdump.html
Found it. Thanks. I was just blind and thought, pg_dump can only re-
create the db with the same name.
Thanks,
Guido
---(end of broadcast)-
On 14.06.2006 13:56 Guido Neitzer wrote:
Hi.
Is there an easy way to copy the content including the table structure,
indexes and so on from one db to another?
Let's say I have a production db called db_production and want to create
a development db called db_dev with exactly the same content
Hi.
Is there an easy way to copy the content including the table
structure, indexes and so on from one db to another?
Let's say I have a production db called db_production and want to
create a development db called db_dev with exactly the same content
on the same machine - just with the d
Aha !!!
Thanks Jim, the "trick" worked for me !
Regards. Milen
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 1:09 AM
To: Tom Lane
Cc: Milen Kulev; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Partitioning...
On Mon, Jun 12, 2006
Hi List;
I've downloaded and unzipped the dblink_tds and the oralink contribs from
the pgfoundry.
Once I move them into the contrib directory and try to run make I get
errors about undeclared functions (see the listing below). Any C guru's
have any thoughts/advice/etc??
Thanks in advance for yo
On Wed, Jun 14, 2006 at 11:45:03AM +0200, Leif B. Kristensen wrote:
> On Wednesday 14. June 2006 11:38, Martijn van Oosterhout wrote:
> >Why did you put parenthesis there? It looks like you're making a
> > record within a record. You wouldn't have parenthesis there for a
> > normal select statement
On Wednesday 14. June 2006 11:38, Martijn van Oosterhout wrote:
>Have a nice day,
I forgot to say thank you. And a nice day to you too.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
---(end of broadcast)---
On Wednesday 14. June 2006 11:38, Martijn van Oosterhout wrote:
>Why did you put parenthesis there? It looks like you're making a
> record within a record. You wouldn't have parenthesis there for a
> normal select statement, would you?
s**t. When I remove the parentheses, it runs fine.
This is a
On Wed, Jun 14, 2006 at 11:35:12AM +0200, Leif B. Kristensen wrote:
> On Wednesday 14. June 2006 11:09, Martijn van Oosterhout wrote:
> >IIRC, if you just declare src as type "record" you can select any
> >fields you like. AIUI, declaring a row to be of a specific type is
> > only really important
On Wednesday 14. June 2006 11:09, Martijn van Oosterhout wrote:
>IIRC, if you just declare src as type "record" you can select any
>fields you like. AIUI, declaring a row to be of a specific type is
> only really important if you plan to return it or pass it to another
> function.
I tried:
CREAT
On Wed, Jun 14, 2006 at 11:04:19AM +0200, Leif B. Kristensen wrote:
> One question: When I have a function like this:
>
> CREATE OR REPLACE FUNCTION get_source_text(INTEGER) RETURNS TEXT AS $$
> DECLARE
> src sources%ROWTYPE;
> What do you suggest that I write instead of "SELECT * FROM sour
On Wednesday 7. June 2006 00:10, Jim C. Nasby wrote:
>Also, the commentary about how MySQL is faster isn't very clear. Are
> you using MySQL as some kind of result cache? When you get to running
> actual concurrent access on the website, you could well find yourself
> very disappointed with the pe
Hi all,
I have a table "phrases" that looks like this :
create table phrases(
id serial ,
language integer references langauges(id),
content text
);
Simply a word or phrase in some language.
Now I want to express the concept of a "translation". A translation is
a number of phrases from differ
On Tue, Jun 13, 2006 at 05:23:56PM -0400, Christopher Browne wrote:
> > [3]
> > http://www.intelligententerprise.com/010327/celko_online.jhtml;jsessionid=NDIHEWXGL4TNKQSNDBNSKHSCJUMEKJVN
>
> The sample problem in [3] is one that shows pretty nicely a
> significant SQL weakness; it's very painful
45 matches
Mail list logo
