Thanks guys!
Yes, 8.3.3 binaries got installed in /usr/local/pgsql/bin and so the
7.3 version that I had previously didn't get overwritten. Binaries for
7.3 were in /usr/local/bin
Works now.
Regards,
Manoj Patwardhan
On Aug 3, 2008, at 12:17 AM, Tom Lane wrote:
John DeSoi <[EMAIL PROTEC
"Ismael " <[EMAIL PROTECTED]> writes:
> I have a function declared as follows
> CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importepago1
> numeric, fechapago1 DATE, concepto1 character varying, tipopagonomina1
> character varying, comentarios1 character varying)
> RETURNS integ
John DeSoi <[EMAIL PROTECTED]> writes:
> On Aug 2, 2008, at 7:13 PM, Manoj Patwardhan wrote:
>> bash-3.2$ initdb -D /usr/local/pgsql/data
>> dyld: Library not loaded: /usr/local/pgsql/lib/libpq.4.dylib
>> Referenced from: /usr/local/bin/initdb
> Could be a path problem. Try
Yeah ... the reference
On Aug 2, 2008, at 7:13 PM, Manoj Patwardhan wrote:
bash-3.2$ initdb -D /usr/local/pgsql/data
dyld: Library not loaded: /usr/local/pgsql/lib/libpq.4.dylib
Referenced from: /usr/local/bin/initdb
Reason: image not found
Trace/BPT trap
Any ideas? This is on Mac OS 10.5.4. What I see in /usr/lo
I downloaded version 8.3.3 and after a successful build from source
and an install, I tried to create a database cluster. I got the
following error:
bash-3.2$ initdb -D /usr/local/pgsql/data
dyld: Library not loaded: /usr/local/pgsql/lib/libpq.4.dylib
Referenced from: /usr/local/bin/initdb
On Sat, Aug 2, 2008 at 9:14 AM, johnf <[EMAIL PROTECTED]> wrote:
> I wonder if he talking about pgadmin3? It's on the menu.
Only J.M. knows for sure...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
Marco Bizzarri wrote:
> Hi all.
>
> I need to keep a numer of counters in my application; my
counters are
> currently stored in a table:
>
> name | next_value | year
>
>
> The counters must be progressive numbers with no holes in between
> them, and they must restart from 1 every year. What I've
sorry, just discovered the answer, only need to cast the value like this
String sql = "SELECT * FROM insertaEgreso(?, ?, ?::DATE, ?, ?, ?)";
pst.setDate(3, date);
:)
>
>
> I have a function declared as follows
> CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importe
I have a function declared as follows
CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importepago1
numeric, fechapago1 DATE, concepto1 character varying, tipopagonomina1
character varying, comentarios1 character varying)
RETURNS integer ASimplementation
notice the field "fech
Hi chaps,
I'm still trying to get postgres working on my qube2 with debian. I've
downgraded it to sarge, and it's a little better, however now when compiling I
get "functions.o: file not recognized: File truncated"
http://privatepaste.com/3f1j0tI0ow
Any ideas?
--- On Tue, 22/7/08, Glyn Astil
On Fri, Aug 1, 2008 at 4:49 PM, Alex Vinogradovs
<[EMAIL PROTECTED]> wrote:
> It's all about number of repetions. If say I load my table
> with 50k every minute, and run reindex every minute, how
> long do you think it would take by end of the day, when
> my table (it's daily partition actually) is
On Saturday 02 August 2008 01:12:35 am Craig Ringer wrote:
> John Meyer wrote:
> > Especially when I haven't edited anything yet?
>
> You might want to tell the readers here just a *little* bit more about
> your problem.
>
> Start with "what menu?!?".
>
> More seriously:
>
> - What is your operatin
On Sat, Aug 02, 2008 at 09:23:31AM +0200, Marco Bizzarri wrote:
> Hi all.
>
> I need to keep a numer of counters in my application; my counters
> are currently stored in a table:
>
> name | next_value | year
>
> The counters must be progressive numbers with no holes in between
> them, and they m
On Sat, Aug 2, 2008 at 11:04 AM, Craig Ringer
<[EMAIL PROTECTED]> wrote:
> Marco Bizzarri wrote:
>> Thanks for the advice, Craig.
>>
>> I'm on a number of different PostgreSQL versions, ranging from 7.4 to
>> 8.3, so I've to retain, where possible, compatibility with older
>> versions.
>>
>> Is thi
On 02/08/2008 07:22, Yi Zhao wrote:
CONTEXT: COPY htmlcontent, line 312807: "1207327 "-//W3C//DTD
HTML 4.0 Transitional//EN">\n\n\n
Would there perchance be tabs embedded in the HTML that might confuse COPY?
Ray.
--
Raymond O'
> Especially when I haven't edited anything yet?
Because you might want to.
--
GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
Marco Bizzarri wrote:
> Thanks for the advice, Craig.
>
> I'm on a number of different PostgreSQL versions, ranging from 7.4 to
> 8.3, so I've to retain, where possible, compatibility with older
> versions.
>
> Is this better on a transaction/serialization point of view?
As far as I know it's no
Thanks for the advice, Craig.
I'm on a number of different PostgreSQL versions, ranging from 7.4 to
8.3, so I've to retain, where possible, compatibility with older
versions.
Is this better on a transaction/serialization point of view?
Regards
Marco
On Sat, Aug 2, 2008 at 10:19 AM, Craig Ringer
Marco Bizzarri wrote:
> Hi all.
>
> I need to keep a numer of counters in my application; my counters are
> currently stored in a table:
>
> name | next_value | year
>
>
> The counters must be progressive numbers with no holes in between
> them, and they must restart from 1 every year. What I'v
John Meyer wrote:
> Especially when I haven't edited anything yet?
You might want to tell the readers here just a *little* bit more about
your problem.
Start with "what menu?!?".
More seriously:
- What is your operating system
- What is the version of your operating system
- What version of Pos
Hi all.
I need to keep a numer of counters in my application; my counters are
currently stored in a table:
name | next_value | year
The counters must be progressive numbers with no holes in between
them, and they must restart from 1 every year. What I've done so far
is to access them while in S
21 matches
Mail list logo
