On lör, 2011-06-04 at 07:09 +, dinesh wrote:
> I have a table which is used during data uploads, a so-called staging table.
> This table has a fixed number of columns that [must] match the input CSV
> file. This CSV file is uploaded using COPY command. Following the COPY, a
> new column (meant
Hey,
While playing around with different MAC address notations supported by
postgresql, I encountered the following:
db=> select '08002b-010203'::macaddr;
macaddr
---
08:00:2b:01:02:03
(1 row)
db=> select '08002b-01023'::macaddr;
macaddr
---
08:00:
Matthijs Bomhoff writes:
> The attached version also rejects MACs containing additional
> whitespace between the octets and separators etc.
I was under the impression that allowing whitespace there was a feature,
not a bug. I'm not sure about the more general question of which
abbreviated MAC
On Jun 6, 2011, at 4:31 PM, Tom Lane wrote:
> Matthijs Bomhoff writes:
>> The attached version also rejects MACs containing additional
>> whitespace between the octets and separators etc.
>
> I was under the impression that allowing whitespace there was a feature,
> not a bug.
Ah, I was not su
On Sat, Jun 04, 2011 at 05:24:22PM -0400, Tom Lane wrote:
> Merlin Moncure writes:
> > On Fri, Jun 3, 2011 at 10:42 AM, Jehan-Guillaume (ioguix) de Rorthais
> > wrote:
> >> test=# CREATE RULE test_ins AS ON INSERT TO test DO INSTEAD INSERT INTO
> >> test2 VALUES (NEW.i);
> >> CREATE RULE
> >> tes
On Fri, Jun 3, 2011 at 1:01 PM, Alvaro Herrera
wrote:
> Excerpts from Robert Haas's message of vie jun 03 12:44:45 -0400 2011:
>> On Wed, Jun 1, 2011 at 2:28 PM, Robert Haas wrote:
>
>> > (4) It strikes me that it might be possible to address this problem a
>> > bit more cleanly by allowing mdnbl
David Fetter writes:
> On Sat, Jun 04, 2011 at 05:24:22PM -0400, Tom Lane wrote:
>> We could paste a copy of the original's cteList into the rule action,
>> but there are still issues:
>>
>> * If there's more than one rule action, we could end up executing
>> multiple copies of the same CTE query
On Wed, Jun 1, 2011 at 7:28 PM, Robert Haas wrote:
> On Thu, May 26, 2011 at 12:34 PM, Tom Lane wrote:
>> Alvaro Herrera writes:
>>> Excerpts from Euler Taveira de Oliveira's message of jue may 26 12:00:05
>>> -0400 2011:
I think we should emit the real cause in those cases, if possible (n
