Hi
I would like to know if there is some way how to disable case
sensitivity in PostgreSQL server. With some varaiable or some setting
in configuration file or how?
So after this would be the same 'Good' and 'GOOD' or 'GoOd' in some
SELECT from table where username='Good'. I wanna get the same
; '.
PostgeSQL version is 7.2.3.
I've nowhere found isuch syntax in the net (I mean with dot -
'public.funcname(...)').
There is plpgsql only in the database;
When I try
./createlang -dbname=mydb sql
it says "unsupported language".
But SELECT * FROM pg_languag
Hello Tom,
Thank you very much for such fast reply.
But now, after I've installed 8.0.1, it says things as examples in
little attach.
<--
Where I have to dig?.. :(
Sunday, March 06, 2005, 2:38:26 AM, you wrote:
TL> Igor Radtchenko <[EMAIL PROTECTED]> writes:
&
Is there a function (or catalog view) that I can call in psql and that
will tell me host name of the machine on which Postgres database is
running?
Igor
And one more question.
Is there a way (function/view) to find machine name on which user
program (connected to Postgres) runs?
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Igor Neyman
Sent: Monday, February 26, 2007 10:29 AM
To: pgsql
You are right, wrong question.
What I really want to know is formulated in my next message.
Which is: based on program (connected to PG) name find the machine name
it runs on.
For those familiar with Oracle, it's program, machine columns in
v$session view.
Right, I looked at pg_stat_activity, but besides having ip address
(instead of machine name), it doesn't have clent program name connected
to PG.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ray Stell
Sent: Monday, February 26, 2007 12:53 PM
To:
PM
To: Igor Neyman
Cc: Andy Shellam (Mailing Lists); pgsql-admin@postgresql.org
Subject: Re: [ADMIN] host name?
not sure how to resolve the name, but maybe this is close
enough:
select usename, client_addr from pg_catalog.pg_stat_activity;
On Mon, Feb 26, 2007 at 11:47:13AM -0500, Igor Neyman
Why wouldn't you look at the definition of the view which is based on
this table (and which you claim is still working), and how it references
basic table?
M.b. it'll point you to the actual table location.
Igor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PRO
Obviously, you are coming from "Oracle world. In PG according to:
http://www.postgresql.org/docs/current/static/errcodes-appendix.html
exception WHEN no_data THEN ...
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Karthikeyan
Sun
Lookup "dblink" in postgres documentation.
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 10:00 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Copying schemas between databases
ID
AS $$ ' || exec_string || ' $$LANGUAGE PLPGSQL;' ;
PERFORM any_block();
RETURN TRUE;
END;
$THIS$LANGUAGE PLPGSQL;
to which I pass my "anonymous" block as a parameter.
As you can see, this function creates/replaces "on the fly" function
"any_block()" and
More important question would be, why would you want to do this (change columns
order)?
I can't think of any valid reason for this.
Igor Neyman
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erwin
Brandstetter
Sent: Wednesday, June 06, 2007 11:
Look up dblink(...) function in PG documentation:
http://search.postgresql.org/search?u=%2Fdocs%2F8.2%2Fstatic%2F&q=dblink
Igor Neyman
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Raul Retamozo
Sent: Wednesday, June 06, 2007 7:09 P
This document:
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
could answer some of your questions.
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Tokmatchi
Sent: Monday, June 18, 2007 11:55 AM
To: [EMAIL
ALTER TABLE tableName ADD CONSTRAINT pkname_pkey (column1, column2,
...);
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jessica Richard
Sent: Tuesday, July 17, 2007 2:44 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Can primary key be dropped
Index will not be used if your string has "wild card" (%) in the
beginning.
It should be used, if you change your query to:
select *
from tb_gen_person
where pes_name like 'albert%';
Igor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On B
It is called "update":
UPDATE SET = NULL, = NULL, =
NULL;
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of smiley2211
Sent: Thursday, August 09, 2007 10:27 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Delete COLUMN data
Hello all,
I need to D
N KEY'
and tc.table_catalog = refc.constraint_catalog
order by prk.table_name , tc.table_name;
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Hoover
Sent: Thursday, August 16, 2007 11:19 AM
To: pgsql-admin@postgresql.org Admin
Subjec
Yes, PG allows compound or composite keys for primary keys.
Igor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Carol Walter
Sent: Wednesday, September 19, 2007 10:37 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Primary key
Hello,
Does postgres
ping
the column, but this will force removal of the column default
expression. "
which proves that you don't understand "serial" data type.
Igor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erik Aronesty
Sent: Thursday, Novembe
In our organization, we are running multiple databases on the same box on
the default port. However, they all have their own data directories and they
listen on different VIP's. Here are the parameters in postrgresql.conf to
make it work:
unix_socket_directory = 'data directory for a particular DB
c:
ADDLOCAL=server,psql,pgadmin,nls
install works fine.
Is it true that odbc was excluded from 8.3.1 Windows distribution
package?
Should I change my scripts to run separate odbc install?
I didn't have this problem with 8.2: odbc was in cluded along with
everything else.
Thanks in advance,
Igor
c:
ADDLOCAL=server,psql,pgadmin,nls
install works fine.
Is it true that odbc was excluded from 8.3.1 Windows distribution
package?
Should I change my scripts to run separate odbc install?
I didn't have this problem with 8.2: odbc was in cluded along with
everything else.
Thanks in advance,
Igor
"stats_start_collector" is an obsolete parameter in 8.3, that's why PG
wouldn't start with it.
Igor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of bogdad
Sent: Wednesday, July 02, 2008 2:38 PM
To: pgsql-admin@postgresql.org
Subje
First do:
DROP OWNED BY user1;
then:
drop role user1;
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rex Mabry
Sent: Tuesday, July 08, 2008 12:45 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] dropping a user in 8.2.6
I am using
First you get to Postgresql docs, from there you get anywhere you want.
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gibson
Chimhamhiwa
Sent: Wednesday, July 23, 2008 11:10 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Query a
Read the docs on "connectby" function provided by "tablefunc" contrib
module.
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gibson
Chimhamhiwa
Sent: Friday, July 25, 2008 7:43 AM
To: pgsql-admin@postgresql.org
Subject:
If you could declare a Foreign Key on two columns in "history" table
referencing "master" table, and declare this FK with "ON UPDATE CASCADE"
option, then postgres will update status in history table for you
whenever you update status in master table.
Igor
-Orig
When I run "VACUUM ANALYZE" (or "vacuumdb -z") on the database, how can
I exclude specific tables from being analyzed?
Igor
Hello everybody!
I have many app servers using connection pooling. At any time, there are
about 1000 total connection to the database from all the app servers;
however, only few random connections are active.
The application often executes relatively big sorts. The work_mem size is
32MB, and event
.
So, eventually enough sessions get big work memory allocated to starve the
Linux out of memory.
My physical memory size is 32GB,
Shared_buffers = 2GB
On 6/15/09 2:13 PM, "Scott Marlowe" wrote:
> On Mon, Jun 15, 2009 at 2:15 PM, Igor Polishchuk wrote:
>> Hello everybody!
>
Alvaro,
Why don't you just create a sql script with a separate vacuum command for each
table you need to vacuum?
-Original Message-
From: pgsql-admin-ow...@postgresql.org on behalf of Anj Adu
Sent: Sun 11/1/2009 8:03 AM
To: Alvaro Herrera
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADM
Hello,
Let's say TableA has "toastable" column, the contents of this column is
stored in let's say pg_toast_1234.
Is there a query to find which records (chunk_id, chunk_seq) in
pg_toast_1234 store data for specific record in TableA (i.e. with PK
column value eq. '567')?
Igor Neyman
Is there a document desribing (ar at least listing) new/obsolete
configuration parameters in postgresql.conf, when upgrading from version
to version?
Regards,
Igor Neyman
tionality?
>
> Mike
>
Partition your MESSAGES table by week or month (read on table
partitioning in PG docs).
Pg_dump "old" purtitions from "current" server, when they are not needed
any more.
Move backups of dumped partitions to your "auxilary" server, and
pg_restore them there.
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
28 May 2010 11:45:17 ο/η Ravi Katkar έγραψε:
> > Hi ,
> >
> > What is the Oracle's Long data type equivalent data type
> in Postgresql ?
> >
>
> int8 i guess
>
> > Regards,
> > Ravi katkar
> >
> >
> >
> >
>
>
ot;old" backups (created with older pg_dump version)
is that I'm trying to save time during upgrade, and I have these big
backup files already created.
TIA,
Igor Neyman
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Tuesday, June 22, 2010 10:37 AM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> "Igor Neyman" writes:
> &g
> -Original Message-
> From: John Rouillard [mailto:rou...@renesys.com]
> Sent: Tuesday, June 22, 2010 11:52 AM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> On Tue, Jun 22, 2010 at 11:05:02AM
> -Original Message-
> From: Glyn Astill [mailto:glynast...@yahoo.co.uk]
> Sent: Tuesday, June 22, 2010 12:36 PM
> To: John Rouillard; Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> --- On Tue, 22/
> -Original Message-
> From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
> Sent: Tuesday, June 22, 2010 12:40 PM
> To: Igor Neyman; John Rouillard; Glyn Astill
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Tuesday, June 22, 2010 1:10 PM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> "Igor Neyman" writes:
> > Attac
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Tuesday, June 22, 2010 2:41 PM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> "Igor Neyman" writes:
> > Atta
the change in
the original "filter" table, but also your history table "old_filter" should be
modified as well: new column should be added.
So, in short there is no "easy" way around.
When "source" table is modified, "destination" table and
Do you have proper configuration (that allows network
connections) in your pg_hba.conf file?
Regards,
Igor Neyman
th the developers if you want to have reproduceable ddl
> changes in all your systems that match the code changes.
>
Completely agree with Scott.
Only want to add that in this kind of development environment:
development/test/production -
Source code versioning software is absolute necessity (there are many:
CSV, SourceSafe, Perforce, ... - pick your choice).
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
]
You need to create "System Data Source" (or User) - not "File
Data Source".
Regards,
Igor Neyman
to
get SELECT privileges on data dictionary views.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
QL/8.4/data" -w
Could it be that account used to start PG service doesn't have
privileges to "run as a service"?
Check in "Local Security Settings" under "Local Policies"/"User Rights
Assignments" - make sure that "Log on as a service" grant
ing GmbH http://www.bfk.de/
> Kriegsstraße 100 tel: +49-721-96201-1
> D-76133 Karlsruhe fax: +49-721-96201-99
PgBouncer is the easiest piece of software to install and to manage I've ever
dealt with, and it's very light on system resources.
Regards,
Ig
> Lutz
No, it is not possible.
But, inside log file you can use %d for "log_line_prefix" to specify
which db emitted particular line.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
s in a very short
time, and start using them, while postponing to run "VALIDATE CONSTRAINT" for
later.
It's similar to Oracle's adding FK with "NOCHECK" option, but if IRC there is
no need to run "VALIDATE CONSTRAINT" later.
Regards,
Igor Neyman
--
Sent v
Can you please help with advice?
I need to design a solution for a database which will grow and will require
a horizontal split at some moment.
Here is how I am planning to do it: Every record in every table has a shard
number. After the database becomes too large (gets too many requests), the
[mailto:liuhaif...@live.com]
Sent: May-29-12 9:13 PM
To: Igor Shmain
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Data split -- Creating a copy of database without
outage
Why not use a partitioned table? You can write a trigger to control which
partition the coming data should be insert
Thank you Craig and thank you Amador for your great help!
Craig's ideas are very useful - I definitely want to look deeper into
Londiste and to use partitioning.
Amador's approach makes perfect sense to me.
Best wishes,
-igor
it is also called premature optimization :-) And you
know what, it does not look like too much extra work now :-)
If you see real or potential problems in this logic, or heard about similar
implementations, please mention that. I would appreciate it very much.
Best wishes,
-igor
, please let me
know. If I cannot find a suitable prototype and has to "invent the wheel", I
hope to be able to contribute back to the community with my story one day.
Thank you once again,
-igor
From: Jan Nielsen [mailto:jan.sture.niel...@gmail.com]
Sent: June-02-12 11:00 P
Thank you, Kevin, for this detailed info. It was very helpful.
Best wishes,
-igor
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: June-06-12 12:39 PM
To: Igor Shmain; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Data split -- Creating a copy of
Hi,
Where in pg_catalog I can find, if the table was created as "unlogged" (or not)?
As in: create unlogged table t1(c1 int);
I can't seem to find this info in pg_catalog tables/views.
Tried psql with -E to describe (\d) unlogged table, but it was not helpful.
Regards,
Igor Neyman
From: Igor Neyman
Sent: Tuesday, November 06, 2012 4:09 PM
To: pgsql-admin@postgresql.org
Subject: unlooged tables
Hi,
Where in pg_catalog I can find, if the table was created as "unlogged" (or not)?
As in: create unlogged table t1(c1 int);
I can't seem to find this info in pg
END IF;
RETURN NEW;
RAISE NOTICE 'gravado local!';
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION teste_after_insert()
OWNER TO postgres;
--
------
Thomaz Luiz Santos
Linux User: #359356
http://thomaz.santos.googlepages.c
to your Postgres database.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ng a single SELECT or
> possibly read the data into a temporary table for processing?
>
> Regards,
> Ken
>
Hi Ken,
So, it means that number of (different) foreign tables joined in single select
cannot exceed 10, right?
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing
command and I read in the docs the
one reason to use reindex is when a table is bloated.
But how do I know when a table is bloated?
You could use PGSTATTUPLE extension, which you could read about here:
http://www.postgresql.org/docs/9.2/static/pgstattuple.html
Regards,
Igor Neyman
--
Sent via
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 10:42 AM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
On Thu, May 30, 2013 at 11:16 AM, Igor Neyman wrote:
From: pgsql-admin-ow...@postgresql.org
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 11:10 AM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
Well, so I need to do reindex frequentely in database? Is that right?
Or should I use cluster, as
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 12:04 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
I have some tables that I do a lot of updates, deletes and inserts.
So I am worried that my
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 2:24 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
I am using the defualt values for autovaccum.
How do you suggest to tune the autovacuum?
If the
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 2:50 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
Well, maybe I am.
But I am worried because I know that there are some tables that do lots of
tovacuum workers you have? Does this long-running autovacuum
prevent other tables from being vacuumed in-time?
Is there some other long running transaction involving this table and
preventing autovacuum from doing its job?
Regards,
Igor Neyman
Regards,
--
Sent via pgsql-admin mailing list (p
gsql,
not pure sql, could be used only inside plpgsql function in 8.3.
OTOH, starting with 9.0 you can use anonymous plpgsql blocks, and get what you
asked for.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
hr values are defaults.
>
> System:
> RAM 74 GB
> PostgreSQL 9.1.9, Debian 6
> Database size on disc: 84 GB data + 23 GB indexes. Different LVMs on RAID
> 10.
>
>
> --
> Best regards
Did you try using any kind of connection pooler, e.g. PgBouncer?
Should help.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
> -Original Message-
> From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
> ow...@postgresql.org] On Behalf Of Viktor
> Sent: Wednesday, October 02, 2013 4:12 AM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Random server overload
>
> On 10/1/2
Title: Gareth Stationery
Hey all!
I'm muddled up about
something.
I'm creating a new database, and absolute
paths are disallowed.
Therefore I su to postgres ( the owner of
the service ) and run the following:
export PGDATA2=/bla/bla/bla
initlocation PGDATA2
initloca
Is there any way to prevent superuser to acces the
database ?
I mean something like "GRANT /
REVOKE CONNECT" MECHANISM
I have no idea how to prevent root from access data
in one of this ways :
root @ linux:~#su
- postgres
postgres @
linux:/usr/local/pgsql/bin$pg_dump
or
e
>
> edit *pg_hba.conf *>
> # Allow any user on the
local system to connect to any>
> # database under any
username, but only via an IP connection:>
>
host
all
127.0.0.1 255.255.255.255
trust >
> # The same, over
Unix-sock
> They can just read the raw database files as
well.
wow I'm not sure
how about this
edit pg_hba.conf
# Allow any user on the local system to connect to
any # database under any
username
local
all
trust
su -
> Next your going to ask what will stop root
from stopping your> PostgreSQL, compiling a second copy with
authentication disabled and> using your data directory as it's source
:)
He he i'm enough paranoic :))
> If you want to prevent root from
accomplishing these things, you're> going to h
> Next your going to ask what will stop root from stopping your
> PostgreSQL, compiling a second copy with authentication disabled and
> using your data directory as it's source :)
He he somebody can blow up ur home with C4, but this don't stop you from
locking ur door !?!
-
>I also installed iodbc like in the howto ...
You need iodbc only if you establish an ODBC connection from ur linux
box
> The problem comes into play when
i try to establish a tcp/ip
connection from windows
The point is tcp/ip
postmaster -i
-i option aloow accept tcp/ip
connections
[EMAIL PROTECTED] wrote:
> Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> on a RH6.2 install.
>
> I have a few questions on it and the use of the -E flag.
>
> 1 - can 7.0.2 be optimized for i686 architecture or is
> it only possible to compile for i386 architecture?
Yes. Chang
Max Pyziur wrote:
> On Thu, 31 Aug 2000, Igor N. Avtaev wrote:
>
> > [EMAIL PROTECTED] wrote:
> >
> > > Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> > > on a RH6.2 install.
> > >
> > > I have a few questions on
to stderr:
FATAL: 1Memory exhausted in AllocSetAlloc()
Please, tell me - what can I do?!
--
DBMS: PostgreSQL 7.0.2
OS:SCO UnixWare 2.1.3
Machine: HP Netserver E30, Pentium 166, 128Mb RAM, 4Gb and 9Gb Wide-SCSI
HDD
result have any N
rows!
--
*** Second trouble:
I can't compile PostgreSQL 7.0.3 (and 7.0.2) with ODBC support.
UnixWare C compiler not understand comment: "//"
Compiler understand only brackets of comment "/*" and "*/".
I can't change all comments! :-(
Best regards,
Igor Avtaev
querie times/performance on table
z_table be faster if this table was created on the 1st_schema ?
How does postgres make this search on the
search_path to find where a table is in?
Thanks for your help, cya!
Regards,
Igor--[EMAIL PROTECTED]
Hi,
Thanks, I did it using alter database and worked fine.
Thanks for all!
Regards,
Igor
--
[EMAIL PROTECTED]
- Original Message -
From: "Jaime Casanova" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 14, 2004 1:19 PM
Subject: Re: [ADMIN] Databas
Thanks!
Regards,
Igor--
[EMAIL PROTECTED]
using it in my
development environment, around 80 tables but just a few megabytes of data
(it's development). Is anyone here using it in a real world application by
now?
Regards,
Igor
--
[EMAIL PROTECTED]
- Original Message -
From: "Heather Johnson" <[EMAIL PROTECTED]>
89 matches
Mail list logo
