I have two postgres servers, one on linux (fedora core 5), one on
windows, both are version 8.1.4.
Both databases are initialized with locale Croatian and win1250 encoding.
running pg_controldata on windows returns this
LC_COLLATE: Croatian_Croatia.1250
LC_CTYPE:Croatian_C
On Fri, Jun 30, 2006 at 11:56:19AM +0200, Dragan Matic wrote:
> I have two postgres servers, one on linux (fedora core 5), one on
> windows, both are version 8.1.4.
>
> Both databases are initialized with locale Croatian and win1250 encoding.
>
> running pg_controldata on windows returns this
>
Hello,
I'm going through the elongated instructions of installing pgsql and
am stuck at the point where one types:
%> su - postgres
When I type this and type in the password I chose, I get the following
error: 'su: no directory'
Anybody know how I fix this? I've Googled and came up with no
On 6/30/06, Victor Escobar <[EMAIL PROTECTED]> wrote:
Hello,
I'm going through the elongated instructions of installing pgsql and
am stuck at the point where one types:
%> su - postgres
When I type this and type in the password I chose, I get the following
error: 'su: no directory'
What dir
On Thu, Jun 29, 2006 at 11:15:09PM -0400, blackwater dev wrote:
> Does anyone have a good tutorial on finding gps points within a polygon? I
> need to be able to pass in a list of gps coordinates and let postgres return
> to me matching cities from my cities table that are within that polygon.
Po
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > C:\www\foo.com\trunk\db>pg_restore -h localhost -U postgres -W
> > mySecretPassword script.sql
>
> I don't think you're supposed to put the password on the command line
> like that. It's probably taking "mySecretPassword" as the file name
> to read.
On Converting from MySQL 5.0.x to PostgreSQL 8.1.x
--
I am in the process of converting a couple of major sites from MySQL 5.0.22
to PostgreSQL 8.1.4, and I thought I would share some of my observations on
this process and the two database systems i
On Thu, Jun 29, 2006 at 07:18:56AM -0700, [EMAIL PROTECTED] wrote:
> it doesn't seem even that: I tried to exclude all other parameters and
> leaving just:
> c:\> pg_restore script.sql
If that's just a straight SQL script produced by pg_dump, then you don't
need pg_restore, just "psql -f script.sq
On Jun 29, 2006, at 5:58 PM, Tim Hart wrote:
I'm coming in a bit late to this conversation, so forgive me if
I've missed
something. Isn't this problem the reason that connection pools were
created?
In a connection pool, connections are only associated with a
particular
user for the durat
"Jason McManus" <[EMAIL PROTECTED]> writes:
> I am in the process of converting a couple of major sites from MySQL 5.0.22
> to PostgreSQL 8.1.4, and I thought I would share some of my observations on
> this process and the two database systems in general.
Nice notes! I see only one small error:
Hello,
Does anybody have experience in running PostgreSQL inside OpenVZ
(http://openvz.org/) or any other virtual private servers solutions?
I'm interested in both cases of running single PostgreSQL server and
multiple PostgreSQLs on one physical machine under relatively high
(though not IO-limit
I don't believe there is any fixed "default character set". Each
installation will have a default locale and encoding, but these depend
on the locale under which initdb was run. From the above comment I
surmise that you initdb'd under some UTF8-using locale ...
Ah, great. Thank you for the cl
Yes indeed if it would be possible, it should go to the website.
Good comparison without saying such things like this dbms has xx features
and this one has xx features.
Some addtitional information for setcion "Further information:"
phpPgAdmin http://phppgadmin.sourceforge.net/
Gborg http://gborg
"Jason McManus" <[EMAIL PROTECTED]> writes:
>> Perhaps they should go on the project website somewhere?
> I was thinking so as well, but I'm not sure where, or who to submit to
> if there is no wiki or other external editing method. Any pointers
> for who to contact/where to submit?
Not my depar
> Right, this is standard operating procedure. But the original poster
> mentioned tying the connection to a particular web user/session. In
> other words, one connection per user.
Maybe I didn't phrase the question correctly, but I think that the
answer to my question is, indeed, connection pool
I agree with Tom, nice notes. I noted a few minor issues that seem to
derive from a familiarity with MySQL. I'll put my corrections below...
On Fri, 2006-06-30 at 08:17, Jason McManus wrote:
> On Converting from MySQL 5.0.x to PostgreSQL 8.1.x
> --
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
> Sent: 30 June 2006 15:47
> To: Jason McManus
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Notes on converting from MySQL 5.0.x
> to PostgreSQL 8.1.4
>
> "Jason McManus" <
hi all, I have the following schema:
CREATE TABLE auctions ( id serial NOT NULL, user_id int4, title
varchar(255), body varchar(255), CONSTRAINT auctions_pkey PRIMARY KEY (id) )
WITHOUT OIDS;
CREATE TABLE bids ( id serial NOT NULL, auction_id int4, user_id int4,
amount float8, created_at times
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
[snip]
> However, the more interesting thing here, is that every
> statement, including DDL is transactable, except for a couple of
> big odd ones, like create database. So, in postgresql, you can do:
>
> begin;
> create table xyz
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe
> Sent: 30 June 2006 16:12
> To: Jason McManus
> Cc: pgsql general
> Subject: Re: [GENERAL] Notes on converting from MySQL 5.0.x
> to PostgreSQL
>
> > * Replication support still rudi
Alan Bullock wrote:
hi all, I have the following schema:
CREATE TABLE auctions ( id serial NOT NULL, user_id int4, title
varchar(255), body varchar(255), CONSTRAINT auctions_pkey PRIMARY KEY (id) )
WITHOUT OIDS;
CREATE TABLE bids ( id serial NOT NULL, auction_id int4, user_id int4,
amount f
Ron Johnson wrote:
begin;
create table xyz...
alter table abc...
insert into abc select * from iii
update iii...;
drop table iii;
(oops, I messed up something)
rollback;
But isn't that what it means to be "transactional"? Or am I spoiled
by my "big, expensive enterprise database"?
Well, ac
Scott Marlowe <[EMAIL PROTECTED]> writes:
> On Fri, 2006-06-30 at 08:17, Jason McManus wrote:
>> * Replication support still rudimentary.
> H. I think that's an overly simplistic evaluation. The slony
> replication engine is actually VERY advanced, but the administrative
> tools consist most
On Friday 30. June 2006 17:12, Scott Marlowe wrote:
>And, I hate the fact that CTRL-C in the mysql command line tool exits
>the tool instead of interrupting the current query.
I agree, it's a nuisance.
>In PostgreSQL it
>interrupts the current query. CTRL-\ will kill the client if you need
>
Out of curiosity, which "big, expensive enterprise database" are you spoiled
by? Many that I support do not allow DDL within an transaction, or if they
allow it, there are many caveats and rules.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ron Joh
Without trying it out, how about something like:
select username, maxbid
from users u, (
select user_id, max(amount) as maxbid
from bids
group by user_id
where auction_id = XXX
) as b
where u.id = b.user_id;
John
Alan Bullock wrote:
hi all, I have the following schema:
CREATE TABLE a
Ron Johnson <[EMAIL PROTECTED]> writes:
> Scott Marlowe wrote:
>> However, the more interesting thing here, is that every
>> statement, including DDL is transactable, except for a couple of
>> big odd ones, like create database. So, in postgresql, you can do:
> But isn't that what it means to be "
If you don't mind using a (quite useful) postgres extension, this might
work for you:
select distinct on (auctions.id, users.id) *
from auctions, bids, users
where
order by auctions.id, users.id, created_at desc;
Hope this helps,
On Fri, Jun 30, 2006 at 04:13:12PM +0100, Alan Bullock wrote:
>
Hi,i'm migrating some SP from MySQL to PostgreSQL 8.1.xI would like to know if it is possible to return aresult of a select request and also a simple interger...thanks a lot,Alain
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
paul rivers wrote:
> Out of curiosity, which "big, expensive enterprise database" are
> you spoiled by? Many that I support do not allow DDL within an
> transaction, or if they allow it, there are many caveats and
> rules.
Oracle Rdb. Built by DEC ba
Hi,
I am new to pgsqlI really appreciate the licensing terms of
pgsql...mysql licensing is a little bit risky to use...
But, I have one question...
Q. when using pgsql as a very heavy and mission critical applications,
what are the advantages of using pgsql instead of mysql?
thanks.
---
On 30 Jun 2006 08:58:27 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I am new to pgsqlI really appreciate the licensing terms of
pgsql...mysql licensing is a little bit risky to use...
Q. when using pgsql as a very heavy and mission critical applications,
what are the advantages of us
On 6/30/06, Martijn van Oosterhout wrote:
On Fri, Jun 30, 2006 at 11:56:19AM +0200, Dragan Matic wrote:
> I have two postgres servers, one on linux (fedora core 5), one on
> windows, both are version 8.1.4.
>
> Both databases are initialized with locale Croatian and win1250 encoding.
>
> running
On Fri, Jun 30, 2006 at 04:22:28PM +0100, Dave Page wrote:
>
>
> > > * Replication support still rudimentary.
> >
> > H. I think that's an overly simplistic evaluation. The slony
> > replication engine is actually VERY advanced, but the
> > administrative tools consist mostly of "your bra
On Fri, Jun 30, 2006 at 11:39:04AM -0400, Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> > On Fri, 2006-06-30 at 08:17, Jason McManus wrote:
> >> * Replication support still rudimentary.
>
> It might be worth pointing out that mysql's replication falls over
> if you so much as look
"Alan Bullock" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> hi all, I have the following schema:
>
thanks all for such prompt replies! I'm going with Martijn's solution, I'm a
total newbie and it appears simplest (though I realise it's pgsql only)
---
Merlin Moncure wrote:
>
> * mysql performance advantage is greatly overstated, although
> postgresql requires you to use certain conventions (example: prepared
> statements) to get comparable performance
> * both databases (IMO) are very stable. in 6 years of workikng with
> both databases, I've n
David Fetter <[EMAIL PROTECTED]> writes:
> On Fri, Jun 30, 2006 at 11:39:04AM -0400, Tom Lane wrote:
>> It might be worth pointing out that mysql's replication falls over
>> if you so much as look at it crosseyed. I have not had to use it
>> for production purposes, but I can tell you that the mys
On Fri, Jun 30, 2006 at 01:41:53PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Fri, Jun 30, 2006 at 11:39:04AM -0400, Tom Lane wrote:
> >> It might be worth pointing out that mysql's replication falls
> >> over if you so much as look at it crosseyed. I have not had to
Both connection pooling and using the superuser with SET SESSION
AUTHORIZATION both have their uses. You might have an application
that processes some type of transaction and inserts data into a users
schema or table, but where there are no user credentials available.
Then you might have a web i
Hi,
I use this approach both for development and backup servers (with PITR).
Everything runs very smoothly. You should, of course, keep an eye on
/proc/user_beancounters and diskquota to ensure that the engines have enough
shared memory, network io (both sockets and buffer, tcp and "other") and
David Fetter <[EMAIL PROTECTED]> writes:
> On Fri, Jun 30, 2006 at 01:41:53PM -0400, Tom Lane wrote:
>> Sure, it's just the standard "make test" sequence in mysql's source.
> Uh oh. I'm a little worried about writing tests based on GPLed code
> for Slony-I or other replication systems. Might the
On 6/25/06, Sim Zacks <[EMAIL PROTECTED]> wrote:
Merlin,
Thank you for your input. My original question did specifically mention
that the events had to be on the same day.
> I need to have a query that gives per employee each event and the event after
it if it happened _on the same day_.
wh
Mysql does not allow you to use now() as the default value of a column.
From their docs:
"The DEFAULT clause specifies a default value for a column. With one
exception, the default value must be a constant; it cannot be a function
or an expression. This means, for example, that you cannot set th
[EMAIL PROTECTED] (Ron Johnson) writes:
> Scott Marlowe wrote:
> [snip]
>> However, the more interesting thing here, is that every
>> statement, including DDL is transactable, except for a couple of
>> big odd ones, like create database. So, in postgresql, you can do:
>>
>> begin;
>> create table
[EMAIL PROTECTED] (Scott Marlowe) writes:
> I agree with Tom, nice notes. I noted a few minor issues that seem to
> derive from a familiarity with MySQL. I'll put my corrections below...
>
> On Fri, 2006-06-30 at 08:17, Jason McManus wrote:
>> On Converting from MySQL 5.0.x to PostgreSQL 8.1.x
>>
On Fri, 2006-06-30 at 16:34, Chris Browne wrote:
> [EMAIL PROTECTED] (Scott Marlowe) writes:
> > I agree with Tom, nice notes. I noted a few minor issues that seem to
> > derive from a familiarity with MySQL. I'll put my corrections below...
> >
> > On Fri, 2006-06-30 at 08:17, Jason McManus wrot
On Wed, Jun 28, 2006 at 11:59:36AM -0700, Karen Hill wrote:
> I have an insert/update/delete trigger on all my tables which add data
> to a log table.
>
> I would like to be able to disable them when the tables are called from
> one stored proceedure I have. Yet I would still like those triggers
On Fri, Jun 30, 2006 at 11:01:19AM -0700, David Fetter wrote:
> On Fri, Jun 30, 2006 at 01:41:53PM -0400, Tom Lane wrote:
> > David Fetter <[EMAIL PROTECTED]> writes:
> > > On Fri, Jun 30, 2006 at 11:39:04AM -0400, Tom Lane wrote:
> > >> It might be worth pointing out that mysql's replication falls
On Fri, Jun 30, 2006 at 11:39:04AM -0400, Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> > On Fri, 2006-06-30 at 08:17, Jason McManus wrote:
> >> * Replication support still rudimentary.
>
> > H. I think that's an overly simplistic evaluation. The slony
> > replication engine
On Fri, Jun 30, 2006 at 05:16:46PM -0500, Scott Marlowe wrote:
> This is essentially correct. Note that I can use pgpool with postgresql
> and get about the same behaviour as mysql's replication, with the same
> basic draw backs, that it's best to copy the database between shutdown
> machines, and
On Fri, Jun 30, 2006 at 01:07:32PM -0400, Merlin Moncure wrote:
> * mysql has decent out of the box replication that is easy to set up
> (one day I hope pg get hot PITR which is analagous feature)
Actually, PITR is in no way analagous. Try replicating something like
'INSERT INTO table SELECT rando
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Chris Browne wrote:
> [EMAIL PROTECTED] (Ron Johnson) writes:
>
>> Scott Marlowe wrote:
>> [snip]
>>> However, the more interesting thing here, is that every
>>> statement, including DDL is transactable, except for a couple of
>>> big odd ones, like c
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Is there actually a lack of ideas for our regression tests, or a lack of
> people/motivation to work on them?
Certainly there are plenty of ideas in the archives ... but writing
regression tests is so *boring* :-(. This is definitely a weak spot
for a
Hi,I have some problems with a stored procedure.In this SP, i run several SELECT statements.1st one is to confirm that profile/account really exist into DB.if it's ok, the 2nd statement (SELECT) is executed and should return records.
these records should be the result of my SP.i try the RETURNS set
am 01.07.2006, um 7:47:09 +0200 mailte Alain Roger folgendes:
[ Problems with set returning functions ]
> Could you give me some piece of code for such use ?
http://www.varlena.com/GeneralBits/26.php
There are any examples.
HTH, Andreas
--
Andreas Kretschmer(Kontakt: siehe Header)
Heyni
56 matches
Mail list logo
