Hi everybody.
I'm implementing a solution that uses PostgreSQL's full text search
capabilities and I have come across a particular set of results for ts_rank
that don't seem to make sense according to the documentation. I have tried
the following queries in PostgreSQL 10, 11 and 12.
In both cases
pá 15. 11. 2019 v 6:26 odesílatel github kran napsal:
>
> Hello postGreSQL Community ,
>>
>>
>>
>> Hope everyone is doing great !!.
>>
>>
>> *Background*
>>
>> We use PostgreSQL Version 10.6 version and heavily use PostgreSQL for our
>> day to day activities to write and read data. We have 2 clus
> Hello postGreSQL Community ,
>
>
>
> Hope everyone is doing great !!.
>
>
> *Background*
>
> We use PostgreSQL Version 10.6 version and heavily use PostgreSQL for our
> day to day activities to write and read data. We have 2 clusters running
> PostgreSQL engine , one cluster
>
> keeps data up to
On 11/14/19 11:49 AM, Ron wrote:
v9.6.16
I have a query which shows the parents and children in FK relations,
along with the parent column name, but can't seem to find the child
column names.
Is there a way to find the child column names without having to dig
into pg_constraint?
Thanks
v9.6.16
I have a query which shows the parents and children in FK relations, along
with the parent column name, but can't seem to find the child column names.
Is there a way to find the child column names without having to dig into
pg_constraint?
Thanks
test=# select ccu.table_schema||'.'|
Kyotaro Horiguchi writes:
> At Wed, 2 Oct 2019 19:24:02 -0400, Stephen Frost wrote
> in
>> * Tom Lane (t...@sss.pgh.pa.us) wrote:
>>> Yeah, those messages are all pretty ancient, from when WAL was new and not
>>> to be trusted much. Perhaps the thing to do is move the existing info
>>> into DE
sorry changing the subject line.
On Thu, Nov 14, 2019 at 11:21 AM github kran wrote:
> Hello Team,
>
>
>
> Hope everyone is doing great !!.
>
>
> *Background*
>
> We use PostgreSQL Version 10.6 version and heavily use PostgreSQL for our
> day to day activities to write and read data. We have 2 c
Hello Team,
Hope everyone is doing great !!.
*Background*
We use PostgreSQL Version 10.6 version and heavily use PostgreSQL for our
day to day activities to write and read data. We have 2 clusters running
PostgreSQL engine , one cluster
keeps data up to 60 days and another cluster retains da
On Thu, Nov 14, 2019 at 10:12:22AM -0500, Tom Lane wrote:
> Adrian Klaver writes:
> > On 11/14/19 5:53 AM, stan wrote:
> >> I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
> >> getting the following error:
> >> ERROR: cannot change name of view column "descrip" to "con
On Thu, Nov 14, 2019 at 06:31:48AM -0800, Adrian Klaver wrote:
> On 11/14/19 5:53 AM, stan wrote:
> > I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
> > getting the following error:
> >
> > ERROR: cannot change name of view column "descrip" to "contact_person_1"
> >
On 11/14/19 7:54 AM, Adrian Klaver wrote:
On 11/14/19 7:45 AM, Tom Lane wrote:
Adrian Klaver writes:
On 11/14/19 7:12 AM, Tom Lane wrote:
If you actually want to rename an existing view column, use
ALTER TABLE ... RENAME COLUMN ... for that.
Alright, I'm missing something here:
test=# a
On 11/14/19 7:45 AM, Tom Lane wrote:
Adrian Klaver writes:
On 11/14/19 7:12 AM, Tom Lane wrote:
If you actually want to rename an existing view column, use
ALTER TABLE ... RENAME COLUMN ... for that.
Alright, I'm missing something here:
test=# alter table up_test rename COLUMN col1 to co
On 11/13/19 11:58 PM, İlyas Derse wrote:
Please reply to list also.
Ccing list.
I want to do like this ;
I can't make sense of the below. I don't see where "x" and "y" are used
in the function, unless they supposed to be "id" and "filesize". I have
no idea what the QUERY is doing? Pretty su
Adrian Klaver writes:
> On 11/14/19 7:12 AM, Tom Lane wrote:
>> If you actually want to rename an existing view column, use
>> ALTER TABLE ... RENAME COLUMN ... for that.
> Alright, I'm missing something here:
> test=# alter table up_test rename COLUMN col1 to col_1;
> ALTER TABLE
> ...
> test=#
On 11/14/19 7:12 AM, Tom Lane wrote:
Adrian Klaver writes:
On 11/14/19 5:53 AM, stan wrote:
I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
getting the following error:
ERROR: cannot change name of view column "descrip" to "contact_person_1"
Am I missing something
>Adrian Klaver wrote:
>On 11/13/19 4:40 PM, Brandon Ragland wrote:
>> Hello,
>>
>> I have a Talend enterprise job that loads data into a PostgreSQL
>> database via the COPY command. When migrating to a new server this
>> command fails with the following error message:
>> org.postgresql.util.PSQLExc
Adrian Klaver writes:
> On 11/14/19 5:53 AM, stan wrote:
>> I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
>> getting the following error:
>> ERROR: cannot change name of view column "descrip" to "contact_person_1"
>> Am I missing something here?
> https://www.postgr
On 11/14/19 5:53 AM, stan wrote:
I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
getting the following error:
ERROR: cannot change name of view column "descrip" to "contact_person_1"
I suppose I can drop the view, and recreate it, but that seems to indicate
that th
Hi,
On Thu, Nov 14, 2019 at 7:54 AM stan wrote:
>
> I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
> getting the following error:
>
> ERROR: cannot change name of view column "descrip" to "contact_person_1"
>
> I suppose I can drop the view, and recreate it, but tha
I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
getting the following error:
ERROR: cannot change name of view column "descrip" to "contact_person_1"
I suppose I can drop the view, and recreate it, but that seems to indicate
that the create or replace functionality i
20 matches
Mail list logo
