PDATE
Regards,
Roman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello!
There is a database in KOI8-R encoding. And we have a client who is
querying the database:
set client_encoding TO 'ALT'
and then he write some data into the database.
I have a problem with some symbols which exists in ALT encoding and
which are absent in KOI8-R encoding. As result, duri
coalesce` isn't a classical function and I
shouldn't quote it? Is it instead a keyword, as described in
the "Lexical Structure" section of the docs [2]? How can I find
out which other functions are not meant to be quoted?
I'm aware that I do not need to quote the `coalesce` a
Tom, Jerry, I'm going to do the same as the `quote_identifier`
function of Postgres does, only quote if necessary.
Thanks for your explanation, Roman.
On Tue, Mar 29, 2016 at 1:31 AM, Jerry Sievers
wrote:
> Roman Scherer writes:
>
> > Hello,
> >
> > I'm bui
Hello postgresql team!
I have question about building postgresql. And here it is: how to build
postgresql statically on windows to get static libs?
Thanks
Hello postgresql team!
I have question about building postgresql. And here it is: how to build
postgresql statically on windows to get static libs?
Thanks
On Wed, Oct 28, 2009 at 05:45:14AM -0700, Xai wrote:
> i want to create a type for an email field but i'm not good with regx
> can some one help me?
http://marc.info/?l=postgresql-general&m=112612299412819&w=2
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
fashion.
Any ideas
?
Roman.
We run several instances of postgre in different countries, and we try keeping
them as same as possible, in terms of structure of the tables and function
definitions (except the content of schema "config", which differs between dbs).
So if we need to implement some different algorithm per countr
I am trying to load data into a rather simple table:
CREATE TABLE "public"."files" (
"id" SERIAL,
"idchar" CHAR(32) NOT NULL,
"content" BYTEA,
CONSTRAINT "files_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;
with this command:
copy files (idchar, content) from '/data/1.dat' delimiter '|';
T
RRABLE INITIALLY DEFERRED
> );
> INSERT INTO x (i) VALUES (1), (2), (3);
> UPDATE x SET i = i + 1;
thanks, this might be a bearable workaround in some cases
provided there's also SET CONSTRAINTS ... DEFERRED / IMMEDIATE.
what I really want is a mode that fires the constraint check
at the en
# scott.marl...@gmail.com / 2010-01-02 11:23:24 -0700:
> On Sat, Jan 2, 2010 at 1:40 AM, Roman Neuhauser wrote:
> > # da...@fetter.org / 2009-12-31 08:04:58 -0800:
> >> On Thu, Dec 31, 2009 at 10:52:20AM +0100,
> >> neuhauser+pgsql-general#postgresql@sig
);
> > INSERT INTO x (i) VALUES (1), (2), (3);
> > UPDATE x SET i = i + 1;
> >
> > are there any plans to make this work?
>
> Hi,
> This seems to work..
> UPDATE x set i=i+1
> from (select i as m from x order by m desc) y where x.i = y.m
> Jayadevan
T
# [EMAIL PROTECTED] / 2005-03-01 17:41:46 +0100:
> > > There are 5 vaccinations in a given vaccination schedule.
> > >
> > > Patient had 3 shots.
> > >
> > > I want the view to show me that shot 4 and 5 are missing
> > > without having to enter the cardinality of the vaccination in
> > > the origin
# [EMAIL PROTECTED] / 2005-04-03 11:14:54 -0700:
> On Sunday 03 April 2005 07:16 am, Michelle Konzack wrote:
> > I am puzzeling around, how to query a postgresql from a BASH script.
> > Generaly it must do nothing else as
>
> I recently came across this program-ShellSQL. I haven't had time to try i
# [EMAIL PROTECTED] / 2005-05-16 09:48:08 +0200:
> I am attempting to select records where one of the dates is the latest
> date before today
>
> select max(date) from expo where date < now()
>
> works for one record but other fields I need must be in aggregate or
> grouped. Is there a simple SQL
# [EMAIL PROTECTED] / 2005-05-19 12:14:58 -0400:
> lister <[EMAIL PROTECTED]> writes:
> > This was the topic of 20 minutes of conversation in 2 tutorials
> > at BSDCan.
>
> Well, if the BSD people are so concerned about it, why don't they fix
> their bleedin' OS? It's inexcusable to have a "jail
ld restore these
tables on an 8.0.3 server if it would make things go faster!
Thanks,
Roman
_
Check All Email Accounts Anywhere!
Check your POP3 and webmail account
from any PC. With no ads
http://www.fusemail.com
_
Consol
# [EMAIL PROTECTED] / 2005-05-03 17:56:53 -0300:
> The FreeBSD is the last STABLE version. I can try to change some
> hardware, I already changed memory, what can I try now ? the processor
> ? motherboard ??
> On 5/3/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> > On Tue, 2005-05-03 at 15:04,
cided not to try
Tom's temp table method because I was afraid the generated table would be
very large, so the subsequent DELETE .. WHERE NOT IN (...) would cause
swapping again.
Thanks all for your help, your insights saved me a lot of headache.
Roman
# [EMAIL PROTECTED] / 2005-06-11 08:44:32 -0400:
> Hi everybody
>
> I am trying to write a stored procedure that returns a result set but it is
> not working
> this is the function:
> ///
> CREATE OR REPLACE FUNCTION
> remisiones.fn_get_total_remitidoxprovision1("numeric")
>
> RETURNS SETOF reco
# [EMAIL PROTECTED] / 2005-06-20 01:02:38 +0200:
> I wanted to define a function like this:
> create or replace function fun(...)...
> create temp table qaz as subquery1;
> create temp table wsx as subquery1;
> select * from qaz, wsx;
> language sql;
> but I get postgresql error saying that relatio
# [EMAIL PROTECTED] / 2005-06-21 15:00:12 -0400:
> We have a system set up whereby postfix and maildrop gather user info
> from a pg database (7.4.2 on FreeBSD 5.2.1) to do local mail acceptance
> and delivery. I have configured max connections at 512 but I find that
> this is not enough and I get
# [EMAIL PROTECTED] / 2005-06-23 17:25:03 -0400:
> On Thu, 2005-06-23 at 03:39 +, Karl O. Pinc wrote:
> > On 06/22/2005 08:23:43 AM, Sven Willenberger wrote:
> > > On Wed, 2005-06-22 at 01:30 +0200, Roman Neuhauser wrote:
> > > > # [EMAIL PROTECTED] / 2005-06-2
# [EMAIL PROTECTED] / 2005-07-09 22:55:26 -0300:
> Hi. I have a form that collects information from the user but then I
> need to update three separate tables from what the user has submitted.
> I could do this with application logic but I would feel it would be
> best handled in Postgres as a t
# [EMAIL PROTECTED] / 2005-07-12 10:08:37 -0500:
> On Sun, Jul 10, 2005 at 15:05:30 -0300,
> David Pratt <[EMAIL PROTECTED]> wrote:
> > Hi Roman. Many thanks for your reply. This is interesting and will I
> > give this a try and let you know how it works out. With
# [EMAIL PROTECTED] / 2005-07-12 12:11:45 -0500:
> On Tue, Jul 12, 2005 at 17:35:35 +0200,
> Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> > # [EMAIL PROTECTED] / 2005-07-12 10:08:37 -0500:
> > > On Sun, Jul 10, 2005 at 15:05:30 -0300,
> > > David Pratt <
Why does the planner want to crawl the table that has 5M rows instead of the one
with 176k rows? Both tables are freshly vacuum-full-analyzed.
7.4.7 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.3 20041212 (Red
Hat 3.4.3-9.EL4)
callrec32=# explain select fd.base from fix.dups fd join f
# dev@archonet.com / 2005-07-13 12:57:31 +0100:
> Roman Neuhauser wrote:
> >Why does the planner want to crawl the table that has 5M rows instead of
> >the one
> >with 176k rows? Both tables are freshly vacuum-full-analyzed.
>
> Because you don't have an ind
# dev@archonet.com / 2005-07-13 14:09:34 +0100:
> Roman Neuhauser wrote:
> >callrec32=# \d fix.files
> > Table "fix.files"
> > Column | Type | Modifiers
> >++---
&
# [EMAIL PROTECTED] / 2005-07-13 15:58:09 +0200:
> # dev@archonet.com / 2005-07-13 14:09:34 +0100:
> > Roman Neuhauser wrote:
> > >callrec32=# \d fix.files
> > > Table "fix.files"
> > >
# [EMAIL PROTECTED] / 2005-07-14 00:57:57 -0400:
> On Thu, Jul 14, 2005 at 02:46:01PM +1000, Neil Conway wrote:
> > Vivek Khera wrote:
> > >The first sentence rules out MySQL, so the second sentence should read
> > >"So that leaves Postgres". Your problem is solved ;-)
> > >
> > >(If you are acc
# [EMAIL PROTECTED] / 2005-07-14 02:14:16 -0500:
> I have a simple table to store account names... I want each name to be
> unique in a case insensitive manner... but I want the case the user
> enters to be remembered so I can't do a simple lower() on the data's way in.
CREATE TABLE tbl (col
# [EMAIL PROTECTED] / 2005-07-20 12:43:48 +0100:
> Tony Caduto wrote:
> >The easiest solution is just not to use caps or spaces in your
> >table/object names, there is no advantage to doing so.
> >People just need to get over the fact that having caps in a name make it
> >easier to read.
> >
> >M
# [EMAIL PROTECTED] / 2005-07-21 10:18:05 +0200:
> I have two functions: funcA() drops a row from table A, funcB() drops a
> row from table B that references table A. funcA() calls funcB() and
> issues a delete command after returning from funcB(). I get an error,
> stating that it can not be done,
# [EMAIL PROTECTED] / 2005-07-21 19:11:04 +0200:
> I use some updateable views to handle my data (which are amazingly
> slow), which gives me ultimate flexibility to handle my data.
>
> there are some insert rules which use currval() to get the last
> sequence id for my data which I have to inser
# [EMAIL PROTECTED] / 2005-07-22 09:10:01 +0200:
> > # [EMAIL PROTECTED] / 2005-07-21 19:11:04 +0200:
> > > I use some updateable views to handle my data (which are amazingly
> > > slow), which gives me ultimate flexibility to handle my data.
> > >
> > > there are some insert rules which use curr
# [EMAIL PROTECTED] / 2005-07-22 13:04:27 +0200:
>
>
> > # [EMAIL PROTECTED] / 2005-07-22 09:10:01 +0200:
> > > > # [EMAIL PROTECTED] / 2005-07-21 19:11:04 +0200:
> > > > > I use some updateable views to handle my data (which are
> > > > > amazingly slow), which gives me ultimate flexibility to
select cast(coalesce(nullif('', trim(callingip)), '127.0.0.1') as inet)
ERROR: invalid input syntax for type inet: ""
what is it trying to tell me?
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. htt
# [EMAIL PROTECTED] / 2005-07-22 06:50:58 -0600:
> On Fri, Jul 22, 2005 at 02:20:31PM +0200, Roman Neuhauser wrote:
> >
> > select cast(coalesce(nullif('', trim(callingip)), '127.0.0.1') as inet)
> >
> > ERROR: invalid input syntax for type ine
# [EMAIL PROTECTED] / 2005-07-22 12:41:25 +1000:
> Tom Lane wrote:
> >Bruno Wolff III <[EMAIL PROTECTED]> writes:
> >>What happens if there is more than one existing function with that name
> >>already. Do all of the old functions get deleted?
> >
> >What happens if there are existing references to
Hello,
I have a VARCHAR column containing mostly ip addresses, with an
occasional piece of junk, and would like to transfer this data to an
INET column. The UPDATE (SET inet_col = CAST(vc_col AS INET)) aborts
as soon as it hits an invalid datum. I'm looking for a way to add
something like WHERE IS
# [EMAIL PROTECTED] / 2005-07-23 06:04:55 -0600:
> On Sat, Jul 23, 2005 at 11:31:23AM +0200, Roman Neuhauser wrote:
> >
> > I have a VARCHAR column containing mostly ip addresses, with an
> > occasional piece of junk, and would like to transfer this data to an
> > I
# [EMAIL PROTECTED] / 2005-07-26 18:25:23 -0300:
> Hello everyone,I am
> searching for a way to have my postgresql 7.4.7 backend be triggered to let
> the front end know there has been a change to the database. If more then one
> person is connected to the database and person (x) makes a change,
# [EMAIL PROTECTED] / 2005-07-26 17:53:35 -0400:
> Read the Rules section of the manual and the section on Rules vs Triggers.
>
> From what I get triggers are necessary for column constraints. As far as
> speed, it seems there are some differences between how fast rules/triggers
> would do the sam
# [EMAIL PROTECTED] / 2005-07-27 10:22:48 +0200:
> Richard Huxton wrote:
> >Sounds like a BEGIN being re-issued alright. Solution - fix your
> >application(s) and don't use persistent connections (or if you do,
> >make sure you rollback any pre-existing transactions and issue any
> >relevant SET
# [EMAIL PROTECTED] / 2005-07-27 08:56:24 -0400:
> How does one receive all mail to this list in a daily digest?
Have you read the mailing list usage notes on the web site?
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't
# [EMAIL PROTECTED] / 2005-07-27 10:03:15 -0400:
> Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2005-07-27 08:56:24 -0400:
> >>How does one receive all mail to this list in a daily digest?
> >
> > Have you read the mailing list usage notes on the web site
# [EMAIL PROTECTED] / 2005-07-26 14:06:34 -0700:
> BEGIN WORK;
> DECLARE cursor1 CURSOR FOR SELECT * FROM PARTS;
> FETCH FIRST FROM cursor1;
> CLOSE cursor1;
> COMMIT WORK;
>
>
> Query result with 1 rows discarded.
> Query returned successfully with no result in 31 ms.
>
# [EMAIL PROTECTED] / 2005-07-27 10:05:43 -0400:
> Greetings,
>
> I am at the design phase of the DB design. That is, I'd like to design
> tables and relationships between them, but not the real implement of
> tables. Could somebody suggest some good and free tools to help/ease
> design the str
# [EMAIL PROTECTED] / 2005-07-27 10:13:10 -0700:
> On Wed, 27 Jul 2005, Roman Neuhauser wrote:
> > # [EMAIL PROTECTED] / 2005-07-27 10:05:43 -0400:
> > > I am at the design phase of the DB design. That is, I'd like to design
> > > tables and relationships between
# [EMAIL PROTECTED] / 2005-07-27 12:21:34 -0700:
> I found using the shell works but using the phAdminIII GUI is the one
> that gives me problems. I've even tried running it on EMS PostgreSQL
> Manager 3. Same results. Is this normal?
>
> Got a couple more questions regarding cursors.
> 1. When
# [EMAIL PROTECTED] / 2005-08-02 10:01:34 -0400:
> I made it happen in MicrosoftSQL using the first code below. The only
> difference is I had to create variables. Which I'm having a hard time
> trying to replicate it in psql.
>
> __Microsoft Code___
> USE test
> GO
> DECLARE @
# [EMAIL PROTECTED] / 2005-08-04 09:56:03 -0700:
> Thanks Roman for sticking with me on this!
> For whatever reason I cannot load another langage, I think it has to do
> with recompiling the program and installing all the options. Not sure
> though?? LANGUAGE plpgsql doesn&#x
# [EMAIL PROTECTED] / 2005-08-06 13:37:45 +0530:
> errors while loading in redhat8.0 linux
> [EMAIL PROTECTED] postgrep]# ls
> postgresql-8.0.3 postgresql-8.0.3.tar.bz2
> [EMAIL PROTECTED] postgrep]# cd postgresql-8.0.3
> [EMAIL PROTECTED] postgresql-8.0.3]# ./configure
> checking build system ty
# kleptog@svana.org / 2005-08-10 10:02:20 +0200:
> After going through pgsql-general a bit I figured there were a few
> important questions missing from the FAQ, so I wrote some.
>
> Comments welcome. I can write more, if people can suggest things to
> write about. I was thinking something about c
# [EMAIL PROTECTED] / 2005-08-10 13:18:32 +0200:
> 1. Will SELECT WHERE LOWER(colname) = 'a001' use the index, or must I create
> a separate index on LOWER(colname)?
the latter
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you we
# kleptog@svana.org / 2005-08-10 11:22:16 +0200:
> On Wed, Aug 10, 2005 at 10:44:14AM +0200, Roman Neuhauser wrote:
> > > +4.22) Why are PostgreSQL table names
> > > case-sensitive?
> >
> > http://www.postgresql.org/docs/current/static/features.html does
# [EMAIL PROTECTED] / 2005-08-11 16:04:00 +0530:
> void *connect(void* threadid)
> {
> char command[100];
> int *id_ptr, taskid;
> id_ptr = (int *) threadid;
> taskid = *id_ptr;
> if(taskid == 0)
> strcpy(command, "select insert (1)");
> else if(taskid == 1)
>
# [EMAIL PROTECTED] / 2005-08-11 13:23:52 -0700:
> I'm getting this warning in pgsql's log:
>
> LOG: plphp: PHP Warning: Call-time pass-by-reference
> has been deprecated - argument passed by value; If
> you would like to pass it by reference, modify the
> declaration of [runtime function name]
# [EMAIL PROTECTED] / 2005-08-11 15:45:18 -0700:
> Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2005-08-11 13:23:52 -0700:
> >
> >>I'm getting this warning in pgsql's log:
> >>
> >>LOG: plphp: PHP Warning: Call-time pass-by-reference
>
# [EMAIL PROTECTED] / 2005-08-11 16:17:09 -0700:
> Hello,
> I currently running an update statement that updates every row in a
> very large table. This query will obviously take a long time to run.
> My question -- is there any way to know how much time it will take
> once it starts? Even someth
# [EMAIL PROTECTED] / 2005-08-11 16:49:25 -0700:
> I'm using PHP5, and I'm not passing by reference. My
> first stop WAS plphp.commandprompt.com, but none of
> their mailing list links for plphp work.
Can you post the code that triggers the warning?
--
How many Vietnam vets does it take to s
# [EMAIL PROTECTED] / 2005-08-11 17:36:49 -0700:
> --- Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> > Can you post the code that triggers the warning?
>
> Sure-
>
>
> CREATE or REPLACE FUNCTION email_activated_member ()
> RETURNS trigger AS $$
>
# [EMAIL PROTECTED] / 2005-08-12 10:17:50 +0200:
> I just experienced some bad SQL causing quite unexpected results.
>
> I used a statement like this:
> SELECT t1.a, t1.b, t2.d FROM test1 t1, test2 t2 WHERE t1.a = test2.a;
>
> Where I should have used this instead:
> SELECT t1.a, t1.b, t2.d FROM
# [EMAIL PROTECTED] / 2005-08-31 12:00:30 +0200:
> I want to copy several columns of a source table from db1 to db2, and
> create the target table and rename the columns in the process.
>
> Is that possible in PostgresQL? If so, an example or url for such a
> command /script would be appreciated.
# [EMAIL PROTECTED] / 2005-09-05 09:39:47 +0200:
> I working now for a wile with postgres (7.4), and I have the impression
> that is one of the slowest dbms with which I've aver worked. Can please
> somebody explain to me, why this is the case?
Because the default configuration (is | seems to
# [EMAIL PROTECTED] / 2005-08-15 20:25:20 -0500:
> On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote:
> > chiranjeevi.i wrote:
> > > Hi Team Members,
> > >
> > > Is it possible to write jobs in postgresql & if possible how
> > > should I write .please help me.
> >
> > See pgjob i
# [EMAIL PROTECTED] / 2005-09-07 11:17:10 -0400:
> Does anybody have regular expression handy to verfiy email addresses?
This is what I have. The comment notes the caveats.
-- CREATE FUNCTION IS_EMAILADDRESS {{{
-- returns TRUE if $1 matches the rules for RFC2822 addr-spec token,
-- ignoring
# [EMAIL PROTECTED] / 2005-09-08 11:31:25 +0300:
> We have a daemon programme that acts as a pgsql client. It writes in a
> DB the status of its own clients. And we have a different daemon that
> needs to read that status information and decide upon it. The problem
> is that the first daemon is a l
This fails on 8.0.3 (syntax error at or near "." at character):
CREATE TYPE ct AS (
foo INTEGER,
bar INTEGER
);
CREATE TABLE t1 (
attr ct,
CONSTRAINT uq UNIQUE (attr.foo)
);
Should it be possible? From reading
http://www.postgresql.org/docs/current/static/rowtypes.html it looks
like almo
# [EMAIL PROTECTED] / 2005-09-09 09:10:30 -0600:
> On Fri, Sep 09, 2005 at 10:39:58AM -0400, Tom Lane wrote:
> > I don't believe you need the function -- this should be enough:
> >
> > CREATE UNIQUE INDEX t1_b_uniq ON t1 ((attr.foo));
>
> I was expecting that to work too, but it doesn't:
>
> ERR
I'm looking for an equivalent of my_composite_type[] for use as a
parameter of a pl/pgsql function. What do people use to dodge this
limitation?
Background: I have a few plpgsql functions that basically accept an
array of objects decomposed into arrays of the objects' attributes:
CREATE FUNCTION
# [EMAIL PROTECTED] / 2005-09-11 12:11:39 -0400:
> Roman Neuhauser <[EMAIL PROTECTED]> writes:
>
> > I'm looking for an equivalent of my_composite_type[] for use as a
> > parameter of a pl/pgsql function. What do people use to dodge this
> > limitation?
> &
# [EMAIL PROTECTED] / 2005-09-13 18:28:07 -0700:
> Please...help me..
> How to unsubcribe
Look at the headers of any message posted to the list.
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http
# [EMAIL PROTECTED] / 2005-09-20 20:45:21 +0200:
> I was thinking if this was possible in some way..
> I have this table where we have X and Y coordinates, and i need to
> select several in one go.
>
> # select * from xy where (x = 1 and y = 2) or (x = 2 and y = 2);
>
> This works but are not so
# [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
> if you want to be taken seriously by anyone who uses Windows (hands up
> anyone who knows a Windows user)
1. what do those two things have in common?
2. what makes you think that "anyone who uses Windows" runs
PostgreSQL on it?
# [EMAIL PROTECTED] / 2006-09-20 21:59:10 -0400:
> To all involved in this project,
>
> I justed wanted to let you know how impressed and pleased I have been
> with postgres over the past 5 years .
Remember, this is an opens source project. Satisfied users are
similar to random victims i
# [EMAIL PROTECTED] / 2006-10-10 14:16:19 -0400:
> FUD from another open source project is really poor form, particulary
> when not in competing segements where a little bit of competitive
> rivalry is expected.
OMG WTF what FUD???
# [EMAIL PROTECTED] / 2006-10-10 13:55:57 -0400:
> http://www
# [EMAIL PROTECTED] / 2006-11-06 15:05:25 +0100:
> I'm sure that it's a typo or something, but as I'm getting into PhP
> and PostgreSQL for the first time, I can't be sure.
> pg_connect ("dbname=cdi user=cdi password=toto") or die
> ("Couldn't Connect: ".pg_last_error());
> $query="SELECT
# [EMAIL PROTECTED] / 2006-11-06 12:26:43 +0100:
> On Sun, 05 Nov 2006, CSN wrote:
>
> > Anybody know of a script that dumps all databases into
> > corresponding dump files
>
> I've written this one in bash:
>
> #
> #!/bin/bash
>
> pg_dump
# [EMAIL PROTECTED] / 2007-01-23 23:17:31 +0800:
> >Please don't top-post, it disturbes the flow of the communication.
>
> Interesting. I prefer getting to the point an author is making.
Top posting means you end up far off the mark.
> >There's documentation about that too, at the end of the in
# [EMAIL PROTECTED] / 2007-01-26 09:21:27 -0800:
> Windows doesn't support symlinks. Is it possible instead for there to
> be a config file that lets one set where the pg_xlog directory will sit?
Windows has junction points.
--
How many Vietnam vets does it take to screw in a light bulb?
You do
# [EMAIL PROTECTED] / 2007-03-13 18:29:36 +0100:
> Hi,
>
> I have a stored procedure which returns a SETOF RECORD.
> so basically a partial rowtype from a table.
>
> to execute the query in PHP, i must write :
> select * from myschema.sp_a_002('username') as result(Column1 varchar);
>
> to get t
# [EMAIL PROTECTED] / 2007-04-14 13:27:33 +0200:
> Hi,
> I am stuck for the moment with 1gig of ram on a win xp machine running
> a 8.2.3 postgres. With the java website taking 300meg,
how is it going to scale?
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.
Hello,
what is the opposite of cast(extract('epoch' from now()) as int)?
The only thing I found that works is
cast(cast(... as abstime) as timestamp)
and the documentation says abstime shouldn't be used, and may
disappear. What should I use instead?
--
FreeBSD 4.10-STABLE
12:01AM up 15:39, 7 use
# [EMAIL PROTECTED] / 2005-01-11 18:35:18 -0500:
> Roman Neuhauser <[EMAIL PROTECTED]> writes:
> > what is the opposite of cast(extract('epoch' from now()) as int)?
> > The only thing I found that works is
> > cast(cast(... as abstime) as timestamp)
> > a
# [EMAIL PROTECTED] / 2005-01-11 19:31:19 -0500:
> Roman Neuhauser <[EMAIL PROTECTED]> writes:
> >> The recommended locution is
> >>
> >> SELECT TIMESTAMP WITH TIME ZONE 'epoch' + * INTERVAL '1 second';
>
> > Have I missed thi
Hello, what is the parser trying to tell me? (7.4.2 if it matters)
test=# CREATE OR REPLACE FUNCTION SYNC_COUPLECOUNT()
test-# RETURNS TRIGGER
test-# AS '
test'# BEGIN
test'# IF TG_OP = ''INSERT'' THEN
test'# UPDATE _calls
test'# SET
test'# realcouplecou
# [EMAIL PROTECTED] / 2005-01-14 13:27:24 +0100:
> Roman Neuhauser wrote:
> >Hello, what is the parser trying to tell me? (7.4.2 if it matters)
> >test'# ELSEIF TG_OP = ''DELETE'' THEN
>
> You typed ELSEIF, the parser doesn't kn
# kleptog@svana.org / 2005-01-16 17:48:08 +0100:
> On Sun, Jan 16, 2005 at 05:30:22PM +0100, Bo Lorentsen wrote:
> > >One could conceivably attempt to make a functional index using
> > >plus_random(), but the result it gives every time is indeterminant.
> > >How would you be able to usefully sear
# [EMAIL PROTECTED] / 2005-01-19 14:57:47 +0100:
> I have a rule similar to this:
>
> CREATE RULE rule_branch_delete AS
> ON DELETE TO tree
> DO DELETE
> FROM tree
> WHERE ancestor_id IS NOT NULL
> AND OLD.child_id = ancestor_id;
> If I try a delete on the tree table I get "Infinit
# [EMAIL PROTECTED] / 2005-01-20 01:35:32 +1100:
> i have a unique index on a table over multiple columns. If now one of
> the records has a null value in one of the indexed columns i can insert
> the same record multiple times.
>
> Is this a problem within postgres or expected?
In SQL, NUL
# [EMAIL PROTECTED] / 2005-01-25 10:40:15 +0100:
> I add use in my time in University some software that use "extended
> type".
> For each variable, we define the mandatory "classic type" as integer,
> float, double array of.
> And we define an optional "extended type" as the unit in the MKSA
>
# [EMAIL PROTECTED] / 2005-02-02 23:32:28 -0800:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> Maybe it's to late for me to think correctly (actually I'm sure of
> that). I'm going to ask anyways. I have a table like
>
> id int4
> user_id int4
> photo varchar
> image_type char(1)
>
>
# [EMAIL PROTECTED] / 2005-02-06 09:34:53 -:
> Since I posted my original question, I realized that pgpool notes a
> failure of either master or slave in its log. Would we want something
> more proactive?
snmp?
--
If you cc me or remove the list(s) completely I'll most likely ignore
you
I have a few questions regarding (or related to) the recent
SELECT INTO fixes in plpgsql.
* There hasn't been an official announcement as far as I can tell.
All I could find is a mention in David Fetter's Weekly News.
Is the risk so low it doesn't warrant informing users?
* What are the plans
Hello,
looks like PostgreSQL (8.0/8.1) has no support for using
other-than-btree indexes for primary keys. Is there a (perhaps
un(der)documented) way to specify the index type?
Rationale: I'm trying to have PKs on a type that defines only the = and
<> operators, and would work with a hash-based P
Hello,
I've been waiting five months for the majordomo moderators to approve
my subscription requests to several @postgresql.org mailing lists.
I sent an email to [EMAIL PROTECTED] more than two months ago,
also without any reaction.
What should I do to spark someone's interest?
Pls cc me on re
# [EMAIL PROTECTED] / 2006-02-26 14:36:47 -0400:
> On Sun, 26 Feb 2006, Roman Neuhauser wrote:
>
> >Hello,
> >
> >I've been waiting five months for the majordomo moderators to approve
> >my subscription requests to several @postgresql.org mailing lists.
>
&g
1 - 100 of 149 matches
Mail list logo
