less there is a compelling
evidence that different databases are required.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
g rough timeline for
the development of 8.3 is:
* mid-May, 2007 - All patches applied, beta testing begins
* July, 2007 - Release of 8.3.0
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you searched our list arch
http://c-jdbc.objectweb.org. Narrow niche,
but if it happens to be the one you are in, then it's an option. I took
a quick look at the user's page, and both of them were using PostgreSQL.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if pos
aw a need and filled it in the domain they work in - Java. Should the
Java folks complain because Perl scripts on CPAN are not accessible from
Java?
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
at it matches the stored hash. No one in your company
ever knows end-user passwords.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTE
te corporation.
Do any of these outsourcers indemnify corporate customers against fraud
or data loss?
--
Guy Rouillier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
and you maintain a balance of say $800, you
probably don't have to worry. If on the other hand this is your only
bank and you have your life savings in there, you most definitely should
consider the risks to which you are exposing your finances.
--
Guy Rouillier
-
this one. Until someone comes out with a standardized
approach for utilizing whatever extra processing power exists on a GPU
in a generic fashion, I can't see much payback for writing special code
for the NVIDIA 8800.
--
Guy Rouillier
---(end of
d endless
time and money refuting all these half-baked comparisons.
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
oral of the story is that, as anyone who has worked
professionally for a number of years knows, no magic bullets exist.
General guidelines can be helpful, but each scenario must be
individually investigated.
--
Guy Rouillier
---(end of broadcast)
for my app with very high
insert/update rates. Is there a PG knowledgebase where this kind of
information might be useful?
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
o I'm pretty sure PG
is still going through the resolution logic, even if you only have a
single instance of a given name.
--
Guy Rouillier
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
cho
mes much easier; you've
got the correct userid to log by just looking at the connection details.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to
Robin Helgelin wrote:
On 8/21/07, Guy Rouillier <[EMAIL PROTECTED]> wrote:
Well, you haven't told us much about your webapp. Are you using
connection pooling? If so, then you'll need to provide the webapp
userid as an additional parameter to your database updates. If y
ppears to
be a significant challenge.
--
Guy Rouillier
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
p
--
(1 row)
now
2007-10-09 23:50:35.774-04
(1 row)
Seems to be working. What version are you using and on what platform?
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Us
the userid for the connection pool.
I'm actually surprised that such a common usage scenario has not forced
connection-unique user-defined variables into the spec.
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you s
Tom Lane wrote:
Guy Rouillier <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Another possibility, if you only need to store and retrieve values
and not do anything especially interesting with them, is to abuse
the "custom GUC variable" facility.
I've had several occasion
Tom Lane wrote:
Guy Rouillier <[EMAIL PROTECTED]> writes:
I set that up, and using the SHOW command returns the set value. I
searched the archives and I couldn't identify a way to retrieve these
values in a trigger function.
http://www.postgresql.org/docs/8.2/static/functions
. Is there a simpler approach?
See the message thread "can I define own variable?" for a discussion of
how to create a temporarily variable. Took place over the last week.
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you se
ou go with
postgresql-8.2.5-1.zip instead. Unzip in a temporary directory, read
the README file, then double click the MSI file (or just type the name
at a command prompt if you use that.)
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have
tored
procs for high-volume inserts) that require you to address with some
thought.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Ow Mun Heng wrote:
On Sun, 2007-10-21 at 22:54 -0400, Guy Rouillier wrote:
The current app uses stored procedures
for all inserts, and PG didn't do well with that approach; substituting
embedded inserts fixed that problem. So PG can definitely "handle" very
Can you
t
case, when you see the "Installment options" pane during the
installation, look at the bottom of the window. You should see "Current
location" with a destination of "C:\Program
Files\PostgreSQL\\". Click the Browse button and change the
destination.
--
Guy
e.
Search the archives there; I think this problem has come up before.
--
Guy Rouillier
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
can't see how a database engine, with all it's transactional
overhead and many other layers, will ever beat a simple grep
performance-wise. I've used Eclipse for refactoring, but having done it
once, I'm sticking with grep.
--
Guy Rouillier
motherboard with a single Opteron socket and 8 DIMM
slots: http://www.tyan.com/product_board_detail.aspx?pid=229
--
Guy Rouillier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
identity to the one used for the list; although the
list always posts to the identity I have set up for mailing lists, for
some reason Thunderbird selects a different identity when I reply.
--
Guy Rouillier
---(end of broadcast)---
TIP 5: don'
throughput I was getting in BigDBMS. The procs
are trivial - just wrappers for insert statements. After I exhausted
all alternatives, I replaced the stored proc invocation in the code with
inserts. Then, PG was able to achieve the same throughput as BigDBMS.
--
Guy Rouillier
-
=
array_append(r_types,tables[t]) WHERE id = r.id;
ELSE
INSERT INTO final_results (id,title,r_types) VALUES
(r.id,r.title,ARRAY[tables.t]);
END LOOP;
END LOOP;
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
AM, Nick wrote:
Thanks Guy, is it possible to get the 3rd column result as an array
instead of string? -Nick
On Oct 14, 9:27 pm, guyr-...@burntmail.com (Guy Rouillier) wrote:
Sure:
select
t3.id,
coalesce
(
t1.title,
t2.title,
t3.title
),
ey CONSTRAINT id_length char_length(...
Sorry, any ideas? (I know it's a stupid question)
See the documentation section 5.3.1 Check Constraints. The condition
needs to be in parentheses. And in order to name your constraint, you
must use the CONSTRAINT variant.
--
Guy Rouillier
--
Sent
esn't StackBuilder get the list of available files dynamically off the
web?
Thanks.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e to install. This should not be a problem with
larger organizations, since most use centrally-administered software
configuration.
Thanks.
--
Guy Rouillier
---
This email is free from viruses and malware because avast! Antivirus protection
is active.
http://www.avast.com
--
Sent via pgsql-
stamp(timestamp with
time zone). Why isn't it being applied?
Thanks.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 3/5/2013 2:03 AM, Stefan Keller wrote:
Hi
Oracle defines database (schema) objects and "non-schema" objects (see [1]).
Is there also such a thing in Postgres?
Yes. See, for example, CREATE USER, CREATE TABLESPACE and CREATE SCHEMA.
--
Guy Rouillier
--
Sent via pgsql-gener
stamp without time zone
This is a subtlety bound to be lost on most. Why is there both a
function and a type name with the same name? I suppose I could define a
synonym to make the function name distinct, but this seems like
something that should be addressed.
Thanks.
--
Guy Rouillier
t as well start with
the latest version. You can get 9.2.3 from the web site
(http://www.postgresql.org/).
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
#x27;[0-9]{1,}'..." for int. Are regular expressions the best approach
here or is there a better way?
I did some quick searching also, looks like regular expressions are your
way to go. Here is one for isInteger, for example:
varchar ~ '^[0-9]+$'
--
Guy Rouillier
--
Sent via
is the password to
your EnterpriseDB account, not a local Windows account. You need to
register an EnterpriseDB account before you can install PPAS.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
C but I don't know libpq, I
might choose to just stick with what I know and use ODBC.
So, really, the first decision you should make is how general you want
your app to be, and how long you expect to use it. Other decisions flow
from there.
--
Guy Rouillier
--
Sent via pgsql-general ma
On 5/21/2013 3:32 PM, Dev Kumkar wrote:
Well to work with psqlODBC, will I need to recompile the psqlODBC binary
and any additional stuff to get ODBC working?
No, you don't need to recompile any libraries. You just use them.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (
g the same binaries.
I'm curious what led you to that conclusion. The MinGW site itself does
not make such a claim. See http://www.mingw.org/wiki/MixingCompilers.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
unorganized archive that is notoriously hard to link to.)
--
Guy Rouillier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
s
email thread. This error happened to me years ago and I don't remember
what the real issue was. Could you point to the actual problem and I'll
see if Windows can identify it?
--
Guy Rouillier
---(end of broadcast)---
TIP 9: In versio
s
the new replication hooks in PostgreSQL 8.3." But if you follow the
link, the resulting page only talks about 1.2.12.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-no
re moderated, then I'd suggest either adding a
"Community Version" directly on that page, or adding one to the
community page off of Techdocs.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
if you use real triggers.
--
Guy Rouillier
---(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
ributed" documentation, so I'm free to add that
myself. Hopefully you appreciate my Catch-22 ;).
"About PostgreSQL Docs" is an important topic, and should be elevated to
the same list as "Main Page".
--
Guy Rouillier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
to the Community
Documentation that just got kicked off?
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message
thers - support and encourage. If it were a community
project it would be under postgresql.org, as all our sites are, (with
the exception of pgFoundry)
And with the new exception of the community documentation recently
started at http://www.postgresqldocs.org.
--
Guy Rouillier
--
Sent via pgsql-ge
Tom Lane wrote:
Guy Rouillier <[EMAIL PROTECTED]> writes:
And with the new exception of the community documentation recently
started at http://www.postgresqldocs.org.
Which in fact has got only the weakest claim to be a "community"
project. If it actually were such, in the
e instance on a backup DB server, but then *it*
completely owns all files related to that instance. Only one instance
can be accessing the files related to that instance at any point in time.
The same could be done with PostgreSQL. As I said, the NetApp is just a
fileserver.
--
Guy Rou
subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
forms.
The only reason I can see for doing DDL in a unit test would be if the
end product will be doing such DDL.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
o loss of
precision. And "for a while" would be over 50 years, as packed decimal
is still in use today. All banks rely on it. The best way to avoid
loss of precision with decimal is to use decimal representation, and not
convert to binary at all. There is no reason why PG could not sup
Christophe Pettus wrote:
On Oct 4, 2009, at 7:09 PM, Guy Rouillier wrote:
There is no reason why PG could not support packed decimal.
Is that not NUMERIC?
No, that is not NUMERIC. All numeric types are stored as binary
representations. Packed decimal is not. Perhaps an example would
Bruce Momjian wrote:
Guy Rouillier wrote:
Christophe Pettus wrote:
On Oct 4, 2009, at 7:09 PM, Guy Rouillier wrote:
There is no reason why PG could not support packed decimal.
Is that not NUMERIC?
No, that is not NUMERIC. All numeric types are stored as binary
representations. Packed
/2008 "ER diagram tool"
http://druid.sf.net/
http://schemaspy.sourceforge.net/
http://uml.sourceforge.net/index.php
And on it goes. Keep searching and you'll find more.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t and
May, with some smaller ones as far back as February.
What kinds of data are written to disk without being registered in
pg_class? How can we determine which (if any) are safe to delete?
Thanks.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On 10/7/2013 5:58 PM, Steve Atkins wrote:
On Oct 7, 2013, at 2:48 PM, Guy Rouillier
wrote:
We have a fairly large (1 TB) database we put on all SSDs because
of a very high insert and update rate (38 million rows/day). As
our business has grown, we've been running into space constraint
On 10/7/2013 6:46 PM, David Kerr wrote:
On Mon, Oct 07, 2013 at 06:32:57PM -0400, Guy Rouillier wrote: - So,
I ran "select pg_relation_filenode(614804)" and got no results. Any
- suggestions on how I can uncover the identify of this node? - -
Thanks much.
You could try oid2
tus, etc. a browswer interface is superb. Why
bother writing a real application for something that trivial?
The point is, use the right tool for the task. It's not always a
browser and those who think so are showing their ignorance of a huge and
varied technology world.
On that we agree.
--
Gu
-numeric.html#DATATYPE-INT
From the documentation, the range of integer data types is not
platform-specific, other than for warning about BIGINT. Perhaps you are
remembering compiler documentation, where the default integer size
typically *is* platform-dependent?
--
Guy Rouillier
--
Sent via pgsql
tuff
I've personally tested.
Our adventure with these cards was a presentation at Postgres Open in
2011. Slides are here:
https://wiki.postgresql.org/images/c/c5/Nvram_fun_profit.pdf
--
Guy Rouillier
---
This email is free from viruses and malware because avast! Antivirus pr
test values(1,1)".
thanks millions!
What do you mean by function? Are you trying to do this from PgAdmin,
from a stored proc or from some flavor of source code? If either of the
latter two, which language?
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@pos
. Why people aren't
bothered by this is beyond me.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
EN empcode = 'NT-028' THEN 1 ELSE 0 END) -
SUM (CASE WHEN empcode = 'NT-031' THEN 1 ELSE 0 END) as NT028_NT031
Or if you prefer, define an outer select with your select in the FROM
clause; in the outer select, you can select each of the 4 columns plus
any difference you like.
to work, I'd suggest switching to SETOF.
I'll get back to you when I find out why OTHER is not working. Or else
you can join the MyBatis mailing list.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On 8/26/2010 5:27 AM, atul.g...@globaldatapoint.com wrote:
Hi Guy,
Thanks for your reply. We were able to work out with type OTHER.
How did you get OTHER to work? Did you define your own TypeHandler?
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
nth N+1. So, if you have the beginning, ending and # customers
added, then attrition = ending - beginning - #added.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
y, we can call
them and open a support issue.
PG is a great piece of work and equal in performance and features to
commercial DBMSs. You can get support contracts from several companies.
But there is no single entity that "owns" PG. CTOs/CIOs like to sleep
at night.
--
Guy Rouillier
Garry Saddington wrote:
It does work but returns a column called case. How can I return the case
column as 'postcode'?
select
CASE WHEN postcode ilike '%OO%' THEN ''
END as postcode
from addresses
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-g
Since I
personally don't like receiving multiple copies of emails from this
list, I delete all of the "To:" addressees and change the list from
"CC:" to "To:". Would be nice if everyone did the same.
--
Guy Rouillier
--
Sent via pgsql-general m
admin.html#FUNCTIONS-ADMIN-SET-TABLE
If you'd like to read a fuller discussion of this very topic, search for
a thread titled "can I define own variables" in the archives. I had to
do the same thing back then.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-genera
Aidan Van Dyk wrote:
But now, if the list munged my reply-to, how would you get back to me?
I wouldn't ;). The whole point of a mailing list is to have discussions
with the list. If I wanted to correspond with you directly, I wouldn't
use the list for that.
--
Guy Rouillier
-
s a "reply to list" add-on for ThunderBird - it's marked
experimental, but may be worth a try:
https://addons.mozilla.org/en-US/thunderbird/addon/4455
Works great! Thanks, Ray - no more complaints from me ;). Anyone using
Thunderbird to read this list would benefit f
ng to do. But I've never investigated.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in
a production environment. I have quite a bit of experience in Gentoo
and other distros, and for Andrus's situation, I continue to recommend a
binary distro with committed multi-year support.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Qiang wrote:
thank you!
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nswer questions about that distro: http://www.gentoo.org
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Uwe Schroeder wrote:
On Sunday 08 November 2009 11:38:28 pm Uwe Schroeder wrote:
(why it uses a transaction for a simple select is the other thing).
Every database interaction happens within a transaction.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
://groups.fsf.org/wiki/Oracle_Forms
or this if you are looking for a web solution:
http://stackoverflow.com/questions/179849/best-solution-for-migration-from-oracle-forms-6i-to-the-web
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
MDD.FMMM.FMYY') from dual;
1.01.9
select to_char(DATE'2009-1-1','FM DD.MM.YY') from dual
1.1.9
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 1/6/2010 3:29 PM, Tom Lane wrote:
Guy Rouillier writes:
Oracle states clearly in the SQL Reference manual:
"A modifier can appear in a format model more than once. In such a case,
each subsequent occurrence toggles the effects of the modifier."
*Toggles* the effect of th
Liraz Siri wrote:
Solaris is awesome (dtrace rocks!), but I still prefer Debian/Linux for
the same reasons I prefer PostgreSQL over MySQL - its lack of dependence
on any single company.
OpenSolaris?
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Joshua D. Drake wrote:
BSD is dying.
We all are, sooner or later ;)
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to your desktop application.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ppen to do inserts on two different tables, each with
a foreign key to the same reference table, deadlocks are pretty easy to
create. This is especially true if the reference table has low
cardinality, which is often the case.
I don't know if this situation has been improved since that ti
Gregory Stark wrote:
Christopher Browne writes:
- Managing jobs (e.g. - "pgcron")
A number of people have mentioned a job scheduler. I think a job scheduler
entirely inside Postgres would be a terrible idea.
PgFoundry already has a project called "Job Scheduler"
s, which becomes a
management issue. As has been pointed out here, the schedule could be
kept in the DB, which would address that. Having a scheduler in the DB
to run those jobs is just the next step.
Different stokes, as they say. All about choice.
--
Guy Rouillier
--
Sent via pgsql-gener
king about? Triggers are
already pieces of code that run upon "certain events", namely insert,
update or delete events. What others do you have in mind?
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
your
comment to fall into the "pet peeves" bucket rather than the "job
scheduler" bucket.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
new one.
A more descriptive subject to your emails would also encourage people to
respond.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
07/08/17/rownum-anyone-cumulative-sum-in-one-query/
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;> ^ ^^^
>> Those aren't going to help, are they?
>>
>> --
>>Richard Huxton
>>Archonet Ltd
>>
--
Guy Rouillier
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
ograms to talk with PostgreSQL? See section 27.15. Building libpq
Programs. Seems pretty clearly laid out there.
--
Guy Rouillier
---(end of broadcast)---
TIP 8: explain analyze is your friend
Title: Message
The
RAISE statement requires a % marker for each variable you want to include in the
output text.
--Guy Rouillier
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Rick CaseySent: Thursday, February 24, 2005
5:51 PMTo: pgsql
cle exported dates like this: "9/14/2004 6:40:21 PM". PG took 'em
right in with no special instructions, and produced the correct
timestamp. Hats off to the PG developers! Thanks for all your work.
--
Guy Rouillier
---(end of broadcast)
1 - 100 of 237 matches
Mail list logo
