On Tue, Nov 26, 2013 at 9:22 AM, Tom Lane wrote:
> Marko Tiikkaja writes:
>> On 11/26/13 2:24 PM, Pavel Stehule wrote:
>>> yes, but we can define new statement like \sq+ (Show Query)
>
>> There's already \p; might not be too difficult to add a \p+ which would
>> also show the line numbers.
>
> I
Marko Tiikkaja writes:
> On 11/26/13 2:24 PM, Pavel Stehule wrote:
>> yes, but we can define new statement like \sq+ (Show Query)
> There's already \p; might not be too difficult to add a \p+ which would
> also show the line numbers.
I don't actually see the point of this. If you're working wi
On 11/26/13 2:24 PM, Pavel Stehule wrote:
yes, but we can define new statement like \sq+ (Show Query)
There's already \p; might not be too difficult to add a \p+ which would
also show the line numbers.
Regards,
Marko Tiikkaja
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgres
2013/11/26 22:24 "Pavel Stehule" :
>
>
>
>
> 2013/11/26 Sawada Masahiko
>>
>> On Tue, Nov 26, 2013 at 9:23 PM, Marko Tiikkaja wrote:
>> > On 11/26/13 1:05 PM, Sawada Masahiko wrote:
>> >>
>> >> When I execute query which contains error, the server returns error
>> >> with line number.
>> >>
>> >>
2013/11/26 Sawada Masahiko
> On Tue, Nov 26, 2013 at 9:23 PM, Marko Tiikkaja wrote:
> > On 11/26/13 1:05 PM, Sawada Masahiko wrote:
> >>
> >> When I execute query which contains error, the server returns error
> >> with line number.
> >>
> >> ERROR: relation "hoge" does not exist
> >> LINE 35:
On Tue, Nov 26, 2013 at 9:23 PM, Marko Tiikkaja wrote:
> On 11/26/13 1:05 PM, Sawada Masahiko wrote:
>>
>> When I execute query which contains error, the server returns error
>> with line number.
>>
>> ERROR: relation "hoge" does not exist
>> LINE 35: hoge;
>>
>> But when query is long, I was not
On 11/26/13 1:05 PM, Sawada Masahiko wrote:
When I execute query which contains error, the server returns error
with line number.
ERROR: relation "hoge" does not exist
LINE 35: hoge;
But when query is long, I was not sure the location where I wrote wrong SQL.
Does the psql have option which sh
2013/11/26 Sawada Masahiko
> Hi all,
>
> When I execute query which contains error, the server returns error
> with line number.
>
> ERROR: relation "hoge" does not exist
> LINE 35: hoge;
>
> But when query is long, I was not sure the location where I wrote wrong
> SQL.
> Does the psql have opti
Hi all,
When I execute query which contains error, the server returns error
with line number.
ERROR: relation "hoge" does not exist
LINE 35: hoge;
But when query is long, I was not sure the location where I wrote wrong SQL.
Does the psql have option which shows line number?
If no, I'm thinking
