Robin Ericsson <[EMAIL PROTECTED]> wrote: On 9/18/06, Najib Abi Fadel <[EMAIL PROTECTED]> wrote:> Hi,>> i was searching for a load balancing solution for> postgres, I found some ready to use software like> PGCluster, Slony, pgpool and others.>> It would really be nice if someone knows which one is>
Tom Lane wrote:
Ron Johnson <[EMAIL PROTECTED]> writes:
On 09/18/06 22:32, Joshua D. Drake wrote:
John Meyer wrote:
has anybody gotten postgresql to install successfully under Windows
Vista?
It's not out yet ;)
Release Candidates are, for the very purpose
Try renaming the schema. alter schema schemaname rename to newname;
then if you want the old schema back create a new one.
If there are already stuff in the schema you want to move to then
write a quick function using a for loop with the pg_class table
to write the alter table statement for anythi
Ron Johnson <[EMAIL PROTECTED]> writes:
> On 09/18/06 22:32, Joshua D. Drake wrote:
>> John Meyer wrote:
>>> has anybody gotten postgresql to install successfully under Windows
>>> Vista?
>>
>> It's not out yet ;)
> Release Candidates are, for the very purpose of allowing ISVs to
> have their s/w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/18/06 22:32, Joshua D. Drake wrote:
> John Meyer wrote:
>> has anybody gotten postgresql to install successfully under Windows
>> Vista?
>
> It's not out yet ;)
Release Candidates are, for the very purpose of allowing ISVs to
have their s/w rea
John Meyer wrote:
has anybody gotten postgresql to install successfully under Windows Vista?
It's not out yet ;)
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sale
has anybody gotten postgresql to install successfully under Windows Vista?
---(end of broadcast)---
TIP 6: explain analyze is your friend
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/18/06 21:19, brian wrote:
> Ron Johnson wrote:
>> On 09/18/06 19:25, Jeff Davis wrote:
>>
>>> On Mon, 2006-09-18 at 19:47 -0300, [EMAIL PROTECTED] wrote:
>>>
Hi,
I'm trying to create a table with a PRIMARY KEY. The CREATE
stat
Ron Johnson wrote:
On 09/18/06 19:25, Jeff Davis wrote:
On Mon, 2006-09-18 at 19:47 -0300, [EMAIL PROTECTED] wrote:
Hi,
I'm trying to create a table with a PRIMARY KEY. The CREATE statement looks
like this:
CREATE TABLE "projects" (
"project_id" serial,
"username" varchar(30) NOT NULL de
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/18/06 19:25, Jeff Davis wrote:
> On Mon, 2006-09-18 at 19:47 -0300, [EMAIL PROTECTED] wrote:
>> Hi,
>>
>> I'm trying to create a table with a PRIMARY KEY. The CREATE statement looks
>> like this:
>>
>> CREATE TABLE "projects" (
>> "project_id"
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Well, these make it clear that you've got some pretty big chunks of
nonstandard code in the backend, so my first thought is that there's a
memory-clobber bug somewhere in that.
I'm not sure what you mean by 'nonstandard code
On Mon, 2006-09-18 at 19:47 -0300, [EMAIL PROTECTED] wrote:
> Hi,
>
> I'm trying to create a table with a PRIMARY KEY. The CREATE statement looks
> like this:
>
> CREATE TABLE "projects" (
> "project_id" serial,
> "username" varchar(30) NOT NULL default '',
> "project_name" varchar(30) NOT
Hi,
I'm trying to create a table with a PRIMARY KEY. The CREATE statement looks
like this:
CREATE TABLE "projects" (
"project_id" serial,
"username" varchar(30) NOT NULL default '',
"project_name" varchar(30) NOT NULL default '',
PRIMARY KEY ("project_id")
) ;
The problem is that somet
Geoffrey <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Well, these make it clear that you've got some pretty big chunks of
>> nonstandard code in the backend, so my first thought is that there's a
>> memory-clobber bug somewhere in that.
> I'm not sure what you mean by 'nonstandard code,' could
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
Problem is, we seem to be having a problem with this reset issue and I
don't see a correlation in the backtraces. Most of them are in fact
related to inserts, but there are at least three different tables
involved. There are also some wher
No, I'm connecting from the same host...this is my
problem!
Any ideas?
- Original Message -
From:
Brandon
Aiken
To: Alberto Molteni ; pgsql-general@postgresql.org
Sent: Monday, September 18, 2006 7:17
PM
Subject: Re: [GENERAL] Restore data from
old install
Geoffrey <[EMAIL PROTECTED]> writes:
> Problem is, we seem to be having a problem with this reset issue and I
> don't see a correlation in the backtraces. Most of them are in fact
> related to inserts, but there are at least three different tables
> involved. There are also some where an INSER
On 2006-09-18, "Jack Orenstein" <[EMAIL PROTECTED]> wrote:
> On 9/14/06, Andrew - Supernews <[EMAIL PROTECTED]> wrote:
>> One way:
>
> Thank you, I hope you can help with some clarifications.
>
>>
>> bytea *my_bytea = (bytea *) palloc(byte_array_len + VARHDRSZ);
>> memcpy(VARDATA(my_bytea),
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
>> Would that work for most people?
>Yes, that's reasonable. Automatically unsubscribing is not...
Um, can we close this thread now? First, the fix for this list was
already put in place some time ago, so this is totally academic.
Second, I'm tired
On Sep 18 02:57, David Brain wrote:
> >Use COPY instead. (You can also prefer CURSORs in your client
> >applications. See related discussions.)
>
> Yes, but COPY isn't an option if I need to do:
>
> SELECT * from really_big_table where foo='zebra' order by createddate
>
> Which is what I r
Tom Lane wrote:
It seems you've got a corrupt "compiled statements" data structure for
a plpgsql trigger function. Offhand this does not look like any of the
known post-7.4.7 bug fixes. Can you show us the source code for that
trigger?
Problem is, we seem to be having a problem with this res
On 9/14/06, Andrew - Supernews <[EMAIL PROTECTED]> wrote:
On 2006-09-14, "Jack Orenstein" <[EMAIL PROTECTED]> wrote:
> I don't think I explained myself clearly. I have a C string (char*,
> terminating zero) and a byte array (char*, possibly containing zeros,
> and I know the length). I want to ob
On Sep 18 01:52, David Brain wrote:
> I had in interesting issue the other day while trying to generate
> delimited files from a query in psql, using:
>
> \f'|'
> \t
> \a
> \o out.file
> select * from really_big_table sort by createddate;
>
> This quantity of data involved here is fairly large (
I had in interesting issue the other day while trying to generate
delimited files from a query in psql, using:
\f'|'
\t
\a
\o out.file
select * from really_big_table sort by createddate;
This quantity of data involved here is fairly large (maybe 2-4GB).
Watching the memory usage, the postmaste
> I wouldn't mind terribly getting an occasional "clippy" message like:
>
> It looks like you're trying to unsubscribe from this mailing list.
>
> Would you like some help with doing that?
>
> As opposed to a message "You've been unsubscribed" After sending
> something about slony to the list.
All of my cool witty retorts to all of these posts are being ruined by the
fact that all of my mails are being scrutinized by the moderators first.
Everyone is getting in before me.
Mine are going to seem like the slow witted back-water cousins to these
sharp NY barristers.
[EMAIL PROTECTED]
Hi everybody!
When I use pgAdmin III I cannot connect to the database..an error is
presented: Connection Refused (0x274D/10061).
I have not found a solution to this problem and I reinstalled the
package of Postgresql 8.0. I saved the directory of the old
installation.
Now, I should need to h
> > I've
> > never used a hammer to put in a screw.
>
> So I guess you're one of those ivory-tower theory-purist academic types,
at
> least when it comes to home repairs.
No no. When it comes to everything.
I have read all the books and watched Norm Abraham till my eyes bled.
There's not m
Are you trying to connect to a remote
server? By default, PostgreSQL only accepts connections from localhost or
127.0.0.1. You will have to change the listen_addresses setting in postgresql.conf
if you wish to connect from a remote node.
--
Brandon
Aiken
CS/IT Systems E
Hi everybody!
When I use pgAdmin III I cannot connect to the database..an error is
presented: Connection Refused (0x274D/10061).
I have not found a solution to this problem and I reinstalled the package
of Postgresql 8.0. I saved the directory of the old installation.
Now, I should nee
Geoffrey <[EMAIL PROTECTED]> writes:
> Program terminated with signal 11, Segmentation fault.
> #0 exec_stmt (estate=0xfeff8a90, stmt=0x0) at pl_exec.c:928
> in pl_exec.c
> #0 exec_stmt (estate=0xfeff8a90, stmt=0x0) at pl_exec.c:928
> #1 0x0083f005 in exec_stmts (estate=0xfeff8a90, stmt
Maybe I'm restating the obvious, but it looks to me like the procedural
trigger from the SQL query "INSERT INTO logs
(seq,level,event_code,event_date,event_time,city,province,user_id,est_ds
p_date,est_dsp_time,country,edilate,carr_code,notes,trac_notes,order_num
)
VALUES ('2','6','TAS','09/14/06','
Sim Zacks <[EMAIL PROTECTED]> writes:
> Here is a simple, reproducible example that delete doesn't cause it to use
> serial:
If you add
raise notice 'past the delete';
between the DELETE and the insert loop, you will discover that the
second guy in fact doesn't manage to complete the DELE
Postgresql 7.4.7 (yes, I've been telling them we need to upgrade to the
latest 7.4)
Red Hat Enterprise Linux ES release 3
We are having problems with the postgresql server resetting and dropping
all user connections. There is a core file generated and I've attached
a backtrace. I'm about to
On Mon, 2006-09-18 at 03:23, Csaba Nagy wrote:
> > > ... which still doesn't cover "RE" translated in most of the world's
> > > languages, which I'm sure occasionally pop up from people who use
> > > localized mail clients.
> >
> > * ! ^Subject:.*(Re|AW|Antwort|Reply|Reponse|Sv):
> >
> > Better?
ALTER TABLE name
SET SCHEMA new_schema
Naz Gassiep wrote:
Is there a way to change the schema that all objects are in?
Essentially I want to move everything currently in the database into
public rather than having the complex schemas that I have at the moment.
They are unnecessary and
Is there a way to change the schema that all objects are in?
Essentially I want to move everything currently in the database into
public rather than having the complex schemas that I have at the moment.
They are unnecessary and the DB complexity is trivial, so using schema
partitioning is mo
On 18/9/2006 16:43, "CN" <[EMAIL PROTECTED]> wrote:
> Hi!
>
> CREATE TABLE t1 (c1 text, c2 SMALLINT, PRIMARY KEY (c1,c2));
>
> CREATE TABLE t2 (a text);
>
> I am looking for a solution that will insert rows into table t1 with one
> SQL similar to this:
>
> INSERT INTO t1
> SELECT a,my_seq() FR
I wonder if you set the transaction mode to "serializable" whether that
would make a difference. In standard read-committed the way it works
below seems to be what's expected (each transaction sees what was
committed at the time is ran).
I tried running this in both windows at the same time (
am Mon, dem 18.09.2006, um 15:13:10 +0800 mailte CN folgendes:
> SELECT * FROM t2 WHERE a='const_id'
>
> , then 3 records will be inserted to table t1:
>
> const_id, 1
> const_id, 2
> const_id, 3
>
> I know a PL/PGSQL function like this does the job:
You can use this:
test=# select * from t2;
Tom,
thank you! from cvs I copied the latest "strategy" to make the sanity checks
and removed those values which were added after version 8.1.4. Using that patch, I can
compile postgres without any problems. This version runs nicely on several servers.
Best regards,
Johannes
Johannes Weberh
On Mon, Sep 18, 2006 at 10:31:26AM +0200, Sim Zacks wrote:
> > I think the reason you are seeing failures in the first function is
> > that the initial DELETE is a no-op so it doesn't serialize anything,
> > and then there is conflict when the two INSERTs proceed in parallel.
>
> Here is a simple,
Scott Ribe schrieb:
I've
never used a hammer to put in a screw.
So I guess you're one of those ivory-tower theory-purist academic types, at
least when it comes to home repairs. As a more practical person myself, let
me just say that sometimes a 3lb hammer is exactly the right tool to get a
scre
On 9/18/06, Najib Abi Fadel <[EMAIL PROTECTED]> wrote:
Hi,
i was searching for a load balancing solution for
postgres, I found some ready to use software like
PGCluster, Slony, pgpool and others.
It would really be nice if someone knows which one is
the best taking in consideration that i have
> > ... which still doesn't cover "RE" translated in most of the world's
> > languages, which I'm sure occasionally pop up from people who use
> > localized mail clients.
>
> * ! ^Subject:.*(Re|AW|Antwort|Reply|Reponse|Sv):
>
> Better?
The point was that you will never ever be able to cover all
> I think the reason you are seeing failures in the first function is
> that the initial DELETE is a no-op so it doesn't serialize anything,
> and then there is conflict when the two INSERTs proceed in parallel.
Here is a simple, reproducible example that delete doesn't cause it to use
serial:
c
Hi!
CREATE TABLE t1 (c1 text, c2 SMALLINT, PRIMARY KEY (c1,c2));
CREATE TABLE t2 (a text);
I am looking for a solution that will insert rows into table t1 with one
SQL similar to this:
INSERT INTO t1
SELECT a,my_seq() FROM t2
WHERE a='const_id'
my_seq() in SELECT clause returns a sequence of S
47 matches
Mail list logo
