Excellent -- thanks so much for your help. I just tried the function
with the right arguments, and it worked just fine.
Yet more proof of named parameters being a good thing...
Reuven
---(end of broadcast)---
TIP 7: don't forget to increase your f
On Mon, 23 Jun 2003 15:16:28 -0400
Carlos <[EMAIL PROTECTED]> wrote:
> start:
> Executing /etc/rc.d/init.d/postgresql start ..
> Starting postgresql service: -sh: [: ==: unary operator expected
> [ OK ]
do:
ls -l /bin/sh
it is supposed to be a symlink pointing fo /bin/bash
if it's not, check
(cross-posting to HACKERS)
Reuven M. Lerner wrote:
I'm creating a new OpenACS package that uses PostgreSQL, and in doing
so have encountered what seems to be a problem in PostgreSQL.
[...snip...]
> CREATE OR REPLACE FUNCTION add_news__test
> (integer,varchar,timestamptz,varchar,varchar,varchar,
>
On Monday 23 Jun 2003 10:06 pm, Jonathan Bartlett wrote:
> Is there a link to some of these discussions?
Go to http://archives.postgresql.org/ and search for "coercion" or "implicit
coercion" or "implicit cast" or similar on the hackers list.
--
Richard Huxton
---(end
Hello,
> And, to avoid the connotation of bias, whomever writes such a
> migration
> tutorial might want to suggest using the PEAR:DB abstraction layer to
> avoid migration hassles in the future. http://pear.php.net/
I don't like very much PEAR::DB since they have a HUGE lack in the
errors mes
Nolan,
> And my pet peeve of the month is software source distributions that
> include the documentation ONLY in HTML, which is OK IF you have Apache
> running on the system you're building the sources on and are willing to
> make the documentation directory available to Apache, but otherwise
> th
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 wh
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
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 \
#
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:
> ftp://ftp5.us.postgresql.org/pub/PostgreSQL/b
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 Postgr
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 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 run
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
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 Postgr
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 AF
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 corre
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
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
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
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
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,
otherf
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 end
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
> da
> 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
--
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
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
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:
We need to use this opportunity to encourage PHP folks to switch to
PostgreSQL.
Indeed. What can we do exactly?
Hmmm... something
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
retrieve
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
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,
> Ka
Is there any
Postgresql client software for linux to connect to Postgresql database
server on linux?
Can somebody please
provide me with the links or the installables if they have them
already?
Thanks and
Regards,
Kallol
Nandi,Systems
Analyst,Indus
Software - A Division of R Systems In
32 matches
Mail list logo
