It'd be great if on completion, you can publish the furnished ERD of the catalog structure, and other representation of the planner, optimizer etc.
Luckys.
On 5/22/06, Bruce Momjian wrote:
Please read the developer's FAQ on our web site. In fact the entiredevelopers se
Thanks for the reply.
> On Mon, 22 May 2006 01:05:38 -0400, Tom Lane <[EMAIL PROTECTED]> said:
> SODA Noriyuki <[EMAIL PROTECTED]> writes:
>> We've encountered failures of "make check", when we put PostgreSQL
>> data directory on a NFS filesystem or a tmpfs filesystem.
>> It doesn't always f
SODA Noriyuki <[EMAIL PROTECTED]> writes:
> We've encountered failures of "make check", when we put PostgreSQL
> data directory on a NFS filesystem or a tmpfs filesystem.
> It doesn't always fail, but fails occasionally.
Is the NFS filesystem mounted fail-soft?
As a rule, database people will tel
Hi,
We've encountered failures of "make check", when we put PostgreSQL
data directory on a NFS filesystem or a tmpfs filesystem.
It doesn't always fail, but fails occasionally.
Is this expected behavior of PostgreSQL?
If it's expected, what is the reason of this symptom?
I grep'ed the source cod
On Fri, May 19, 2006 at 12:21:28 -0700,
Siah <[EMAIL PROTECTED]> wrote:
> Some pointers could help. & any arguments pro/against saving bin data
> in db?
If you want transactional semantics you want the data in the DB. If not,
then you will probably get better perfomance if it isn't.
---
Please read the developer's FAQ on our web site. In fact the entire
developers section will help you.
---
Federico Petronio wrote:
> Hello all,
>
> as part of an University assignment, a group friends and I have to
> resea
Hello all,
as part of an University assignment, a group friends and I have to
research in PostgreSQL internals (i.e. parsing, optimizing, execution
planning, etc) and compare it with other DBMS (an educational oriented
one called MiniBase). I would like to know is you can point us to a
place where
kmh496 wrote:
> this is a forward of my problem from April.
> I have this time gone all the way and re-inited a DB from scratch,
> created a new database, documented the import procedure, set the locale
> to match but I am still having problems.
> For example, look at this match count~
> mod=# se
Some pointers could help. & any arguments pro/against saving bin data
in db?
Thanks,
Sia
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On Sun, May 21, 2006 at 06:55:18PM +0200, Tino Wildenhain wrote:
> > I have a website that has multilingual text stored in the database.
> > Currently I just have a flat table (lets called it "translations"), one
> > row per text item, one column per language. This works OK, for now, but
> > I am
Daniel McBrearty wrote:
> Hi
>
> I have a website that has multilingual text stored in the database.
> Currently I just have a flat table (lets called it "translations"), one
> row per text item, one column per language. This works OK, for now, but
> I am looking at a redesign. Mostly I want to ke
first of all, it's not -i as i wrote but \ii work under windows OS.and my script is working now.thanks for your helpMartijn van Oosterhout wrote: On Sun, May 21, 2006 at 02:59:25AM -0700, P.M wrote:> To run the script i use :> > under psql command line, i load my SQL script file via :> > psql -i m
Hi,
On Sun, 2006-05-21 at 02:25 -0700, P.M wrote:
> And when i run the SQL script, PostgreSQL stops just on first
> errorso if user does not exist, my script is not any longer
> run :-(
I think you are running your query inside a transaction. Remove the
BEGIN and COMMIT parts...
--
The Pos
On Sun, May 21, 2006 at 02:59:25AM -0700, P.M wrote:
> To run the script i use :
>
> under psql command line, i load my SQL script file via :
>
> psql -i myfile;
Don't know what -i does, it's not a supported option, perhaps you mean
-f?
In any case, my version of postgres 7.4.7 works fine:
$ c
To run the script i use :under psql command line, i load my SQL script file via :psql -i myfile;Martijn van Oosterhout wrote: On Sun, May 21, 2006 at 02:25:44AM -0700, P.M wrote:> Thanks Martijn, but i'm currently working on the SQL script to create the full database. Not on some stored procedure.
On Sun, May 21, 2006 at 02:25:44AM -0700, P.M wrote:
> Thanks Martijn, but i'm currently working on the SQL script to create the
> full database. Not on some stored procedure.
>
> And when i run the SQL script, PostgreSQL stops just on first
> errorso if user does not exist, my script is not
Thanks Martijn, but i'm currently working on the SQL script to create the full database. Not on some stored procedure.And when i run the SQL script, PostgreSQL stops just on first errorso if user does not exist, my script is not any longer run :-(do you have any idea how to pass over this issue
On Sun, May 21, 2006 at 02:08:38AM -0700, P.M wrote:
> Hi,
>
> How under postgreSQL 7 do the equivalent as DROP USER / ROLE IF EXISTS ?
> my web provider only support postgreSQL 7 :-(
Do the DROP USER and ignore the error if it doesn't exist.
--
Martijn van Oosterhout http://svana.org/klep
Hi,How under postgreSQL 7 do the equivalent as DROP USER / ROLE IF EXISTS ?my web provider only support postgreSQL 7 :-(thanks a lot,Maileen
Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice.
19 matches
Mail list logo