That'd likely be useful. Either specify the column
names with COPY or \copy, or put them in the data file
and pass an option to the command to look for them.
The only time this could be a problem is if you forget
to tell COPY to look for the field names in the file
(AND specify the field names to
On Wed, 11 Aug 2004, Robert Treat wrote:
On Wed, 2004-08-11 at 01:11, Tom Lane wrote:
Robert Treat <[EMAIL PROTECTED]> writes:
On Tuesday 10 August 2004 22:57, Christopher Kings-Lynne wrote:
I don't think many users realise they can use the next version's pg_dump
to upgrade. I think it should be p
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> "Hicham G. Elmongui" <[EMAIL PROTECTED]> writes:
>> is there a way to pull the projection operator to the top of
>> the query plan? I wish there's a variable that can be set to do
>> so.
Tom> Could you be more specific a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 16 Aug 2004, Marc G. Fournier wrote:
> stupid question, but what *is* a blog?
http://dotnet.org.za/armand/archive/0001/01/01/1172.aspx
"A blog is basically a journal that is available on the web. The activity
of updating a blog is "bl
On Tue, 17 Aug 2004, Devrim GUNDUZ wrote:
stupid question, but what *is* a blog?
Hi,
Many hackers worked for PostgreSQL 8.0.0 release, which was one of the
most active development period of PostgreSQL history. We got too many
contributors for this release which is a great success, I think.
A lot of
"Hicham G. Elmongui" <[EMAIL PROTECTED]> writes:
> is there a way to pull the projection operator to the top of the query
> plan? I wish there's a variable that can be set to do so.
Could you be more specific about what you're hoping to accomplish?
regards, tom lane
-
Added to open items:
* remove to_char(interval) if we initdb
---
Alvaro Herrera wrote:
> On Mon, Aug 16, 2004 at 10:43:10AM -0400, Bruce Momjian wrote:
> > Karel Zak wrote:
> > > On Fri, Aug 13, 2004 at 12:24:28PM
Tom,
> Understood, but this seems like a bad design to me, because it's
> non-orthogonal.
Or just a natural consequence of our having loaded Functions down with all of
the functionality usually assigned to Procedures over the years.
> I think that named params would have no significant extra co
On Mon, Aug 16, 2004 at 10:43:10AM -0400, Bruce Momjian wrote:
> Karel Zak wrote:
> > On Fri, Aug 13, 2004 at 12:24:28PM -0400, Tom Lane wrote:
> > > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > > Someone on IRC just reported this to_char() failure with negative
> > > > intervals:
> > >
> > > I
Hi,
is there a way to pull the projection operator to the top of the query
plan? I wish there's a variable that can be set to do so.
Thanks,
--h
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.pos
I posted a patch for this last Friday 13th.
Gavin
On Mon, 16 Aug 2004, Bruce Momjian wrote:
>
> Added to TODO;
>
> o Add ALTER INDEX syntax to work like ALTER TABLE indexname
>
> ---
>
> Christopher Kings-Lynne wrote
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Many hackers worked for PostgreSQL 8.0.0 release, which was one of the
most active development period of PostgreSQL history. We got too many
contributors for this release which is a great success, I think.
A lot of other OSS projects seem to hav
# This message was accidentally sent only to Bruce. It's pasted here
for comment from the rest of the list too :)
Folks,
While on the topic of Ingres and open source, I was wondering whether
there's interest in an effort to port some of the enterprise-grade
features from Ingres over to Postgres
Joe Conway wrote:
Steve Bergman wrote:
Anyone have an SRPM of spec file for the beta?
I just created and posted a source RPM for 8.0.0beta1. As I'm not the
usual packager, and a pure hack when it comes to building my own RPMs,
it would be a Good Thing(tm) if someone else could vet this package;
Tom Lane wrote:
> Andrew Dunstan <[EMAIL PROTECTED]> writes:
> > The use case is that it fits in with the way spreadsheets usually do
> > data tables, and many will only allow you to export a whole worksheet
> > (including the heading row) to CSV, not a part of one. Conversely,
> > working with
Might be worthwhile to look at SQL*Server BCP format files:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsq
l/ad_impt_bcp_9yat.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref
/ts_ba-bz_4fec.asp
A TCL/TK front end would be especially nice. Of c
Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
The use case is that it fits in with the way spreadsheets usually do
data tables, and many will only allow you to export a whole worksheet
(including the heading row) to CSV, not a part of one. Conversely,
working with imported data
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> The use case is that it fits in with the way spreadsheets usually do
> data tables, and many will only allow you to export a whole worksheet
> (including the heading row) to CSV, not a part of one. Conversely,
> working with imported data tables will
Tom Lane wrote:
Bruce Momjian <[EMAIL PROTECTED]> writes:
I certainly think it's worth considering, although I see Tom has
objected :-) . Say we have an option called FIRSTLINELABELS, then on
copy out it would write the headings on the first line, and on copy in
it could just ignore the firs
Sorry for the late reply, missed your initial response.
> "Merlin Moncure" <[EMAIL PROTECTED]> writes:
> >> Does anyone have any more?
>
> > win32 signal safe socket handler
>
> I thought that was solved long ago?
As magnus wrote, we need to confirm that ssl sockets don't block singals
while wa
Magnus Hagander wrote:
> >>> Does anyone have any more?
> >
> >> win32 signal safe socket handler
> >
> >I thought that was solved long ago?
>
> If this is what I think it is (Merlin - please confirm), this relates to
> the SSL code only. And the issue is that there are (I think - haven't
> 100% v
>Since we do have control over the timezone library now, one possible
>answer is to extend the src/timezone API so that it's possible to
>convert/format against more than a single timezone. We could then
>remember the zone setting inherited from the postmaster and always use
>that when formatting
>> That's ugly, and unfortunately %z is GNU-specific.
>
>Does Windows' strftime have any short zone name %-spec? Seems like a
>quick #ifdef WIN32 to use a more compact zone name would be the best
>solution.
No. This is what the cruft in pgtz.c (TZABBREV macro and associated
function) was all abou
>>> Does anyone have any more?
>
>> win32 signal safe socket handler
>
>I thought that was solved long ago?
If this is what I think it is (Merlin - please confirm), this relates to
the SSL code only. And the issue is that there are (I think - haven't
100% verified it yet) paths in the SSL code tha
Josh Berkus <[EMAIL PROTECTED]> writes:
> Tom, just to be perfectly clear about why I see Procedures as a way of
> resolving parameter ambiguity, my idea is that:
> FUNCTIONS will support overloading but will not support named parameter
> calling;
> PROCEDURES will support named parameter calling
Tom,
> I agree however with Andrew's nearby point that this is completely
> unrelated to named parameters to functions/procedures, or to defaults
> for parameters.
I think that was Peter's point, not Andrew's.Andrew agreed with me.
I do think, though, that we should hammer out the parameters
Added to TODO;
o Add ALTER INDEX syntax to work like ALTER TABLE indexname
---
Christopher Kings-Lynne wrote:
> > What I mean here is that I think it would be in our best interests to
> > define the syntax for any n
Added to open items:
* determine proper crash recovery/logging for pg_subtrans
---
Alvaro Herrera Munoz wrote:
> On Tue, Aug 10, 2004 at 12:24:06PM -0400, Tom Lane wrote:
> > My discovery last night of a WAL synchr
David Fetter <[EMAIL PROTECTED]> writes:
> What about making HASHes a first-class object?
I see less than zero value in this. You'd have to serialize the
contents to ship it to the client anyway, so there is no particular
point in inventing a random new representation for "row".
On Fri, Aug 13, 2004 at 07:12:14PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > IOW, their function resolution code treats a(int, int default 0)
> > as being equivalent to a(int) and a(int, int).
>
> So you are willing to prohibit a(int) from existing in parallel with
>
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> I certainly think it's worth considering, although I see Tom has
>> objected :-) . Say we have an option called FIRSTLINELABELS, then on
>> copy out it would write the headings on the first line, and on copy in
>> it could just ignore the first line (
On Mon, Aug 16, 2004 at 11:30:49AM -0400, Tom Lane wrote:
> The bigger question is whether this would do anything to satisfy the
> requestor. He probably wants the headings to appear in the file
> resulting from COPY TO file (or the psql equivalent), which this would
> not do. Providing the info
"Jeroen T. Vermeulen" <[EMAIL PROTECTED]> writes:
> Wouldn't it be more logical, and more compatible, to keep this information
> as regular column information in the PGresult returned by the COPY?
That would work but would require a protocol change, which this is
surely not worth by itself. (We c
Andrew Dunstan wrote:
>
>
> Bruce Momjian wrote:
>
> >Someone just asked about a COPY capability to supply the column headings
> >as the first line of the copy statement. Do we want to support
> >something like that? Does anyone else want such functionality?
> >
> >
> >
>
> I had it in mind
Bruce Momjian wrote:
Someone just asked about a COPY capability to supply the column headings
as the first line of the copy statement. Do we want to support
something like that? Does anyone else want such functionality?
I had it in mind all along as a possible option for CSV mode, but given
On Mon, Aug 16, 2004 at 10:53:36AM -0400, Bruce Momjian wrote:
> Someone just asked about a COPY capability to supply the column headings
> as the first line of the copy statement. Do we want to support
> something like that? Does anyone else want such functionality?
Wouldn't it be more logical,
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Someone just asked about a COPY capability to supply the column headings
> as the first line of the copy statement. Do we want to support
> something like that?
No. Tell him to use SELECT.
(Such a capability would be a permanent hazard, because any ti
Someone just asked about a COPY capability to supply the column headings
as the first line of the copy statement. Do we want to support
something like that? Does anyone else want such functionality?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
Karel Zak wrote:
> On Fri, Aug 13, 2004 at 12:24:28PM -0400, Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > Someone on IRC just reported this to_char() failure with negative
> > > intervals:
> >
> > I think Karel wanted to remove to_char(interval) altogether.
>
> Yes, the no
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> Is NULL above an empty statement in oracle or is it a normal expression
It's an actual empty statement.
> (the normal NULL value) so that the above is a shorthand for
>WHEN OTHERS THEN SELECT NULL;
Even if it were, the point here is to accept st
On Fri, Aug 13, 2004 at 12:24:28PM -0400, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Someone on IRC just reported this to_char() failure with negative
> > intervals:
>
> I think Karel wanted to remove to_char(interval) altogether.
Yes, the notice about it is already in 7.4 d
41 matches
Mail list logo
