Quoting Mark Kirkwood <[EMAIL PROTECTED]>:
>
>
>
> >On page 7 of this document:
> >
> >"Earlier versions of Postgres were often unstable and quite often there
> were
> >even data losses. The Postgres developer team has invested a great deal of
> time
> >in regression tests, which guarantee high
> Was wondering if there are ways to completely script a new postgresql installation.
> I need to be able to create the db, users, and db elements from one command so that
> I can included it in a setup routine.
That's rather easy.
A shell script can do roughly the following:
- initdb somewher
> Thanks Doug! I got some weird errors though when trying to run a command to
> create db, create user, create elements from the pgAdmin sql editor. I was
> trying to test and in a nutshell it not allow me to create the db in the same
> script as everything else, because I seperated the parts and i
> Where do you get that impression? currval() refers to the last ID for the
> session you are in. It's also FAQ question 4.15.3. Even better, if you
> havn't used nextval() in your current session, currval() returns an error,
> so you can't even get it wrong by accident.
I stand corrected. I was
Hi,
Was wondering if there was anything akin to an evaluate statement in Postgresql for dynamic strings?
Alex
Actually, I've gotta admit I don't take my own advice. I deployed a PHP
company directory for a small company (to small to make the MS Exchange
mistake) and it was deployed on MySQL, then about 2 weeks after
completion I moved it over to OpenLDAP :)
C'est la Vie :)
T.
Hehe, yea those infamou
Mike Nolan <[EMAIL PROTECTED]> writes:
>> Where do you get that impression? currval() refers to the last ID for the
>> session you are in. It's also FAQ question 4.15.3. Even better, if you
>> havn't used nextval() in your current session, currval() returns an error,
>> so you can't even get it wro
Hi frds
Actually i have a problem, my problem is like this... i have a table A with
one column, table B with one column and table C with one column. Now i want to
create another table D which has all the three columns from table A, B,C.
Could anyone plz help me regarding this.
Thanks in advanc
hi,
I need help in using filter tag
Regards,
Krishna
Do you Yahoo!?
Yahoo! Photos - Get your photo on the big screen in Times Square
I'm installing a CMS called ezpublish on
my Redhat 9.0 machine. I've needed to install a php 4.4 and a newer postgresql (I
also installed apache2.0.48, and the later two went into the non-redhat-standard location of /usr/local).
ezpublish requires that I
run pgcrypto.sql on my database greg
Hi,
My problem is rather complex. I will try to explain it clearly (I hope !)
Sorry for my poor english.
I'm tracking change of state for entities (something than can be
monitored.)
The set of states are limited (state1 to state5.)
A table is storing the current state for each entities, and an
Has anyone found any packages for SuSE 9.0? I see there are v7.4 packages,
but no 7.4.1. I'd like those fixes and if I don't have to compile, that'd be
great.
Thanks.
--
Andy Czerwonka
---(end of broadcast)---
TIP 8: explain analyze is your fr
I need to change a varchar(32) to varchar(1024). It is a primary key
that many tables reference. How do I do this without reloading the
entire database?
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Fri, 26 Dec 2003, Russ Schneider wrote:
> I need to transfer a dump from a psql 7.3 database to a 7.2 database.
>
> Is there any way to do this?
In case anyone wants to know (or find out later searching the archives), I
was able to do this with minimal effort.
Here's what worked for me:
Ahhh. Yes. A nasty typo. I did a global search for %1, %2, %3, etc. and
turned up several elsewhere. Ouch. Thank you for your close reading.
== Ezra Epstein
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "ezra epstein" <[EMAIL PROTECTED]> writes:
> > IF NOT EXI
Hi,
Tom Lane wrote, On 12/30/2003 11:06 PM:
BTW, 7.4 also has a specialized index opclass that can be used to create
LIKE-compatible indexes even if you are using a non-C locale.
I do some tests:
PostgreSQL 7.4.1
on a varchar(255) column:
#CREATE INDEX crossref_oidx ON crossref (cr_origmark varcha
Yup,
So slow in fact that I never use it. I did once or twice and gave up.
It is ironic! I only come to the online docs when I already know the
part of my search and just go to that part or section. For
everything else, there's google!
SECURITY INVOKER site:postgresql.org
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I keep searching the web hoping someone has come up with a 'tsearch2'
> based search engine that does the spidering, but, unless its sitting right
> in front of my eyes and I'm not seeing it, I haven't found it yet :(
I wrote my own search engi
On Wed, 31 Dec 2003, Dave Cramer wrote:
> Well it appears there are quite a few solutions to use so the next
> question should be what are we trying to accomplish here?
>
> One thing that I think is that the documentation search should be
> limited to the documentation.
>
> Who is in a position to
On Sat, 3 Jan 2004, Oleg Bartunov wrote:
> On Sat, 3 Jan 2004, Joshua D. Drake wrote:
>
> > >
> > >
> > >
> > >A content management system is long overdue I think, do you have any
> > >good recommendations?
> > >
> > >
> > >
> > Bricolage
> >
>
> It's good Mason driven CMS, but Marc seems is a PHP
On Sun, 4 Jan 2004, Oleg Bartunov wrote:
> On Sat, 3 Jan 2004, Marc G. Fournier wrote:
>
> > On Sat, 3 Jan 2004, Oleg Bartunov wrote:
> >
> > > time was one of implementation of such system. This is what I hope to have on
> > > www.pgsql.ru, if Marc will give us access to mailing list archives :)
I have an embedded sql program with a while loop. I declare
and open a cursor before the while. The fetch forward next
is inside the while. The first time through the while
the cursor works perfectly the second time I get the error:
sql error PerformPortalFetch: portal "foo_crsr" not found
I h
Send it to me too please?
Dave
On Sun, 2004-01-04 at 04:34, Oleg Bartunov wrote:
> On Sat, 3 Jan 2004, Marc G. Fournier wrote:
>
> > On Sat, 3 Jan 2004, Oleg Bartunov wrote:
> >
> > > time was one of implementation of such system. This is what I hope to have on
> > > www.pgsql.ru, if Marc will gi
23 matches
Mail list logo
