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
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andy Shellam
(Mailing Lists)
Sent: Monday, February 26, 2007 10:56 AM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] host name?
Igor Neyman wrote:
Is there a function (or catalog view) that I can call
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 wrote:
You
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 wrote
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 PROTECTED] On
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
Sundaram
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
Hi
Im
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 executes it.
Pretty simple solution.
Igor Neyman
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:22 AM
Look up dblink(...) function in PG documentation:
http://search.postgresql.org/search?u=%2Fdocs%2F8.2%2Fstatic%2Fq=dblink
Igor Neyman
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Raul Retamozo
Sent: Wednesday, June 06, 2007 7:09 PM
To: pgsql
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
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 Behalf Of Alexander B.
Sent:
It is called update:
UPDATE table_name SET column1 = NULL, column2 = NULL, column2 =
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
Why not use information_schema?
select prk.table_name AS PARENT_TABLE, prk.constraint_name AS PK,
tc.table_name AS CHILD_TABLE, refc.constraint_name AS FK
from information_schema.table_constraints prk,
information_schema.referential_constraints refc,
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
Eric,
Don't be so defensive.
Here is an abstract from documentation:
8.1.4. Serial Types
The data types serial and bigserial are not true types, but merely a
notational convenience for setting up unique identifier columns (similar
to the AUTO_INCREMENT property supported by some other
I'm trying to install 8.3.1 (binaries) on Win2003 using windows
installer (msi).
I'm runnning silent install with:
ADDLOCAL=server,psql,pgadmin,psqlodbc,nls
and I'm getting error message saying, that psqlodbc is not included in
the package.
When I exclude odbc:
I'm trying to install 8.3.1 (binaries) on Win2003 using windows
installer (msi).
I'm runnning silent install with:
ADDLOCAL=server,psql,pgadmin,psqlodbc,nls
and I'm getting error message saying, that psqlodbc is not included in
the package.
When I exclude odbc:
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
Subject: [ADMIN] Postgres
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: [ADMIN] Prent-Child
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
-Original Message-
From: [EMAIL
When I run VACUUM ANALYZE (or vacuumdb -z) on the database, how can
I exclude specific tables from being analyzed?
Igor
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
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
έγραψε:
Hi ,
What is the Oracle's Long data type equivalent data type
in Postgresql ?
int8 i guess
Regards,
Ravi katkar
--
Achilleas Mantzios
No, it's bytea (and not int8).
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
)
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 iney...@perceptron.com writes:
I'm testing 8.4.4 (on Windows
-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 -0400, Igor Neyman wrote:
Igor
-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/6/10, Igor Neyman iney...@perceptron.com
-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
Glyn Astill glynast...@yahoo.co.uk
-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 iney...@perceptron.com writes:
Attached are couple smallish files
-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 iney...@perceptron.com writes:
Attached is script that could
, in short there is no easy way around.
When source table is modified, destination table and trigger function
should be also modified.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
proper configuration (that allows network
connections) in your pg_hba.conf file?
Regards,
Igor Neyman
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
Data Source (or User) - not File
Data Source.
Regards,
Igor Neyman
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
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 granted to the
account specified in PG service properties.
Regards,
Igor Neyman
--
Sent via pgsql-admin
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,
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
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
.
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 via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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_catalog tables
this error with exception handler inside
senddatato(...) function?
See PG docs:
http://www.postgresql.org/docs/9.2/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
.
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
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 list (pgsql-admin@postgresql.org)
To make changes
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
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
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
54 matches
Mail list logo
