On Thu, Mar 10, 2005 at 08:17:03AM +, Eimantas Vai??i??nas wrote:
> I've recently started using PgSQL and i must say it gose quite good as far as
> i can say. Just been wondering how important is template1 database to PgSQL?
> What would happen if i drop this database together with postgres
Eimantas =?utf-8?q?Vai=C4=8Di=C5=ABnas?= <[EMAIL PROTECTED]> writes:
> Just been wondering how important is template1 database to PgSQL?
The database server itself doesn't care, but there are enough
client-side tools that assume template1 exists that you would not
find life pleasant if you do thi
Hi list,
I've recently started using PgSQL and i must say it gose quite good as far as
i can say. Just been wondering how important is template1 database to PgSQL?
What would happen if i drop this database together with postgres user.
--
Eimantas VaiÄiÅnas
VU SkaiÄiavimo centras
--
> I am interested in what people here think are good tools (free or not) for
> creating / maintaining a pg data model. A layout view for relationships is
P.S.
If you are interested in only the layout view of relationship and not
designing, a trivial, despised but useful one is M$ Access. (Sorry f
I created schema name "foo_schema" different from user name "foo".
However, when I created the schema, I had specified authorization set to
foo user.
Does that mean, if the owner of the schema and schema name are
different, then only way, is to set through alter user set or search
path correct ?
"Subbiah, Stalin" <[EMAIL PROTECTED]> writes:
> I logged into foodb as foo user and tried to create a table. Bang!
> ERROR: no schema has been selected to create in. search_path had $user,
> public the default ones, shouldn't the table get created in user's
> authorized schema.
Which one?
Now, i
Title: Schemas to Search_path
I was playing around with schemas today to understand how it would fit in our application design. I couldn't understand why I got to set search_path to schema name everytime I login to psql.
This is what I did.
-ceated a user "foo" with createdb privilege as p
Kris Kiger <[EMAIL PROTECTED]> writes:
> Here is my problem. I have a function that is triggered on insert. For
> simplicity's sake, lets say the function looks like this:
> CREATE OR REPLACE FUNCTION dostuff_on_insert() RETURNS TRIGGER AS '
> DECLARE lockrows RECORD;
> BEGIN
> select into
I guess first we should understand why the insert B waits at all,the
insert A did not commit ,right ,then how did it found any pkey_id =
NEW.pkey_id? That means you have already had those while starting your
experiment.
So ,insert B wait for those "old" rows not for your insert (i mean an
INSER
On Mar 9, 2005, at 4:24 PM, Scott Marlowe wrote:
assuming you're on an rpm based system, look for the readline-devel rpm
package and install it. Same a go for a few other packages, like
zlib-devel.
And if not and you don't need readline just use
./configure --without-readline
John DeSoi, Ph.D.
htt
On Wed, 2005-03-09 at 15:14, Gaurav Arora wrote:
> hi all
>
> please help me... I am trying to instal
> PostgreSQL 7.4.6 and when I run the command
> ./configure, I get the error...
>
> configure: error: readline library not found
>
> Please help ... !!!
assuming you're on an
hi all
please help me... I am trying to instal
PostgreSQL 7.4.6 and when I run the command
./configure, I get the error...
configure: error: readline library not found
Please help ... !!!
regards
Gaurav Arora
__
Cele
transaction_isolation
---
read committed
Running Postgres 7.4 btw
Kris
Tsirkin Evgeny wrote:
What transaction level are you using?
Evgeny.
Kris Kiger wrote:
Here is my problem. I have a function that is triggered on insert.
For simplicity's sake, lets say the function looks
What transaction level are you using?
Evgeny.
Kris Kiger wrote:
Here is my problem. I have a function that is triggered on insert. For
simplicity's sake, lets say the function looks like this:
CREATE OR REPLACE FUNCTION dostuff_on_insert() RETURNS TRIGGER AS '
DECLARE lockrows RECORD;
BEGIN
If it is necessary for you to comapre each row with a list of 26 possible values (VARIABLES) in the IN clause and not do a replacement of all values in column1 with "0" as suggested previously, you might want to place the 26000 variables in a temporary table that is either sorted physically in the
Here is my problem. I have a function that is triggered on insert. For
simplicity's sake, lets say the function looks like this:
CREATE OR REPLACE FUNCTION dostuff_on_insert() RETURNS TRIGGER AS '
DECLARE lockrows RECORD;
BEGIN
select into lockrows * from table1 where pkey_id = NEW.pkey_id f
> How tablespaces are implemented in Windows if there's no
> symbolic links?
It uses NTFS Junctions, which is bscailly symbolic links for
directories.
//Magnus
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi all,
If anyone is interested, here's the final solution
that I'm using to build a list of tables and their md5sums
based on what the psql interface queries when you do '\d [TABLE NAME]'
I attached the function I created, and this is the SQL I run :
select relname||':'||get_table_checksum(relna
How tablespaces are implemented in Windows if there's no symbolic links?
Thanks.
---(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 Wed, Mar 09, 2005 at 11:44:33 -0300,
Ricardo Valença de Assis <[EMAIL PROTECTED]> wrote:
> Hi everydoby!
>
> I have a table with more than 26000 rows and I need to use update a
> column of this tables on all lines according with a column. So, I need to
> use update 26000 times correct? I
Ken,
Table partitioning doesn't really exist, to the best of my knowledge,
but tablespaces, which are new to 8.0, allow for partitioning of data
(individual tables, indexes) across multiple locations on disk.
See
http://www.postgresql.org/docs/8.0/static/sql-createtablespace.html
-tfo
--
Thomas
Hi everydoby!
I have a table with more than 26000 rows and I need to use update a
column of this tables on all lines according with a column. So, I need to
use update 26000 times correct? I tried to use a this command:
"UPDATE database SET column1=0 WHERE column2 in (VARIABLES)", where
VARIABL
I had the same problem a few weeks ago.
Was happening that our developers using Tomcat, were using connection
pools, and stoping and restarting their aplications which causes to
leave these connection opened and opening some new.
Look in the servlet engine (or what they use) for the number of
c
|-Original Message-
|From: Goulet, Dick [mailto:[EMAIL PROTECTED]
|Sent: Montag, 07. März 2005 16:33
|To: John DeSoi; Stef
|Cc: pgsql-ADMIN@postgresql.org; pgsql-sql@postgresql.org
|Subject: Re: [SQL] [ADMIN] Postgres schema comparison.
|
|
| My favorite for this task is WinSql available f
24 matches
Mail list logo
