Jeff Janes wrote
> That's not really true. There are no per-row WAL records. There is still
> a per-transaction WAL record, the commit record. If you only care about
> the
> timing of the WAL and not the volume, changing to unlogged will not make a
> difference. (These commit-only records are au
Hi,
please ignore my previous question about piping pg_dump output to
pg_restore. This is already working.
Thanks,
Frank
can avoid the complexities of that approach.
Thanks,
Frank
On Tue, Mar 25, 2014 at 4:46 PM, Raymond O'Donnell wrote:
> On 25/03/2014 13:56, Frank Foerster wrote:
> >
> > Hi,
> >
> > we are currently in the process of upgrading a production/live 1 T
This message has been digitally signed by the sender.
Re___GENERAL__CPU_move.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.
This message has been digitally signed by the sender.
Re___GENERAL_.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
27;s problem at all, since
his queries are only *reading* the referenced tables??
Regards,
Frank
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
rawback that
if you update the reference table (if you keep it), you mustn't forget
to also update the check constraints in more than one place.
Rgds, Frank
---(end of broadcast)---
TIP 6: Have you searched our list archiv
Hello,
I would like to try postgresql and was wondering what benefits it
has over MySql.
I am using navicat to manage my MySQL databases.
Thanks for the help.
Frank
---(end of broadcast)---
TIP 6: explain analyze is your friend
;),
(11, 'Software - PC', 2, '2004-10-12 10:50:03'),
(13, 'Software - Network', 2, '2004-10-12 10:50:04'),
(14, 'Software - Midrange, AS/400', 2, '2004-10-12 10:50:04'),
(15, 'Software - Server', 2, '2004-10-12 10:50:04'),
(16, 'Hardware - Wyse Terminal', 2, '2004-10-12 10:50:05');
Regards,
Frank
---(end of broadcast)---
TIP 6: explain analyze is your friend
rk', 2, '2004-10-12 10:50:04'),
> (14, 'Software - Midrange, AS/400', 2, '2004-10-12 10:50:04'),
> (15, 'Software - Server', 2, '2004-10-12 10:50:04'),
> (16, 'Hardware - Wyse Terminal', 2, '2004-10-12 10:50:05');
Regards,
Frank
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
>>mysqldump --extended-insert=FALSE<<
Thanks for the help, this is allowing me to import the data now.
Regards,
Frank
At 09:37 AM 9/1/2005, Michael Fuhr wrote:
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion. Also, please don&#x
t anything.
I just increased my postgres debug to -d 2 to see if that provides any
useful information. Does anyone else have any debugging suggestions or
know what might be causing this problem?
Thanks,
Frank
---(end of broadcast)---
TIP 9: In vers
On Sun, Apr 09, 2006 at 06:22:40PM -0400, Tom Lane wrote:
> Frank <[EMAIL PROTECTED]> writes:
> > I have a perl script running as a daemon. It's using DBD::Pg (1.43) to
> > connect to my Postgres server (8.0.7) running on the same box and talking
> > over a sock
Hi,
Does someone have a success story of using Postgres Full Search Capability
with significant data, lets say > 50-100 GB ?
Any pointers would be much appreciated
Thanks
Frank
On Thu, 2015-10-29 at 08:33 -0400, Will McCormick wrote:
> Trying to get the bdr-plugin to install make install on RHEL7.1. Having some
> issues with make of the plugin.
>
>
>
> # make -j4 -s all make -s install
> make: *** No rule to make target `make'. Stop.
> make: *** Waiting for unfinished
*think* that the solution is to BEGIN the transaction, then perform SELECT
... WITH UPDATE, then proceed with INSERT and COMMIT if ok, else ROLLBACK.
Is this the correct approach, or am I missing something?
Thanks
Frank Millman
From: hubert depesz lubaczewski
Sent: Wednesday, October 26, 2016 10:46 AM
To: Frank Millman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Locking question
On Wed, Oct 26, 2016 at 10:42:29AM +0200, Frank Millman wrote:
> Hi all
> >
> > I am designing an inventory app
From: Frank Millman
Sent: Wednesday, October 26, 2016 10:42 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Locking question
> I am designing an inventory application, and I want to ensure that the stock
> level of any item cannot go negative.
Thanks to all for some really
better ideas?
Thanks
Frank Millman
From: amul sul
Sent: Monday, January 02, 2017 12:42 PM
To: Frank Millman
Cc: pgsql-general
Subject: Re: [GENERAL] Difficulty modelling sales taxes
> On Mon, Jan 2, 2017 at 4:03 PM, Frank Millman wrote:
> > Hi all
> >
> > It is a bit ugly, because I have to use the ‘NVARC
Hi all
I am running PostgreSQL 9.4.4 on Fedora 22.
SELECT floor(4.725 * 100 + 0.5) returns 473, which is what I expected.
SELECT floor(4.725 * power(10, 2) + 0.5) returns 472, which I find surprising.
Please can someone explain the anomaly.
Thanks
Frank Millman
responses.
Plenty of workarounds. I can carry on now :-)
Frank
--
numeric
I found that adding a decimal point after the 10 is the easiest way to force it
to return a numeric.
Putting this together, my solution is -
test=> select floor(4.725 * power(10., 2) + 0.5);
floor
---
473
Can anyone see any problems with this?
Thanks
Frank
On Tue, Mar 15, 2016 at 12:02 PM, Francisco Olarte wrote:
> Hi Frank:
>
> This may byte you any day, so I wuld recommend doing
>
> s=> select v, pg_typeof(v) from (select floor(4.725 * power(cast(10 as
> numeric), 2) + 0.5)) as aux(v);
> v | pg_typeof
> -+-
what could cause this behavior of the slave server?
Could upgrading to 8.2.4 help? - I didn't find something related in the
release notes.
Could this be a bug?
Greetings,
Frank Wittig
signature.asc
Description: OpenPGP digital signature
the master
too as soon as I can get me a maintenance window for this.
Greetings,
Frank Wittig
signature.asc
Description: OpenPGP digital signature
1 13:11:29.365 CEST:%> CONTEXT: xlog redo checkpoint: redo
C9/C20DE050; undo 0/0; tli 1; xid 0/36130541; oid 241990328; multi 8;
offset 15; online
<2007-06-01 13:11:29.365 CEST:%> LOCATION: RecoveryRestartPoint,
xlog.c:5769
best regards,
Frank Wittig
signature.asc
Description: OpenPGP digital signature
Teodor Sigaev schrieb:
> Hmm. I found that gin_xlog_cleanup doesn't reset incomplete_splits list.
> Is it possible reason of bug?
Sounds reasonable to me. Would explain why the system didn't ever
recover from that state.
I'll test your patch and report results on this list
Hi Simon,
> The attached patch should show which of these it is. I'll dress it up a
> little better so we have a debug option on this. Please note I've not
> tested this patch myself, so Frank if you don't mind me splatting
> something at you we'll see what we see.
3 CEST:%> LOG: GIN incomplete split root:8
l:45303 r:111740 at redo CA/C8243C28
<2007-06-01 16:38:23.133 CEST:%> LOG: GIN incomplete split root:4269
l:102123 r:111741 at redo CA/EEAD8B80
It didnt do us the favor to produce more incomplete splits. But these
two are enough to keep the standby server from doing checkpoints.
Greetings,
Frank Wittig
signature.asc
Description: OpenPGP digital signature
Hi Teodor,
Teodor Sigaev schrieb:
> Hope, attached patch fix that. Pls, test it.
The patch is running. I'll keep on reporting.
Have a nice weekend.
Greetings,
Frank Wittig
signature.asc
Description: OpenPGP digital signature
Teodor Sigaev schrieb:
> Hope, attached patch fix that. Pls, test it.
It still happens.
The log is full of incomplete split dumps:
<2007-06-01 23:00:00.001 CEST:%> LOG: GIN incomplete splits=8
<2007-06-01 23:00:00.001 CEST:%> CONTEXT: xlog redo checkpoint: redo
D0/28020F48; undo 0/0; tli 1; xid
r the good work!
Regards,
Frank Wittig
Teodor Sigaev schrieb:
> Ooops. Patch doesn't apply cleanly. New version.
>
>
>> Attached patch fixes that deadlock bug too. And, previous version of
>> my patch has a mistake which is observable on CREATE INDEX .. USING
>>
gs per day.
Greetings,
Frank Wittig
signature.asc
Description: OpenPGP digital signature
ll start over again. ;)
Greetings,
Frank Wittig
signature.asc
Description: OpenPGP digital signature
Frank Wittig schrieb:
> 24 Hex digits means 24^16 unique file names. Assuming your server saves
> a WAL file each second (you should review your config it it does) it
> takes (24^16)/(60*60*24*365)=3.84214066×10^14 years to reach the upper
> bound.
How embarrassing - I messed up the
Regards,
Frank Wittig
signature.asc
Description: OpenPGP digital signature
nate order, I can get duplicate level numbers while the command is
being executed.
My workaround at present is the following -
UPDATE treelevels SET levelno = (levelno+10001) WHERE levelno >= 1;
UPDATE treelevels SET levelno = (levelno-1) WHERE levelno >= 1;
It works, but it feels very
Michael Glaesemann wrote:
>
> On Aug 22, 2007, at 1:02 , Frank Millman wrote:
>
> > I want to store data in a 'tree' form, with a fixed number
> of levels,
> > so that each level has a defined role.
>
Thanks very much for the in-depth response, Michael
---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>match
This could be a DNS related problem, if not the request itself, but the
connect, is
Is there a built in function for retrieving the next value of a
sequence and updating the sequence counter?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ab.
I guess you then would have seen an error message saying that pg_dump
was not found because cron doesn't load the users environment and
therefore PATH variable isn't set.
I suggest you call pg_dump in your script by absolute path.
Greetings,
Frank Wittig
signature.asc
Description: OpenPGP digital signature
bie around here, but this is one that I can answer :-)
update table set boolean_column = not boolean_column where fk = some_value
HTH
Frank Millman
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
PostgreSQL.
I am new to both PostgreSQL and PointBase.
Thank you in advance.
Regards,
Frank
CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended
read and never write. We want just
connection pooling and load balacing through pgpool to our 2 slaves.
Couldnt find anyone on google using pgpool to access read only his slony
slaves, maybe someone has suggestions for me.
Regards,
Frank Jansen
--
Sent via pgsql-general mailing list (pgsql
Regards,
Frank Heikens
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in joins together so we know which tables/groups of tables we
have to keep together on physical postgres instances while we scale
out horizantally.
Is that fixable somehow for 8.3? Perhaps we can set a flag that tells
the logger to emit the table name instead of the alias, or both, and
then recompil
On Wed, Jan 19, 2011 at 7:10 PM, Tom Lane wrote:
> frank joerdens writes:
>> I was just experimenting with debug logging on 8.3 and am finding that
>> I can't get it to log the table names involved in a given query, it
>> will always print the table alias used in you
Hi, I'm new to postgresql and sql in general. I desired to write a program in C that used an sql data base for IPC and because multiple copies of my program might run on the same machine I wanted a way to ensure that only one copy of each multithreaded program got one database but I'm uncertain how
> how would an instance of your program know what to connect to, or which
> previous instance its 'predecessor' was ?
> normally, you have ONE database for a given set of applications, and all
> the applications share the same database tables and such.
That's the problem, is there some way to t
That actually sounds terrifying. I'd throw up a caching layer ASAP to try
to decrease the speed those transactions are happening.
Frank
On Mon, Jul 7, 2014 at 2:25 PM, Nicolas Zin <
nicolas@savoirfairelinux.com> wrote:
> Maybe you can priorize your worker with a ionice?
Hello, I can't seem to find the allowed values for OIDs.
result = PQprepare(parrentcon, insertstmt, insert, 2, /*FIXME*/);
Both arguments are to be of type char * in C and of type varchar(255) in sql.
I looked in the docs but I can't seem to find where OIDs are enumerated, please point me in the
ronments. Previously I've just used a quick
wrapper:
https://gist.github.com/frankpinto/3427cf769a72ef25ffac
It can be modified to accept arguments for the script name, run a sql
script by the same name, have a default environment, etc.
Frank
On Fri, Jul 18, 2014 at 10:43 AM, Martin Gud
Looks like you're doing it right, you actually have to specify the user
though:
psql -U postgres
and make sure you restarted the server so your changes take effect.
Frank
On Wed, Aug 6, 2014 at 4:43 PM, Jorge Arevalo
wrote:
> Hello,
>
> I want to connect to my local i
Payal,
I think you completely ignored john r pierce...any reason you're using
9.2.4? Whoevers going to help you will want to be testing on what you're
eventually going to compile
Frank
On Fri, Aug 8, 2014 at 4:54 PM, Payal Shah wrote:
> Hello John,
>
>
>
> Thank
Hello, I'd like to see all the tables in my data base,
but can't figure out how to access th information scheme.
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
an be applied in case of an upgrade. Is there any build in for?
Cheers,
Frank
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
username,password and database again ? In Java, we
are using set catalog to do this in MySQL.
2. Based on #1 above, would the latest JDBC driver support the ability to
create this type of connection?
Thanks,
Frank
Database Administrator
PostgreSQL has something similar.
Thanks,
Frank
From:
Adrian Klaver
To:
Frank Cavaliero/Boston/IBM@IBMUS
Cc:
pgsql-general@postgresql.org, pgsql-ad...@postgresql.org
Date:
02/25/2013 01:48 PM
Subject:
Re: [GENERAL] Use, Set Catalog and JDBC questions
On 02/25/2013 10:22 AM, Frank Cavaliero
Hi John,
Thanks for the response. I will look into that as an option.
Thanks,
Frank
From:
John R Pierce
To:
pgsql-general@postgresql.org
Date:
02/25/2013 01:33 PM
Subject:
Re: [GENERAL] Use, Set Catalog and JDBC questions
Sent by:
pgsql-general-ow...@postgresql.org
On 2/25/2013 10
Hi Adrian,
Thanks a lot!I will certainly look into the multiple datasources as an
option.
-Frank
From:
Adrian Klaver
To:
Frank Cavaliero/Boston/IBM@IBMUS
Cc:
pgsql-ad...@postgresql.org, pgsql-general@postgresql.org
Date:
02/25/2013 02:16 PM
Subject:
Re: [GENERAL] Use, Set Catalog
Hi folks,
I'm looking for a HowTo of Foreign Tables feature. We are thinking of
connecting two postgres databases via this way and I wanted to try
before I do say yes or no ;) However, I didn't find any good HowTo on
via §search_engine.
Cheers,
Frank
--
Sent via pgsql-general ma
without restarting. Please check for HowTo for upgrading
postgres.
Cheers,
Frank
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
workplaces (name, workers) VALUES ('My Place', 5);
having the incrementation and the uniqueness. I was thinking off
creating a number of triggers doing this for me but wondering whether
there might be a better way.
Cheers,
Frank
BTW: Using Postgres 9.2 and up
--
Sent via pgsql-
Am 17.05.2013 21:21, schrieb Alfonso Afonso:
> Hi Frank
>
> Although you are thinking in OOP, the SQL is itself one definition
> model that you should not ignore and, IMHO, try to follow the
> normalization statements.
>
> You can build a robust and normalized schema (
nting this? I never use this switch
and my .pgpass is used by shell scripts and other programs ...
Frank
--
Frank BRONIEWSKI
METRICO s.à r.l.
géomètres
technologies d'information géographique
rue des Romains 36
L-5433 NIEDERDONVEN
tél.: +352 26 74 94 - 28
fax.: +352 26 74 94 99
http://www.
Hi,
i have the following question:
Given an empty database with only schema api_dev in it, a table and a
function is created as follows:
CREATE TABLE api_dev.item_texts
(
item_id integer,
item_text text
)
WITH (
OIDS=FALSE
);
CREATE OR REPLACE FUNCTION api_dev.add_texts_to_item(
p_it
.
Exactly the same exercise on Sql Server results in 0.06 seconds for both
versions.
I realise that, if I was selecting a large number of rows, 0.23 seconds is
trivial and the overall result could be different. But still, it seems odd.
Is this normal, or should I investigate further?
Frank Millman
Pavel Stehule wrote:
>
> 2017-09-12 8:45 GMT+02:00 Frank Millman :
I am using 9.4.4 on Fedora 22.
I am experimenting with optimising a SQL statement. One version uses 4 LEFT
JOIN’s and a 5-way CASE statement in the body. The second moves the filtering
into the JOIN section, and I
Ron Johnson wrote:
>
On 09/12/2017 01:45 AM, Frank Millman wrote:
Hi all
I am using 9.4.4 on Fedora 22.
I am experimenting with optimising a SQL statement. One version uses 4 LEFT
JOIN’s and a 5-way CASE statement in the body. The second moves the filtering
into the JOIN section, and I
Pavel Stehule wrote:
2017-09-12 9:36 GMT+02:00 Frank Millman :
Pavel Stehule wrote:
>
> 2017-09-12 8:45 GMT+02:00 Frank Millman :
I am using 9.4.4 on Fedora 22.
I am experimenting with optimising a SQL statement. One version uses 4 LEFT
JOIN’s and a 5-way CASE statement
2017-09-12 12:39 GMT+02:00 Pavel Stehule :
2017-09-12 12:25 GMT+02:00 Frank Millman :
Pavel Stehule wrote:
2017-09-12 9:36 GMT+02:00 Frank Millman :
Pavel Stehule wrote:
>
> 2017-09-12 8:45 GMT+02:00 Frank Millman :
I am using 9.4.4 on Fed
From: Chris Travers
Sent: Tuesday, September 12, 2017 3:36 PM
To: Frank Millman
Cc: Postgres General
Subject: Re: [GENERAL] Joining 16 tables seems slow
Chris Travers wrote:
On Tue, Sep 12, 2017 at 3:15 PM, Frank Millman wrote:
2017-09-12 12:39 GMT+02:00 Pavel Stehule :
> ple
analysis correct?
If so, is there any way to force it to use an indexed read?
Thanks for any pointers.
Frank Millman
Pavel Stehule wrote:
2017-09-14 10:14 GMT+02:00 Frank Millman :
Hi all
This is a follow-up to a recent question I posted regarding a slow query. I
thought that the slowness was caused by the number of JOINs in the query, but
with your assistance I have found the true reason. I said in the
2017-09-14 15:09 GMT+02:00 Pavel Stehule :
2017-09-14 14:59 GMT+02:00 Frank Millman :
Pavel Stehule wrote:
2017-09-14 10:14 GMT+02:00 Frank Millman :
Hi all
This is a follow-up to a recent question I posted regarding a slow query.
I thought that the slowness was
too effective - maybe some composite or partial
> > index helps.
>
> In my testing JOINS can push through UNION ALL. Why do we need to
> materialize union first? What version is this?
>
I am using version 9.4.4 on Fedora 22.
Frank Millman
On 2017-09-18 Frank Millman wrote:
>
> Here are the timings for running the query on identical data sets using
> Postgresql, Sql Server, and Sqlite3 -
>
> PostgreSQL -
> Method 1 - 0.28 sec
> Method 2 – 1607 sec, or 26 minutes
>
> Sql Server -
> Meth
On Thu, Sep 21, 2017 at 3:54 PM, Merlin Moncure wrote:
>
> > On Thu, Sep 21, 2017 at 1:51 AM, Frank Millman wrote:
> >
> > I did not get any response to this, but I am still persevering, and feel
> > that I am getting closer. Instead of waiting 26 minutes for a resul
On Thu, Sep 21, 2017 at 3:54 PM, Merlin Moncure wrote:
> Something is not adding up here. Can you EXPLAIN ANALYZE the 26 minute
> query?
Here it is -
https://explain.depesz.com/s/cwm
Frank
Merlin Moncure wrote:
On Thu, Sep 21, 2017 at 12:02 PM, Frank Millman wrote:
>
> SELECT q.cust_row_id,
> SUM(CASE WHEN q.tran_date > '2015-08-31' THEN q.balance ELSE 0 END
> ) AS "balance_curr AS [DECTEXT]",
> SUM(CASE WHEN q.tran_date <= '201
Frank Millman wrote:
>
> On Thu, Sep 21, 2017 at 3:54 PM, Merlin Moncure wrote:
> > Something is not adding up here. Can you EXPLAIN ANALYZE the 26 minute
> > query?
> Here it is -
>
> https://explain.depesz.com/s/cwm
>
There is one thing I have not
From: Frank Millman
Sent: Friday, September 22, 2017 7:34 AM
To: pgsql-general@postgresql.org
Subject: Re: a JOIN to a VIEW seems slow
On Fri, Sep 22, 2017 at 7:34 AM, Frank Millman wrote:
>
> On Thu, Sep 21, 2017 at 3:54 PM, Merlin Moncure wrote:
> > Something is not ad
On Wednesday, October 4, 2017 06:07 PM Jan de Visser wrote:
> On Monday, October 2, 2017 2:32:34 AM EDT Frank Millman wrote:
> >
> > Just checking – is this under investigation, or is this thread considered
> > closed?
>
> That's not how it works. This is a c
On 4 Oct 2017, at 9:19 PM, Alban Hertroys wrote:
> On 2 Oct 2017, at 8:32, Frank Millman wrote:
>
>
> On Fri, Sep 22, 2017 at 7:34 AM, Frank Millman wrote:
> >
> > On Thu, Sep 21, 2017 at 3:54 PM, Merlin Moncure wrote:
> > > Something is not adding up h
On 5 Oct 2017, at 8:20 AM, Frank Millman wrote:
> If anyone wants to take this further, maybe this is a good place to start.
I should have re-stated the reason for my original post.
Exactly the same query, on exactly the same data, takes 1.8 seconds on Sql
Server, 1.0 seconds on SQLite3,
On 5 Oct 2017, at 9:51 AM, Frank Millman wrote:
>
> I should have re-stated the reason for my original post.
>
> Exactly the same query, on exactly the same data, takes 1.8 seconds on Sql
> Server, 1.0 seconds on SQLite3, and 1607 seconds, or 26 minutes, on
> PostgreSQL
to a join with a GROUP BY, like ...
>
Wow, David, that is perfect – 0.91 seconds. Problem well and truly solved.
It took me a little while to modify my original query to use that concept, but
now it flies.
Many thanks
Frank
> -
>
> a) vacuumdb - shell command
> b) VACUUM - SQL command
> c) autovacuum
> d) What is vacuum?
>
>
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subsc
First of all, many thanks to all the developers for creating such a great DB.
I have a moderately DB-ignorant question: is there a "built-in" way for an
application to receive the message emitted by a RAISE in a PgSQL function?
Context: I have a moderately complex application (in python, us
On Fri, Apr 04, 2008 at 12:02:20PM -0700, Frank Miles wrote:
I have a moderately DB-ignorant question: is there a "built-in" way for an
application to receive the message emitted by a RAISE in a PgSQL function?
Context: I have a moderately complex application (in python, usin
No, it's not possible, pgSQL does't have a CREATE ALIAS -syntax
You could put this function into another function to create sort of an
alias, but that wouldn't make to much sense.
Frank
Op 9 jun 2009, om 22:03 heeft Agoston Postgres het volgende geschreven:
Hi!
Is
N pg_index.indrelid = tcls.oid
JOIN pg_namespace AS nmsp ON tcls.relnamespace = nmsp.oid
WHERE
nmsp.nspname NOT IN ('pg_catalog', 'pg_toast')
ORDER BY
schemaname ASC,
tablename ASC,
indexname ASC;
Kind regards,
Frank
SELECT
tablename,
pg_size_pretty(pg_relation_size(schemaname || '.' || tablename))
FROM
pg_tables
WHERE
schemaname = 'econ';
Kind regard,
Frank
Op 16 jun 2009, om 13:17 heeft Whit Armstrong het volgende geschreven:
Does anyone know why I g
Agreed.
Personally I wouldn't use pg_tables at all because of the missing oid.
Would be nice to have in this view, but it can't be changed because
it's a system-view. pg_class would do the job.
Regards,
Frank
Op 16 jun 2009, om 16:12 heeft Tom Lane het volgende gesc
ase of pg_tables you
need the oid's of the schema and the table.
http://www.postgresql.org/docs/8.3/static/views-overview.html
Regards,
Frank
Op 16 jun 2009, om 16:52 heeft Magnus Hagander het volgende geschreven:
Actually, is there any particular reason why we can't *add* that
c
CUTE 'CREATE TABLE z()';
END IF;
RETURN TRUE;
END;
$$
language plpgsql;
SELECT new_table(1);
Use EXECUTE and be sure you can't be the next victim of SQL injection.
If you need some userinput in the EXECUTE-statement, use
quote_literal() and/or quote_ident().
What version of pg_dump and pgAdmin are you using?
In PostgreSQL version 8.3 it's reltriggers, in version 8.4 it's
relhastriggers. Just run the next query to see the difference:
SELECT * FROM pg_class;
Using pgAdmin 1.10, I don't have any problemes with 8.3 nor 8.4
Regards,
You can't use default values in a function, that option is available
as of version 8.4. You are using 8.3.
Regards,
Frank
Op 4 aug 2009, om 19:16 heeft Gert het volgende geschreven:
I'm a bit in the dark:
I use Windows XP
I use pgAdmin ver 1.8.4
I use PostGres 8.3.6
All the doc
1 - 100 of 441 matches
Mail list logo
