Is it
desiarable to default postgresql.conf datestyle to match the locale?
#
# Locale settings
#
# (initialized by initdb -- may be changed)
LC_MESSAGES = 'C'
LC_MONETARY = 'C'
LC_NUMERIC = 'C'
LC_TIME = 'C'
Another JPY 2 from the
On Fri, Jun 20, 2003 at 11:14:02PM -0400, Tom Lane wrote:
There are some, but I still disagree. The biggest advantage of
PostgreSQL in my opinion has always been that it's a community project
and not driven by some commercial interests.
These are not mutually exclusive. Each developer
On Sat, Jun 21, 2003 at 11:40:52AM -0300, The Hermit Hacker wrote:
I have no doubt that some of those features were 'pushed to the top of the
TODO list' due to their business case, but I can't think of any that were
against teh desires of the community ... were there?
No, there were definitely
On 23 Jun 2003 at 12:53, Kallol Nandi wrote:
Is there any Postgresql client softwarefor linuxto connect to Postgresql
database server on linux?
Can somebody please provide me with the links or the installables if they have
them already?
How about psql?
Thanks and Regards,
Kallol
Okay, I did a quick search through both the general and SQL lists(1,2)
trying to determine if there is a PostgreSQL construct equivalent to
Microsoft SQL Server's SELECT @@IDENTITY. After performing an insert the
database caches the last sequence number for each connection and the select
retrieves
Hey!
You stole my favorite laugh!
My second favortie one is 'Nya, Nya, Ny' (Snidely Whiplash of Bulwinkle fame)
Justin Clift wrote:
Tom Lane wrote:
snip
We need to use this opportunity to encourage PHP folks to switch to
PostgreSQL.
Indeed. What can we do exactly?
Hmmm...
I think rejecting the data is the best approach. I raises a big flag to the sysadmin or user.
Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
The one thing that should absolutely be turned off is day/month swapping
on dates of the form: 2003-02-22.
Agreed on that. -DD-MM isn't
At the bottom of an email from this list, I saw:
-(end of broadcast)-
TIP 9: the planner will ignore your desire to choose an index scan
if your joining column's datatypes do not match
If that's so, then what is the recommended way to ensure an
We require ~* syntax for that, or upper()/lower().
Slowly the light dawns!
If I anchor a ~ search on both ends, it is the same search as =.
Duh!
I converted the prototype over to use ~ and it is running much faster.
I'll try to do some detailed timings against MySQL tonight.
--
Mike Nolan
On 6/23/03 12:58 PM, Robert J. Sanford, Jr. [EMAIL PROTECTED] wrote:
Okay, I did a quick search through both the general and SQL lists(1,2)
trying to determine if there is a PostgreSQL construct equivalent to
Microsoft SQL Server's SELECT @@IDENTITY. After performing an insert the
database
See the FAQ item about index usage. You have to anchor the start only.
---
[EMAIL PROTECTED] wrote:
We require ~* syntax for that, or upper()/lower().
Slowly the light dawns!
If I anchor a ~ search on both ends, it
just have a quick question. What i need to do is to create a shared memory
structure (which i can do) and maintain in it a linked list which should
be in shared memory too. I found the shmemqueue in postgres, but am having
some problems using it. I just need to have the linked list store
relation
It would be nice. keep table names short, name id columns the tablename plus id,
and let PG assign sequence names, so I can write:
set sql select currval(${tablename}_${tablename}id_seq) as lastid
in pltcl.
In other words,
create table foobar (
foobarid serial primary key,
otherfoo
I always use Steve's method (it's easier), but if you still want to do it in the sql-server way, you can use OIDs to fetch the id of the last INSERTed row.
I don't know which programming language you are using, but are some examples:
*plpgsql
DECLARE
myOid INTEGER;
identity
Tom Lane writes:
Other than me, I think you mean. dd/mm/ and mm/dd/ are
inherently ambiguous in the real world, and when you can clearly
determine what the intended meaning is, I think it's more reasonable
to assume the datestyle isn't set correctly than to reject the data.
That
Title: Eliminating start error message: unary operator expected
Hi Forum,
What should I correct in order to eliminate the following error message on start:
Executing /etc/rc.d/init.d/postgresql start ..
Starting postgresql service: -sh: [: ==: unary operator expected
[ OK ]
We installed a
On Mon, 23 Jun 2003, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
The one thing that should absolutely be turned off is day/month swapping
on dates of the form: 2003-02-22.
Agreed on that. -DD-MM isn't used in the real world AFAIK, and it's
reasonable to treat it as an
Peter Eisentraut wrote:
Tom Lane writes:
Other than me, I think you mean. dd/mm/ and mm/dd/ are
inherently ambiguous in the real world, and when you can clearly
determine what the intended meaning is, I think it's more reasonable
to assume the datestyle isn't set correctly than
scott.marlowe wrote:
On Mon, 23 Jun 2003, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
The one thing that should absolutely be turned off is day/month swapping
on dates of the form: 2003-02-22.
Agreed on that. -DD-MM isn't used in the real world AFAIK, and it's
On Mon, 23 Jun 2003, Carlos wrote:
Hi Forum,
What should I correct in order to eliminate the following error message on
start:
Executing /etc/rc.d/init.d/postgresql start ..
Starting postgresql service: -sh: [: ==: unary operator expected
[ OK ]
We installed a v7.3.2 and PostgreSQL
On Monday 23 Jun 2003 7:08 pm, Erik Price wrote:
At the bottom of an email from this list, I saw:
-(end of broadcast)-
TIP 9: the planner will ignore your desire to choose an index scan
if your joining column's datatypes do not match
If
On 23/06/2003 20:16 Carlos wrote:
Hi Forum,
What should I correct in order to eliminate the following error message
on
start:
Executing /etc/rc.d/init.d/postgresql start ..
Starting postgresql service: -sh: [: ==: unary operator expected
[ OK ]
We installed a v7.3.2 and PostgreSQL seems to be
Postgresql was installed from RPMS, downloaded from the following url:
ftp://ftp5.us.postgresql.org/pub/PostgreSQL/binary/v7.3.2/RPMS/redhat-7.
3/
The startup script was created when the rpms were installed.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
On Mon, 23 Jun 2003, Carlos wrote:
Hi Forum,
What should I correct in order to eliminate the following error message on
start:
Executing /etc/rc.d/init.d/postgresql start ..
Starting postgresql service: -sh: [: ==: unary operator expected
[ OK ]
We installed a v7.3.2 and PostgreSQL
Could you post a copy of the /etc/rc.d/init.d/postgresql file here? It
may have gotten corrupted or have a simple syntax error in it.
On Mon, 23 Jun 2003, Carlos Oliva wrote:
Postgresql was installed from RPMS, downloaded from the following url:
Hi Scott,
There it goes. I also enclosed it in a text file.
Thanks you for your help
#! /bin/sh
# postgresqlThis is the init script for starting up the PostgreSQL
# server
#
# chkconfig: - 85 15
# description: Starts and stops the PostgreSQL backend daemon that
handles \
#
On Tue, 2003-06-24 at 04:58, Matthew Nuzum wrote:
I too started doing php stuff because of the need to do a web front end for
a database. Prior to that I had no database experience at all and the
wealth of PHP/MySQL tutorials made it easy for me to learn both.
Then there are those of us who
The PostgreSQL Core would like to publicly welcome welcome Josh Berkus as
our newest member.
Josh is being included especially as a liason between the
source-programmer and non-source-programmer contributors to PostgreSQL, in
an effort to expand PostgreSQL volunteer documentation, advocacy, and
28 matches
Mail list logo