Dragan Matic <[EMAIL PROTECTED]> writes:
> I was about to say the same thing. I think that the whole point in
> having a portable database system is that the data inside the database
> should behave the _same way_ no matter what operating system database is
> running on - client shouldn't be awa
Kirti S. Bajwa wrote:
> Hello List:
>
> I hope my question does not start war of the posts. This question is
> genuine. Please answer objectively:
>
> I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS,
> DNS, Apache, (mySQL & PostgreeSQL), PHP, Postfix, etc. This Master
> Server
On Sun, Jul 02, 2006 at 06:40:30PM -0700, [EMAIL PROTECTED] wrote:
> is there a command like uf_purge which purges the last x days of data.
> i noticed this command somewhere but i cant find a reference to it any
> documentation. is it a deprecated command and we just use delete now.
> whats its fu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Correct, 3 tables. T_SALES_DETAIL records are "line items", the
stuff the customer bought. There is only a T_SALES_CC_DETAIL record
if the transaction happens to use a credit card.
a wrote:
> you mean there are 3 tables
> the list of items purchase
hi all,
is there a command like uf_purge which purges the last x days of data.
i noticed this command somewhere but i cant find a reference to it any
documentation. is it a deprecated command and we just use delete now.
whats its functionality?
any ideas.
---(end of broad
you mean there are 3 tables
the list of items purchased - this is what i am asking for
the list of items purchased
What is difference between
T_SALES_CC_DETAIL and > T_SALES_DETAIL
thanks a lot ron
-
> T_SALE
> I hope my question does not start war of the posts. This question is
> genuine. Please answer objectively:
> I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS, DNS,
> Apache, (mySQL & PostgreeSQL), PHP, Postfix, etc. This Master Server will
> have all the software I we need for o
Victor Escobar wrote:
The directory is set to /dev/null. I also forgot to add that I'm using
OS X 10.4. Since obviously /dev/null means the bit-bucket, what should I
set the home directory to?
Always CC the list, you'll get much faster/better responses.
Set the home dir to the base of your po
On Sun, Jul 02, 2006 at 11:17:12PM +0200, Alexander Farber wrote:
> However when I try to execute the latter query by my C-program,
> then it fails, saying that my bind command supplies 2 arguments
> (yes, that's true), but the prepared statement requires 1 argument
> (why 1? I don't understand)
On Sun, Jul 02, 2006 at 12:25:43PM -0400, Agent M wrote:
> On Jul 2, 2006, at 6:13 AM, Martijn van Oosterhout wrote:
> >But I don't think anyone is actually considering importing ICU into the
> >postgres source tree, are they?
> Why not?
Because it's a project of similar size to postgres and proba
Hello,
these 2 statements work fine for me on the psql-prompt:
punbb=> select id, username, md5('deadbeef' || password) from users
where id = 7;
id | username | md5
+--+--
7 | Alex | b962415469222eeb31e739c3afbc8a4a
(1 row)
punbb=>
On 7/2/06, Agent M <[EMAIL PROTECTED]> wrote:
Certain Japanese characters cannot make a reliable round-trip through
Unicode. ICU uses UTF-16 as its store, so the Japanese folks won't be
happy with an ICU-only solution. However, it would still be of great
Could you explain what you mean and wha
Check where you are executing this.the user postgres does not have
permission to write logfile in your current directory
Victor Escobar wrote:
Hello,
I'm getting the following error when I do this step:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
Exit 1: Perm
Hello,
I'm getting the following error when I do this step:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
Exit 1: Permission denied: logfile 2>&1 &
I did a chown on /usr/local/pgsql/data and am running this as postgres.
---(end of broadcast)-
On 2 jul 2006, at 18.29, Victor Escobar wrote:
What should the default directory for the postgres user be? I'm
using OSX 10.4. Right now, the default directory is set to /dev/null.
I've set the home directory to /var/empty and the shell to /usr/bin/
false, like most of the other daemon users
Hello List:
I hope my question does not start war of the posts. This
question is genuine. Please answer objectively:
I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS,
DNS, Apache, (mySQL & PostgreeSQL), PHP, Postfix, etc. This Master Server will
have all the softwa
On Sunday 02 July 2006 01:42, Tino Wildenhain wrote:
> Uwe C. Schroeder wrote:
> > You can technically just copy & paste the postgresql data directory IF
> > YOU SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for
> > the same version of postgresql. Also: this is not a good way to
The shell is probably /bin/false right? That indicates that the
postgres user won't log in to an active session. If that's an issue,
then you should change that to whatever you like (probably
/usr/local/pgsql/).
On Jul 2, 2006, at 12:29 PM, Victor Escobar wrote:
What should the default direct
Tom Lane wrote:
Plan B is to leave the pgsql user alone and add another superuser named
postgres. You can have more than one superuser ...
Yes, that's what my hosting provider (hub.org, which also hosts
postgresql.org) seems to have done. This also avoids another minor
problem: initdb on U
What should the default directory for the postgres user be? I'm using
OSX 10.4. Right now, the default directory is set to /dev/null.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an inde
On Jul 2, 2006, at 6:13 AM, Martijn van Oosterhout wrote:
But I don't think anyone is actually considering importing ICU into the
postgres source tree, are they?
Why not?
Size - I'm not sure this is relevent since I don't think we want to
incorporate it into postgres itself, just let people us
Joe <[EMAIL PROTECTED]> writes:
> It was when I tried starting PostgreSQL from boot, which requires adding
> "postgresql_enable" in /etc/rc.conf, that it didn't work. I tracked
> that down to /usr/local/etc/rc.d/010.pgsql.sh which uses a
> "postgresql_user" variable defined as "pgsql" by the po
Tom Lane wrote:
FreeBSD is out in left field here. However, I don't see why you need to
alter the build to change this. Just create a new user postgres and run
the initdb step as that user. initdb uses the OS user name it's run as
to determine the initial superuser name.
That's exactly what
> -Original Message-
> From: David Fetter [mailto:[EMAIL PROTECTED]
> Sent: 30 June 2006 18:30
> To: Dave Page
> Cc: Scott Marlowe; Jason McManus; pgsql general
> Subject: Re: [GENERAL] Notes on converting from MySQL 5.0.x
> to PostgreSQL
>
> Last I checked, pgAdmin 1.4 doesn't help s
Joe <[EMAIL PROTECTED]> writes:
> I'm now migrating to FreeBSD and was surprised to find that the port
> used 'pgsql' as the user. The maintainer said that was done to ensure
> backward compatibility because that *was* the original name.
It's always been "postgres", at least as far as the stand
On 7/2/06, Joe <[EMAIL PROTECTED]> wrote:
Hi,
I started using PostgreSQL (8.0) about a year ago on Windows. Following
the installation instructions, I created a 'postgres' user (BTW, this
was based on the Short Version instructions for UNIX, i.e., "adduser
postgres" --I'm not sure it this is ma
Hi,
I started using PostgreSQL (8.0) about a year ago on Windows. Following
the installation instructions, I created a 'postgres' user (BTW, this
was based on the Short Version instructions for UNIX, i.e., "adduser
postgres" --I'm not sure it this is made explicit elsewhere, even for UNIX).
On Sun, Jul 02, 2006 at 12:13:02PM +0200, Martijn van Oosterhout wrote:
> However, the most important point is that people have said they'll take
> the speed hit if they could get consistant collation.
I can second that.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD
Tomi NA wrote:
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.
>
Not beeing able to depend on the engine to consistently collate
stri
On Sat, Jul 01, 2006 at 06:23:07PM -0400, Tom Lane wrote:
> "Tomi NA" <[EMAIL PROTECTED]> writes:
> > Basically, it comes down to three possibilities, doesn't it:
> > 1.) use an existing library
> > 2.) write a pgsql specific implementation
> > 3.) forget about it and tend to other issues
>
> > Pe
Uwe C. Schroeder wrote:
> You can technically just copy & paste the postgresql data directory IF YOU
> SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for the
> same version of postgresql. Also: this is not a good way to do it and I'd
> encourage you not to use this as general
Hmm, not good - I've forwarded this to the techdocs author.
Regards, Dave
-Original Message-
From: "Jason McManus" <[EMAIL PROTECTED]>
To: "Dave Page"
Cc: "pgsql-general@postgresql.org"
Sent: 02/07/06 05:00
Subject: Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4
32 matches
Mail list logo
