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
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
"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
-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
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
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 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 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 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, 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
[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
>>
[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
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
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
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
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
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
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
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
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
"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)
---
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
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 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 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
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.
---
-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'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
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:
>
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 "
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
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
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
>
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
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
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
> -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
-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
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
> -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" <
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
> --
> 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
"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
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
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
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
"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:
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
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 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
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 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
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
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 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
>
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
56 matches
Mail list logo