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
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
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
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
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
fashion.
Any ideas
?
Roman.
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
);
> > 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
# 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
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
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
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
# [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.
# [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-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-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] / 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] / 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-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-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-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-01 20:13:14 +1000:
> Hey,
>
> I am running PostgreSQL 8.1.4 and I want to create a user from inside a
> function. Is this possible in 8.1?
>
> Ive found quite a few references on google using EXECUTE, but this seems
> relevant to earlier versions, not 8.1.
>
> I hav
# [EMAIL PROTECTED] / 2006-09-01 03:19:03 -0400:
> If that is the case then why does it throw error in one on the insert
> queries in the shared object written in SPI without inserting the row on the
> table on which record is inserted.
>
> Follwing query in the shared object throws an error.
>
>
# [EMAIL PROTECTED] / 2006-08-31 07:35:30 -0700:
> > Ralf Engelschall's OSSP uuid looks very good. Written in C with
> > interfaces into PostgreSQL, PHP and C++ (classes wrapping the C
> > structures and functions).
> >
> > http://www.ossp.org/pkg/lib/uuid/
>
> Can you give a link
# [EMAIL PROTECTED] / 2006-08-30 12:32:21 -0500:
> There are good reasons why that is not a feature found in many popular
> email clients. The biggest of which is that if it was people would use
> it all the time and spammers would abuse it as a way to cull current
> email addresses.
IOW g
# [EMAIL PROTECTED] / 2006-08-30 14:11:11 -0400:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > So I don't think we should do anything about it. It's not really a
> > serious problem.
>
> Actually, what I'd like to see done is to get majordomo to bounce list
> messages containing "unsubscribe"
# [EMAIL PROTECTED] / 2006-08-30 12:22:47 -0400:
> -- Forwarded message --
> From: Chris Hoover <[EMAIL PROTECTED]>
> Date: Aug 30, 2006 12:22 PM
> Subject: How to convert a string to bytea?
> To: "pgsql-admin@postgresql.org"
>
> I am in need of some help. I need to use the encod
# [EMAIL PROTECTED] / 2006-08-21 21:16:14 -0700:
> I'm considering using a UUID as a primary / foreign key for my schema,
> to help ensure portability of data in a multi-master context. Does
> anyone have experience with this?
>
> There's a project on Gborg (pguuid) to create a "native" UUID ty
# [EMAIL PROTECTED] / 2006-08-19 20:18:53 -0700:
> Installing with yum, Fedora core 5. Get error: "could
> not open file "global/pg_database": No such file or
> directory." The file exists however, in
> /var/lib/pgsql/data/global and contains 3 lines:
> postgres 10793 1663 499 499
> template
# [EMAIL PROTECTED] / 2006-08-18 10:00:20 +0200:
> On 8/18/06, Stephan Szabo <[EMAIL PROTECTED]> wrote:
> >When the subselect returns
> >NULL for at least one row, you fall into this sort of case.
> >
> >x NOT IN (...) is equivalent to NOT(x IN (...)) which is
> >NOT(x = ANY (...))
> >
> >x = ANY (
# [EMAIL PROTECTED] / 2006-08-16 11:55:39 -0400:
> Hi,
> Conventionally a trigger would fire a few sql queries on a particular event
> and we have standard code for that.
>
> My requirement is to start a stored procedure or a C function as a trigger
> action.
>
> Is this possible?
Besides th
# [EMAIL PROTECTED] / 2006-08-11 10:12:40 -0400:
> I think my Dell Precision 650 has SATA on the motherboard. The boss says
> I can order one drive, so what should I get? How much faster is RAID 0+1
> than a single drive?
You need 4 disks for 0+1 (or 1+0, also called 10).
--
How many Viet
# [EMAIL PROTECTED] / 2006-08-07 22:17:26 -0700:
>
> I have a DATA folder of my previous PostgreSQL 8.1 (Windows XP) installation.
> I do not have any DUMP or other backups. I want to use this folder instead
> of the newly created DATA folder after new installtion.
>
> I tried replacing the new f
# [EMAIL PROTECTED] / 2006-08-06 11:47:43 +0200:
> the following function is created properly:
> CREATE OR REPLACE FUNCTION insert_into_table_overview(text, chr integer)
> RETURNS void AS '
> DECLARE
> in_tableALIAS FOR $1;
> p RECORD;
> BEGIN
> RAISE NOTICE '
# [EMAIL PROTECTED] / 2006-08-05 19:32:27 +0200:
> I stop the postmaster service and then i copy the directory in an other place.
> Restart the postmaster and then test someting modifications.
> Then i stop the service and restore the saved data directory
> Now the postmaster dont start any more
>
# [EMAIL PROTECTED] / 2006-08-02 10:49:01 -0700:
> On 8/1/06, Reece Hart <[EMAIL PROTECTED]> wrote:
> >
> > Eric Andrews wrote:
> >> I am not much of a schema designer and have a general questoin about
> >> the proper use of the array datatype. In my example, I have
> >> destinations, and destinati
# [EMAIL PROTECTED] / 2006-08-02 07:57:55 +0200:
> I'm bothered by listen listening from the end of the transaction in
> stead of the start of the transaction.
Sorry if this isn't what you're after, instead just a question:
Why don't you issue the LISTEN in a separate transaction before
# [EMAIL PROTECTED] / 2006-08-01 10:18:45 -0700:
> I read in the documentation that the money type is depreciated. It
> says to use the to_char function and NUMERIC/decimal instead. Why was
> the money type depreciated when it was so useful? How would be the
> best way to use to_char and numeri
# [EMAIL PROTECTED] / 2006-08-01 02:35:48 -0400:
> On 8/1/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> >
> ># [EMAIL PROTECTED] / 2006-07-31 11:58:49 -0400:
> >> Actually Postgres manual of triggers says that in postgres, you can't
> >write
> >>
# [EMAIL PROTECTED] / 2006-07-31 11:58:49 -0400:
> Actually Postgres manual of triggers says that in postgres, you can't write
> a trigger in conventional sql. You have to write it in a procedural language
> like C. So wanted some more insight on it.
> ~Jas
Where does it say so? Do you have a
# [EMAIL PROTECTED] / 2006-07-19 09:50:05 -0400:
> Yesterday I sent two messages to pgsql-general@postgresql.org, and
> neither one posted, as far as I can tell.
>
> "Please explain the gin index" - 7/18/06 10:44 AM EDT
>
> "number of distinct values in tsearch2 gist index" - 7/18/06 1:24 PM EDT
# [EMAIL PROTECTED] / 2006-07-11 12:04:07 -0400:
> On 6/30/2006 1:07 PM, Merlin Moncure wrote:
>
> >* mysql has a few features here and there which are nice...just to
> >name a few, flush tables with lock, multiple insert, etc
(...)
> The multiple insert stuff is not only non-standard, it al
# [EMAIL PROTECTED] / 2006-07-07 14:08:08 -0600:
> --On July 7, 2006 12:35:53 PM +0000 Roman Neuhauser <[EMAIL PROTECTED]>
> wrote:
>
> ># [EMAIL PROTECTED] / 2006-07-06 22:41:27 -0600:
> >>OK I know this is an odd question but I'm working on an app that will
# [EMAIL PROTECTED] / 2006-07-06 22:41:27 -0600:
> OK I know this is an odd question but I'm working on an app that will rely
> more and more on database driven functions, and while the app's source is
> in SVN, and I intend for the source of the SQL scripts to also be there, I
> was wondering..
# kleptog@svana.org / 2006-06-22 09:19:44 +0200:
> On Tue, Jun 20, 2006 at 02:06:19AM -0700, [EMAIL PROTECTED] wrote:
> > Such construction is very slow but when I modify SQL to:
> > OPEN cursor1 FOR SELECT * FROM alias WHERE mask>=alias_out
> > ORDER BY mask LIMIT 100;
> >
> > it works ve
# [EMAIL PROTECTED] / 2006-06-09 10:12:21 +0200:
> Agent M wrote:
> > If you don't use NULL, then you don't
> > come across 3-valued logic--problem solved.
>
> So was does "SELECT sum(1) FROM dual WHERE false" return?
You stripped this:
> > Some Tutorial D notions really make sense; I would
# [EMAIL PROTECTED] / 2006-06-06 11:58:26 +0300:
> How to force postgres to use index for the following query (I can change the
> query to equivalent if required)
>
> select nimi from klient where lower(nimi) like 'test%'
do you have an index on klient (lower(nimi))?
--
How many Vietnam ve
# [EMAIL PROTECTED] / 2006-06-05 16:19:19 +1000:
> On 6/5/06, Joe Conway wrote:
> >Chris Velevitch wrote:
> >> But what about my original question?
> >>
> >> "What is the point of the create or replace view command if you
> >> can't change the
> >> column and data types?"
> >
> >-- create t
# [EMAIL PROTECTED] / 2006-06-02 05:18:08 -0700:
> I think I need to explain a bit further.
>
> I tried simply using
>
> update people
> replace(address, 'mailto:','');
>
> but unfortunately that produced a duplicate key error as some of the
> addresses prefixed with 'mailto:' are already presen
# [EMAIL PROTECTED] / 2006-05-29 08:10:43 -0400:
> Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
> >
> >>Basically we've got several different "states" that an item can be in.
> >>From what I've seen the way many pla
# [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
> Basically we've got several different "states" that an item can be in.
> From what I've seen the way many places seem to deal with them is
> something along the lines of making bool values that act as
> switches...
>
> Ex:
> table items:
> item_id
# [EMAIL PROTECTED] / 2006-04-08 14:04:28 +0200:
> Am 07.04.2006 um 13:50 schrieb User Roman:
> ># [EMAIL PROTECTED] / 2006-03-31 10:05:06 +0200:
> >>I would like to know if somebody already has a Mac OSX Intel 10.4.5
> >>pg-Library (for C, C++, Objective C)
# [EMAIL PROTECTED] / 2006-04-07 14:31:04 -0700:
> A further question: we are using Debian system. So when we leave the
> 'Address' box
> blank (on the Add Server page of pgAdmin), according to the help file, it
> will go to
> use the default Postgresql socket on the local machine.
> We actual
# [EMAIL PROTECTED] / 2006-03-29 17:17:48 -0800:
> Hello,
>
> I would like to create a function that lets me to search in a table
> rows according differents parameters.
> I looked in the documentation of postgresql 8.1 about Pl/Perl
> procedures but I didn't found how to cross each row of a table
# [EMAIL PROTECTED] / 2006-03-31 10:05:06 +0200:
> I would like to know if somebody already has a Mac OSX Intel 10.4.5
> pg-Library (for C, C++, Objective C) or knows how to compile it?
What problems did you have building libpq?
Note: I'm not an OSX user.
--
How many Vietnam vets does
# [EMAIL PROTECTED] / 2006-04-06 12:03:18 -0400:
> On Apr 3, 2006, at 11:23 PM, Chris Browne wrote:
> >Yeah, someone at the office was asking me on the elevator about
> >whether some Post-something was somehow up and coming.
> >
> >In retrospect, I think he was trying to pronounce Postgre, and arri
I've compared Debug log between correct and wrong activity:
Good activity:
2006-03-24 16:30:36 2632Debug String written: select * from
getvideodata(2::int4, 1::int4, '2006-03-24 16:30:31.40'::timestamp,
1::int4) AS (idvideodate timestamp, mediabinary bytea).
2006-03-24 16:30:36 26
and in 1.0 beta 2.
I've also tried commercial driver from Core Lab.. with the same
result.
PostgresSQL version 8.1.2.
The field idvideodate is Timestamp and mediabinary is bytea.
Probably it's a problem not with ado.net driver, but with
PostgressSQL but how to cope with that?
Roman.
Let me start this email by saying thank you to whoever fixed the
problem. I found a bunch of "Welcome to..." / "Results from delayed
command" message pairs in my mail this morning, and a batch of
messages from each of sql, performance, and hackers mailing lists.
# [EMAIL PROTECTED]
# [EMAIL PROTECTED] / 2006-02-28 15:14:39 -:
> It looks like the listserv cannot handle that address - it says:
>
> "Individual words are not allowed in an e-mail address without an
> intervening period or at symbol ('.' or '@')."
Which address? I see no whitespace in any of the addresse
# [EMAIL PROTECTED] / 2006-02-27 16:32:55 -0400:
> On Mon, 27 Feb 2006, Roman Neuhauser wrote:
>
> ># [EMAIL PROTECTED] / 2006-02-26 19:01:58 -0400:
> >>'k, I just checked all the lists you listed, and you are subscribed to
> >>each of them ... are you not rec
gsql--owner@ and postmaster@
aliases? Does anyone pay attention to the approval queue?
Anyway, here's a few snippets from my last year's email
conversations with [EMAIL PROTECTED]
My subscription requests:
: Date: Sat, 24 Sep 2005 12:17:37 +0200
: From: Roman
# [EMAIL PROTECTED] / 2006-02-26 20:15:20 +0100:
> # [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 a
# [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
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
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
# [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] / 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-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?
> &
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-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
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-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
# [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-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-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-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-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-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-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 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 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 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 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)
>
# 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-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 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-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
# [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-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-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-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 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-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: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-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: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-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-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,
1 - 100 of 149 matches
Mail list logo
