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
Easy: you've got 3 Ifs without END IF:
IF uppergt = 'BOD' THEN RETURN 0 ;
IF uppergt = 'MOD' THEN RETURN 86400/2 ;
IF uppergt = 'EOD' THEN RETURN 86399 ;
Igor
-Original Message-
From: Ralph Smith [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2008 3:19 PM
To:
Read about dynamic sql in Postgres documentation (EXECUTE statement):
http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html
Igor
-Original Message-
From: Anderson dos Santos Donda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2008 9:10 PM
To:
-Original Message-
From: Dmitry Teslenko [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2008 6:57 AM
To: pgsql-general@postgresql.org
Subject: Strange query plan
Hello!
I have following table:
CREATE TABLE table1 (
field1 INTEGER NOT NULL,
field2 INTEGER NOT
objective.
Igor Neyman
-Original Message-
From: Gauthier, Dave [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2008 11:14 PM
To: pgsql-general@postgresql.org
Subject: That was easy
I just ported my whole DB instance, 4 db's inside with roles, triggers, stored
procedures, etc... from
.Key, however what if I want to do the reverse?
I want to ensure Table1.ColA does NOT exist in Table2.Key.. Can I do
this with any sort of CHECK constraint, trigger, custom function, etc?
Thanks!
Mike
Trigger (with corresponding trigger function) will definitely do the
job.
Regards,
Igor
://people.collaborativefusion.com/~wmoran/
Use pg_get_keywords(OUT word text, OUT catcode char, OUT catdesc text)
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
?
--
Regards,
Condor
double precision is imprecise data type, that's why you see what you see.
If you want to avoid your problem, switch to NUMERIC(precision, scale), which
is precise data type.
Alter the type of your double columns.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list
they are, they definitely have their use when properly implemented with
specific purpose.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: Gregg Jaskiewicz [mailto:gryz...@gmail.com]
Sent: Friday, September 30, 2011 5:18 AM
To: Igor Neyman
Cc: Ondrej Ivanič; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Rules going away
speaking of DO INSTEAD, for insert/update case. Try using RETURNING
in this discussion.
But I think, your problem is right here:
running VACUUM FULL pg_largeobject
If you are running VACUUM FULL ... on the table, you should follow it with
the REINDEX TABLE ..., at least on PG versions prior to 9.0.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql
-Original Message-
From: Stefan Keller [mailto:sfkel...@gmail.com]
Sent: Friday, January 06, 2012 1:12 AM
To: Igor Neyman
Cc: Simon Windsor; pgsql-general@postgresql.org
Subject: Re: Vacuum and Large Objects
Hi Igor
2011/12/16 Igor Neyman iney...@perceptron.com wrote: But I
Stefan,
-Original Message-
From: Stefan Keller [mailto:sfkel...@gmail.com]
Sent: Friday, January 06, 2012 1:12 AM
To: Igor Neyman
Cc: Simon Windsor; pgsql-general@postgresql.org
Subject: Re: Vacuum and Large Objects
Hi Igor
2011/12/16 Igor Neyman iney...@perceptron.com wrote
.
For last 5 years we are running PG on many, many (hundreds) servers
under WIN, and we have no complains regarding PG stability.
Regards,
Igor Neyman
From: Serge Fonville [mailto:serge.fonvi...@gmail.com]
Sent: Friday, February 24, 2012 11:07 AM
To: mgo...@isstrucksoftware.net
Cc
or _int2 (or whatever
integer length you need).
No need to create new type.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to add
explicit type casts.
Context: SQL function _pg_keysequal during inlining
I don't have more recent 8.4 releases to try it on.
It works fine on PG 9.1.3.
Did anyone else experienced this problem?
Regards,
Igor Neyman
information_schema.referential_constraints;
against information_schema.referential_constraints work without errors.
Sorry, for the noise.
Igor Neyman
From: Igor Neyman
Sent: Friday, July 27, 2012 9:27 AM
To: pgsql-general@postgresql.org
Subject: information_schema.referential_constraints broken?
This query:
select * from
out what relation it belongs to?
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: Evan D. Hoffman [mailto:evandhoff...@gmail.com]
Sent: Wednesday, May 08, 2013 3:35 PM
To: Igor Neyman
Subject: Re: [GENERAL] pg_upgrade fails, mismatch of relation OID -
9.1.9 to 9.2.4
Looks like it IS the same OID every time, referencing an index. I
-Original Message-
From: Evan D. Hoffman [mailto:evandhoff...@gmail.com]
Sent: Wednesday, May 08, 2013 4:22 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_upgrade fails, mismatch of relation OID -
9.1.9 to 9.2.4
Well, each time it fails it refers
the case:
UPDATE tbl1 t1
SET col3 = t2.col3, col4 = t2.col4, col5 = t2.col5
FROM tbl2 t2
WHERE t1.col1 = t2.col1
AND t.col1 = criteria;
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
vacuum and autovacuum
running at the same time, each requesting 2GB (your current setting).
3. Use connection pooling software (e.g. PgBouncer) and reduce max_connections.
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
-Original Message-
From: Ioana Danes [mailto:ioanasoftw...@yahoo.ca]
Sent: Tuesday, May 14, 2013 10:30 AM
To: Igor Neyman; PostgreSQL General
Subject: Re: [GENERAL] Running out of memory on vacuum
Hi Igor,
1. I could remove the nightly vacuum but I think
-Original Message-
From: Ioana Danes [mailto:ioanasoftw...@yahoo.ca]
Sent: Tuesday, May 14, 2013 11:29 AM
To: Igor Neyman; PostgreSQL General
Subject: Re: [GENERAL] Running out of memory on vacuum
Hi Igor,
I don't need the manual vacuum. I just don't want to remove it now
. However, I'd
suggest to try the --check at first of pg_upgrade.
--
Why?
Do you have specific experience, when link mode caused any problems?
Could you share?
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Lonni J Friedman
Sent: Thursday, May 16, 2013 2:23 PM
To: Igor Neyman
Cc: AI Rumman; Fabio Rueda Carrascosa; pgsql-general
Subject: Re: [GENERAL] pg_upgrade link
it started)
--
john r pierce 37N 122W
somewhere on the middle of the left coast
Look for bitrock_installer.log in the
\Users\account_you_are_using\AppData\Local\Temp.
Or just do search for bitrock_installer.log file.
Igor Neyman
--
Sent via pgsql-general
12:49 PM, Igor Neyman wrote:
Look for bitrock_installer.log in the
\Users\account_you_are_using\AppData\Local\Temp.
Or just do search for bitrock_installer.log file.
ahhh. two weirdnesses below...
A) why is it using 'myusername' (the account I ran the installer from) instead
, and those are per database, not per schema.
On the other hand, MS SQL Server has Transaction Logs, and they are per
database.
Still, I don't quite understand, what goal original poster is trying to achieve.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general
cannot be made a member of itself
SQL state: 42P16
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
If autovacuum was disabled one of the elements of the array will be:
'autovacuum_enabled=false'.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
with client for a few times till all the data
is transferred?
Best Regards
No, PG does not have feature similar to Oracle's Resource Manager.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
. But the way, if users is using Windows, is the link option still works?
Thanks,
Patrick
It definitely works.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
considering that my whole upgrade
process always starts with backing up existing cluster.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From: Patrick Dung [mailto:patrick_...@yahoo.com.hk]
Sent: Friday, September 13, 2013 3:50 PM
To: Igor Neyman; Stephen Frost
Cc: pgsql-general@postgresql.org; Ivan Voras; Tom Lane
Subject: Re: [GENERAL] Major upgrade of PostgreSQL and MySQL
For Windows, is it using symbolic links or hard
';
should work. Be aware, I didn't test it.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: Juan Daniel Santana Rodés [mailto:jdsant...@estudiantes.uci.cu]
Sent: Tuesday, September 17, 2013 11:54 AM
To: Igor Neyman
Subject: Re: [GENERAL] How to compare the results of two queries?
El 17/09/13 11:27, Igor Neyman escribió:
create or replace
-Original Message-
From: Juan Daniel Santana Rodés [mailto:jdsant...@estudiantes.uci.cu]
Sent: Tuesday, September 17, 2013 12:51 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to compare the results of two queries?
I want to know
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Igor Neyman
Sent: Tuesday, September 17, 2013 12:02 PM
To: Juan Daniel Santana Rodés; pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to compare the results
to
Postgres through ODBC driver.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: Juan Daniel Santana Rodés [mailto:jdsant...@estudiantes.uci.cu]
Sent: Tuesday, September 17, 2013 1:38 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to compare the results of two queries?
El 17/09/13 12:56, Igor Neyman
,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Raymond O'Donnell
Sent: Wednesday, October 09, 2013 11:54 AM
To: Bob Futrelle
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] I need more specific
.
PgBouncer works fine on Windows, and does pretty good job.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
or pool
connections from PgBouncer to Postgres server.
Second, you could learn a lot about status of your connections, when you
connect as administrator to PgBouncer and use commands such as show pools,
show clients, etc...
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql
to 127.0.0.1 in your hosts file under
windows\system32\drivers\ets directory?
If not, change your pgbouncer.ini config file to use IP address 127.0.0.1
instead of localhost in [database] section.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Again, this output indicates that pgbouncer is not connecting to postgres
server.
Regards,
Igor Neyman
On Thu, Oct 31, 2013 at 11:02 AM, si24 smrcoutt...@gmail.com wrote:
I don't know if this will help in terms of my problem?
this came from the admin pgbouncer console.
pgbouncer=# show
,
the error doesn't say what kinda memory ran out.
-
You are testing with work_mem set to between 1GB and 40GB.
You were asked to lower this setting.
Even 1GB is too much, try something like work_mem=64MB.
Regards,
Igor Neyman
. I'm not using
jdbc, so can't commect on why this could happen.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/auto-explain.html
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
IT.
**
Original poster asked for the sql that will touch inventory table only
once.
Your statement (with 3 subqueries) will do it 3 times.
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
return NEW, not
NULL (OLD - for on delete trigger):
CREATE OR REPLACE FUNCTION r.m_t()
RETURNS trigger AS
$BODY$
BEGIN
INSERT INTO temp_m_t VALUES (NEW.*,1+1); RETURN NEW; END;
$BODY$ LANGUAGE 'plpgsql';
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
sales as s WHERE s.modelnumber LIKE 'GH77%')
AS results
JOIN customers as c ON (results.customerid = c.customerid)
GROUP BY results.customerid, c.customername
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
When in doubt - test.
Why not remove index in MySQL (or create index in PostgreSQL) and see
what happens.
Why trying compare apples and oranges?
Igor Neyman
-Original Message-
From: Yang Zhang [mailto:yanghates...@gmail.com]
Sent: Monday, February 22, 2010 1:37 PM
To: Richard
Joe,
What PG version are running?
8.2 here complains when running your example:
ERROR: column foo.name does not exist
LINE 6: select foo.name from foo;
^
** Error **
ERROR: column foo.name does not exist
SQL state: 42703
Igor Neyman
-Original Message
reference to this fix beeing backported into 8.2.
So, was it or was it not backported into 8.2.5?
Magnus, sorry for sending this message to you directly (as well as to
the list), but it's a really hot issue for me.
Regards,
Igor Neyman
What's the complete error message?
Vacuum is using maintenance_work_mem. What is your setting
maintenance_work_mem compared to your RAM size.
Igor Neyman
-Original Message-
From: akp geek [mailto:akpg...@gmail.com]
Sent: Wednesday, March 03, 2010 1:10 PM
To: Joao Ferreira gmail
See attached attached OneClick_PG_Installer notes.
Igor Neyman
-Original Message-
From: John Gage [mailto:jsmg...@numericable.fr]
Sent: Friday, April 02, 2010 3:44 AM
To: sachin.srivast...@enterprisedb.com
Cc: pgsql-general@postgresql.org
Subject: Re: 1-Click installer problems
entity/rule you are trying to
implement here, it'll be easier to help you.
Igor Neyman
-Original Message-
From: Dino Vliet [mailto:dino_vl...@yahoo.com]
Sent: Saturday, April 03, 2010 7:32 AM
To: r...@iol.ie
Cc: pgsql-general@postgresql.org
Subject: Re: join two tables without a key
given a solution: INSERT with RETURNING clause.
Check PG documentation regarding this clause.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
It's part of pgstattupple contrib module - read it up in the docs.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,
ha.last_refresh_date as d3 from tbl1 a join tbl2 ae on
a.id_anuncio_externo = ae.id_anuncio_externo join tbl3 ha on
a.id_anuncio_externo = ha.id_anuncio_externo) q;
should do it.
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
for any hints
Alex
Based on your PG version there are different solutions to your problem.
Not to re-invent the wheel, check this article:
http://www.postgresonline.com/journal/archives/191-String-Aggregation-in
-PostgreSQL%2C-SQL-Server%2C-and-MySQL.html%23extended
Regards,
Igor Neyman
--
Sent
report.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
...
Which PG creates automatically (behind the scene), when view is created.
Is there a way, or did anyone try to modify this Rule?
It is after all DO INSTEAD Rule.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Indexes don't maintain counts, indexes maintain pointers to the table
records.
What you need is materialized view storing aggregates.
And it looks like you already have it with your triggers.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
memory area called
temp_buffers, try to play with this configuration parameter.
And, yes there is a 1GB files size limit (not only for temp files),
that's why you see .1, .2, ... In the file names.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
out of topic, but a small correction here:
Oracle's analog of WAL files is RedoLog files, and they rollback
segments (or newer UNDO tablespace) is separate from RedoLog files.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
, statecode FROM WildLife WHERE
state_pt = ' || statecode INTO ...;
See:
http://www.postgresql.org/docs/8.4/interactive/plpgsql-statements.html
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
, sum(col1) from tab
Where id 10
Group by id
Having sum)col1) 30;
Spend some time reading basic SQL docs/books - it'll help you
tremendously.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
than one index based on the column in question? -
Which one optimizer is supposed to satisfy by rearranging where clause?
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
(arg1 table.column%TYPE ...
Which, AFAICT, is not possible.
It is definetily possible, i.e:
CREATE OR REPLACE FUNCTION myMaxCycle(i_n_Cell_id GP_CELL.cell_id%TYPE)
RETURNS GP_CYCLE.cycle_date_time%TYPE
AS $$...
Works in my 8.2 PG.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list
not violate uniqueness of your constraint.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
on.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com The Enterprise
Postgres Company
Dave,
Are there any plans to build 8.4... As 64 bit for Windows?
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
Will 9.0 also have 64-bit ODBC driver?
Igor Neyman
-Original Message-
From: Dave Page [mailto:dp...@pgadmin.org]
Sent: Wednesday, May 12, 2010 11:34 AM
To: Igor Neyman
Cc: Luis Guillermo Dangel; pgsql-general@postgresql.org
Subject: Re: Question about Beta for Windows 64 bits
. drop original table
4. rename intermediate table to original name
5. re-created required indexes (and any other objects dependent on this
table)
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Wednesday, May 19, 2010 4:15 AM
To: A. Kretschmer
Cc: pgsql-general@postgresql.org
Subject: Re: default ordering of query result - are they
always guarantee
...
it... I spent quite some
time to find out out to fix this log on failure).
Dario
Does this XP has a policy set up, that requires every login to change
it's password every so often (say 30 days, or whatever)?
If so, exclude postgres account from this policy.
Regards,
Igor Neyman
--
Sent via
-Original Message-
From: dario@libero.it [mailto:dario@libero.it]
Sent: Tuesday, June 29, 2010 3:38 AM
To: vibhor.ku...@enterprisedb.com; Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: R: Re: [GENERAL] postgres user password: Log on failure
Hi guys,
Thanks
\PostgreSQL\Installations\postgresql-8.4
folder?
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
'postgres', instead of the PostgreSQL-specific
application data folder (f.e., C:\PostgreSQL\8.4\data).
It results
in some unexpected bugs.
Could you please be more specific in describing what
problems are you
seeing on Win7?
Regards, Igor Neyman
What files are being created
different from what OP asked.
Jen wants to avoid getting error on CREATE TABLE in case her table
already exists (but proceed with CREATE TABLE, if it doesn't).
What you suggest, will drop the table (IF EXISTS), and then create it
anew - what if there is already data in the table?
Regards,
Igor Neyman
backpatching 8.4, when 9.0 Beta3 was
released.
So, backpatched to 8.4 - does it mean that we can expect new 8.4
release (8.4.5) that will include these patches in near future?
And if yes, then - when? Will it coinside with 9.0 release?
Thank you in advance,
Igor Neyman
across
the most popular SQL databases. I also explicitly don't want
to create an extra tree ID or something like that, because it
only mitigates the problem of anomalies, but does not solve it.
Thanks in advance,
Jason.
Look up connectby() in tablefuncs contrib module.
Regards,
Igor
of Administrators group.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of fixing it.
However, I wanted to share this little tidbit with the
PostgreSQL community.
Raymond
What you need for your update to work is deferred unique constraints.
I think, this feature appears in 9.0.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general
table1
GROUP BY field1, field2
ORDER BY field1) AS q1
INNER JOIN table2 ON ( ... )
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
only Stand by slave to remove
overhead caused by slony due to triggers (also the slave was
always lagging in case of bulkloads on master) in the hope
of speeding up the process.
Any help would be much appriciated ...
With Regards
sandy
Regards,
Igor Neyman
--
Sent via pgsql
IRC (freenode): dark_ixion
Registered Linux user: #516935
Sorry, for being late to this conversation.
Possibly it works for SQL Server, because SS has SQL_VARIANT data type
(kind of anytype).
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
(NEW.*);
DELETE FROM crm_active WHERE crmid = NEW.crmid;
RETURN NULL; -- so that that trigger doesn't proceed
with UPDATE on crm_active table
ELSE
RETURN (NEW.*);
END IF;
END;
$$
LANGUAGE plpgsql;
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list
, so
please correct me if my code modification is wrong.
Regards,
Igor Neyman
From: Ashesh Vashi [mailto:ashesh.va...@enterprisedb.com]
Sent: Wednesday, October 13, 2010 1:32 AM
To: Igor Neyman
Cc: pgsql-general@postgresql.org; Dave Page
Subject: Re: [GENERAL] problem with PG install script
indices need to be updated, because Postgres does not do upgrade in
place, like some other databases do.
When any column is updated, new version of the row created and the old
one marked as deleted.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
FROM gr_counts C, gr_counts D
WHERE D.groupid C.groupid
AND D.count C.count;
This will execute:
SELECT groupid, COUNT(*) AS CNT
FROM A
GROUP BY groupid
only once.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
This question didn't get any traction on admin list, so I'll try
here:
I want to analyze the entire database with the exception of several
tables.
When I run VACUUM ANALYZE (or vacuumdb -z) on the database, how can
I exclude specific tables from being analyzed?
Is there any place in system
original recursive query.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
compatible? For instance, how
can I tell it to check the version, and only run if 8.3 or lower? Or
another way to make it cross-version?
Find your PG version with:
SELECT version();
and continue accordingly...
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general
-Original Message-
From: Daniele Varrazzo [mailto:daniele.varra...@gmail.com]
Sent: Tuesday, September 25, 2012 11:26 AM
To: Adrian Klaver
Cc: David Johnston; Robert James; Igor Neyman; Postgres General
Subject: Re: [GENERAL] Running CREATE only on certain Postgres versions
On Tue
.
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
1 - 100 of 249 matches
Mail list logo